diff options
| author | Vicențiu Ciorbaru <vicentiu@mariadb.org> | 2020-08-13 14:24:04 +0300 |
|---|---|---|
| committer | Vicențiu Ciorbaru <vicentiu@mariadb.org> | 2020-08-13 14:24:20 +0300 |
| commit | 1b4ed7f215fccf47974c7e7f1d212c8921c42e63 (patch) | |
| tree | 944dfab02b1656bab21d42f6b7158763cfff095b | |
| parent | 8f3f8ff30cf478d72a3a881899932713a223fe49 (diff) | |
| download | mariadb-git-bb-10.3-vicentiu-json-review.tar.gz | |
Test if LOCK command worksbb-10.3-vicentiu-json-review
| -rw-r--r-- | mysql-test/main/mysql_json_table_recreate.result | 2 | ||||
| -rw-r--r-- | mysql-test/main/mysql_json_table_recreate.test | 3 |
2 files changed, 5 insertions, 0 deletions
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 |