CREATE TABLE T1
  (
    A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
  , B                                INT DEFAULT NULL
  , C                                INT DEFAULT NULL
  , PRIMARY KEY (A ASC)
  )
  SALT USING 8 PARTITIONS
;


CREATE TABLE T6
  (
    A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
  , B                                INT DEFAULT NULL
  , C                                INT DEFAULT NULL
  , PRIMARY KEY (A ASC)
  )
  SALT USING 8 PARTITIONS
;


CREATE TABLE T8
  (
    A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
  , B                                INT DEFAULT NULL
  , C                                INT DEFAULT NULL
  , PRIMARY KEY (A ASC)
  )
  SALT USING 8 PARTITIONS
;


CREATE TABLE CUBE1
  (
    A                                INT NO DEFAULT NOT NULL NOT DROPPABLE
  , B                                INT NO DEFAULT NOT NULL NOT DROPPABLE
  , C                                INT NO DEFAULT NOT NULL NOT DROPPABLE
  , D                                INT DEFAULT NULL
  , E                                INT DEFAULT NULL
  , F                                INT DEFAULT NULL
  , TXT                              CHAR(100) CHARACTER SET ISO88591 COLLATE
      DEFAULT DEFAULT NULL
  , PRIMARY KEY (A ASC, B ASC, C ASC)
  )
  SALT USING 8 PARTITIONS
;



--
--
-- insert 10 rows into t1
insert into t1 values (0,0,0);
insert into t1 values (1,1,1);
insert into t1 values (2,2,2);
insert into t1 values (3,3,3);
insert into t1 values (4,4,4);
insert into t1 values (5,5,5);
insert into t1 values (6,6,6);
insert into t1 values (7,7,7);
insert into t1 values (8,8,8);
insert into t1 values (9,9,9);

-- t6 is 100 rows
insert into t6 select t1.a+10*t2.a,t1.a,t2.a from t1 as t1,t1 as t2;

-- t8 is 1000 rows
insert into t8 select t6.a+100*t1.a,t6.a,t1.a from t1,t6;