github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/tests/integration_tests/tidb_mysql_test/r/drop.result (about)

     1  drop table if exists t1;
     2  drop database if exists mysqltest;
     3  drop database if exists client_test_db;
     4  drop table t1;
     5  Error 1051: Unknown table 'drop.t1'
     6  create table t1(n int);
     7  insert into t1 values(1);
     8  create table t1(n int);
     9  Error 1050: Table 'drop.t1' already exists
    10  create database mysqltest;
    11  drop database if exists mysqltest;
    12  create database mysqltest;
    13  create table mysqltest.mysqltest (n int);
    14  insert into mysqltest.mysqltest values (4);
    15  select * from mysqltest.mysqltest;
    16  n
    17  4
    18  drop database if exists mysqltest;
    19  create database mysqltest;
    20  use mysqltest;
    21  drop table table1, table2, table3, table4, table5, table6,
    22  table7, table8, table9, table10, table11, table12, table13,
    23  table14, table15, table16, table17, table18, table19, table20,
    24  table21, table22, table23, table24, table25, table26, table27,
    25  table28;
    26  Error 1051: Unknown table 'mysqltest.table1,mysqltest.table2,mysqltest.table3,mysqltest.table4,mysqltest.table5,mysqltest.table'
    27  drop table table1, table2, table3, table4, table5, table6,
    28  table7, table8, table9, table10, table11, table12, table13,
    29  table14, table15, table16, table17, table18, table19, table20,
    30  table21, table22, table23, table24, table25, table26, table27,
    31  table28, table29, table30;
    32  Error 1051: Unknown table 'mysqltest.table1,mysqltest.table2,mysqltest.table3,mysqltest.table4,mysqltest.table5,mysqltest.table'
    33  use test;
    34  drop database mysqltest;
    35  drop database if exists mysqltest;
    36  drop table if exists t1;
    37  create table t1 (i int);
    38  create database mysqltest;
    39  lock tables t1 read;
    40  show open tables;
    41  Database	Table	In_use	Name_locked
    42  select 1;
    43  1
    44  1
    45  unlock tables;
    46  End of 5.0 tests
    47  
    48  create database mysqltestbug26703;
    49  use mysqltestbug26703;
    50  create table `#mysql50#abc``def` ( id int );
    51  create table `aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa` (a int);
    52  Error 1059: Identifier name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' is too long
    53  create table `aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa` (a int);
    54  create table `#mysql50#aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa` (a int);
    55  create table `#mysql50#aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa` (a int);
    56  Error 1059: Identifier name '#mysql50#aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' is too long
    57  use test;
    58  End of 5.1 tests
    59  
    60  # --
    61  # -- Bug#37431 (DROP TABLE does not report errors correctly).
    62  # --
    63  DROP TABLE IF EXISTS t1;
    64  DROP TABLE t1;
    65  Error 1051: Unknown table 'test.t1'
    66  SHOW WARNINGS;
    67  Level	Code	Message
    68  
    69  # --
    70  # -- End of Bug#37431.
    71  # --
    72  #
    73  # Bug#54282 Crash in MDL_context::upgrade_shared_lock_to_exclusive
    74  #
    75  #
    76  # BUG#34750: Print database name in Unknown Table error message
    77  #
    78  
    79  # Test error message when droping table/view
    80  DROP TABLE table1;
    81  Error 1051: Unknown table 'test.table1'
    82  DROP TABLE table1,table2;
    83  Error 1051: Unknown table 'test.table1,test.table2'
    84  DROP VIEW view1,view2,view3,view4;
    85  Error 1051: Unknown table 'test.view1,test.view2,test.view3,test.view4'
    86  
    87  DROP TABLE IF EXISTS table1;
    88  DROP TABLE IF EXISTS table1,table2;
    89  DROP VIEW IF EXISTS view1,view2,view3,view4;
    90  
    91  # Test error message when trigger does not find table
    92  CREATE DATABASE bug19573998;
    93  # Verify that it is possible to drop the database
    94  DROP DATABASE bug19573998;
    95  USE test;
    96  # End Bug#19573998