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, 1579 chars in all lines |
4 |
5 |
|
5 |
|
5 |
|
5 |
8 |
|
8 |
|
8 |
|
8 |
9 |
# 17:12:55 > |
9 |
! |
9 |
# 19:20:10 > |
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:20:10 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-3087" "--port=39593" |
10 |
11 |
# 17:12:55 > |
11 |
! |
11 |
# 19:20:10 > |
11 |
12 |
|
12 |
! |
12 |
|
12 |
13 |
|
13 |
! |
13 |
#~ MAPI = (monetdb) /var/tmp/mtest-3087/.s.monetdb.39593 |
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-3087/.s.monetdb.39593 |
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-3087/.s.monetdb.39593 |
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-3087/.s.monetdb.39593 |
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-3087/.s.monetdb.39593 |
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-3087/.s.monetdb.39593 |
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:20:10 > |
47 |
|
|
|
+ |
48 |
# 19:20:10 > "Done." |
48 |
|
|
|
+ |
49 |
# 19:20:10 > |
49 |
22 |
|
22 |
|
50 |
|
50 |