text: CREATE TABLE t1(i INT) $$
  CREATE INDEX idx1 ON t1(i);
  CREATE INDEX idx1 ON t1(i);
  CREATE INDEX IF NOT EXISTS idx1 ON t1(i);
  CREATE UNIQUE INDEX idx1 ON t1(i);
  CREATE UNIQUE INDEX idx2 ON t1(i);
  CREATE INDEX 'idx3' ON t1(i);
  CREATE INDEX "idx4" ON t1(i);
  CREATE INDEX `idx5` ON t1(i);
  CREATE INDEX idx6 ON t1('i');
  CREATE INDEX IF NOT EXISTS idx7 ON t1('i');
  
  CREATE TABLE t2(i INT, j INT) $$
  CREATE INDEX idx1 ON t2 (i) WHERE (j > 10);
  CREATE INDEX idx3 ON t2(i,j);
  CREATE INDEX idx3 ON t2(i,j);
  CREATE INDEX idx3 ON t2(i);
  CREATE INDEX idx4 ON t2(i,j);
  
  CREATE TABLE t3(i INT, j INT) $$
  CREATE INDEX idx1 ON t3(i) OPTION DATACOPY;
  CREATE INDEX idx2 ON t3(i) OPTION DATACOPY WHERE (j > 10);
  CREATE INDEX idx3 ON t3(i COLLATE DATACOPY);
  
  CREATE TABLE t4(i INT) $$
  CREATE INDEX 'uniqueidxname' ON t4(i);
  CREATE INDEX 'sameidxname' ON t4(i);
  CREATE TABLE t5(i INT) $$
  CREATE INDEX 'sameidxname' ON t5(i);
  DROP INDEX 'uniqueidxnameXXX';
  DROP INDEX IF EXISTS 'uniqueidxnameXXX';
  DROP INDEX 'uniqueidxname';
  DROP INDEX 'sameidxname';
  DROP INDEX 'sameidxname' ON t5;
  DROP INDEX IF EXISTS 'sameidxname';
  
  SELECT * FROM comdb2_tables WHERE tablename NOT LIKE 'sqlite_stat%';
  SELECT * FROM comdb2_columns WHERE tablename NOT LIKE 'sqlite_stat%';
  SELECT * FROM comdb2_keys WHERE tablename NOT LIKE 'sqlite_stat%';
  SELECT * FROM comdb2_constraints WHERE tablename NOT LIKE 'sqlite_stat%';
  SELECT * FROM sqlite_master WHERE name NOT LIKE 'sqlite_stat%';
  DROP TABLE t1;
  DROP TABLE t2;
  DROP TABLE t3;
  DROP TABLE t4;
  DROP TABLE t5;
  
  CREATE TABLE t1(i INT PRIMARY KEY) $$
  CREATE TABLE t2(i INT) $$
  CREATE INDEX 'COMDB2_PK' ON t1(i);
  CREATE INDEX 'COMDB2_PK' ON t2(i);
  DROP INDEX 'COMDB2_PK' ON t1;
  
  SELECT * FROM comdb2_tables WHERE tablename NOT LIKE 'sqlite_stat%';
  SELECT * FROM comdb2_columns WHERE tablename NOT LIKE 'sqlite_stat%';
  SELECT * FROM comdb2_keys WHERE tablename NOT LIKE 'sqlite_stat%';
  SELECT * FROM comdb2_constraints WHERE tablename NOT LIKE 'sqlite_stat%';
  SELECT * FROM sqlite_master WHERE name NOT LIKE 'sqlite_stat%';
  DROP TABLE t1;
  DROP TABLE t2;
  
  # https://github.com/bloomberg/comdb2/issues/855
  CREATE TABLE t1(i INT) $$
  CREATE INDEX idx1 ON t1(i) WHERE i > 1;
  CREATE INDEX idx2 ON t1(i) WHERE (i > 1);
  SELECT * FROM sqlite_master WHERE name = 't1';
  DROP TABLE t1;
  
  CREATE TABLE t1(i INT) $$
  CREATE INDEX idx1 ON t1(i+i)
  CREATE INDEX idx1 ON t1('i+i')
  CREATE INDEX idx1 ON t1(where i > 1)
  CREATE INDEX idx1 ON t1(wherei > 1)
  DROP TABLE t1;
  
  CREATE TABLE t1(v CSTRING(10))$$
  CREATE INDEX idx1 ON t1(CAST(v || 'aaa' AS CSTRING(10)));
  SELECT csc2 FROM sqlite_master WHERE name NOT LIKE 'sqlite_stat%';
  DROP TABLE t1;
  