vitess.io/vitess@v0.16.2/go/test/endtoend/vtgate/queries/union/schema.sql (about) 1 create table t1( 2 id1 bigint, 3 id2 bigint, 4 primary key(id1) 5 ) Engine=InnoDB; 6 7 create table t1_id2_idx( 8 id2 bigint, 9 keyspace_id varbinary(10), 10 primary key(id2) 11 ) Engine=InnoDB; 12 13 create table t2( 14 id3 bigint, 15 id4 bigint, 16 primary key(id3) 17 ) Engine=InnoDB; 18 19 create table t2_id4_idx( 20 id bigint not null auto_increment, 21 id4 bigint, 22 id3 bigint, 23 primary key(id), 24 key idx_id4(id4) 25 ) Engine=InnoDB;