summaryrefslogtreecommitdiff
path: root/storage/spider/mysql-test/spider/bg/include/hs_init_child2_2.inc
blob: 7c69d73ced6a8d78730d0d5e977aa0b96dbf8e81 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
let $CHILD2_2_HS_DROP_TABLES=
  DROP TABLE IF EXISTS hs_r3;
let $CHILD2_2_HS_CREATE_TABLES=
  CREATE TABLE hs_r3 (
    a INT DEFAULT 10,
    b CHAR(1) DEFAULT 'c',
    c DATETIME DEFAULT '1999-10-10 10:10:10',
    d INT DEFAULT 11,
    PRIMARY KEY(a)
  ) $CHILD2_2_ENGINE $CHILD2_2_CHARSET;
let $CHILD2_2_HS_SELECT_TABLES=
  SELECT a, b, date_format(c, '%Y-%m-%d %H:%i:%s'), d FROM hs_r3 ORDER BY a;