diff options
| author | Sergey Vojtovich <svoj@mariadb.org> | 2020-02-27 18:04:06 +0400 |
|---|---|---|
| committer | Sergey Vojtovich <svoj@mariadb.org> | 2020-02-27 18:12:47 +0400 |
| commit | a346ff353e4909f96b6cdf1c997cd168b59b004f (patch) | |
| tree | 112e218c15e8ede21a3b48ba6bfc6451ba35b34f /mysql-test/main/func_misc.test | |
| parent | 127fee998f7275485aeca91ad82030e6f796d809 (diff) | |
| download | mariadb-git-a346ff353e4909f96b6cdf1c997cd168b59b004f.tar.gz | |
cleanup trailing ws
Diffstat (limited to 'mysql-test/main/func_misc.test')
| -rw-r--r-- | mysql-test/main/func_misc.test | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/mysql-test/main/func_misc.test b/mysql-test/main/func_misc.test index 951553705ab..a471d224677 100644 --- a/mysql-test/main/func_misc.test +++ b/mysql-test/main/func_misc.test @@ -1280,8 +1280,8 @@ DROP TABLE t1; --echo # --echo # ---echo # MDEV-10569 Add RELEASE_ALL_LOCKS SQL-function ---echo # +--echo # MDEV-10569 Add RELEASE_ALL_LOCKS SQL-function +--echo # --echo # Test function without any locks SELECT RELEASE_ALL_LOCKS(); @@ -1289,9 +1289,9 @@ SELECT RELEASE_ALL_LOCKS(); --echo # Test function with one lock only SELECT GET_LOCK('l1',10); SELECT RELEASE_ALL_LOCKS(); -SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA +SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA FROM information_schema.metadata_lock_info WHERE thread_id>0 ORDER BY TABLE_SCHEMA; - + --echo # Test function with multiple locks SELECT GET_LOCK('l01',10), GET_LOCK('l02',10), @@ -1307,11 +1307,11 @@ SELECT GET_LOCK('l01',10), GET_LOCK('l12',10), GET_LOCK('l13',10), GET_LOCK('l14',10), - GET_LOCK('l15',10); -SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA + GET_LOCK('l15',10); +SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA FROM information_schema.metadata_lock_info WHERE thread_id>0 ORDER BY TABLE_SCHEMA; SELECT RELEASE_ALL_LOCKS(); -SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA +SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA FROM information_schema.metadata_lock_info WHERE thread_id>0 ORDER BY TABLE_SCHEMA; --echo # Test function with recursive locks @@ -1329,9 +1329,9 @@ SELECT GET_LOCK('l1',10), GET_LOCK('l5',10), GET_LOCK('l5',10), GET_LOCK('l5',10), - GET_LOCK('l5',10); -SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA + GET_LOCK('l5',10); +SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA FROM information_schema.metadata_lock_info WHERE thread_id>0 ORDER BY TABLE_SCHEMA; SELECT RELEASE_ALL_LOCKS(); -SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA -FROM information_schema.metadata_lock_info WHERE thread_id>0 ORDER BY TABLE_SCHEMA;
\ No newline at end of file +SELECT LOCK_MODE, LOCK_TYPE, TABLE_SCHEMA +FROM information_schema.metadata_lock_info WHERE thread_id>0 ORDER BY TABLE_SCHEMA; |