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

     1  select 1 as account, 1 as accounts, 1 as action, 1 as admin_name, 1 as after, 1 as against, 1 as algorithm, 1 as ascii, 1 as any, 1 as ascii;
     2  
     3  select 1 as attribute, 1 as auto_increment, 1 as auto_random, 1 as autoextend_size, 1 as avg_row_length, 1 as backend;
     4  
     5  select 1 as backup, 1 as bigint, 1 as bindings, 1 as bit, 1 as blob, 1 as bool;
     6  
     7  select 1 as boolean, 1 as bsi, 1 as btree, 1 as cancel, 1 as cascade, 1 as cascaded, 1 as chain;
     8  
     9  select 1 as charset, 1 as checksum, 1 as cipher, 1 as client, 1 as cluster, 1 as coalesce, 1 as collation;
    10  
    11  select 1 as column_format, 1 as column_number, 1 as columns, 1 as commit, 1 as committed, 1 as compressed, 1 as compression, 1 as connect, 1 as connection;
    12  
    13  select 1 as connector, 1 as connectors, 1 as consistent, 1 as copy, 1 as credentials, 1 as current, 1 as cycle, 1 as daemon;
    14  
    15  select 1 as data,  1 as date, 1 as day, 1 as datetime, 1 as date, 1 as deallocate, 1 as decimal, 1 as definer, 1 as delay_key_write, 1 as directory;
    16  
    17  select 1 as disable, 1 as discard, 1 as disk, 1 as do, 1 as double, 1 as drainer, 1 as duplicate, 1 as dynamic, 1 as enable;
    18  
    19  select 1 as encryption, 1 as enforced, 1 as engine, 1 as engine_attribute, 1 as engines, 1 as enum, 1 as errors, 1 as event;
    20  
    21  select 1 as events, 1 as exclusive, 1 as execute, 1 as expansion, 1 as expire, 1 as extended, 1 as extension, 1 as external, 1 as failed_login_attempts, 1 as fields;
    22  
    23  select 1 as file, 1 as filesystem, 1 as fill, 1 as first, 1 as fixed, 1 as float, 1 as following, 1 as force_quote, 1 as format;
    24  
    25  select 1 as full, 1 as geometry, 1 as geometrycollection, 1 as global, 1 as grant, 1 as grants, 1 as handler, 1 as hash;
    26  
    27  select 1 as header, 1 as history, 1 as hour, 1 as identified, 1 as import, 1 as increment, 1 as indexes, 1 as inline;
    28  
    29  select 1 as inplace, 1 as insert_method, 1 as instant, 1 as int, 1 as integer, 1 as invisible, 1 as invoker, 1 as isolation;
    30  
    31  select 1 as issuer, 1 as ivfflat, 1 as json, 1 as jsontype, 1 as key_block_size, 1 as keys, 1 as language, 1 as last, 1 as less, 1 as level;
    32  
    33  select 1 as linear, 1 as linestring, 1 as list, 1 as lists, 1 as local;
    34  
    35  select 1 as locks, 1 as longblob, 1 as longtext, 1 as low_cardinality, 1 as manage, 1 as master, 1 as max_connections_per_hour;
    36  
    37  select 1 as max_file_size, 1 as max_queries_per_hour, 1 as max_rows, 1 as max_update_per_hour, 1 as max_user_connections, 1 as median, 1 as mediumblob;
    38  
    39  select 1 as mediumint, 1 as mediumtext, 1 as memory, 1 as merge, 1 as microsecond, 1 as min_rows, 1 as minute, 1 as minvalue, 1 as mode;
    40  
    41  select 1 as modify, 1 as modump, 1 as month, 1 as multilinestring, 1 as multipoint, 1 as multipolygon, 1 as mysql_compatibility_mode, 1 as names;
    42  
    43  select 1 as nchar, 1 as never, 1 as next, 1 as no, 1 as node, 1 as none, 1 as nulls, 1 as numeric, 1 as offset, 1 as only, 1 as op_type;
    44  
    45  select 1 as open, 1 as optimize, 1 as option, 1 as optional, 1 as ownership, 1 as pack_keys, 1 as parallel, 1 as parallelism;
    46  
    47  select 1 as parser, 1 as partial, 1 as partitions, 1 as password_lock_time, 1 as pause, 1 as percent, 1 as persist, 1 as plugins;
    48  
    49  select 1 as point, 1 as polygon, 1 as preceding, 1 as prepare, 1 as prev, 1 as privileges, 1 as procedure, 1 as processlist, 1 as profiles;
    50  
    51  select 1 as properties, 1 as proxy, 1 as publication, 1 as publications, 1 as pump, 1 as quarter;
    52  
    53  select 1 as query, 1 as query_result, 1 as random, 1 as range, 1 as read, 1 as real, 1 as redundant, 1 as reference, 1 as release, 1 as reload;
    54  
    55  select 1 as reorganize, 1 as repair, 1 as repeatable, 1 as replication, 1 as reset, 1 as restrict, 1 as restricted, 1 as resume;
    56  
    57  select 1 as returns, 1 as reuse, 1 as reverse, 1 as revoke, 1 as role, 1 as roles, 1 as rollback, 1 as routine, 1 as row_count;
    58  
    59  select 1 as row_format, 1 as rtree, 1 as s3option, 1 as sample, 1 as san, 1 as second, 1 as secondary;
    60  
    61  select 1 as secondary_engine_attribute, 1 as security, 1 as sequence, 1 as sequences, 1 as serializable, 1 as servers, 1 as session, 1 as share;
    62  
    63  select 1 as shared, 1 as shutdown, 1 as signed, 1 as simple, 1 as slave, 1 as sliding, 1 as smallint, 1 as snapshot;
    64  
    65  select 1 as some, 1 as source, 1 as spatial, 1 as sql, 1 as sql_cache, 1 as sql_no_cache, 1 as sql_tsi_day, 1 as sql_tsi_hour, 1 as sql_tsi_minute;
    66  
    67  select 1 as sql_tsi_second, 1 as sql_tsi_year, 1 as sql_tsi_quarter, 1 as sql_tsi_month, 1 as sql_tsi_week, 1 as stage, 1 as stageoption;
    68  
    69  select 1 as stages, 1 as start, 1 as stats_auto_recalc, 1 as stats_persistent, 1 as stats_sample_pages, 1 as status, 1 as storage, 1 as stream;
    70  
    71  select 1 as subject, 1 as subpartition, 1 as subpartitions, 1 as subscriptions, 1 as super, 1 as suspend, 1 as table_number, 1 as table_size;
    72  
    73  select 1 as table_values, 1 as tables, 1 as tablespace, 1 as task, 1 as temptable, 1 as text, 1 as than, 1 as time;
    74  
    75  select 1 as timestamp, 1 as tinyblob, 1 as tinyint, 1 as tinytext, 1 as transaction, 1 as trigger, 1 as triggers;
    76  
    77  select 1 as truncate, 1 as type, 1 as unbounded, 1 as uncommitted, 1 as undefined, 1 as unknown, 1 as unlock, 1 as unsigned, 1 as url;
    78  
    79  select 1 as user, 1 as uuid, 1 as validation, 1 as value, 1 as varbinary, 1 as varchar, 1 as variables, 1 as vecf32, 1 as vecf64;
    80  
    81  select 1 as verbose, 1 as view, 1 as visible, 1 as warnings, 1 as week, 1 as without, 1 as write, 1 as work;
    82  
    83  select 1 as x509, 1 as year, 1 as zerofill, 1 as zonemap, 1 as comment;
    84  
    85  drop database if exists test;
    86  create database test;
    87  use test;
    88  create table test01(`db_type` blob default null);
    89  insert into test01 values (_binary "relational database");
    90  insert into test01 values (_binary "nosql Database");
    91  insert into test01 values (_binary "object-oriented database");
    92  insert into test01 values (_binary "hierarchical database");
    93  insert into test01 values (_binary "network database");
    94  insert into test01 values (_binary "in-memory database");
    95  insert into test01 values (null);
    96  select * from test01;
    97  drop database test;