github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/keyword/ReservedKeyword.sql (about)

     1  drop database if exists test;
     2  create database test;
     3  
     4  drop table if exists `_binary`;
     5  create table `_binary` (`add` int, `all` bigint, `alter` smallint, `analyze` decimal, `and` char, `as` varchar, `asc` int, `begin` float);
     6  show create table `_binary`;
     7  drop table `_binary`;
     8  
     9  drop table if exists `between`;
    10  create table `between` (`binary` int, `both` bigint, `by` smallint, `call` decimal, `case` char, `change` varchar, `char` int, `character` float);
    11  show create table `between`;
    12  drop table `between`;
    13  
    14  drop table if exists `check`;
    15  create table `check` (`collate` int, `column` bigint, `config` decimal, `constraint` char, `convert` varchar, `create` int, `cross` float);
    16  show create table `check`;
    17  drop table `check`;
    18  
    19  drop table if exists `current_date`;
    20  create table `current_date` (`current_role` int, `current_time` bigint, `current_timestamp` smallint, `current_user` decimal, `database` char, `databases` varchar, `day_hour` int, `day_microsecond` float);
    21  show create table `current_date`;
    22  drop table `current_date`;
    23  
    24  drop table if exists `day_minute`;
    25  create table `day_minute` (`day_second` int, `declare` bigint, `default` smallint, `delayed` decimal, `delete` char, `dense_rank` varchar, `desc` int, `describe` float);
    26  show create table `day_minute`;
    27  drop table `day_minute`;
    28  
    29  drop table if exists `distinct`;
    30  create table `distinct` (`div` int, `drop` bigint, `else` smallint, `elseif` decimal, `enclosed` char, `end` varchar, `escape` int, `escaped` float);
    31  show create table `distinct`;
    32  drop table `distinct`;
    33  
    34  drop table if exists `except`;
    35  create table `except` (`exists` int, `explain` bigint, `false` smallint, `for` decimal, `force` char, `foreign` varchar, `from` int, `fulltext` float);
    36  show create table `except`;
    37  drop table `except`;
    38  
    39  drop table if exists `function`;
    40  create table `function` (`group` int, `groups` bigint, `having` smallint, `high_priority` decimal, `hour_microsecond` char, `hour_minute` varchar, `hour_second` int, `if` float);
    41  show create table `function`;
    42  drop table `function`;
    43  
    44  drop table if exists `ignore`;
    45  create table `ignore` (`ilike` int, `in` bigint, `index` smallint, `infile` decimal, `inner` char, `inout` varchar, `insert` int, `int1` float);
    46  show create table `ignore`;
    47  drop table `ignore`;
    48  
    49  drop table if exists `int2`;
    50  create table `int2` (`int3` int, `int4` bigint, `int8` smallint, `intersect` decimal, `interval` char, `into` varchar, `is` int, `iterate` float);
    51  show create table `int2`;
    52  drop table `int2`;
    53  
    54  drop table if exists `join`;
    55  create table `join` (`key` int, `kill` bigint, `leading` smallint, `leave` decimal, `left` char, `like` varchar, `limit` int, `lines` float);
    56  show create table `join`;
    57  drop table `join`;
    58  
    59  drop table if exists `load`;
    60  create table `load` (`localtime` int, `localtimestamp` bigint, `lock` smallint, `loop` decimal, `low_priority` char, `match` varchar, `maxvalue` int, `minus` float);
    61  show create table `load`;
    62  drop table `load`;
    63  
    64  drop table if exists `minute_microsecond`;
    65  create table `minute_microsecond` (`minute_second` int, `mod` bigint, `natural` smallint, `not` decimal, `null` char, `on` varchar, `optionally` int, `or` float);
    66  show create table `minute_microsecond`;
    67  drop table `minute_microsecond`;
    68  
    69  drop table if exists `order`;
    70  create table `order` (`out` int, `outer` bigint, `outfile` smallint, `over` decimal, `partition` char, `primary` varchar, `quick` int, `rank` float);
    71  show create table `order`;
    72  drop table `order`;
    73  
    74  drop table if exists `recursive`;
    75  create table `recursive` (`references` int, `regexp` bigint, `reindex` smallint, `rename` decimal, `repeat` char, `replace` varchar, `require` int, `right` float);
    76  show create table `recursive`;
    77  drop table `recursive`;
    78  
    79  drop table if exists `rlike`;
    80  create table `rlike` (`row` int, `row_number` bigint, `rows` smallint, `schema` decimal, `schemas` char, `second_microsecond` varchar, `select` int, `separator` float);
    81  show create table `rlike`;
    82  drop table `rlike`;
    83  
    84  drop table if exists `set`;
    85  create table `set` (`show` int, `sql_big_result` bigint, `sql_buffer_result` smallint, `sql_small_result` decimal, `ssl` char, `starting` varchar, `straight_join` int, `table` float);
    86  show create table `set`;
    87  drop table `set`;
    88  
    89  drop table if exists `temporary`;
    90  create table `temporary` (`terminated` int, `then` bigint, `to` smallint, `trailing` decimal, `true` char, `union` varchar, `unique` int, `until` float);
    91  show create table `temporary`;
    92  drop table `temporary`;
    93  
    94  drop table if exists `update`;
    95  create table `update` (`usage` int, `use` bigint, `using` smallint, `utc_date` decimal, `utc_time` char, `utc_timestamp` varchar, `values` int, `when` float);
    96  show create table `update`;
    97  drop table `update`;
    98  
    99  drop table if exists `where`;
   100  create table `where` (`while` int, `with` bigint, `xor` smallint, `year_month` decimal);
   101  show create table `where`;
   102  drop table `where`;
   103  
   104  drop database test;