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: 3653140 (mserver5)
           UID: 9375 (monet)
           GID: 60020 (da)
        Signal: 6 (ABRT)
     Timestamp: Wed 2021-11-24 23:48:00 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-3642145/.s.monetdb.${PORT} --forcemito --dbpath=/export/scratch1/home/monet/testing/2075952d1dc8-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/2075952d1dc8-3-1-1/install/bin/mserver5
 Control Group: /user.slice/user-9375.slice/session-20118.scope
          Unit: session-20118.scope
         Slice: user-9375.slice
       Session: 20118
     Owner UID: 9375 (monet)
       Boot ID: c774beee00fc44c0a2bbbcf0adb435d0
    Machine ID: cddf4002c76942fca7082c8a14b6ccfb
      Hostname: lab04.da.cwi.nl
       Storage: /var/lib/systemd/coredump/core.mserver5.9375.c774beee00fc44c0a2bbbcf0adb435d0.3653140.1637794080000000.lz4
       Message: Process 3653140 (mserver5) of user 9375 dumped core.

[New LWP 3653789]
[New LWP 3653141]
[New LWP 3653143]
[New LWP 3653140]
[New LWP 3653151]
[New LWP 3653142]
[New LWP 3653150]
[New LWP 3653155]
[New LWP 3653148]
[New LWP 3653147]
[New LWP 3653149]
[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  0x00007fd27d5d99e5 in raise () from /lib64/libc.so.6
[Current thread is 1 (Thread 0x7fd24eead640 (LWP 3653789))]

Thread 11 (Thread 0x7fd24f4b0640 (LWP 3653149)):
#0  0x00007fd27d7790d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007fd27d7791d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007fd27df7cb38 in q_dequeue () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007fd27df7d05d in DFLOWworker () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#4  0x00007fd27db585b9 in THRstarter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007fd27db9b129 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007fd27d7703f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007fd27d69d4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 10 (Thread 0x7fd24f8b2640 (LWP 3653147)):
#0  0x00007fd27d7790d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007fd27d7791d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007fd27df7cb38 in q_dequeue () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007fd27df7d05d in DFLOWworker () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#4  0x00007fd27db585b9 in THRstarter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007fd27db9b129 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007fd27d7703f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007fd27d69d4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 9 (Thread 0x7fd24f6b1640 (LWP 3653148)):
#0  0x00007fd27d7790d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007fd27d7791d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007fd27df7cb38 in q_dequeue () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007fd27df7d05d in DFLOWworker () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#4  0x00007fd27db585b9 in THRstarter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007fd27db9b129 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007fd27d7703f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007fd27d69d4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 8 (Thread 0x7fd22fb6d640 (LWP 3653155)):
#0  0x00007fd27d664451 in clock_nanosleep@GLIBC_2.2.5 () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007fd27d669997 in nanosleep () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007fd27db9db5f in MT_sleep_ms () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00007fd27bda279d in store_manager () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#4  0x00007fd27db585b9 in THRstarter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007fd27db9b129 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007fd27d7703f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007fd27d69d4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 7 (Thread 0x7fd24f2af640 (LWP 3653150)):
#0  0x00007fd27d7790d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007fd27d7791d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007fd27df7d5e0 in DFLOWworker () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007fd27db585b9 in THRstarter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#4  0x00007fd27db9b129 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007fd27d7703f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#6  0x00007fd27d69d4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 6 (Thread 0x7fd27c246640 (LWP 3653142)):
#0  0x00007fd27d664451 in clock_nanosleep@GLIBC_2.2.5 () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007fd27d669997 in nanosleep () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007fd27db9db5f in MT_sleep_ms () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00007fd27df8e583 in profilerHeartbeat () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#4  0x00007fd27db9b129 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007fd27d7703f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#6  0x00007fd27d69d4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 5 (Thread 0x7fd24f0ae640 (LWP 3653151)):
#0  0x00007fd27d7790d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007fd27d7791d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007fd27df7d5e0 in DFLOWworker () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007fd27db585b9 in THRstarter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#4  0x00007fd27db9b129 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007fd27d7703f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#6  0x00007fd27d69d4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 4 (Thread 0x7fd27c63e8c0 (LWP 3653140)):
#0  0x00007fd27d664451 in clock_nanosleep@GLIBC_2.2.5 () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007fd27d669997 in nanosleep () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007fd27db9db5f in MT_sleep_ms () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00000000004037c4 in main ()
No symbol table info available.

Thread 3 (Thread 0x7fd24fab3640 (LWP 3653143)):
#0  0x00007fd27d6923ff in poll () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007fd27e02fd92 in SERVERlistenThread () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#2  0x00007fd27db9b129 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00007fd27d7703f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#4  0x00007fd27d69d4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 2 (Thread 0x7fd27c447640 (LWP 3653141)):
#0  0x00007fd27d664451 in clock_nanosleep@GLIBC_2.2.5 () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007fd27d669997 in nanosleep () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007fd27db9db5f in MT_sleep_ms () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00007fd27db4ceba in BBPmanager () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#4  0x00007fd27db585b9 in THRstarter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007fd27db9b129 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007fd27d7703f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007fd27d69d4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 1 (Thread 0x7fd24eead640 (LWP 3653789)):
#0  0x00007fd27d5d99e5 in raise () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007fd27d5c28a4 in abort () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007fd27d5c2789 in __assert_fail_base.cold () from /lib64/libc.so.6
No symbol table info available.
#3  0x00007fd27d5d2026 in __assert_fail () from /lib64/libc.so.6
No symbol table info available.
#4  0x00007fd27bce6eae in exp_bin () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#5  0x00007fd27bce7ceb in exp_bin () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#6  0x00007fd27bce6c1c in exp_bin () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#7  0x00007fd27bcf1a89 in rel2bin_project () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#8  0x00007fd27bce3d47 in subrel_bin () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#9  0x00007fd27bce42a9 in subrel_bin () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#10 0x00007fd27bcef93e in rel2bin_join () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#11 0x00007fd27bce3bd0 in subrel_bin () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#12 0x00007fd27bcf1816 in rel2bin_project () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#13 0x00007fd27bce3d47 in subrel_bin () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#14 0x00007fd27bcf4bd6 in output_rel_bin () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#15 0x00007fd27bd0e58c in backend_dumpstmt () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#16 0x00007fd27bcd23f2 in SQLparser () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#17 0x00007fd27df91c46 in runScenario () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#18 0x00007fd27df92482 in MSserveClient () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#19 0x00007fd27df92bd3 in MSscheduleClient () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#20 0x00007fd27e02f304 in doChallenge () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#21 0x00007fd27db585b9 in THRstarter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#22 0x00007fd27db9b129 in thread_starter () from /export/scratch1/home/monet/testing/2075952d1dc8-3-1-1/install/lib64/libbat.so.23
No symbol table info available.
#23 0x00007fd27d7703f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#24 0x00007fd27d69d4c3 in clone () from /lib64/libc.so.6
No symbol table info available.