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 value;
received "NULL"
expected "True"
query started on line 617 of file sqlancer18.test
query text:
SELECT (SELECT 'a' FROM v1) <> ALL(SELECT 'b' FROM t2) FROM v2

query result:
NULL
unexpected value;
received "NULL"
expected "1"
query started on line 622 of file sqlancer18.test
query text:
SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((SELECT 'a' FROM v1) <> ALL((SELECT 'b' FROM t2) UNION (SELECT 'c' FROM v1)) AS INT)
as count FROM v2) as res

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


Aborted
           PID: 4167988 (mserver5)
           UID: 9375 (monet)
           GID: 60020 (da)
        Signal: 6 (ABRT)
     Timestamp: Thu 2021-11-25 23:49:41 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-4156894/.s.monetdb.${PORT} --forcemito --dbpath=/export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/tests/sql/dbfarm/mTests_sql_test_SQLancer --set gdk_use_strimps yes --set gdk_vm_maxsize 8589934592 --loadmodule udf
    Executable: /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/bin/mserver5
 Control Group: /user.slice/user-9375.slice/session-20418.scope
          Unit: session-20418.scope
         Slice: user-9375.slice
       Session: 20418
     Owner UID: 9375 (monet)
       Boot ID: c774beee00fc44c0a2bbbcf0adb435d0
    Machine ID: cddf4002c76942fca7082c8a14b6ccfb
      Hostname: lab04.da.cwi.nl
       Storage: /var/lib/systemd/coredump/core.mserver5.9375.c774beee00fc44c0a2bbbcf0adb435d0.4167988.1637880581000000.lz4
       Message: Process 4167988 (mserver5) of user 9375 dumped core.

[New LWP 4168641]
[New LWP 4167995]
[New LWP 4167989]
[New LWP 4167990]
[New LWP 4167999]
[New LWP 4167991]
[New LWP 4167988]
[New LWP 4167997]
[New LWP 4167996]
[New LWP 4167998]
[New LWP 4168003]
[New LWP 4168171]
[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  0x00007f1afbb639e5 in raise () from /lib64/libc.so.6
[Current thread is 1 (Thread 0x7f1acd436640 (LWP 4168641))]

Thread 12 (Thread 0x7f1acd235640 (LWP 4168171)):
#0  0x00007f1afbd030d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007f1afbd031d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007f1afc5075d0 in DFLOWworker () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007f1afc0e25b9 in THRstarter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#4  0x00007f1afc124909 in thread_starter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007f1afbcfa3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#6  0x00007f1afbc274c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 11 (Thread 0x7f1acc2c6640 (LWP 4168003)):
#0  0x00007f1afbbee451 in clock_nanosleep@GLIBC_2.2.5 () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007f1afbbf3997 in nanosleep () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007f1afc12733f in MT_sleep_ms () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00007f1afa32be8d in store_manager () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#4  0x00007f1afc0e25b9 in THRstarter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007f1afc124909 in thread_starter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007f1afbcfa3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007f1afbc274c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 10 (Thread 0x7f1acd838640 (LWP 4167998)):
#0  0x00007f1afbd030d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007f1afbd031d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007f1afc506b28 in q_dequeue () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007f1afc50704d in DFLOWworker () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#4  0x00007f1afc0e25b9 in THRstarter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007f1afc124909 in thread_starter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007f1afbcfa3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007f1afbc274c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 9 (Thread 0x7f1acdc3a640 (LWP 4167996)):
#0  0x00007f1afbd030d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007f1afbd031d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007f1afc506b28 in q_dequeue () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007f1afc50704d in DFLOWworker () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#4  0x00007f1afc0e25b9 in THRstarter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007f1afc124909 in thread_starter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007f1afbcfa3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007f1afbc274c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 8 (Thread 0x7f1acda39640 (LWP 4167997)):
#0  0x00007f1afbd030d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007f1afbd031d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007f1afc506b28 in q_dequeue () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007f1afc50704d in DFLOWworker () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#4  0x00007f1afc0e25b9 in THRstarter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007f1afc124909 in thread_starter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007f1afbcfa3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007f1afbc274c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 7 (Thread 0x7f1afabc88c0 (LWP 4167988)):
#0  0x00007f1afbbee451 in clock_nanosleep@GLIBC_2.2.5 () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007f1afbbf3997 in nanosleep () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007f1afc12733f in MT_sleep_ms () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00000000004037c4 in main ()
No symbol table info available.

Thread 6 (Thread 0x7f1ace03c640 (LWP 4167991)):
#0  0x00007f1afbc1c3ff in poll () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007f1afc5b9d92 in SERVERlistenThread () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#2  0x00007f1afc124909 in thread_starter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00007f1afbcfa3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#4  0x00007f1afbc274c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 5 (Thread 0x7f1acd637640 (LWP 4167999)):
#0  0x00007f1afbd030d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007f1afbd031d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007f1afc5075d0 in DFLOWworker () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007f1afc0e25b9 in THRstarter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#4  0x00007f1afc124909 in thread_starter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007f1afbcfa3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#6  0x00007f1afbc274c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 4 (Thread 0x7f1afa7d0640 (LWP 4167990)):
#0  0x00007f1afbbee451 in clock_nanosleep@GLIBC_2.2.5 () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007f1afbbf3997 in nanosleep () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007f1afc12733f in MT_sleep_ms () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00007f1afc518583 in profilerHeartbeat () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#4  0x00007f1afc124909 in thread_starter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007f1afbcfa3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#6  0x00007f1afbc274c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 3 (Thread 0x7f1afa9d1640 (LWP 4167989)):
#0  0x00007f1afbbee451 in clock_nanosleep@GLIBC_2.2.5 () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007f1afbbf3997 in nanosleep () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007f1afc12733f in MT_sleep_ms () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00007f1afc0d6eba in BBPmanager () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#4  0x00007f1afc0e25b9 in THRstarter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007f1afc124909 in thread_starter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007f1afbcfa3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007f1afbc274c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 2 (Thread 0x7f1acde3b640 (LWP 4167995)):
#0  0x00007f1afbd030d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007f1afbd031d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007f1afc5075d0 in DFLOWworker () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007f1afc0e25b9 in THRstarter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#4  0x00007f1afc124909 in thread_starter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007f1afbcfa3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#6  0x00007f1afbc274c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 1 (Thread 0x7f1acd436640 (LWP 4168641)):
#0  0x00007f1afbb639e5 in raise () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007f1afbb4c8a4 in abort () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007f1afbb4c789 in __assert_fail_base.cold () from /lib64/libc.so.6
No symbol table info available.
#3  0x00007f1afbb5c026 in __assert_fail () from /lib64/libc.so.6
No symbol table info available.
#4  0x00007f1afa270c5e in exp_bin () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#5  0x00007f1afa271a9b in exp_bin () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#6  0x00007f1afa2709cc in exp_bin () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#7  0x00007f1afa27b839 in rel2bin_project () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#8  0x00007f1afa26daf7 in subrel_bin () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#9  0x00007f1afa26e059 in subrel_bin () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#10 0x00007f1afa2796ee in rel2bin_join () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#11 0x00007f1afa26d980 in subrel_bin () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#12 0x00007f1afa27b5c6 in rel2bin_project () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#13 0x00007f1afa26daf7 in subrel_bin () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#14 0x00007f1afa27e266 in output_rel_bin () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#15 0x00007f1afa297b0c in backend_dumpstmt () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#16 0x00007f1afa25c1a2 in SQLparser () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#17 0x00007f1afc51bc46 in runScenario () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#18 0x00007f1afc51c482 in MSserveClient () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#19 0x00007f1afc51cbd3 in MSscheduleClient () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#20 0x00007f1afc5b9304 in doChallenge () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#21 0x00007f1afc0e25b9 in THRstarter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#22 0x00007f1afc124909 in thread_starter () from /export/scratch1/home/monet/testing/4f3d242147a5-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#23 0x00007f1afbcfa3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#24 0x00007f1afbc274c3 in clone () from /lib64/libc.so.6
No symbol table info available.