vitess.io/vitess@v0.16.2/go/vt/vttablet/tabletserver/planbuilder/testdata/ddl_cases.txt (about)

     1  "create table a(abcd bigint)"
     2  {
     3    "PlanID": "DDL",
     4    "TableName": "",
     5    "Permissions": [
     6      {
     7        "TableName": "a",
     8        "Role": 2
     9      }
    10    ],
    11    "FullQuery": "create table a (\n\tabcd bigint\n)"
    12  }
    13  
    14  "drop  table b"
    15  {
    16    "PlanID": "DDL",
    17    "TableName": "",
    18    "Permissions": [
    19      {
    20        "TableName": "b",
    21        "Role": 2
    22      }
    23    ],
    24    "FullQuery": "drop table b"
    25  }
    26  
    27  "drop table b.c"
    28  {
    29    "PlanID": "DDL",
    30    "TableName": "",
    31    "Permissions": [
    32      {
    33        "TableName": "c",
    34        "Role": 2
    35      }
    36    ],
    37    "FullQuery": "drop table b.c"
    38  }
    39  
    40  "alter table c add column foo bigint"
    41  {
    42    "PlanID": "DDL",
    43    "TableName": "",
    44    "Permissions": [
    45      {
    46        "TableName": "c",
    47        "Role": 2
    48      }
    49    ],
    50    "FullQuery": "alter table c add column foo bigint"
    51  }
    52  
    53  "alter table c comment 'aa'"
    54  {
    55    "PlanID": "DDL",
    56    "TableName": "",
    57    "Permissions": [
    58      {
    59        "TableName": "c",
    60        "Role": 2
    61      }
    62    ],
    63    "FullQuery": "alter table c comment 'aa'"
    64  }
    65  
    66  "alter table b.c comment 'aa'"
    67  {
    68    "PlanID": "DDL",
    69    "TableName": "",
    70    "Permissions": [
    71      {
    72        "TableName": "c",
    73        "Role": 2
    74      }
    75    ],
    76    "FullQuery": "alter table b.c comment 'aa'"
    77  }
    78  
    79  "drop index a on b"
    80  {
    81    "PlanID": "DDL",
    82    "TableName": "",
    83    "Permissions": [
    84      {
    85        "TableName": "b",
    86        "Role": 2
    87      }
    88    ],
    89    "FullQuery": "alter table b drop key a"
    90  }
    91  
    92  "drop index a on b.c"
    93  {
    94    "PlanID": "DDL",
    95    "TableName": "",
    96    "Permissions": [
    97      {
    98        "TableName": "c",
    99        "Role": 2
   100      }
   101    ],
   102    "FullQuery": "alter table b.c drop key a"
   103  }
   104  
   105  "drop index a on b lock=none"
   106  {
   107    "PlanID": "DDL",
   108    "TableName": "",
   109    "Permissions": [
   110      {
   111        "TableName": "b",
   112        "Role": 2
   113      }
   114    ],
   115    "FullQuery": "alter table b drop key a, lock none"
   116  }
   117  
   118  "rename table a to b"
   119  {
   120    "PlanID": "DDL",
   121    "TableName": "",
   122    "Permissions": [
   123      {
   124        "TableName": "a",
   125        "Role": 2
   126      },
   127      {
   128        "TableName": "b",
   129        "Role": 2
   130      }
   131    ],
   132    "FullQuery": "rename table a to b"
   133  }
   134  
   135  "rename table c.a to c.b"
   136  {
   137    "PlanID": "DDL",
   138    "TableName": "",
   139    "Permissions": [
   140      {
   141        "TableName": "a",
   142        "Role": 2
   143      },
   144      {
   145        "TableName": "b",
   146        "Role": 2
   147      }
   148    ],
   149    "FullQuery": "rename table c.a to c.b"
   150  }
   151  
   152  
   153  "alter table a rename b"
   154  {
   155    "PlanID": "DDL",
   156    "TableName": "",
   157    "Permissions": [
   158      {
   159        "TableName": "a",
   160        "Role": 2
   161      },
   162      {
   163        "TableName": "b",
   164        "Role": 2
   165      }
   166    ],
   167    "FullQuery": "alter table a rename b"
   168  }
   169  
   170  "alter table a rename to b"
   171  {
   172    "PlanID": "DDL",
   173    "TableName": "",
   174    "Permissions": [
   175      {
   176        "TableName": "a",
   177        "Role": 2
   178      },
   179      {
   180        "TableName": "b",
   181        "Role": 2
   182      }
   183    ],
   184    "FullQuery": "alter table a rename b"
   185  }
   186  
   187  
   188  "alter table c.a rename to c.b"
   189  {
   190    "PlanID": "DDL",
   191    "TableName": "",
   192    "Permissions": [
   193      {
   194        "TableName": "a",
   195        "Role": 2
   196      },
   197      {
   198        "TableName": "b",
   199        "Role": 2
   200      }
   201    ],
   202    "FullQuery": "alter table c.a rename c.b"
   203  }
   204  
   205  "create view a as select * from asdasd"
   206  {
   207    "PlanID": "DDL",
   208    "TableName": "",
   209    "Permissions": [
   210      {
   211        "TableName": "a",
   212        "Role": 2
   213      }
   214    ],
   215    "FullQuery": "create view a as select * from asdasd"
   216  }
   217  
   218  # syntax error
   219  "alter view c as foo"
   220  "syntax error at position 20 near 'foo'"
   221  
   222  "drop  view b"
   223  {
   224    "PlanID": "DDL",
   225    "TableName": "",
   226    "Permissions": [
   227      {
   228        "TableName": "b",
   229        "Role": 2
   230      }
   231    ],
   232    "FullQuery": "drop view b"
   233  }
   234  
   235  "alter table a reorganize partition b into (partition c values less than (1000), partition d values less than (maxvalue))"
   236  {
   237    "PlanID": "DDL",
   238    "TableName": "",
   239    "Permissions": [
   240      {
   241        "TableName": "a",
   242        "Role": 2
   243      }
   244    ],
   245    "FullQuery": "alter table a reorganize partition b into (partition c values less than (1000), partition d values less than maxvalue)"
   246  }
   247  
   248  "alter table a partition by range (id) (partition p0 values less than (10), partition p1 values less than (maxvalue))"
   249  {
   250    "PlanID": "DDL",
   251    "TableName": "",
   252    "Permissions": [
   253      {
   254        "TableName": "a",
   255        "Role": 2
   256      }
   257    ],
   258    "FullQuery": "alter table a \npartition by range (id)\n(partition p0 values less than (10),\n partition p1 values less than maxvalue)"
   259  }
   260  
   261  # truncate
   262  "truncate a"
   263  {
   264    "PlanID": "DDL",
   265    "TableName": "",
   266    "Permissions": [
   267      {
   268        "TableName": "a",
   269        "Role": 2
   270      }
   271    ],
   272    "FullQuery": "truncate table a"
   273  }
   274  
   275  # truncate
   276  "truncate table a"
   277  {
   278    "PlanID": "DDL",
   279    "TableName": "",
   280    "Permissions": [
   281      {
   282        "TableName": "a",
   283        "Role": 2
   284      }
   285    ],
   286    "FullQuery": "truncate table a"
   287  }
   288  
   289  # create a temporary table
   290  "create temporary table a(id bigint primary key)"
   291  {
   292    "PlanID": "DDL",
   293    "TableName": "",
   294    "Permissions": [
   295      {
   296        "TableName": "a",
   297        "Role": 2
   298      }
   299    ],
   300    "FullQuery": "create temporary table a (\n\tid bigint primary key\n)",
   301    "NeedsReservedConn": true
   302  }
   303  
   304  # temporary table with ddl statement only partially parsed
   305  "create temporary table x"
   306  {
   307    "PlanID": "DDL",
   308    "TableName": "",
   309    "Permissions": [
   310      {
   311        "TableName": "x",
   312        "Role": 2
   313      }
   314    ],
   315    "NeedsReservedConn": true
   316  }