Test insert_self_ref_FK.Bug-6131.sql (id baf04b4f27a7) (out)
insert_self_ref_FK.Bug-6131.stable.err.FILTERED 2020-11-22 19:26:40.000000000 +0100insert_self_ref_FK.Bug-6131.test.err.FILTERED 2020-11-22 19:26:40.000000000 +0100
1 Statistics about stderr of test 'insert_self_ref_FK.Bug-6131` in directory 'sql/test/BugTracker-2017`: 1 1 Statistics about stderr of test 'insert_self_ref_FK.Bug-6131` in directory 'sql/test/BugTracker-2017`: 1
2 1 lines, 8 words, 92 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 28 lines, 147 words, 1063 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 1 lines, 8 words, 92 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 28 lines, 147 words, 1063 chars in lines not matching '^$|^(\| |)#` 3
4 # 17 lines, 62 words, 639 chars in all lines 4 ! 4 # 45 lines, 205 words, 1586 chars in all lines 4
5 5 5 5
..................
# 17 lines, 62 words,
8 8 8 8
9 # 17:12:55 > 9 ! 9 # 19:26:40 > 9
10 # 17:12:55 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=33887" "--set" "mapi_usock=/var/tmp/mtest-16836/.s.monetdb.33887" "--set" "monet_prompt=" "--forcemito" "--dbpath=/export/scratch2/dinther/INSTALL/var/MonetDB/mTests_sql_test_BugTracker-2017" "--set" "embedded_r=yes" "--set" "embedded_py=true" 10 ! 10 # 19:26:40 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-96723" "--port=31995" 10
11 # 17:12:55 > 11 ! 11 # 19:26:40 > 11
12 12 ! 12 12
13 13 ! 13 #~ MAPI = (monetdb) /var/tmp/mtest-96723/.s.monetdb.31995 13
14 # 17:12:56 > 14 ! 14 QUERY = INSERT INTO test101 VALUES (101, 101, 101); 14
15 # 17:12:56 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-16836" "--port=33887" 15 ! 15 ERROR = !INSERT INTO: FOREIGN KEY constraint 'test101.fC' violated 15
16 # 17:12:56 > 16 ! 16 CODE = 40002 16
17 17 ! 17 #~ MAPI = (monetdb) /var/tmp/mtest-96723/.s.monetdb.31995 17
18 18 ! 18 QUERY = INSERT INTO test101 VALUES (102, 102, 102); 18
19 # 17:12:56 > 19 ! 19 ERROR = !INSERT INTO: FOREIGN KEY constraint 'test101.fC' violated 19
20 # 17:12:56 > "Done." 20 ! 20 CODE = 40002 20
21 # 17:12:56 > 21 ! 21 #~ MAPI = (monetdb) /var/tmp/mtest-96723/.s.monetdb.31995 21
+ 22 QUERY = INSERT INTO test101 VALUES (103, 103, 101); 22
+ 23 ERROR = !INSERT INTO: FOREIGN KEY constraint 'test101.fC' violated 23
+ 24 CODE = 40002 24
+ 25 #~ MAPI = (monetdb) /var/tmp/mtest-96723/.s.monetdb.31995 25
+ 26 QUERY = INSERT INTO test101 VALUES (104, 104, 104); 26
+ 27 ERROR = !INSERT INTO: FOREIGN KEY constraint 'test101.fC' violated 27
+ 28 CODE = 40002 28
+ 29 #~ MAPI = (monetdb) /var/tmp/mtest-96723/.s.monetdb.31995 29
+ 30 QUERY = COPY 9 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"'; 30
+ 31 0.21248182395969406 31
+ 32 0.6307796692265083 32
+ 33 2059310235 33
+ 34 -6.5457821e+8 34
+ 35 0.743704157497456 35
+ 36 0.4001718453135127 36
+ 37 0.3935743494971655 37
+ 38 0.5299192301063729 38
+ 39 0.7609386265982908 39
+ 40 ERROR = !INSERT INTO: FOREIGN KEY constraint 't1.t1_c0_fkey' violated 40
+ 41 CODE = 40002 41
+ 42 #~ MAPI = (monetdb) /var/tmp/mtest-96723/.s.monetdb.31995 42
+ 43 QUERY = INSERT INTO t0(tc0) VALUES('b' BETWEEN 'a' AND 'c'); 43
+ 44 ERROR = !INSERT INTO: FOREIGN KEY constraint 't0.t0_tc0_fkey' violated 44
+ 45 CODE = 40002 45
+ 46 46
+ 47 # 19:26:40 > 47
+ 48 # 19:26:40 > "Done." 48
+ 49 # 19:26:40 > 49
22 22 50 50