Test insert_self_ref_FK.Bug-6131.sql (id f56b8f83e70a) (err)
insert_self_ref_FK.Bug-6131.stable.out.FILTERED 2019-09-11 22:53:49.398253900 +0200insert_self_ref_FK.Bug-6131.test.out.FILTERED 2019-09-11 22:53:49.398253900 +0200
1 Statistics about stdout of test 'insert_self_ref_FK.Bug-6131` in directory 'sql/test/BugTracker-2017`: 1 1 Statistics about stdout of test 'insert_self_ref_FK.Bug-6131` in directory 'sql/test/BugTracker-2017`: 1
2 15 lines, 70 words, 298 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 8 lines, 43 words, 227 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 15 lines, 70 words, 298 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 8 lines, 43 words, 227 chars in lines not matching '^$|^(\| |)#` 3
4 # 102 lines, 508 words, 3509 chars in all lines 4 ! 4 # 47 lines, 229 words, 1505 chars in all lines 4
5 5 5 5
..................
# CONSTRAINT "fC" FOREIGN KEY (C) REFER
78 #); 78 34 #); 34
79 #INSERT INTO test101 VALUES (101, 101, 101); 79 -
80 [ 1 ] 80 -
81 #ALTER TABLE test101 ALTER C SET NULL; 81 35 #ALTER TABLE test101 ALTER C SET NULL; 35
..................
#INSERT INTO test101 VALUES (100, 100, N
83 [ 1 ] 83 37 [ 1 ] 37
84 #INSERT INTO test101 VALUES (102, 102, 102); 84 -
85 [ 1 ] 85 -
86 #INSERT INTO test101 VALUES (103, 103, 101); 86 -
87 [ 1 ] 87 -
88 #UPDATE test101 SET C = 100 WHERE C IS NULL; 88 38 #UPDATE test101 SET C = 100 WHERE C IS NULL; 38
..................
#select * from test101;
94 % 3, 3, 3 # length 94 44 % 3, 3, 3 # length 44
95 [ 101, 101, 101 ] 95 -
96 [ 100, 100, 100 ] 96 45 [ 100, 100, 100 ] 45
97 [ 102, 102, 102 ] 97 -
98 [ 103, 103, 103 ] 98 -
99 #ALTER TABLE test101 ALTER C SET NOT NULL; 99 46 #ALTER TABLE test101 ALTER C SET NOT NULL; 46
100 #INSERT INTO test101 VALUES (104, 104, 104); 100 -
101 [ 1 ] 101 -
102 #DROP TABLE test101; 102 47 #DROP TABLE test101; 47