show_check fails sometimes

[Vlad Lesin]

--echo #
--echo # Bug #48985: show create table crashes if previous access to the table
--echo # was killed
--echo #

connect(con1,localhost,root,,);
CONNECTION con1;
LET $ID= `SELECT connection_id()`;

CONNECTION default;
--disable_query_log
eval KILL QUERY $ID;
--enable_query_log

CONNECTION con1;
--error ER_QUERY_INTERRUPTED
SHOW CREATE TABLE non_existent;
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

In the case if the query is executed before the connection is killed there will be "the table does not exist" error.

Here is an example:
http://jenkins.percona.com/view/PS%205.6/job/percona-server-5.6-param/1062/BUILD_TYPE=release,Host=ubuntu-wily-64bit/testReport/junit/(root)/main/show_check/

CURRENT_TEST: main.show_check
mysqltest: At line 1223: query 'SHOW CREATE TABLE non_existent' failed with wrong errno 1146: 'Table 'test.non_existent' doesn't exist', instead of 1317...

The result from queries just before the failure was:
< snip >
FOR EACH ROW
SET NEW.c1 = 'тест' koi8r koi8r_general_ci latin1_swedish_ci
SHOW CREATE EVENT ev1;
Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
ev1 NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `ev1` ON SCHEDULE AT '2030-01-01 00:00:00' ON COMPLETION NOT PRESERVE ENABLE DO SELECT 'тест' AS test koi8r koi8r_general_ci latin1_swedish_ci
DROP VIEW v1;
DROP PROCEDURE p1;
DROP FUNCTION f1;
DROP TABLE t1;
DROP EVENT ev1;
SHOW STORAGE ENGINES;
CREATE USER test_u@localhost;
GRANT PROCESS ON *.* TO test_u@localhost;
SHOW ENGINE MYISAM MUTEX;
SHOW ENGINE MYISAM STATUS;
DROP USER test_u@localhost;
#
# Bug #48985: show create table crashes if previous access to the table
# was killed
#

[Laurynas Biveinis (laurynas-biveinis)]

Does this affect 5.5 and 5.7? This is upstream, right? Then it has to be reported there.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3351