Test insert_self_ref_FK.Bug-6131.sql (id 03daa4a14bfc) (err)
insert_self_ref_FK.Bug-6131.stable.out.FILTERED 2018-06-14 22:42:53.974721400 +0200insert_self_ref_FK.Bug-6131.test.out.FILTERED 2018-06-14 22:42:53.977721400 +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 16 lines, 71 words, 304 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 9 lines, 44 words, 233 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 16 lines, 71 words, 304 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 9 lines, 44 words, 233 chars in lines not matching '^$|^(\| |)#` 3
4 # 103 lines, 509 words, 3515 chars in all lines 4 ! 4 # 48 lines, 227 words, 1559 chars in all lines 4
5 5 5 5
..................
# CONSTRAINT "fC" FOREIGN KEY (C) REFER
79 #); 79 35 #); 35
80 #INSERT INTO test101 VALUES (101, 101, 101); 80 -
81 [ 1 ] 81 -
82 #ALTER TABLE test101 ALTER C SET NULL; 82 36 #ALTER TABLE test101 ALTER C SET NULL; 36
..................
#INSERT INTO test101 VALUES (100, 100, N
84 [ 1 ] 84 38 [ 1 ] 38
85 #INSERT INTO test101 VALUES (102, 102, 102); 85 -
86 [ 1 ] 86 -
87 #INSERT INTO test101 VALUES (103, 103, 101); 87 -
88 [ 1 ] 88 -
89 #UPDATE test101 SET C = 100 WHERE C IS NULL; 89 39 #UPDATE test101 SET C = 100 WHERE C IS NULL; 39
..................
#select * from test101;
95 % 3, 3, 3 # length 95 45 % 3, 3, 3 # length 45
96 [ 101, 101, 101 ] 96 -
97 [ 100, 100, 100 ] 97 46 [ 100, 100, 100 ] 46
98 [ 102, 102, 102 ] 98 -
99 [ 103, 103, 103 ] 99 -
100 #ALTER TABLE test101 ALTER C SET NOT NULL; 100 47 #ALTER TABLE test101 ALTER C SET NOT NULL; 47
101 #INSERT INTO test101 VALUES (104, 104, 104); 101 -
102 [ 1 ] 102 -
103 #DROP TABLE test101; 103 48 #DROP TABLE test101; 48