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

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