setup

package
v0.0.0-...-e065498 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Dec 11, 2022 License: Apache-2.0 Imports: 7 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source
var (
	Mytable           [][]SetupScript
	KeylessSetup      [][]SetupScript
	VersionedSetup    [][]SetupScript
	SpecialSetup      [][]SetupScript
	SimpleSetup       [][]SetupScript
	PlanSetup         [][]SetupScript
	OrdinalSetup      [][]SetupScript
	SpatialSetup      [][]SetupScript
	JsonSetup         [][]SetupScript
	FooSetup          [][]SetupScript
	GraphSetup        [][]SetupScript
	ReservedSetup     [][]SetupScript
	ChecksSetup       [][]SetupScript
	NullsSetup        [][]SetupScript
	ComplexIndexSetup [][]SetupScript
	LoadDataSetup     [][]SetupScript
	XySetup           [][]SetupScript
)
View Source
var AutoincrementData = []SetupScript{{
	`drop table if exists auto_increment_tbl`,
	"CREATE TABLE `auto_increment_tbl` (  `pk` bigint NOT NULL AUTO_INCREMENT,  `c0` bigint,  PRIMARY KEY (`pk`))",
	`INSERT INTO auto_increment_tbl values    (1, 11),    (2, 22),    (3, 33)`,
}}
View Source
var BigtableData = []SetupScript{{
	`create table bigtable (t varchar(1) primary key, n bigint)`,
	`insert into bigtable values	('a', 1),	('s', 2),	('f', 3),	('g', 1),	('h', 2),	('j', 3),	('k', 1),	('l', 2),	('ñ', 4),	('z', 5),	('x', 6),	('c', 7),	('v', 8),	('b', 9)`,
}}
View Source
var BlobData = []SetupScript{{
	`create table blobt (i bigint primary key, b longblob);`,
	`create table textt (i bigint primary key, t text);`,
	`insert into blobt values    (1, 'first row'),    (2, 'second row'),    (3, 'third row')`,
	`insert into textt values    (1, 'first row'),    (2, 'second row'),    (3, 'third row')`,
}}
View Source
var Check_constraintData = []SetupScript{{
	`CREATE TABLE checks (a INTEGER PRIMARY KEY, b INTEGER, c varchar(20))`,
	`ALTER TABLE checks ADD CONSTRAINT chk1 CHECK (B > 0)`,
	`ALTER TABLE checks ADD CONSTRAINT chk2 CHECK (b > 0) NOT ENFORCED`,
	`ALTER TABLE checks ADD CONSTRAINT chk3 CHECK (B > 1)`,
	`ALTER TABLE checks ADD CONSTRAINT chk4 CHECK (upper(C) = c)`,
}}
View Source
var Comp_index_tablesData = []SetupScript{{
	`CREATE TABLE comp_index_t0 (pk BIGINT PRIMARY KEY, v1 BIGINT, v2 BIGINT)`,
	`create INDEX v_idx on comp_index_t0 (v1, v2)`,
	`INSERT INTO comp_index_t0 VALUES (0,0,48),(1,0,52),(2,2,4),(3,2,10),(4,3,35),(5,5,36),(6,5,60),(7,6,1),(8,6,51),(9,6,60),(10,6,73),(11,9,44),(12,9,97),(13,13,44),(14,14,53),(15,14,57),(16,14,98),(17,16,19),(18,16,53),(19,16,95),(20,18,31),(21,19,48),(22,19,75),(23,19,97),(24,24,60),(25,25,14),(26,25,31),(27,27,9),(28,27,24),(29,28,24),(30,28,83),(31,31,14),(32,33,39),(33,34,22),(34,34,91),(35,35,89),(36,38,20),(37,38,66),(38,39,55),(39,39,86),(40,40,97),(41,42,0),(42,42,82),(43,43,63),(44,44,48),(45,44,67),(46,45,22),(47,45,31),(48,45,63),(49,45,86),(50,46,46),(51,47,5),(52,48,22),(53,49,0),(54,50,0),(55,50,14),(56,51,35),(57,54,38),(58,56,0),(59,56,60),(60,57,29),(61,57,49),(62,58,12),(63,58,32),(64,59,29),(65,59,45),(66,59,54),(67,60,66),(68,61,3),(69,61,34),(70,63,19),(71,63,69),(72,65,80),(73,65,97),(74,67,95),(75,68,11),(76,69,34),(77,72,52),(78,74,81),(79,76,39),(80,78,0),(81,78,90),(82,79,36),(83,80,61),(84,80,88),(85,81,4),(86,82,16),(87,83,30),(88,83,74),(89,84,9),(90,84,45),(91,86,56),(92,86,88),(93,87,51),(94,89,3),(95,93,19),(96,93,21),(97,93,96),(98,98,0),(99,98,51),(100,98,61);`,
	`CREATE TABLE comp_index_t1 (pk BIGINT PRIMARY KEY, v1 BIGINT, v2 BIGINT, v3 BIGINT)`,
	`create INDEX v_idx on comp_index_t1 (v1, v2, v3)`,
	`INSERT INTO comp_index_t1 VALUES (0,0,3,16),(1,2,65,9),(2,3,38,37),(3,3,99,99),(4,5,17,42),(5,6,6,76),(6,6,81,33),(7,7,33,51),(8,7,37,42),(9,8,9,21),(10,8,37,90),(11,9,39,20),(12,9,71,82),(13,10,16,21),(14,10,32,46),(15,10,47,36),(16,12,44,84),(17,12,66,40),(18,13,47,30),(19,13,56,41),(20,14,38,24),(21,14,91,1),(22,15,2,69),(23,16,40,36),(24,20,29,93),(25,21,9,89),(26,21,42,76),(27,23,13,53),(28,23,28,68),(29,23,28,90),(30,23,30,44),(31,24,20,8),(32,25,49,88),(33,26,15,28),(34,27,35,12),(35,28,39,84),(36,29,7,38),(37,29,21,74),(38,29,27,48),(39,29,77,46),(40,31,47,21),(41,31,47,91),(42,32,40,76),(43,33,70,50),(44,34,27,58),(45,35,32,36),(46,36,4,36),(47,36,84,75),(48,37,27,32),(49,38,88,68),(50,41,17,68),(51,41,77,26),(52,42,80,85),(53,45,1,57),(54,46,58,8),(55,49,26,11),(56,50,49,20),(57,50,86,6),(58,54,13,78),(59,54,57,83),(60,55,45,46),(61,55,81,80),(62,56,0,97),(63,56,8,78),(64,56,58,4),(65,56,66,33),(66,57,7,52),(67,59,77,53),(68,60,8,70),(69,61,11,25),(70,63,85,23),(71,65,17,9),(72,66,46,46),(73,66,73,4),(74,67,55,27),(75,70,8,54),(76,70,58,33),(77,71,39,15),(78,72,65,64),(79,74,78,26),(80,75,91,35),(81,76,40,52),(82,76,44,87),(83,81,32,4),(84,82,11,6),(85,82,46,32),(86,84,40,8),(87,84,93,37),(88,85,53,50),(89,86,63,79),(90,87,22,34),(91,87,57,62),(92,88,88,42),(93,90,30,67),(94,91,15,15),(95,93,7,26),(96,94,92,38),(97,95,89,66),(98,97,63,19),(99,98,31,21),(100,98,42,22)`,
	`CREATE TABLE comp_index_t2 (pk BIGINT PRIMARY KEY, v1 BIGINT, v2 BIGINT, v3 BIGINT, v4 BIGINT)`,
	`create INDEX v_idx on comp_index_t2 (v1, v2, v3, v4)`,
	`INSERT INTO comp_index_t2 VALUES (0,0,33,2,67),(1,0,55,14,32),(2,1,43,13,36),(3,1,72,29,21),(4,2,27,1,75),(5,3,31,22,81),(6,4,6,67,80),(7,4,10,53,69),(8,4,27,77,5),(9,5,17,52,13),(10,5,32,30,48),(11,5,76,70,46),(12,7,7,66,62),(13,7,21,75,70),(14,7,76,26,47),(15,8,54,46,87),(16,8,99,43,1),(17,9,7,74,92),(18,9,19,38,35),(19,10,36,27,5),(20,12,0,33,62),(21,12,42,15,31),(22,12,46,43,23),(23,15,42,17,60),(24,17,49,14,7),(25,17,75,86,18),(26,20,30,34,71),(27,21,21,32,8),(28,22,21,28,78),(29,22,98,22,21),(30,23,43,13,11),(31,24,26,69,25),(32,24,45,96,0),(33,29,72,97,93),(34,32,16,97,29),(35,33,29,69,6),(36,33,53,56,88),(37,33,86,12,22),(38,34,55,37,34),(39,34,87,13,51),(40,34,89,27,90),(41,35,6,86,74),(42,36,7,40,16),(43,37,35,6,44),(44,37,41,36,10),(45,38,71,22,37),(46,39,45,75,55),(47,41,1,85,9),(48,41,21,82,54),(49,43,23,15,0),(50,43,66,85,66),(51,45,9,76,9),(52,47,94,56,21),(53,48,3,11,18),(54,50,26,23,71),(55,50,36,73,58),(56,50,39,26,37),(57,50,79,10,12),(58,50,97,0,79),(59,51,97,39,36),(60,52,72,44,2),(61,53,6,53,89),(62,53,48,19,36),(63,55,31,29,92),(64,57,25,97,65),(65,63,50,20,43),(66,64,23,33,5),(67,64,26,77,97),(68,64,41,74,85),(69,64,77,41,17),(70,66,97,6,39),(71,67,39,87,15),(72,69,81,70,37),(73,70,40,19,5),(74,70,56,21,22),(75,71,3,49,55),(76,71,48,89,99),(77,73,10,2,0),(78,73,91,56,0),(79,74,22,42,16),(80,74,35,72,97),(81,76,74,97,18),(82,82,29,66,71),(83,82,31,22,99),(84,82,70,5,47),(85,83,37,36,16),(86,83,41,53,57),(87,84,56,78,18),(88,85,2,3,88),(89,86,7,57,96),(90,87,23,16,63),(91,87,66,8,22),(92,88,57,12,88),(93,89,1,27,50),(94,89,91,7,45),(95,90,25,0,17),(96,91,23,2,9),(97,93,56,71,53),(98,94,43,71,43),(99,94,79,53,73),(100,96,73,38,38)`,
	`CREATE TABLE comp_index_t3 (pk BIGINT PRIMARY KEY, v1 BLOB, v2 BLOB)`,
	`create INDEX v_idx on comp_index_t3 (v1(3))`,
	`INSERT INTO comp_index_t3 VALUES (0, 'a', 'a'), (1, 'ab', 'ab'), (2, 'abc', 'abc'), (3, 'abcde', 'abcde')`,
}}
View Source
var DatetimetableData = []SetupScript{{
	"CREATE TABLE `datetime_table` (  `i` bigint NOT NULL,  `date_col` date,  `datetime_col` datetime,  `timestamp_col` timestamp,  `time_col` time(6),  PRIMARY KEY (`i`))",
	`insert into datetime_table values    (1, '2019-12-31T12:00:00Z', '2020-01-01T12:00:00Z', '2020-01-02T12:00:00Z', '03:10:0'),    (2, '2020-01-03T12:00:00Z', '2020-01-04T12:00:00Z', '2020-01-05T12:00:00Z', '04:00:44'),    (3, '2020-01-07T00:00:00Z', '2020-01-07T12:00:00Z', '2020-01-07T12:00:01Z', '15:00:00.005000')`,
	`create index datetime_table_d on datetime_table (date_col)`,
	`create index datetime_table_dt on datetime_table (datetime_col)`,
	`create index datetime_table_ts on datetime_table (timestamp_col)`,
}}
View Source
var EmptytableData = []SetupScript{{
	`create table emptytable (i mediumint primary key, s varchar(20))`,
}}
View Source
var ExplodeData = []SetupScript{{
	`create table explode (a bigint, b JSON, c varchar(20))`,
	`insert into explode values    (1, '["a", "b"]', 'first'),    (2, '["c", "d"]', 'second'),    (3, '["e", "f"]', 'third')`,
}}
View Source
var Fk_tblData = []SetupScript{{
	"CREATE TABLE `fk_tbl` (  `pk` bigint NOT NULL,  `a` bigint,  `b` varchar(20),  PRIMARY KEY (`pk`))",
	`ALTER TABLE fk_tbl ADD CONSTRAINT fk1 FOREIGN KEY (a,b) REFERENCES mytable (i,s) ON DELETE CASCADE`,
}}
View Source
var FloattableData = []SetupScript{{
	"CREATE TABLE `floattable` (  `i` bigint NOT NULL,  `f32` float NOT NULL,  `f64` double NOT NULL,  PRIMARY KEY (`i`))",
	`insert into floattable values    (1, 1.0, 1.0),    (2, 1.5, 1.5),    (3, 2.0, 2.0),    (4, 2.5, 2.5),    (-1, -1.0, -1.0),    (-2, -1.5, -1.5)`,
	`create index floattable_f on floattable (f64)`,
}}
View Source
var FooData = []SetupScript{{
	`create database if not exists foo`,
	`create table foo.other_table (text varchar(20) primary key, number mediumint)`,
	`insert into foo.other_table values    ('a', 4),    ('b', 2),    ('c', 0)`,
}}
View Source
var Graph_tablesData = []SetupScript{{
	"CREATE TABLE `bus_routes` (  `origin` varchar(20) NOT NULL,  `dst` varchar(20) NOT NULL,  PRIMARY KEY (`origin`,`dst`))",
	`insert into bus_routes values    ('New York', 'Boston'),    ('Boston', 'New York'),    ('New York', 'Washington'),    ('Washington', 'Boston'),    ('Washington', 'Raleigh')`,
	"CREATE TABLE `parts` (  `part` varchar(20) NOT NULL,  `sub_part` varchar(20) NOT NULL,  `quantity` bigint NOT NULL,  PRIMARY KEY (`part`,`sub_part`))",
	`insert into parts values	('pie', 'crust', 1),	('pie', 'filling', 2),	('crust', 'flour', 20),	('crust', 'sugar', 2),	('crust', 'butter', 15),	('crust', 'salt', 15),	('filling', 'sugar', 5),	('filling', 'fruit', 9),	('filling', 'salt', 3),	('filling', 'butter', 3)`,
}}
View Source
var Integration_testData = []SetupScript{{
	`create table T52LX (	id varchar(24) not null,	DZLIM varchar(100) not null,	F3YUE varchar(1000),	PRIMARY KEY (id),	UNIQUE KEY VAEXO (DZLIM)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table YYBCX (	id varchar(24) not null,	ESFVY varchar(100) not null,	SL76B varchar(100) not null,	GE5EL double,	F7A4Q double,	TUV25 double,	YKSSU varchar(1000),	FHCYT varchar(1000),	PRIMARY KEY (id),	UNIQUE KEY WITSV (ESFVY),	UNIQUE KEY CEAF3 (SL76B)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table XGSJM (	id varchar(24) not null,	DZLIM varchar(100) not null,	F3YUE varchar(1000),	PRIMARY KEY (id),	UNIQUE KEY CQIIE (DZLIM)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table WE72E (	id varchar(24) not null,	QZ7E7 varchar(100) not null,	SSHPJ varchar(100) not null,	FHCYT varchar(1000),	PRIMARY KEY (id),	UNIQUE KEY SOCSM (SSHPJ),	UNIQUE KEY LOW5B (QZ7E7)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table TNMXI (	id varchar(24) not null,	DZLIM varchar(100) not null,	F3YUE varchar(1000),	PRIMARY KEY (id),	UNIQUE KEY TCKRP (DZLIM)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table F35MI (	id varchar(24) not null,	DZLIM varchar(100) not null,	F3YUE varchar(1000),	PRIMARY KEY (id),	UNIQUE KEY FTWOK (DZLIM)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table E2I7U (	id varchar(24) not null,	DKCAJ varchar(24) not null,	KNG7T varchar(24),	TW55N varchar(100) not null,	QRQXW double not null,	ECXAJ double not null,	FGG57 varchar(100),	ZH72S varchar(100),	FSK67 varchar(100) not null,	XQDYT varchar(24) not null,	TCE7A double,	IWV2H double,	HPCMS varchar(24) not null,	N5CC2 varchar(1000),	FHCYT varchar(1000),	ETAQ7 double,	A75X7 double,	PRIMARY KEY (id),	KEY XQDYT (XQDYT),	KEY KNG7T (KNG7T),	KEY URBSA (ZH72S),	KEY HPCMS (HPCMS),	KEY DKCAJ (DKCAJ),	UNIQUE KEY TKKOQ (FGG57),	UNIQUE KEY SFMWS (TW55N),	constraint NEPLHKGH foreign key (XQDYT) references XGSJM (id) on delete cascade on update cascade,	constraint ZANIGGZJ foreign key (KNG7T) references WE72E (id) on delete cascade on update cascade,	constraint GYIuPKNP foreign key (HPCMS) references TNMXI (id) on delete cascade on update cascade,	constraint VOLFAYOL foreign key (DKCAJ) references F35MI (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table IIISV (	id varchar(24) not null,	DZLIM varchar(100) not null,	F3YUE varchar(1000),	PRIMARY KEY (id),	UNIQUE KEY PGYTV (DZLIM)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table ARLV5 (	id varchar(24) not null,	LUEVY varchar(24) not null,	F6NSZ varchar(24) not null,	PRIMARY KEY (id),	KEY F6NSZ (F6NSZ),	KEY LUEVY (LUEVY),	UNIQUE KEY G3AVB (LUEVY, F6NSZ),	constraint MPYOIDMG foreign key (LUEVY) references E2I7U (id) on delete cascade on update cascade,	constraint RMWuWBGS foreign key (F6NSZ) references IIISV (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table EPZU6 (	id varchar(24) not null,	TOFPN varchar(100) not null,	SJYN2 varchar(100) not null,	BTXC5 varchar(100) not null,	FVUCX varchar(100) not null,	SWCQV int not null,	YKSSU varchar(1000),	FHCYT varchar(1000),	PRIMARY KEY (id),	KEY EUOFY (BTXC5),	KEY SZ5IY (TOFPN),	KEY LJD63 (SJYN2),	KEY LP75T (FVUCX)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table S3FQX (	id varchar(24) not null,	ADWYM tinyint not null,	FPUYA tinyint not null,	PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table RLOHD (	id varchar(24) not null,	LUEVY varchar(24) not null,	LIILR double,	KSFXH double,	KLMAU double,	ecm double,	RQI4M varchar(1000),	FHCYT varchar(1000),	PRIMARY KEY (id),	UNIQUE KEY HVHB5 (LUEVY),	constraint BPWTWuWC foreign key (LUEVY) references E2I7U (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table SFEGG (	id varchar(24) not null,	NO52D varchar(100) not null,	VYO5E varchar(100),	DKCAJ varchar(24) not null,	ADURZ int not null,	FHCYT varchar(1000),	PRIMARY KEY (id),	UNIQUE KEY DKRQA (NO52D, VYO5E, DKCAJ),	KEY DKCAJ (DKCAJ),	constraint TLBCIFRR foreign key (DKCAJ) references F35MI (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table OUBDL (	id varchar(24) not null,	FTQLQ varchar(100),	ZH72S varchar(200),	SFJ6L varchar(2500),	V5DPX varchar(100),	LJLUM varchar(100),	IDPK7 varchar(100),	NO52D varchar(100),	ZRV3B varchar(100),	VYO5E varchar(100),	YKSSU text,	FHCYT text,	QZ6VT varchar(1000),	PRIMARY KEY (id),	KEY IRMAC (NO52D),	KEY SVIT7 (FTQLQ),	KEY CZWS6 (V5DPX),	KEY JFRPY (ZH72S)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table SISUT (	id varchar(24) not null,	T4IBQ varchar(100),	ZH72S varchar(100),	AMYXQ varchar(100),	KTNZ2 varchar(100),	HIID2 varchar(100),	DN3OQ varchar(100),	VVKNB varchar(100),	SH7TP varchar(100),	SRZZO varchar(100),	QZ6VT varchar(100),	PRIMARY KEY (id),	KEY TTQYJ (T4IBQ),	KEY Z7LT5 (ZH72S)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table NZKPM (	id varchar(24) not null,	T4IBQ varchar(100),	FGG57 varchar(100),	SSHPJ varchar(100),	NLA6O varchar(100),	SFJ6L varchar(100),	TJPT7 varchar(100),	ARN5P varchar(200),	SYPKF varchar(100),	IVFMK varchar(100),	IDE43 varchar(500),	AZ6SP varchar(500),	FSDY2 varchar(100),	XOSD4 varchar(200),	HMW4H varchar(100),	S76OM varchar(100),	vaf varchar(100),	ZROH6 varchar(100),	QCGTS varchar(100),	LNFM6 varchar(100),	TVAWL varchar(100),	HDLCL varchar(100),	BHHW6 varchar(100),	FHCYT varchar(1000),	QZ6VT varchar(1000),	PRIMARY KEY (id),	KEY UFF3F (T4IBQ),	KEY FXQHW (FGG57)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table JMRQL (	id varchar(24) not null,	DZLIM varchar(100) not null,	F3YUE varchar(1000),	PRIMARY KEY (id),	UNIQUE KEY LYX3G (DZLIM)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table SZW6V (	id varchar(24) not null,	T4IBQ varchar(100) not null,	V7UFH varchar(100) not null,	SYPKF varchar(100) not null,	H4DMT varchar(100) not null,	SWCQV int not null,	YKSSU varchar(1000),	FHCYT varchar(1000),	PRIMARY KEY (id),	KEY SPZMU (T4IBQ),	KEY GGI5L (SYPKF),	KEY UTKLA (V7UFH),	KEY EMW6Y (H4DMT)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table XOAOP (	id varchar(24) not null,	DZLIM varchar(100) not null,	F3YUE varchar(1000),	PRIMARY KEY (id),	UNIQUE KEY THCUL (DZLIM)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table JJGQT (	id varchar(24) not null,	CH3FR varchar(24) not null,	LUEVY varchar(24) not null,	PRIMARY KEY (id),	KEY CH3FR (CH3FR),	UNIQUE KEY QHY76 (LUEVY),	constraint DRBJBJAI foreign key (LUEVY) references E2I7U (id) on delete cascade on update cascade,	constraint HZHLDWSR foreign key (CH3FR) references XOAOP (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table TPXHZ (	id varchar(24) not null,	SVAZ4 varchar(100) not null,	PRIMARY KEY (id),	UNIQUE KEY SVAZ4 (SVAZ4)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table YK2GW (	id varchar(24) not null,	FTQLQ varchar(100) not null,	TUXML varchar(100),	PAEF5 varchar(100),	RUCY4 varchar(100),	TPNJ6 varchar(100) not null,	LBL53 varchar(100),	NB3QS varchar(100),	EO7IV varchar(100),	MUHJF varchar(100),	FM34L text,	TY5RF text,	ZHTLH text,	NPB7W text,	SX3HH text,	ISBNF text,	YA7YB text,	C5YKB text,	QK7KT text,	FFGE6 text,	FIIGJ text,	SH3NC text,	NTENA text,	M4AUB text,	X5AIR text,	SAB6M text,	G5QI5 text,	ZVQVD text,	YKSSU varchar(1000),	FHCYT varchar(1000),	PRIMARY KEY (id),	KEY TU5AX (LBL53),	KEY C7DFM (NB3QS),	KEY NFJNB (EO7IV),	KEY TWFWA (MUHJF),	UNIQUE KEY FEGLT (PAEF5),	UNIQUE KEY T3X5H (TUXML),	UNIQUE KEY EZCTT (FTQLQ)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table IJLXP (	id varchar(24) not null,	WZP3R varchar(100) not null,	IXUXU varchar(24) not null,	PRIMARY KEY (id),	KEY IXUXU (IXUXU),	UNIQUE KEY IFQUF (WZP3R, IXUXU),	constraint YWSOXPJG foreign key (IXUXU) references YK2GW (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table HU5A5 (	id varchar(24) not null,	TOFPN varchar(100) not null,	I3VTA varchar(200) not null,	SFJ6L varchar(2500),	V5DPX varchar(100) not null,	LJLUM varchar(100) not null,	IDPK7 varchar(100) not null,	NO52D varchar(100) not null,	ZRV3B varchar(100) not null,	VYO5E varchar(100),	SWCQV int not null,	YKSSU varchar(1000),	FHCYT varchar(1000),	PRIMARY KEY (id),	KEY UYQR2 (TOFPN),	KEY Z2WXS (I3VTA)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table JDLNA (	id varchar(24) not null,	FTQLQ varchar(100) not null,	FWWIQ varchar(100),	O3QXW varchar(100),	FHCYT text,	PRIMARY KEY (id),	UNIQUE KEY XDW7Z (FTQLQ)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table FCBVZ (	id varchar(24) not null,	FZ2R5 varchar(24) not null,	J6B7H double not null,	BMNNY double not null,	PRIMARY KEY (id),	UNIQUE KEY IC4BT (FZ2R5),	constraint XDGOFPLT foreign key (FZ2R5) references JDLNA (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table IMJ6V (	id varchar(24) not null,	FTQLQ varchar(100),	BACOW varchar(100),	PRIMARY KEY (id),	KEY EUAEL (BACOW),	KEY C7XE4 (FTQLQ)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table TPXBU (	id varchar(24) not null,	BTXC5 varchar(100),	FHCYT varchar(1000),	PRIMARY KEY (id),	UNIQUE KEY UZ6GK (BTXC5)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table THNTS (	id varchar(24) not null,	NFRYN varchar(24) not null,	IXUXU varchar(24),	FHCYT varchar(1000),	PRIMARY KEY (id),	KEY NFRYN (NFRYN),	KEY IXUXU (IXUXU),	constraint PVRKLKKQ foreign key (NFRYN) references JMRQL (id) on delete cascade on update cascade,	constraint uIRGWEWQ foreign key (IXUXU) references YK2GW (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table HGMQ6 (	id varchar(24) not null,	GXLUB varchar(24) not null,	LUEVY varchar(24) not null,	M22QN varchar(24) not null,	TJPT7 varchar(100) not null,	ARN5P varchar(200) not null,	XOSD4 varchar(200) not null,	IDE43 varchar(500),	HMW4H varchar(100),	ZBT6R int,	FSDY2 varchar(100) not null,	LT7K6 double,	SPPYD double,	QCGTS double,	TEUJA varchar(24),	QQV4M varchar(24),	FHCYT varchar(1000),	PRIMARY KEY (id),	KEY M22QN (M22QN),	KEY GXLUB (GXLUB),	KEY QQV4M (QQV4M),	KEY LUEVY (LUEVY),	KEY TEUJA (TEUJA),	constraint ZTDIWKIu foreign key (TEUJA) references NZKPM (id) on delete cascade on update cascade,	constraint OPENAEGM foreign key (LUEVY) references E2I7U (id) on delete cascade on update cascade,	constraint GRXCIZOK foreign key (QQV4M) references SZW6V (id) on delete cascade on update cascade,	constraint VMJAAVNQ foreign key (M22QN) references TPXBU (id) on delete cascade on update cascade,	constraint XOVPPACH foreign key (GXLUB) references THNTS (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table D34QP (	id varchar(24) not null,	TWMSR varchar(100) not null,	QHMGE varchar(1000),	MLNPU varchar(100) not null,	FI3GA varchar(100) not null,	ZNP4P varchar(100) not null,	PRIMARY KEY (id),	UNIQUE KEY LZLGJ (FI3GA),	UNIQUE KEY F2C6B (TWMSR)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table SEQS3 (	id varchar(24) not null,	Z7CP5 varchar(24) not null,	YH4XB varchar(24) not null,	PRIMARY KEY (id),	KEY Z7CP5 (Z7CP5),	UNIQUE KEY SQKGT (Z7CP5, YH4XB),	KEY YH4XB (YH4XB),	constraint OCPWMCFX foreign key (YH4XB) references D34QP (id) on delete cascade on update cascade,	constraint CROMXATM foreign key (Z7CP5) references HGMQ6 (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table FEVH4 (	id varchar(24) not null,	DZLIM varchar(100) not null,	F3YUE varchar(1000),	PRIMARY KEY (id),	UNIQUE KEY QPADP (DZLIM)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table NOXN3 (	id varchar(24) not null,	BRQP2 varchar(24) not null,	FFTBJ varchar(24) not null,	A7XO2 varchar(24),	KBO7R double not null,	ECDKM double,	NUMK2 int not null,	LETOE int not null,	YKSSU varchar(1000),	FHCYT varchar(1000),	PRIMARY KEY (id),	KEY A7XO2 (A7XO2),	KEY BRQP2 (BRQP2),	KEY FFTBJ (FFTBJ),	constraint YHuJBJOA foreign key (BRQP2) references E2I7U (id) on delete cascade on update cascade,	constraint MZZLFWKV foreign key (FFTBJ) references E2I7U (id) on delete cascade on update cascade,	constraint OOIIJMRS foreign key (A7XO2) references FEVH4 (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table FLQLP (	id varchar(24) not null,	FZ2R5 varchar(24) not null,	LUEVY varchar(24) not null,	M22QN varchar(24) not null,	OVE3E varchar(24) not null,	NRURT varchar(24),	OCA7E varchar(24),	XMM6Q varchar(24),	V5DPX varchar(100) not null,	S3Q3Y double not null,	ZRV3B varchar(100) not null,	FHCYT text,	PRIMARY KEY (id),	KEY M22QN (M22QN),	KEY XMM6Q (XMM6Q),	KEY OCA7E (OCA7E),	KEY OVE3E (OVE3E),	KEY FZ2R5 (FZ2R5),	KEY LUEVY (LUEVY),	KEY NRURT (NRURT),	constraint RSSVKRQV foreign key (OVE3E) references SFEGG (id) on delete cascade on update cascade,	constraint EXBYRKVB foreign key (XMM6Q) references HU5A5 (id) on delete cascade on update cascade,	constraint HCEKFTJK foreign key (M22QN) references TPXBU (id) on delete cascade on update cascade,	constraint KWNRRXuP foreign key (NRURT) references OUBDL (id) on delete cascade on update cascade,	constraint RQuDOGQu foreign key (OCA7E) references EPZU6 (id) on delete cascade on update cascade,	constraint uIRDRBRV foreign key (FZ2R5) references JDLNA (id) on delete cascade on update cascade,	constraint MSMuETPN foreign key (LUEVY) references E2I7U (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table AMYXQ (	id varchar(24) not null,	GXLUB varchar(24) not null,	LUEVY varchar(24) not null,	XQDYT varchar(24) not null,	AMYXQ double not null,	OZTQF double not null,	Z35GY double not null,	KKGN5 varchar(24),	PRIMARY KEY (id),	KEY GXLUB (GXLUB),	KEY XQDYT (XQDYT),	KEY LUEVY (LUEVY),	UNIQUE KEY VN3QP (GXLUB, LUEVY),	KEY KKGN5 (KKGN5),	constraint AVDTHRGA foreign key (XQDYT) references XGSJM (id) on delete cascade on update cascade,	constraint TTJXJHYD foreign key (GXLUB) references THNTS (id) on delete cascade on update cascade,	constraint uVMOASBI foreign key (KKGN5) references SISUT (id) on delete cascade on update cascade,	constraint RYPGYAZH foreign key (LUEVY) references E2I7U (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table ZTFET (	id varchar(24) not null,	CYZU6 varchar(200) not null,	AERTL varchar(200) not null,	PMM7A tinyint not null,	SIJCN varchar(200) not null,	RTLWN varchar(200) not null,	ZMABC varchar(200) not null,	W3GHO text not null,	U7IJ3 text,	PRIMARY KEY (id),	UNIQUE KEY CIMX7 (CYZU6, AERTL),	KEY BRPXE (CYZU6),	KEY SSO2T (AERTL)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table WRZVO (	id varchar(24) not null,	TVNW2 varchar(100),	ZHITY varchar(100),	SYPKF varchar(100),	IDUT2 varchar(200),	O6QJ3 varchar(1000),	NO2JA varchar(1000),	YKSSU text,	FHCYT text,	QZ6VT varchar(1000),	PRIMARY KEY (id),	KEY QKJKS (SYPKF),	KEY GAG3S (TVNW2),	KEY JH666 (ZHITY)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table WGSDC (	id varchar(24) not null,	NOHHR varchar(100) not null,	AVPYF varchar(100) not null,	SYPKF varchar(100) not null,	IDUT2 varchar(200) not null,	FZXV5 varchar(100),	DQYGV varchar(100),	SWCQV int not null,	YKSSU varchar(1000),	FHCYT varchar(1000),	PRIMARY KEY (id),	KEY X6K5N (IDUT2),	KEY M5B5R (SYPKF),	KEY XW5IP (NOHHR),	KEY F7H3Y (AVPYF),	KEY T65YI (FZXV5),	KEY XRKQ4 (DQYGV)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table HDDVB (	id varchar(24) not null,	FV24E varchar(24) not null,	UJ6XY varchar(24) not null,	M22QN varchar(24) not null,	NZ4MQ varchar(24) not null,	ETPQV varchar(24),	PRUV2 varchar(24),	YKSSU varchar(1000),	FHCYT varchar(1000),	PRIMARY KEY (id),	KEY M22QN (M22QN),	KEY PRUV2 (PRUV2),	KEY NZ4MQ (NZ4MQ),	KEY FV24E (FV24E),	KEY UJ6XY (UJ6XY),	KEY ETPQV (ETPQV),	constraint XDHAOISE foreign key (NZ4MQ) references YYBCX (id) on delete cascade on update cascade,	constraint CYXIDCXY foreign key (FV24E) references E2I7U (id) on delete cascade on update cascade,	constraint ZKROQGGX foreign key (ETPQV) references WRZVO (id) on delete cascade on update cascade,	constraint NTEDELZZ foreign key (PRUV2) references WGSDC (id) on delete cascade on update cascade,	constraint QCVKLYAS foreign key (UJ6XY) references E2I7U (id) on delete cascade on update cascade,	constraint LOQSITZQ foreign key (M22QN) references TPXBU (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table PG27A (	id varchar(24) not null,	DZLIM varchar(100) not null,	F3YUE varchar(1000),	PRIMARY KEY (id),	UNIQUE KEY S4YPB (DZLIM)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table NPCYY (	id varchar(24) not null,	CH3FR varchar(24) not null,	XVSBH varchar(24),	B5OUF int,	PRIMARY KEY (id),	KEY CH3FR (CH3FR),	KEY XVSBH (XVSBH),	UNIQUE KEY S2DGA (CH3FR, XVSBH),	constraint LKKuNSTQ foreign key (CH3FR) references XOAOP (id) on delete cascade on update cascade,	constraint ZDHFJuOJ foreign key (XVSBH) references PG27A (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table SR2I6 (	id varchar(24) not null,	A7XO2 varchar(24) not null,	SSWZH varchar(24) not null,	PRIMARY KEY (id),	KEY SSWZH (SSWZH),	KEY A7XO2 (A7XO2),	UNIQUE KEY ZKOHZ (A7XO2, SSWZH),	constraint LXOBZQWX foreign key (A7XO2) references FEVH4 (id) on delete cascade on update cascade,	constraint PDDMDJJW foreign key (SSWZH) references T52LX (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table TTGWX (	id varchar(24) not null,	LUEVY varchar(24) not null,	CBVKT varchar(100) not null,	PRIMARY KEY (id),	KEY F7YYM (LUEVY),	UNIQUE KEY GKL7R (CBVKT),	constraint GWWPGJWX foreign key (LUEVY) references E2I7U (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table TDRVG (	id varchar(24) not null,	FGG57 varchar(100) not null,	SSHPJ varchar(100) not null,	SFJ6L varchar(100) not null,	ZH72S varchar(100) not null,	PRIMARY KEY (id),	KEY P62K5 (SSHPJ),	KEY XEGEF (SFJ6L),	KEY WJM3Z (ZH72S),	UNIQUE KEY TK2R2 (FGG57)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table ZYGMF (	id varchar(24) not null,	DZLIM varchar(100) not null,	F3YUE varchar(1000),	PRIMARY KEY (id),	UNIQUE KEY JVSQT (DZLIM)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table FG26Y (	id varchar(24) not null,	T4IBQ varchar(100),	ner varchar(100),	ber varchar(100),	hr varchar(100),	mmr varchar(100),	QZ6VT varchar(1000),	PRIMARY KEY (id),	KEY SPAIF (T4IBQ)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table SZQWJ (	id varchar(24) not null,	GXLUB varchar(24) not null,	CH3FR varchar(24) not null,	D237E int not null,	JOGI6 varchar(24),	PRIMARY KEY (id),	KEY GXLUB (GXLUB),	KEY CH3FR (CH3FR),	UNIQUE KEY ZRLKW (GXLUB, CH3FR),	KEY JOGI6 (JOGI6),	constraint TJNEMQOD foreign key (GXLUB) references THNTS (id) on delete cascade on update cascade,	constraint HWEBZOML foreign key (CH3FR) references XOAOP (id) on delete cascade on update cascade,	constraint XVMMFQXM foreign key (JOGI6) references FG26Y (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table QYWQD (	id varchar(24) not null,	WNUNU varchar(24) not null,	HHVLX varchar(24) not null,	HVHRZ double not null,	YKSSU varchar(1000),	FHCYT varchar(1000),	PRIMARY KEY (id),	KEY HHVLX (HHVLX),	KEY WNUNU (WNUNU),	constraint DSGZOCYH foreign key (HHVLX) references NOXN3 (id) on delete cascade on update cascade,	constraint ZWNuDBuB foreign key (WNUNU) references NOXN3 (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table I66GN (	id varchar(24) not null,	FZ2R5 varchar(24),	GJBJC varchar(24),	PRIMARY KEY (id),	KEY FZ2R5 (FZ2R5),	UNIQUE KEY TBOZS (FZ2R5, GJBJC),	KEY GJBJC (GJBJC),	constraint RHXJuQZJ foreign key (FZ2R5) references JDLNA (id) on delete cascade on update cascade,	constraint OOTILHEG foreign key (GJBJC) references ZYGMF (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table BACOW (	id varchar(24) not null,	WZP3R varchar(100) not null,	FZ2R5 varchar(24) not null,	PRIMARY KEY (id),	KEY FZ2R5 (FZ2R5),	UNIQUE KEY CYVZQ (WZP3R),	constraint NDCWQFVN foreign key (FZ2R5) references JDLNA (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table moa (	id varchar(24) not null,	DZLIM varchar(100) not null,	F3YUE varchar(1000),	PRIMARY KEY (id),	UNIQUE KEY TTHMB (DZLIM)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table TA5EB (	id varchar(24) not null,	V34C7 varchar(24) not null,	GJBJC varchar(24) not null,	PRIMARY KEY (id),	KEY V34C7 (V34C7),	KEY GJBJC (GJBJC),	UNIQUE KEY B3QPZ (V34C7, GJBJC),	constraint HBCXAVLB foreign key (GJBJC) references ZYGMF (id) on delete cascade on update cascade,	constraint ZLSVFLDM foreign key (V34C7) references moa (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table NMYH3 (	id varchar(24) not null,	FTQLQ varchar(100),	RCRDD varchar(100),	FWWIQ varchar(100),	O3QXW varchar(100),	FHCYT text,	PRIMARY KEY (id),	KEY DQQLF (FTQLQ)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table FEIOE (	id varchar(24) not null,	LUEVY varchar(24) not null,	GMSGA varchar(24) not null,	FVGD2 int not null,	YP2CR int not null,	TQ7W3 int not null,	PRIMARY KEY (id),	KEY LUEVY (LUEVY),	KEY GMSGA (GMSGA),	UNIQUE KEY A7XUS (LUEVY, GMSGA),	constraint ILKPBIJV foreign key (GMSGA) references NPCYY (id) on delete cascade on update cascade,	constraint GDBYYSTF foreign key (LUEVY) references E2I7U (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
	`create table FBPKL (	id varchar(24) not null,	V34C7 varchar(24) not null,	CH3FR varchar(24) not null,	PRIMARY KEY (id),	KEY V34C7 (V34C7),	KEY CH3FR (CH3FR),	UNIQUE KEY ANGG7 (V34C7, CH3FR),	constraint AJZVSJXW foreign key (CH3FR) references XOAOP (id) on delete cascade on update cascade,	constraint ZFEIKGRF foreign key (V34C7) references moa (id) on delete cascade on update cascade) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_bin;`,
}}
View Source
var Invert_pkData = []SetupScript{{
	"CREATE TABLE `invert_pk` (  `x` bigint NOT NULL,  `y` bigint NOT NULL,  `z` bigint NOT NULL,  PRIMARY KEY (`y`,`z`,`x`))",
	`insert into invert_pk values    (0, 2, 2),    (1, 1, 0),    (2, 0, 1)`,
}}
View Source
var JsontableData = []SetupScript{{
	`create table jsontable (pk smallint primary key, c1 varchar(20), c2 JSON, c3 JSON)`,
	`insert into jsontable values    (1, 'row one', '[1,2]', '{"a": 2}'),    (2, 'row two', '[3,4]', '{"b": 2}'),    (3, 'row three', '[5,6]', '{"c": 2}'),    (4, 'row four', '[7,8]', '{"d": 2}')`,
}}
View Source
var KeylessData = []SetupScript{{
	"CREATE TABLE `unique_keyless` (  `c0` bigint,  `c1` bigint)",
	`insert into unique_keyless values    (0,0),    (1,1),    (2,2)`,
	"CREATE TABLE `keyless` (  `c0` bigint,  `c1` bigint)",
	`insert into keyless values    (0,0),    (1,1),    (1,1),    (2,2)`,
}}
View Source
var Keyless_idxData = []SetupScript{{
	`CREATE INDEX keyless_c0_idx ON keyless (c0)`,
	`CREATE INDEX keyless_c0_c1_idx ON keyless (c0, c1)`,
	`CREATE INDEX keyless_c1_c0_odx ON keyless (c1, c0)`,
}}
View Source
var LoadtableData = []SetupScript{{
	`create table loadtable(pk int primary key)`,
}}
View Source
var MydbData = []SetupScript{{
	`create database if not exists mydb`,
	`use mydb`,
}}
View Source
var MyhistorytableData = []SetupScript{{
	"CREATE TABLE `myhistorytable` (  `i` bigint NOT NULL,  `s` varchar(20) NOT NULL,  `c` varchar(20) NOT NULL,  PRIMARY KEY (`i`))",
}}
View Source
var MytableData = []SetupScript{{
	`create table mytable (i bigint primary key, s varchar(20) comment 'column s' NOT NULL)`,
	`insert into mytable values    (1, 'first row'),    (2, 'second row'),    (3, 'third row')`,
	`create unique index mytable_s on mytable (s)`,
	`create index mytable_i_s on mytable (i,s)`,
	"create index `idx_si` on mytable (`s`,`i`)",
}}
View Source
var Mytable_del_idxData = []SetupScript{{
	`drop index mytable_s on mytable;`,
	`drop index mytable_i_s on mytable;`,
	`drop index idx_si on mytable;`,
}}
View Source
var NewlinetableData = []SetupScript{{
	"CREATE TABLE `newlinetable` (  `i` bigint NOT NULL,  `s` varchar(32) NOT NULL,  PRIMARY KEY (`i`))",
	`insert into newlinetable values    (1, '\nthere is some text in here'),	(2, 'there is some\ntext in here'),	(3, 'there is some text\nin here'),	(4, 'there is some text in here\n'),	(5, 'there is some text in here')`,
}}
View Source
var NiltableData = []SetupScript{{
	"CREATE TABLE `niltable` (  `i` bigint NOT NULL,  `i2` bigint,  `b` tinyint,  `f` double,  PRIMARY KEY (`i`))",
	`insert into niltable values    (1,null,null,null),    (2,2,1,null),    (3,null,0,null),    (4,4,null,4.0),    (5,null,1,5.0),    (6,6,0,6.0)`,
	`create index niltable_i2 on niltable (i2)`,
}}
View Source
var Null_rangesData = []SetupScript{{
	`create table null_ranges (x int primary key, y int)`,
	`create index idx1 on null_ranges (y);`,
	`insert into null_ranges values    (0,0),    (1,1),    (2,2),    (3,null),    (4,null)`,
}}
View Source
var Ordinals_ddlData = []SetupScript{{
	`CREATE TABLE short_ord_pk (x int not null, y int not null, primary key (y,x))`,
	`CREATE TABLE long_ord_pk1 (u int, v int, w int, x int, y int, z int, PRIMARY KEY (y,v))`,
	`CREATE TABLE long_ord_pk2 (u int, v int, w int, x int, y int, z int, PRIMARY KEY (y,v,x,z,u))`,
	`CREATE TABLE long_ord_pk3 (u int, v int, w int, ww int, x int, y int, z int, PRIMARY KEY (y,v,x,z,u))`,
	`CREATE TABLE ord_kl (u int, v int, w int, x int, y int, z int)`,
}}
View Source
var OthertableData = []SetupScript{{
	`create table othertable (s2 varchar(20) not null, i2 bigint primary key)`,
	`insert into othertable values    ('first', 3),    ('second', 2),    ('third', 1)`,
	`create index othertable_s2 on othertable (s2)`,
	`create index othertable_s2_i2 on othertable (s2,i2)`,
}}
View Source
var Othertable_del_idxData = []SetupScript{{
	`drop index othertable_s2 on othertable;`,
	`drop index othertable_s2_i2 on othertable;`,
}}
View Source
var Parent_childData = []SetupScript{{
	`CREATE TABLE parent (id INT PRIMARY KEY, v1 INT, v2 INT)`,
	`create index v1 on parent (v1)`,
	`create index v2 on parent (v2)`,
	`CREATE TABLE child (id INT PRIMARY KEY, v1 INT, v2 INT)`,
}}
View Source
var PeopleData = []SetupScript{{
	"CREATE TABLE `people` (  `dob` date NOT NULL,  `first_name` varchar(20) NOT NULL,  `last_name` varchar(20) NOT NULL,  `middle_name` varchar(20) NOT NULL,  `height_inches` bigint NOT NULL,  `gender` bigint NOT NULL,  PRIMARY KEY (`dob`,`first_name`,`last_name`,`middle_name`))",
	`insert into people values    ('1970-12-1', 'jon', 'smith', '', 72, 0),    ('1980-1-11', 'jon', 'smith', '', 67, 0),    ('1990-2-21', 'jane', 'doe', '', 68, 1),    ('2000-12-31', 'frank', 'franklin', '', 70, 2),    ('2010-3-15', 'jane', 'doe', '', 69, 1)`,
	`create index people_l_f on people (last_name,first_name)`,
}}
View Source
var Pk_tablesData = []SetupScript{{
	`create table one_pk (pk smallint primary key, c1 smallint, c2 smallint, c3 smallint, c4 smallint, c5 smallint)`,
	`insert into one_pk values    (0,0,1,2,3,4),    (1,10,11,12,13,14),    (2,20,21,22,23,24),    (3,30,31,32,33,34)`,
	`create table two_pk (    pk1 tinyint,    pk2 tinyint,    c1 tinyint NOT NULL,    c2 tinyint NOT NULL,    c3 tinyint NOT NULL,    c4 tinyint NOT NULL,    c5 tinyint NOT NULL,    primary key (pk1, pk2))`,
	`insert into two_pk values    (0,0,0,1,2,3,4),    (0,1,10,11,12,13,14),    (1,0,20,21,22,23,24),    (1,1,30,31,32,33,34)`,
	`create table one_pk_two_idx (    pk bigint primary key,    v1 bigint,    v2 bigint)`,
	`insert into one_pk_two_idx values    (0,0,0),    (1,1,1),    (2,2,2),    (3,3,3),    (4,4,4),    (5,5,5),    (6,6,6),    (7,7,7)`,
	`create table one_pk_three_idx (    pk bigint primary key,    v1 bigint,    v2 bigint,    v3 bigint)`,
	`insert into one_pk_three_idx values    (0,0,0,0),    (1,0,0,1),    (2,0,1,0),    (3,0,2,2),    (4,1,0,0),    (5,2,0,3),    (6,3,3,0),    (7,4,4,4)`,
	`create index one_pk_two_idx_1 on one_pk_two_idx (v1)`,
	`create index one_pk_two_idx_2 on one_pk_two_idx (v1, v2)`,
	`create index one_pk_three_idx_idx on one_pk_three_idx (v1, v2, v3)`,
}}
View Source
var Reserved_keywordsData = []SetupScript{{
	"CREATE TABLE `reservedWordsTable` (  `Timestamp` varchar(20) NOT NULL,  `and` varchar(20),  `or` varchar(20),  `select` varchar(20),  PRIMARY KEY (`Timestamp`))",
	`insert into reservedWordsTable values    ('1', '1.1', 'aaa', 'create')`,
}}
View Source
var SpatialData = []SetupScript{{
	`create table stringtogeojson_table (i bigint primary key, s blob)`,
	`insert into stringtogeojson_table values        (0, '{"type": "Point", "coordinates": [1,2]}'),        (1, '{"type": "Point", "coordinates": [123.45,56.789]}'),        (2, '{"type": "LineString", "coordinates": [[1,2],[3,4]]}'),        (3, '{"type": "LineString", "coordinates": [[1.23,2.345],[3.56789,4.56]]}'),        (4, '{"type": "Polygon", "coordinates": [[[1.1,2.2],[3.3,4.4],[5.5,6.6],[1.1,2.2]]]}'),        (5, '{"type": "Polygon", "coordinates": [[[0,0],[1,1],[2,2],[0,0]]]}'),        (6, '{"type": "MultiPoint", "coordinates": [[1,2],[3,4]]}'),        (7, '{"type": "MultiPoint", "coordinates": [[1.23,2.345],[3.56789,4.56]]}'),        (8, '{"type": "MultiLineString", "coordinates": [[[1.1,2.2],[3.3,4.4]],[[5.5,6.6],[7.7,8.8]]]}'),        (9, '{"type": "MultiPolygon", "coordinates": [[[[0.0, 0.0],[1.1,2.2],[3.3,4.4],[0.0,0.0]]],[[[1.1,1.1],[1.1,2.2],[3.3,4.4],[1.1,1.1]]]]}'),        (10, '{"type": "GeometryCollection", "geometries": [{"type": "GeometryCollection", "geometries":[]}]}')`,
	`create table geometry_table (i bigint primary key, g geometry NOT NULL)`,
	`insert into geometry_table values        (1, ST_GeomFromText('Point(1 2)')),        (2, ST_SRID(ST_GeomFromText('Point(1 2)'), 4326)),		(3, ST_GeomFromText('Linestring(1 2,3 4)')),		(4, ST_SRID(ST_GeomFromText('Linestring(1 2,3 4)'), 4326)),        (5, ST_GeomFromText('POLYGON((0 0,0 1,1 1,0 0))')),        (6, ST_SRID(ST_GeomFromText('POLYGON((0 0,0 1,1 1,0 0))'), 4326)),        (7, ST_GeomFromText('MultiPoint(1 2,3 4)')),		(8, ST_SRID(ST_GeomFromText('MultiPoint(1 2,3 4)'), 4326)),		(9, ST_GeomFromText('MULTILINESTRING((1 2,3 4))')),        (10, ST_SRID(ST_GeomFromText('MULTILINESTRING((1 2,3 4))'), 4326)),        (11, ST_GeomFromText('MultiPolygon(((0 0,1 2,3 4,0 0)))')),        (12, ST_SRID(ST_GeomFromText('MultiPolygon(((0 0,1 2,3 4,0 0)))'), 4326)),        (13, ST_GeomFromText('GeometryCollection(GeometryCollection())')),        (14, ST_SRID(ST_GeomFromText('GeometryCollection(GeometryCollection())'), 4326))`,
	`create table point_table (i bigint primary key, p point NOT NULL);`,
	`insert into point_table values (5, ST_GeomFromText('Point(1 2)'))`,
	`create table line_table (i bigint primary key, l linestring NOT NULL);`,
	`insert into line_table values    (0, ST_GeomFromText('Linestring(1 2,3 4)')),    (1, ST_GeomFromText('Linestring(1 2,3 4,5 6)'))`,
	`create table polygon_table (i bigint primary key, p polygon NOT NULL);`,
	`insert into polygon_table values    (0, ST_GeomFromText('Polygon((0 0,0 1,1 1,0 0))')),    (1, ST_GeomFromText('Polygon((0 0,0 1,1 1,0 0),(0 0,0 1,1 1,0 0))'))`,
	`create table mpoint_table (i bigint primary key, p multipoint NOT NULL);`,
	`insert into mpoint_table values    (0, ST_GeomFromText('MultiPoint(1 2,3 4)')),    (1, ST_GeomFromText('MultiPoint(1 2,3 4,5 6)'))`,
	`create table mline_table (i bigint primary key, l multilinestring NOT NULL);`,
	`insert into mline_table values    (0, ST_GeomFromText('MultiLineString((1 2,3 4))')),    (1, ST_GeomFromText('MultiLineString((1 2,3 4,5 6))'))`,
	`create table mpoly_table (i bigint primary key, p multipolygon NOT NULL);`,
	`insert into mpoly_table values    (0, ST_GeomFromText('MultiPolygon(((0 0,1 2,3 4,0 0)))')),    (1, ST_GeomFromText('MultiPolygon(((0 0,1 2,3 4,0 0)),((1 1,2 3,4 5,1 1)))'))`,
	`create table geom_coll_table (i bigint primary key, g geometrycollection NOT NULL);`,
	`insert into geom_coll_table values    (0, ST_GeomFromText('GeometryCollection(GeometryCollection())'))`,
}}
View Source
var SpecialtableData = []SetupScript{{
	`create table specialtable (id bigint primary key, name varchar(20))`,
	`insert into specialtable values    (1, 'first_row'),    (2, 'second_row'),    (3, 'third_row'),    (4, '%'),    (5, '\''),    (6, '\"'),    (7, '\t'),    (8, '\n'),    (9, "\v"),    (10, 'test%test'),    (11, 'test\'test'),    (12, 'test\"test'),    (13, 'test\ttest'),    (14, 'test\ntest'),    (15, 'test\vtest')`,
}}
View Source
var StringandtableData = []SetupScript{{
	"CREATE TABLE `stringandtable` (   `k` bigint NOT NULL,   `i` bigint,   `v` varchar(20),   PRIMARY KEY (`k`));",
	`insert into stringandtable values    (0, 0, '0'),    (1, 1, '1'),    (2, 2, ''),    (3, 3, 'true'),    (4, 4, 'false'),    (5, 5, null),    (6, null, '2');`,
}}
View Source
var TabletestData = []SetupScript{{
	`create table tabletest (    i int primary key,    s varchar(20) not null)`,
	`insert into tabletest values    (1, 'first row'),    (2, 'second row'),    (3, 'third row')`,
}}
View Source
var TestdbData = []SetupScript{{
	`create database test;`,
}}
View Source
var TypestableData = []SetupScript{{
	"CREATE TABLE `typestable` (  `id` bigint NOT NULL,  `i8` tinyint,  `i16` smallint,  `i32` int,  `i64` bigint,  `u8` tinyint unsigned,  `u16` smallint unsigned,  `u32` int unsigned,  `u64` bigint unsigned,  `f32` float,  `f64` double,  `ti` timestamp,  `da` date,  `te` varchar(20),  `bo` tinyint,  `js` json,  `bl` blob,  `e1` enum('', 'v1', 'v2'),  `s1` set('', 'v1', 'v2'),  PRIMARY KEY (`id`))",
	`insert into typestable values    (1,2,3,4,5,6,7,8,9,10.0,11.0,'2019-12-31T12:00:00Z','2019-12-31T00:00:00Z','fourteen', 0,null,null, '', '')`,
}}
View Source
var ViewsData = []SetupScript{{
	`CREATE VIEW myview1 AS SELECT * FROM myhistorytable`,
	`CREATE VIEW myview2 AS SELECT * FROM myview WHERE i = 1`,
}}
View Source
var XyData = []SetupScript{{
	`CREATE table xy (x int primary key, y int);`,
	`CREATE table uv (u int primary key, v int);`,
	`CREATE table ab (a int primary key, b int);`,
	`CREATE table pq (p int primary key, q int);`,
	`CREATE table mn (m int primary key, n int);`,
	`insert into xy values  (1,0),  (2,1),  (0,2),  (3,3);`,
	`insert into uv values  (0,1),  (1,1),  (2,2),  (3,2);`,
	`insert into ab values  (0,2),  (1,2),  (2,2),  (3,1);`,
	`insert into pq values  (0,0),  (1,1),  (2,2),  (3,3);`,
	`insert into mn values  (2,0),  (3,1),  (4,2),  (5,3);`,
}}

Functions

func NewFileSetup

func NewFileSetup(path string) (*fileSetup, error)

func NewStringSetup

func NewStringSetup(s ...string) []setupSource

Types

type SetupScript

type SetupScript []string

type Testdata

type Testdata struct {
	Sql string
	// contains filtered or unexported fields
}

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL