Test sqlsmith-exists.sql (id 257bc073dc33) (out)
sqlsmith-exists.stable.err.FILTERED 2019-12-02 21:02:03.380061796 +0100sqlsmith-exists.test.err.FILTERED 2019-12-02 21:02:03.384061817 +0100
+ 1 Statistics about stderr of test 'sqlsmith-exists` in directory 'sql/test/mergetables`: 1
+ 2 25 lines, 88 words, 613 chars in lines not matching '^$|^(\| |)#|^=` 2
+ 3 = 25 lines, 88 words, 613 chars in lines not matching '^$|^(\| |)#` 3
+ 4 # 45 lines, 158 words, 1497 chars in all lines 4
+ 5 5
+ 6 stderr of test 'sqlsmith-exists` in directory 'sql/test/mergetables` itself: 6
+ 7 7
+ 8 8
+ 9 # 21:02:02 > 9
+ 10 # 21:02:02 > "mserver5" "--debug=0" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=36945" "--set" "mapi_usock=/var/tmp/mtest-5450/.s.monetdb.36945" "--forcemito" "--set" "gdk_vm_maxsize=8589934592" "--dbpath=/export/scratch1/home/monet/testing/257bc073dc33-3-1-2/tests/sql/dbfarm/mTests_sql_test_mergetables" "--set" "embedded_c=true" 10
+ 11 # 21:02:02 > 11
+ 12 12
+ 13 could not find ref_1.type_id 13
+ 14 #client2:!ERROR:MALException:optimizer.garbagecollector:42000!Incorrect MAL plan encountered 14
+ 15 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 15
+ 16 #client2:!ERROR:MALException:garbageCollector:42000!Error in optimizer garbageCollector 16
+ 17 17
+ 18 # 21:02:03 > 18
+ 19 # 21:02:03 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-5450" "--port=36945" 19
+ 20 # 21:02:03 > 20
+ 21 21
+ 22 #~ MAPI = (monetdb) /var/tmp/mtest-5450/.s.monetdb.36945 22
+ 23 QUERY = select 23
+ 24 cast(coalesce(ref_0.id, ref_0.owner) as int) as c0, ref_0.system as c1, 24
+ 25 50 as c2, 25
+ 26 ref_0.name as c3 26
+ 27 from 27
+ 28 sys.schemas as ref_0 28
+ 29 where (false) 29
+ 30 or (exists ( 30
+ 31 select 31
+ 32 ref_0.system as c0, 32
+ 33 ref_0.id as c1, 33
+ 34 ref_1.type_name as c2, 34
+ 35 ref_2.owner as c3, 35
+ 36 ref_2.optimize as c4, 36
+ 37 ref_1.function_type as c5, 37
+ 38 cast(nullif(ref_1.function_type, ref_1.function_id) as int) as c6, 38
+ 39 ref_1.type_name as c7, 39
+ 40 73 as c8, 40
+ 41 ref_2.query as c9, 41
+ 42 ref_1.function_name as c10, 42
+ 43 ref_1.function_id as c11, 43
+ 44 ERROR = !Error in optimizer garbageCollector 44
+ 45 CODE = 42000 45
+ 46 46
+ 47 # 21:02:03 > 47
+ 48 # 21:02:03 > "Done." 48
+ 49 # 21:02:03 > 49
+ 50 50