From 1b4ed7f215fccf47974c7e7f1d212c8921c42e63 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Vicen=C8=9Biu=20Ciorbaru?= Date: Thu, 13 Aug 2020 14:24:04 +0300 Subject: Test if LOCK command works --- mysql-test/main/mysql_json_table_recreate.result | 2 ++ mysql-test/main/mysql_json_table_recreate.test | 3 +++ 2 files changed, 5 insertions(+) diff --git a/mysql-test/main/mysql_json_table_recreate.result b/mysql-test/main/mysql_json_table_recreate.result index 77e8d01b6f4..3dfc6d7a259 100644 --- a/mysql-test/main/mysql_json_table_recreate.result +++ b/mysql-test/main/mysql_json_table_recreate.result @@ -30,6 +30,8 @@ show create table mysql_json_test; ERROR HY000: Table rebuild required. Please do "ALTER TABLE `test.mysql_json_test` FORCE" or dump/reload to fix it! select * from mysql_json_test; ERROR HY000: Table rebuild required. Please do "ALTER TABLE `test.mysql_json_test` FORCE" or dump/reload to fix it! +LOCK TABLES mysql_json_test WRITE; +ERROR HY000: Table rebuild required. Please do "ALTER TABLE `test.mysql_json_test` FORCE" or dump/reload to fix it! alter table mysql_json_test force; select description, expected, actual, expected = actual from mysql_json_test; description expected actual expected = actual diff --git a/mysql-test/main/mysql_json_table_recreate.test b/mysql-test/main/mysql_json_table_recreate.test index dc73a7a0a2f..1762a452cc8 100644 --- a/mysql-test/main/mysql_json_table_recreate.test +++ b/mysql-test/main/mysql_json_table_recreate.test @@ -50,6 +50,9 @@ show create table mysql_json_test; --error ER_TABLE_NEEDS_REBUILD select * from mysql_json_test; +--error ER_TABLE_NEEDS_REBUILD +LOCK TABLES mysql_json_test WRITE; + alter table mysql_json_test force; --sorted_result -- cgit v1.2.1