unexpected value;
received "True"
expected "False"
query started on line 535 of file sqlancer18.test
query text:
SELECT EXISTS (SELECT vc0 = ANY(SELECT vc0) FROM v100 WHERE FALSE)

query result:
True
unexpected value;
received "True"
expected "False"
unexpected value;
received "True"
expected "False"
unexpected value;
received "True"
expected "False"
unexpected value;
received "True"
expected "False"
unexpected value;
received "True"
expected "False"
unexpected value;
received "True"
expected "False"
unexpected value;
received "True"
expected "False"
unexpected value;
received "True"
expected "False"
unexpected value;
received "True"
expected "False"
unexpected value;
received "True"
expected "False"
query started on line 540 of file sqlancer18.test
query text:
SELECT EXISTS (SELECT vc0 = ANY(SELECT vc0) FROM v100 WHERE FALSE) FROM t0

query result:
True
True
True
True
True
True
True
True
True
True
unexpected value;
received "10"
expected "0"
query started on line 559 of file sqlancer18.test
query text:
SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(EXISTS (SELECT tv0l1n0.vc0 < ANY(SELECT tv0l1n0.vc0 FROM v100 WHERE FALSE)
FROM v100 AS tv0l1n0 WHERE 1 NOT BETWEEN SYMMETRIC 6 AND 0) AS INT) as count FROM t0) as res

query result:
10
unexpected error from pymonetdb
Server closed connection
query started on line 605 of file sqlancer18.test
query text:
SELECT ((SELECT 5) INTERSECT (SELECT 9)) = ALL(SELECT 4) >= TRUE


Aborted
           PID: 105204 (mserver5)
           UID: 9375 (monet)
           GID: 60020 (da)
        Signal: 6 (ABRT)
     Timestamp: Wed 2021-11-24 23:56:20 CET (11s ago)
  Command Line: mserver5 --debug=10 --set gdk_nr_threads 0 --set mapi_listenaddr all --set mapi_port 0 --set mapi_usock /tmp/mtest-94190/.s.monetdb.${PORT} --forcemito --dbpath=/export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/tests/sql/dbfarm/mTests_sql_test_SQLancer --set gdk_use_strimps yes --set gdk_vm_maxsize 8589934592 --loadmodule udf --dbextra=/export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/tests/sql/dbfarm/mTests_transient
    Executable: /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/bin/mserver5
 Control Group: /user.slice/user-9375.slice/session-33241.scope
          Unit: session-33241.scope
         Slice: user-9375.slice
       Session: 33241
     Owner UID: 9375 (monet)
       Boot ID: f6574743b28148169aca4bd1274f98c3
    Machine ID: 1f4194aaa0f646ea93c51854757f1d73
      Hostname: lab01.da.cwi.nl
       Storage: /var/lib/systemd/coredump/core.mserver5.9375.f6574743b28148169aca4bd1274f98c3.105204.1637794580000000.lz4
       Message: Process 105204 (mserver5) of user 9375 dumped core.

[New LWP 105854]
[New LWP 105204]
[New LWP 105206]
[New LWP 105215]
[New LWP 105211]
[New LWP 105205]
[New LWP 105214]
[New LWP 105213]
[New LWP 105207]
[New LWP 105212]
[New LWP 105219]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib64/libthread_db.so.1".
Core was generated by `mserver5 --debug=10 --set gdk_nr_threads 0 --set mapi_listenaddr all --set mapi'.
Program terminated with signal SIGABRT, Aborted.
#0  0x00007ff01cda59e5 in raise () from /lib64/libc.so.6
[Current thread is 1 (Thread 0x7fefee428640 (LWP 105854))]

Thread 11 (Thread 0x7fefd5248640 (LWP 105219)):
#0  0x00007ff01ce30451 in clock_nanosleep@GLIBC_2.2.5 () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007ff01ce35997 in nanosleep () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007ff01d5fc3b2 in MT_sleep_ms () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00007ff01b3ea6d9 in store_manager () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#4  0x00007ff01b462841 in mvc_logmanager () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#5  0x00007ff01d581b65 in THRstarter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007ff01d5f8429 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#7  0x00007ff01cf3c3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#8  0x00007ff01ce694c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 10 (Thread 0x7fefeec2c640 (LWP 105212)):
#0  0x00007ff01cf450d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007ff01cf451d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007ff01dcdd6b8 in q_dequeue () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007ff01dcddcbe in DFLOWworker () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#4  0x00007ff01d581b65 in THRstarter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007ff01d5f8429 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007ff01cf3c3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007ff01ce694c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 9 (Thread 0x7fefef02e640 (LWP 105207)):
#0  0x00007ff01ce5e3ff in poll () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007ff01ddde1d4 in SERVERlistenThread () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#2  0x00007ff01d5f8429 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00007ff01cf3c3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#4  0x00007ff01ce694c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 8 (Thread 0x7fefeea2b640 (LWP 105213)):
#0  0x00007ff01cf450d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007ff01cf451d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007ff01dcdd6b8 in q_dequeue () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007ff01dcddcbe in DFLOWworker () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#4  0x00007ff01d581b65 in THRstarter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007ff01d5f8429 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007ff01cf3c3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007ff01ce694c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 7 (Thread 0x7fefee82a640 (LWP 105214)):
#0  0x00007ff01cf450d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007ff01cf451d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007ff01dcde590 in DFLOWworker () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007ff01d581b65 in THRstarter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#4  0x00007ff01d5f8429 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007ff01cf3c3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#6  0x00007ff01ce694c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 6 (Thread 0x7ff01bbe8640 (LWP 105205)):
#0  0x00007ff01ce30451 in clock_nanosleep@GLIBC_2.2.5 () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007ff01ce35997 in nanosleep () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007ff01d5fc3b2 in MT_sleep_ms () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00007ff01d5755da in BBPmanager () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#4  0x00007ff01d581b65 in THRstarter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007ff01d5f8429 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007ff01cf3c3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007ff01ce694c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 5 (Thread 0x7fefeee2d640 (LWP 105211)):
#0  0x00007ff01cf450d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007ff01cf451d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007ff01dcdd6b8 in q_dequeue () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007ff01dcddcbe in DFLOWworker () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#4  0x00007ff01d581b65 in THRstarter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007ff01d5f8429 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007ff01cf3c3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007ff01ce694c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 4 (Thread 0x7fefee629640 (LWP 105215)):
#0  0x00007ff01cf450d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007ff01cf451d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007ff01dcde590 in DFLOWworker () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007ff01d581b65 in THRstarter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#4  0x00007ff01d5f8429 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007ff01cf3c3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#6  0x00007ff01ce694c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 3 (Thread 0x7ff01b9e7640 (LWP 105206)):
#0  0x00007ff01ce30451 in clock_nanosleep@GLIBC_2.2.5 () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007ff01ce35997 in nanosleep () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007ff01d5fc3b2 in MT_sleep_ms () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00007ff01dcf878d in profilerHeartbeat () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#4  0x00007ff01d5f8429 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007ff01cf3c3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#6  0x00007ff01ce694c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 2 (Thread 0x7ff01bddf8c0 (LWP 105204)):
#0  0x00007ff01ce30451 in clock_nanosleep@GLIBC_2.2.5 () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007ff01ce35997 in nanosleep () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007ff01d5fc3b2 in MT_sleep_ms () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x000000000040428e in main ()
No symbol table info available.

Thread 1 (Thread 0x7fefee428640 (LWP 105854)):
#0  0x00007ff01cda59e5 in raise () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007ff01cd8e8a4 in abort () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007ff01cd8e789 in __assert_fail_base.cold () from /lib64/libc.so.6
No symbol table info available.
#3  0x00007ff01cd9e026 in __assert_fail () from /lib64/libc.so.6
No symbol table info available.
#4  0x00007ff01b2e7c2c in exp_bin () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#5  0x00007ff01b2e8beb in exp_bin () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#6  0x00007ff01b2e7944 in exp_bin () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#7  0x00007ff01b2fa0bb in rel2bin_project () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#8  0x00007ff01b2f22d0 in subrel_bin () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#9  0x00007ff01b2f8f0d in rel2bin_groupby () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#10 0x00007ff01b2f1d1d in subrel_bin () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#11 0x00007ff01b2fdcfc in rel2bin_join () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#12 0x00007ff01b2f1966 in subrel_bin () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#13 0x00007ff01b2f9e1e in rel2bin_project () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#14 0x00007ff01b2f22d0 in subrel_bin () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#15 0x00007ff01b300446 in output_rel_bin () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#16 0x00007ff01b325c64 in backend_dumpstmt () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#17 0x00007ff01b2d09e1 in SQLparser () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#18 0x00007ff01dcfc784 in runPhase () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#19 0x00007ff01dcfd696 in runScenario () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#20 0x00007ff01dcfe27a in MSserveClient () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#21 0x00007ff01dcfeb83 in MSscheduleClient () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#22 0x00007ff01ddddad4 in doChallenge () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#23 0x00007ff01d581b65 in THRstarter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#24 0x00007ff01d5f8429 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#25 0x00007ff01cf3c3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#26 0x00007ff01ce694c3 in clone () from /lib64/libc.so.6
No symbol table info available.