main.subselect fails in buildbot with --ps-protocol

main.subselect                           w2 [ fail ]

        Test ended at 2021-02-01 04:23:35

CURRENT_TEST: main.subselect

/mnt/buildbot/build/mariadb-10.2.37/client/mysqltest: Error on delete of '/mnt/buildbot/build/mariadb-10.2.37/mysql-test/var/2/tmp/subselect.out.file.1' (Errcode: 2 "No such file or directory")

mysqltest: At line 5898: query 'select exists(select 1 from t1 group by `c` in (select `c` from t1))' failed: 2013: Lost connection to MySQL server during query

Core was generated by `/mnt/buildbot/build/mariadb-10.2.37/sql/mysqld --defaults-group-suffix=.1 --def'.

Program terminated with signal SIGABRT, Aborted.

#0  0xb7754c31 in __kernel_vsyscall ()

[Current thread is 1 (Thread 0xb0dfeb40 (LWP 1365))]

#0  0xb7754c31 in __kernel_vsyscall ()

#1  0xb73b3ce1 in pthread_kill () from /lib/i386-linux-gnu/libpthread.so.0

#2  0x80d5392d in my_write_core (sig=6) at /home/buildbot/buildbot/build/mariadb-10.2.37/mysys/stacktrace.c:382

#3  0x8064888a in handle_fatal_signal (sig=6) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/signal_handler.cc:343

#4  <signal handler called>

#5  0xb7754c31 in __kernel_vsyscall ()

#6  0xb7032e89 in raise () from /lib/i386-linux-gnu/libc.so.6

#7  0xb70343e7 in abort () from /lib/i386-linux-gnu/libc.so.6

#8  0xb702bd07 in ?? () from /lib/i386-linux-gnu/libc.so.6

#9  0xb702bd8b in __assert_fail () from /lib/i386-linux-gnu/libc.so.6

#10 0x8040ac27 in reinit_stmt_before_use (thd=0xb06005d0, lex=0xb0655970) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_prepare.cc:3097

#11 0x8040f039 in Prepared_statement::execute (this=0xb041ffc0, expanded_query=0xb0dfd9bc, open_cursor=false) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_prepare.cc:5012

#12 0x8040d90c in Prepared_statement::execute_loop (this=0xb041ffc0, expanded_query=0xb0dfd9bc, open_cursor=false, packet=0xb0605a52 "", packet_end=0xb0605a52 "") at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_prepare.cc:4466

#13 0x8040b642 in mysql_stmt_execute_common (thd=0xb06005d0, stmt_id=2250, packet=0xb0605a52 "", packet_end=0xb0605a52 "", cursor_flags=0, bulk_op=false, read_types=false) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_prepare.cc:3468

#14 0x8040b09d in mysqld_stmt_execute (thd=0xb06005d0, packet_arg=0xb0605a49 "\312\b", packet_length=9) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_prepare.cc:3259

#15 0x803e0e7b in dispatch_command (command=COM_STMT_EXECUTE, thd=0xb06005d0, packet=0xb0605a49 "\312\b", packet_length=9, is_com_multi=false, is_next_command=false) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_parse.cc:1770

#16 0x803dfbc6 in do_command (thd=0xb06005d0) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_parse.cc:1382

#17 0x805243ec in do_handle_one_connection (connect=0x832ba6e8) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_connect.cc:1336

#18 0x8052414c in handle_one_connection (arg=0x832ba6e8) at /home/buildbot/buildbot/build/mariadb-10.2.37/sql/sql_connect.cc:1241

#19 0x8084a8f8 in pfs_spawn_thread (arg=0x832f4748) at /home/buildbot/buildbot/build/mariadb-10.2.37/storage/perfschema/pfs.cc:1869

#20 0xb73ad2b5 in start_thread () from /lib/i386-linux-gnu/libpthread.so.0

#21 0xb70ee16e in clone () from /lib/i386-linux-gnu/libc.so.6

commit 26f5033555a9bb33d3d8b68e2d766e274bec28ba (origin/bb-10.2-varun)

Author: Varun Gupta <varun.gupta@mariadb.com>

Date:   Sun Jan 31 19:55:07 2021 +0530

    MDEV-23449: alias do not exist and a query do not report an error