CREATE TABLE t1 (b BLOB, vb BLOB AS (b) VIRTUAL);

INSERT INTO t1 (b) VALUES ('foobar');

SELECT 'foo' AS f1, CONVERT( 'bar' USING latin1 ) AS f2 FROM t1

  UNION

SELECT b AS f1, CONVERT( vb USING latin1 ) AS f2 FROM t1

;

# Cleanup

DROP TABLE t1;

2018-10-18  6:32:17 16 [ERROR] mysqld: Table '/home/travis/logs/vardir/tmp/#sql_5632_4' is marked as crashed and should be repaired

mysqld: /home/travis/src/storage/maria/ma_open.c:1379: _ma_state_info_write: Assertion `(&(&share->intern_lock)->m_mutex)->count > 0 && pthread_equal(pthread_self(), (&(&share->intern_lock)->m_mutex)->thread)' failed.

181018  6:32:17 [ERROR] mysqld got signal 6 ;

#7  0x00007fe48d64cca2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6

#8  0x000055a86e71f95e in _ma_state_info_write (share=0x55a872307c80, pWrite=1) at /home/travis/src/storage/maria/ma_open.c:1379

#9  0x000055a86e7643ee in maria_close (info=0x55a872308e80) at /home/travis/src/storage/maria/ma_close.c:148

#10 0x000055a86e6dac6e in ha_maria::close (this=0x55a8722b9428) at /home/travis/src/storage/maria/ha_maria.cc:1275

#11 0x000055a86e102eae in handler::ha_close (this=0x55a8722b9428) at /home/travis/src/sql/handler.cc:2751

#12 0x000055a86e6df288 in ha_maria::drop_table (this=0x55a8722b9428, name=0x55a872307380 "/home/travis/logs/vardir/tmp/#sql_5632_4") at /home/travis/src/storage/maria/ha_maria.cc:2697

#13 0x000055a86e108194 in handler::ha_drop_table (this=0x55a8722b9428, name=0x55a872307380 "/home/travis/logs/vardir/tmp/#sql_5632_4") at /home/travis/src/sql/handler.cc:4579

#14 0x000055a86de7933f in free_tmp_table (thd=0x55a871ed1ed0, entry=0x55a872305f38) at /home/travis/src/sql/sql_select.cc:18605

#15 0x000055a86defc3e2 in st_select_lex_unit::cleanup (this=0x55a871ed5d80) at /home/travis/src/sql/sql_union.cc:1876

#16 0x000055a86def5bd8 in mysql_union (thd=0x55a871ed1ed0, lex=0x55a871ed5cb8, result=0x55a8722c5ff0, unit=0x55a871ed5d80, setup_tables_done_option=0) at /home/travis/src/sql/sql_union.cc:42

#17 0x000055a86de452d5 in handle_select (thd=0x55a871ed1ed0, lex=0x55a871ed5cb8, result=0x55a8722c5ff0, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:360

#18 0x000055a86de0fc5d in execute_sqlcom_select (thd=0x55a871ed1ed0, all_tables=0x55a871ee5028) at /home/travis/src/sql/sql_parse.cc:6547

#19 0x000055a86de062cf in mysql_execute_command (thd=0x55a871ed1ed0) at /home/travis/src/sql/sql_parse.cc:3769

#20 0x000055a86de13bea in mysql_parse (thd=0x55a871ed1ed0, rawbuf=0x55a871ee4148 "/* GenTest::Transform::ExecuteAsIntersect */ (  SELECT DISTINCT UpdateXML( '01:10:09.003094', '/bed/dbecbcebaa/decce', NULL ) AS field1, CONVERT( ( IF( `pk`, 'g', `vcol_blob` ) ) USING latin1 ) AS fie"..., length=555, parser_state=0x7fe48c0b9600, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:8091

#21 0x000055a86de00dfa in dispatch_command (command=COM_QUERY, thd=0x55a871ed1ed0, packet=0x55a871edba11 "/* GenTest::Transform::ExecuteAsIntersect */ (  SELECT DISTINCT UpdateXML( '01:10:09.003094', '/bed/dbecbcebaa/decce', NULL ) AS field1, CONVERT( ( IF( `pk`, 'g', `vcol_blob` ) ) USING latin1 ) AS fie"..., packet_length=556, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1850

#22 0x000055a86ddff82b in do_command (thd=0x55a871ed1ed0) at /home/travis/src/sql/sql_parse.cc:1395

#23 0x000055a86df6804a in do_handle_one_connection (connect=0x55a871df8df0) at /home/travis/src/sql/sql_connect.cc:1402

#24 0x000055a86df67dce in handle_one_connection (arg=0x55a871df8df0) at /home/travis/src/sql/sql_connect.cc:1308

#25 0x00007fe48e20e184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0

#26 0x00007fe48d71affd in clone () from /lib/x86_64-linux-gnu/libc.so.6

mysqltest: At line 4: query 'SELECT 'foo' AS f1, CONVERT( 'bar' USING latin1 ) AS f2 FROM t1

UNION

SELECT b AS f1, CONVERT( vb USING latin1 ) AS f2 FROM t1

' failed: 1194: Table '/dev/shm/var/tmp/mysqld.1/#sql_2a71_0' is marked as crashed and should be repaired