Test insert_self_ref_FK.Bug-6131.sql (id c90de82591ad) (out)
insert_self_ref_FK.Bug-6131.stable.err.FILTERED 2020-09-18 23:54:37.000000000 +0200insert_self_ref_FK.Bug-6131.test.err.FILTERED 2020-09-18 23:54:37.000000000 +0200
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 25 lines, 125 words, 921 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 1 lines, 8 words, 92 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 25 lines, 125 words, 921 chars in lines not matching '^$|^(\| |)#` 3
4 # 17 lines, 62 words, 639 chars in all lines 4 ! 4 # 41 lines, 178 words, 1387 chars in all lines 4
5 5 5 5
..................
# 17 lines, 62 words,
8 8 8 8
9 # 17:12:55 > 9 ! 9 # 23:54:37 > 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 # 23:54:37 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-34262" "--port=34689" 10
11 # 17:12:55 > 11 ! 11 # 23:54:37 > 11
12 12 ! 12 12
13 13 ! 13 #~ MAPI = (monetdb) /var/tmp/mtest-34262/.s.monetdb.34689 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-34262/.s.monetdb.34689 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-34262/.s.monetdb.34689 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-34262/.s.monetdb.34689 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-34262/.s.monetdb.34689 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 42
+ 43 # 23:54:37 > 43
+ 44 # 23:54:37 > "Done." 44
+ 45 # 23:54:37 > 45
22 22 46 46