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