github.com/dolthub/go-mysql-server@v0.18.0/enginetest/scriptgen/setup/scripts/xy (about)

     1  exec
     2  CREATE table xy (x int primary key, y int, unique index y_idx(y));
     3  ----
     4  
     5  exec
     6  CREATE table uv (u int primary key, v int);
     7  ----
     8  
     9  exec
    10  CREATE table ab (a int primary key, b int);
    11  ----
    12  
    13  exec
    14  CREATE table pq (p int primary key, q int);
    15  ----
    16  
    17  exec
    18  CREATE table mn (m int primary key, n int);
    19  ----
    20  
    21  exec
    22  create table rs (r int primary key, s int, index s_idx(s));
    23  ----
    24  
    25  exec
    26  CREATE table xy_hasnull (x int primary key, y int);
    27  ----
    28  
    29  exec
    30  CREATE table ab_hasnull (a int primary key, b int);
    31  ----
    32  
    33  exec
    34  CREATE table xy_hasnull_idx (x int primary key, y int, index y_idx(y));
    35  ----
    36  
    37  exec
    38  insert into xy_hasnull values
    39    (1,0),
    40    (2,1),
    41    (0,2),
    42    (3,NULL);
    43  ----
    44  
    45  exec
    46  insert into ab_hasnull values
    47    (0,2),
    48    (1,2),
    49    (2,NULL),
    50    (3,1);
    51  ----
    52  
    53  exec
    54  insert into xy_hasnull_idx values
    55    (1,0),
    56    (2,1),
    57    (0,2),
    58    (3,NULL);
    59  ----
    60  
    61  exec
    62  insert into xy values
    63    (1,0),
    64    (2,1),
    65    (0,2),
    66    (3,3);
    67  ----
    68  
    69  exec
    70  insert into uv values
    71    (0,1),
    72    (1,1),
    73    (2,2),
    74    (3,2);
    75  ----
    76  
    77  exec
    78  insert into ab values
    79    (0,2),
    80    (1,2),
    81    (2,2),
    82    (3,1);
    83  ----
    84  
    85  exec
    86  insert into pq values
    87    (0,0),
    88    (1,1),
    89    (2,2),
    90    (3,3);
    91  ----
    92  
    93  exec
    94  insert into mn values
    95    (2,0),
    96    (3,1),
    97    (4,2),
    98    (5,3);
    99  ----
   100  
   101  exec
   102  insert into rs values
   103    (0,0),
   104    (1,0),
   105    (2,0),
   106    (4,4),
   107    (5,4);
   108  ----
   109  
   110  exec
   111  analyze table ab update histogram on (a) using data '{"row_count": 1000}';
   112  ----
   113  
   114  exec
   115  analyze table ab_hasnull update histogram on (a) using data '{"row_count": 1000}';
   116  ----
   117  
   118  exec
   119  analyze table xy update histogram on (x) using data '{"row_count": 1000}';
   120  ----
   121  
   122  exec
   123  analyze table xy_hasnull update histogram on (x) using data '{"row_count": 1000}';
   124  ----
   125  
   126  exec
   127  analyze table rs update histogram on (r) using data '{"row_count": 1000}'
   128  ----