statement was expected to fail with, error message GDK reported error: BATsubcross: more than one match
TypeException:user.main[147]:'algebra.join' undefined in:     (X_0:any, X_1:any) := algebra.join(X_2:bat[:bte], X_3:bat[:int], nil:BAT, nil:BAT, true:bit, nil:lng);
query started on line 61 of file batappend-undefined.Bug-7130.test
query text:
select EXISTS(select 1 from t_qh left outer join (select cast(2 as INTEGER) from t_qh) as subq_0(c1) on true <> EXISTS(select 1 from t_qh as ref_6 where 2 <
(select subq_0.c1 as c0 from t_qh where (1 <> ref_6.c_f) or (subq_0.c1 is NULL)))) from (select 30 from t_qh) as subq_0(c1)

Server may have crashed
Server closed connection
query started on line 65 of file batappend-undefined.Bug-7130.test
query text:
select EXISTS(select 1 from t_qh left outer join (select cast(2 as INTEGER) from t_qh) as subq_0(c1) on 2 <> (select 1 from t_qh where EXISTS(select 3 as c0 from t_qh as ref_6 where 2 <
(select subq_0.c1 as c0 from t_qh where (1 <> ref_6.c_f) or (subq_0.c1 is NULL))))) from (select 30 from t_qh) as subq_0(c1)

Server may have crashed
[Errno 32] Broken pipe
query started on line 69 of file batappend-undefined.Bug-7130.test
query text:
drop table t_qh cascade


Aborted
           PID: 54276 (mserver5)
           UID: 9375 (monet)
           GID: 60020 (da)
        Signal: 6 (ABRT)
     Timestamp: Wed 2021-10-13 02:05:48 CEST (12s ago)
  Command Line: mserver5 --debug=10 --set gdk_nr_threads 0 --set mapi_listenaddr all --set mapi_port 0 --set mapi_usock /tmp/mtest-44116/.s.monetdb.${PORT} --forcemito --dbpath=/export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/tests/sql/dbfarm/mTests_sql_test_BugTracker-2021 --set gdk_use_strimps yes --set gdk_vm_maxsize 8589934592 --set embedded_py 3 --dbextra=/export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/tests/sql/dbfarm/mTests_transient
    Executable: /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/bin/mserver5
 Control Group: /user.slice/user-9375.slice/session-20651.scope
          Unit: session-20651.scope
         Slice: user-9375.slice
       Session: 20651
     Owner UID: 9375 (monet)
       Boot ID: f6574743b28148169aca4bd1274f98c3
    Machine ID: 1f4194aaa0f646ea93c51854757f1d73
      Hostname: lab01.da.cwi.nl
       Storage: /var/lib/systemd/coredump/core.mserver5.9375.f6574743b28148169aca4bd1274f98c3.54276.1634083548000000.lz4
       Message: Process 54276 (mserver5) of user 9375 dumped core.

[New LWP 54428]
[New LWP 54278]
[New LWP 54276]
[New LWP 54287]
[New LWP 54279]
[New LWP 54291]
[New LWP 54283]
[New LWP 54277]
[New LWP 54285]
[New LWP 54284]
[New LWP 54286]
[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  0x00007ff4c58679e5 in raise () from /lib64/libc.so.6
[Current thread is 1 (Thread 0x7ff495c4e640 (LWP 54428))]

Thread 11 (Thread 0x7ff496050640 (LWP 54286)):
#0  0x00007ff4c5a070d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007ff4c5a071d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007ff4c678feb8 in q_dequeue () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007ff4c67904be in DFLOWworker () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#4  0x00007ff4c6042065 in THRstarter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007ff4c60b2c09 in thread_starter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007ff4c59fe3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007ff4c592b4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 10 (Thread 0x7ff496452640 (LWP 54284)):
#0  0x00007ff4c5a070d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007ff4c5a071d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007ff4c678feb8 in q_dequeue () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007ff4c67904be in DFLOWworker () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#4  0x00007ff4c6042065 in THRstarter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007ff4c60b2c09 in thread_starter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007ff4c59fe3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007ff4c592b4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 9 (Thread 0x7ff496251640 (LWP 54285)):
#0  0x00007ff4c5a070d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007ff4c5a071d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007ff4c6790d90 in DFLOWworker () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007ff4c6042065 in THRstarter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#4  0x00007ff4c60b2c09 in thread_starter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007ff4c59fe3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#6  0x00007ff4c592b4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 8 (Thread 0x7ff4c46aa640 (LWP 54277)):
#0  0x00007ff4c58f2451 in clock_nanosleep@GLIBC_2.2.5 () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007ff4c58f7997 in nanosleep () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007ff4c60b6b92 in MT_sleep_ms () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00007ff4c603667a in BBPmanager () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#4  0x00007ff4c6042065 in THRstarter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007ff4c60b2c09 in thread_starter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007ff4c59fe3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007ff4c592b4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 7 (Thread 0x7ff496653640 (LWP 54283)):
#0  0x00007ff4c5a070d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007ff4c5a071d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007ff4c678feb8 in q_dequeue () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007ff4c67904be in DFLOWworker () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#4  0x00007ff4c6042065 in THRstarter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007ff4c60b2c09 in thread_starter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007ff4c59fe3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#7  0x00007ff4c592b4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 6 (Thread 0x7ff47c924640 (LWP 54291)):
#0  0x00007ff4c58f2451 in clock_nanosleep@GLIBC_2.2.5 () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007ff4c58f7997 in nanosleep () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007ff4c60b6b92 in MT_sleep_ms () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00007ff4c3ebc389 in store_manager () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#4  0x00007ff4c3f2f531 in mvc_logmanager () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#5  0x00007ff4c6042065 in THRstarter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#6  0x00007ff4c60b2c09 in thread_starter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#7  0x00007ff4c59fe3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#8  0x00007ff4c592b4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 5 (Thread 0x7ff49775d640 (LWP 54279)):
#0  0x00007ff4c59203ff in poll () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007ff4c688f664 in SERVERlistenThread () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#2  0x00007ff4c60b2c09 in thread_starter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00007ff4c59fe3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#4  0x00007ff4c592b4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 4 (Thread 0x7ff495e4f640 (LWP 54287)):
#0  0x00007ff4c5a070d4 in do_futex_wait.constprop () from /lib64/libpthread.so.0
No symbol table info available.
#1  0x00007ff4c5a071d8 in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0
No symbol table info available.
#2  0x00007ff4c6790d90 in DFLOWworker () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#3  0x00007ff4c6042065 in THRstarter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#4  0x00007ff4c60b2c09 in thread_starter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007ff4c59fe3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#6  0x00007ff4c592b4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 3 (Thread 0x7ff4c48a18c0 (LWP 54276)):
#0  0x00007ff4c58f2451 in clock_nanosleep@GLIBC_2.2.5 () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007ff4c58f7997 in nanosleep () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007ff4c60b6b92 in MT_sleep_ms () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x000000000040428e in main ()
No symbol table info available.

Thread 2 (Thread 0x7ff4c44a9640 (LWP 54278)):
#0  0x00007ff4c58f2451 in clock_nanosleep@GLIBC_2.2.5 () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007ff4c58f7997 in nanosleep () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007ff4c60b6b92 in MT_sleep_ms () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#3  0x00007ff4c67aaf5d in profilerHeartbeat () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#4  0x00007ff4c60b2c09 in thread_starter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#5  0x00007ff4c59fe3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#6  0x00007ff4c592b4c3 in clone () from /lib64/libc.so.6
No symbol table info available.

Thread 1 (Thread 0x7ff495c4e640 (LWP 54428)):
#0  0x00007ff4c58679e5 in raise () from /lib64/libc.so.6
No symbol table info available.
#1  0x00007ff4c58508a4 in abort () from /lib64/libc.so.6
No symbol table info available.
#2  0x00007ff4c5850789 in __assert_fail_base.cold () from /lib64/libc.so.6
No symbol table info available.
#3  0x00007ff4c5860026 in __assert_fail () from /lib64/libc.so.6
No symbol table info available.
#4  0x00007ff4c3dd90b9 in rel2bin_join () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#5  0x00007ff4c3dc9b86 in subrel_bin () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#6  0x00007ff4c3dd44de in rel2bin_project () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#7  0x00007ff4c3dca4f0 in subrel_bin () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#8  0x00007ff4c3dca26f in subrel_bin () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#9  0x00007ff4c3dd364d in rel2bin_groupby () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#10 0x00007ff4c3dc9f3d in subrel_bin () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#11 0x00007ff4c3dd44de in rel2bin_project () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#12 0x00007ff4c3dca4f0 in subrel_bin () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#13 0x00007ff4c3dd83be in rel2bin_join () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#14 0x00007ff4c3dc9b86 in subrel_bin () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#15 0x00007ff4c3dd44de in rel2bin_project () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#16 0x00007ff4c3dca4f0 in subrel_bin () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#17 0x00007ff4c3dda926 in output_rel_bin () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#18 0x00007ff4c3dffaa4 in backend_dumpstmt () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#19 0x00007ff4c3daacd1 in SQLparser () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdbsql.so.11
No symbol table info available.
#20 0x00007ff4c67aee94 in runPhase () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#21 0x00007ff4c67afda6 in runScenario () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#22 0x00007ff4c67b098a in MSserveClient () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#23 0x00007ff4c67b1293 in MSscheduleClient () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#24 0x00007ff4c688ef64 in doChallenge () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libmonetdb5.so.31
No symbol table info available.
#25 0x00007ff4c6042065 in THRstarter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#26 0x00007ff4c60b2c09 in thread_starter () from /export/scratch1/home/monet/testing/b50e8e2d6f02-1-1-1/install/lib64/libbat.so.23
No symbol table info available.
#27 0x00007ff4c59fe3f9 in start_thread () from /lib64/libpthread.so.0
No symbol table info available.
#28 0x00007ff4c592b4c3 in clone () from /lib64/libc.so.6
No symbol table info available.