# xsql

sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> time(1 -11)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> time(1 AND-11)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> time(1 ||  -11)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> time(1 ||  -11)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> time(1 || .141)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> time(1 ||20011)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> time(1 ||20011)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> time(1, -1)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> time(1, -1)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> time(1,1,1)=2000;
INSERT INTO t4(a,b) VALUES(50, julianday(1,1,1)) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> time(1,1.1)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> time(1,1E1)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( 'a',1)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( 'a',1)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -11, -11)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -11, -11)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -11, round(1,1) -11)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -11,.001)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -11,1)-2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -11,1200 || -01)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -11,12001-20011)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -11,2001)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -11,2001)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -11,202001-01-0101)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -11,92001-01-01)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -11,92021-01-01)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -11,NULL)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -11,NULL)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -19,12001-01-01)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -19,12001-01-01)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( -19,12801-01-01)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( 111,12001-20011)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( 111,2001)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( 111,92001-01-01)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim( b> trim( -11,12001-20011)=200-11,12001-20011)=2000;
INSERT INTO t4(a,b) VALUES(50,60) OI CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(1,  json_parse(1))=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(1, round(1,1) /11)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(1, round(1,1)COLLATE nocase -11)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(1.1)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(12001-01- `a`)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(12001-01-01,12001-01-01)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(1E2001-01-011)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(2000,12001-20011)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(2001-01-019,1)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(9, 
11)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(9, 
11)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(9, ltrim(1,1))=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(9, ltrim(1,1))=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(9,20012001011)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(9,20012001011)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(9,20012001E11)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(92001-01-01,12001-01-01)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(92001-01-01,2001-01-011)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(NULL,1)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(NULL,1)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> typeof(1)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> typeof(1)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> unicode(1)=2000;
INSERT INTO t4(a,b) VALUES(50,60)


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> upper( 
11)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> upper( -11)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> upper(200/-01E011)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> upper(2001-01E011)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> upper(2001-01E011)=2000;
INSERT INTO t4(a,b) VALUES(50E60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> upper(2001-01E015)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> upper(2001-01E111)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> upper(2001-01E211)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> upper(2001-81E011)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> upper(NULL)=2000;
INSERT INTO t4(a,b) VALUES(50,60)ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> upper(NULL)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> zeroblob(1)|| 0;
INSERT INTO t4(a,b) VALUES(50,60)


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>.20000
IN ERT I


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>.20000
INSERT I


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>.2800;
INSERT INTO t4(a,b) VALUES(50,60)�ON


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>=2000;ANALYZE INTO 


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>>instr(1,1)=2000;
INSERT INTO t4(a,b) VALUES(50,60)


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>>json_remove(ALL)=2000;VACUUM


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>NOT substr(1,1, 'a'COLLATE nocase)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>length( ltrim(9,1))=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>length(1E2001-01-011)=2000;
INSERT INTO t4(a,b) VALUES(50,60)


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE json( -1 || 1);
INSERT INTO t4(a,b) VALUES(50,60)


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE json(1)IS `a`;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE json(1)NOTNULL;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE#b> round(1,1)AND 0;
INSERT INTO t4(a,b) VALUES(50,60)


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE+json(1);
INSERT INTO t4(a,b) VALUES(+0,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE+json(1)AND true INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE- 'a'in(1,1)=2000;
INSERT INTO t4(a,b) VALUES(50,60)�O;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE- [a]in(1<1)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE-b>>instr(1,1)=2000;
INSERT INTO t4(a,b) VALUES(50,60)


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;EXPLAIN
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> time(1,1,1)=2000;
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<10E0;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> json_array_length(1E1)=2000;
I


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1E00;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> trim(1E1)=2000;
INSERT INTO t4(a,b) VALUES(50,60)�G;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<<000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> json_remove(ALL)=2000;VACUUM


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<=000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b<=2000;REPLACE INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<?0000
CNTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b| `a`OR true;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>=2000;REPLACE INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE++++(+++++++++++++++b<1000;
CREATE UNIQUE INDEX t4a2 ON trlen�th(1,1)=;
I


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE++++++++++++++++++++b glob(1,1)ATE UNIQUE INDEX t4a2 ON trlen�th(1,1)=;
I


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE++++++++++++++++++++b,1000;
CREATE UNIQUE INDEX t4a2 ON trlen�th(1,1)=;
I


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE++++++++++++++++++++b<1000;
CREATE UNIQUE INDEX t4a2 ON trlen�th(1,1)=;
I


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE++++++++++++++++++++b<1000;REINDEX UNIQUE INDEX t4a2 ON trlen�th(1,1)=;
I


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE+++++++++-++++++++++b<1000;
CREATE UNIQUE INDEX t4a2 ON trlen�th(1,1)=;
I


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE++++++++-+++++++++++b<1000;
CREATE UNIQUE INDEX t4a2 ON trlen�th(1,1)=;
I


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE++++-+++++++++++++++b<1000;
CREATE UNIQUE INDEX t4a2 ON trlen�th(1,1)=;
I


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE+++-++++++++++++++++b<1000;
CREATE UNIQUE INDEX t4a2 ON trlen�th(1,1)=;
I


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE+NOT(1)IS true;
CNTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHI


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE+b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>=2000;REPLACE INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE+b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE+json(1);
INSERT INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE-/* */0;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>=2000;REPLACE INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE -11000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>52000;
ING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX t4�1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>=:000;
ING;


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX ���� ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> json_remove(ALL affinity(1))=2000;VACUUM


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX ���� ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX �˞� ON t4(a) WHERE b> json_remove(ALL)=2000;VACUUM


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX ���� ON t4(a) WHERE b<102001-01-0100;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> json_remove(ALL)=2000;VACUUM


sqltext:
CREATE TABLE t4(a INT, b INT);
CREATE UNIQUE INDEX ���� ON t4(a) WHERE b<>000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> json_remove(ALL)=2000;VACUUM


sqltext:
CREATE TABLE t4(a INT, b INT);EXPLAIN
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> json_remove(ALL)=2000;VACUUM


sqltext:
CREATE TABLE t4(a INT, b INT);EXPLAIN
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> json_set(1,1,1)=2000;


sqltext:
CREATE TABLE t4(a INT, b INT);EXPLAIN
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>=2000;REINDEX INTO 


sqltext:
CREATE TABLE t4(a INT, b INT);EXPLAIN
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;EXPLAIN
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> json_set(1,1,1)=2000;


sqltext:
CREATE TABLE t4(a INT, b INTobject);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> glob(1,1)=2000;
INSERT INTNFLICT


sqltext:
CREATE TABLE t4(a INT, b,INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b< `a`;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>= `a`;REPLACE INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT, b,INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b< `a`;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b>=2000;REPLACE INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INT1 b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE NOT/* */0;
CREATE UNIQUE INDEX t4a2 ON t4(a) W.ERE b>=2000;REPLACE INTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t4(a INTEXCEPT, b INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CREATE UNIQUE INDEX t4a2 ON t4(a) WHERE b> json_remove(ALL)=2000;VACUUM


sqltext:
CREATE TABLE t4(a IN���� INT);
CREATE UNIQUE INDEX t4a1 ON t4(a) W\E<1/*0;
C WHERE bO ecordb) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE t6(
  a I
  b INT UNIQUE ON CONFLICT replace,
  c INT UE6ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
PRIMARY KEY


sqltext:
CREATE TABLE t6(
  a INT UN COJFLICTONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  OT fail,
  N CONFLICT fail,
  dINTT UNIQUE ON CONFLICT replace
);
INSMRT INTO t6(a,b,c,d) VALU*S(1,2,3,4),(5,6,7,8),(1,100,11A,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ,N CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(b) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b DEFERRABLEbON CONFLICT realace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
PRIMARY KEY);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNI a,bO blobFLICT realace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNI a,bON CONFLICT rT real,
  c INT UNIQUE ON CONFLICT f OUPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNI a,bON CONFLICT rT real,
  c INrT real,
  c INT UNIQUE ON CONF�T UNIQUE ON CONF�ICT f OUPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNI a,bON CONFLICT realace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;VACUUM


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNI a,bON CONFLICT rep,ace,
  c INT UNIQ a,bN CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;VACUUM


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNI a,bON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;ANALYZE


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNI a,bON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;REINDEX


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNI a,bON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;REINDEX rtrim(1,1)


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNI a,bON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);EXPLAIN
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNI a,bON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
COLLATE nocase t6(;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ,N CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;VACUUM


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT  CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(G,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) SELECT *,2,3, a,b5,CONFLICT1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) SELECT(1,2,3, a,b5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) SELECT(SELECT a,b5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(  a,ba,b1,2,3, a,b5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES( /* */(1,1),6,7,8),(1,100,110,120)
  ON CONFLICT(b) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES( a,b1,2,3, a,b5,6,7,8),(1,100,110,1,0)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES( instr(1,1),6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;VACUUM


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1, a.b2,3,4),(5, a.b6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3, a.b5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3, a.b5�6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3, a.b����7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(?) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;ANALYZE


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,?20)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,?00,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,db,c,d) VALUES(1,2,3,4) VA


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);REPLACE INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;REINDEX


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
)WITHOUT ROWID t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,1,0)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
COLLATE nocase);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
COLLATE nocase);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;VACUUM


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
UNIQUE);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;VACUUM


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE UNIQUE ON CONFLICT fail,
SERT INTO


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c Iail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(�,100,110,120)
  ON CONFLICT(a) DO UPLATE SET aU1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c,INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT ROLLBACK);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(b) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE�ON CONFLICT replace�
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,A,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b INil,
IQUEUPDATE O1 CONFLICT rep UNIQUE ON CONFLICT fail,
  LICT fail,
  INDO t6(a,b,cS(1,2,3,4),(5,6,7,8),(1,100,11020���ON CWNFL6CT(a) DO UPDATE�SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b,INT UNI a,bON CONFLICT rep,ace,
  c INT UNIQ a,bN CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;VACUUM


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b,INT UNI a,bON CONFLICT rep,ace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);REPLACE INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b,INT,UNI a,bON CONFLICT rep,ace,
  c INT UNIQ a,bN CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE ON CONFLICT fail,
  b,INT,UNI a,bON CONFLICT rep,ace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);REPLACE INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a INT UNIQUE�ON CONFLICT fail,
  b INT UNI a,bON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
COLLATE nocase t6(;


sqltext:
CREATE TABLE t6(
  a I��������������������������������NT UNIQUE ON CONFLICT Fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,1C;
INSERT INTO t6DATE SET a=1000;


sqltext:
CREATE TABLE t6(
  a WITHOUT ROWIDINT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;VACUUM


sqltext:
CREATE TABLE t6(
  afaLl,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNIQUE ON CONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8),(1,100,110,120)
  ON CONFLICT(a) DO UPDATE SET a=1000;


sqltext:
CREATE TABLE t6INT(
  a INT UNIQUE ON CONFLICT fail,
  b INT UNIQUE ON CONFLICT replace,
  c INT UNRECURSIVEONFLICT fail,
  d INT UNIQUE ON CONFLICT replace
);
INSERT INTO t6(a,b,c,d) VALUES(1,2,3,4),(5,6,7,8)7(1,100,110,120)
  ON CONFLICT(a) DO UPD@TE SET a=1000;


sqltext:
CREATE TABLE t7( ``�a UNIQUE, b UNIQUE);
INSERT INTO t7(a,b) VALUES(1,1),(1,2) ON CONFLICT(b COLLATE binary) DO NOTHING;


sqltext:
CREATE TABLE t7(a IQUEUNIQUE, b UNIQUE);
INSERT INTO t7(a,b) VALUES(1,1),(1,2) ON CONFLICT(b COLLATE btnary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UN3QUE, b UNIQUE);
INSERT INTO t7(a,b) VALUES(1,1),(1,2) ON CONFLICT(b COLLATE bINTinary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNI REFERENCES"a"DEFERRABLE,"b"NIQUE);
INSERT INTO t7(a,b) VALUES(1,1),(1,2) ON CONFLICT(b COLLATE binary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNINGE, b UNIQUE);
INSERT INTO t7(a,b) VALUES(1,1),(1,2) ON CONFLICT(b COLLATE bixary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNIQCE, b UNIQUE);
INSEDT INTO t7(a,b) VALUES(1,1),(1,2) ON CONFLI��(b COLLATE binary' DO NOTHING;


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(a,a) VALUES(1,1),($1=11,2) ON CONFLICT(b COLLATE binary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(a,b) SELECT(1,1)-(1,2) ON CONFLICT(b COLLATE binary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(a,b) SELECT(1,1)=(1, total_changes() COLLATE binary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(a,b) SELECT(1,1)=(1,2)="a","b" ON CONFLICT(b COLLATE binary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(a,b) SELECT(1,1)=(1,2)ISNULL "a", json_extract(1,1)"b" ON CONFLICT(b COLLATE binary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(a,b) SELECT(1,2)=(1,2) "a","b" ON CONFLICT(b COLLATE binary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(a,b) SELECT(9,1)<(1,2) "a","b" ON CONFLICT(b COLLATE binary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(a,b) VALUES(1,1),(1,2) ON CONFLICT(?COLLATE nocase COLLATE binary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(a,b) VALUES(1,1),(1,2) ON CONFLICT(b COLLATE bina�y) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(a,b) VALUES(?,?),(1,2) ON CONFLICT(b COLLATE binary) DO NOTHING;ANALYZE


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(a,b) VALUES(?,?),(?,2) ON CONFLICT(b COLLATE binary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(a,b) VALUES(?,?),(?,?) ON CONFLICT(b COLLATE binary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(b,b) VALUES(1,1),( 1=11,2) ON CONFLICT(b COLLATE binary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(b,b) VALUES(1,1),($1=11,2) ON CONFLICT(b COLLATE binary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(b,b) VALUES(1,1),(2001-01-011,2) ON CONFLICT(b COLLATE binary) DO NOTHING;


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(b,b) VALUES(?,1),(1,2) ON CONFLICT(b COLLATE binary) DO NOTHING;?NALYZE


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE);
INSERT INTO t7(b,b) VALUES(?,1),(1,2) ON CONFLICT(b COLLATE binary) DO NOTHING;ANALYZE


sqltext:
CREATE TABLE t7(a UNIQUE, b UNIQUE); VALUES(1,1),(11,1),(1,1),(11,1),(1,2) ON CONFLICT(? COLLATE binary) DO NOTHING;


sqltext:
CREATE TABLE t8( [a] [a]IMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;VACUUM


sqltext:
CREATE TABLE t8( [a]TEACHMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;VACUUM


sqltext:
CREATE TABLE t8(a INATTACHARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INATTACHARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;VACUUM


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX ABORTt8x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;VACUUM


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8  ON t8((b||'x'));
INSERne',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8(  json_array(1,1,1),3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8( "a","b"COLLATE  a,bse);
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8( "a","b"COLLATE nocase);
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8( 'a''x')T INTO tne',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8( 'a''x'COLLATE binary)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8( char(1));
INSERT INTO t8(a,b,c) VALUES(1 glob(1,1), julianday(1,1,1),3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8( json(1));REINDEX INTO t   ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((NOT'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((NOT'x')COLLATE nocase);
INSERT INTO t8(a,b,c) VALUES(1,NOT'one'COLLATE'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b| LIKE(1,1, 
11)|'x'));
INSERT INTO t8FLICT((b||'x')) DO NOTHI


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b| LIKE(1,1, ' bm25(1)a')|'x'));
INSERT INTO t8FLICT((b||'x')) DO NOTHI


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b| LIKE(1,1, ' datetime(1,1,1)a')|'x'));
INSERT INTO t8FLICT((b||'x')) DO NOTHI


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b| LIKE(1,1, 'a')|'x'));
INSERT INTO t8FLICT((b||'x')) DO NOTHI


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b| LIKE(1,1, '�')|'x'));
INSERT INTO t8FLICT((b||'x')) DO NOTHI


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b| LIKE(1,1, -11)|'x'));
INSERT INTO t8FLICT((b||'x')) DO NOTHI


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b| LIKE(1,1,1)|'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
   ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b| LIKE(1,1,12001-01-01)|'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b| LIKE(1,1,2001-01-011)|'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b| date( 1=11)|'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
   ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b| date( 1=11)|'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b| date(1,12001-01-01,1)|'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
   ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b| date(1,12001-01-01,1)|'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b| json_type(1<1)|'x'));REINDEX INTO t8FLICT((b||'x')) DO NOTHI


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|x'x���,(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|| - 'a'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b|| @1)) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|| - - -1.1));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b|| @1)) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|| - -+1));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b|| @1)) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|| - -.1));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b|| @1)) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|| -A));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b|| @1)) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|| -NULL));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b|| @1)) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));
INSERT INTO t8(`,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1, julianday( 1=11),3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1, julianday(1,?,1),3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1, julianday(?,1,1),3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT( @1(b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')ASC) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x'COLLATE nocase)) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one�,3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one'IS true,2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));
INSERT INTO t8(a,c,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));REINDEXINTO t   ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));REINDEX rtrim(1,1)N CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x')ASC);
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')ASC) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x')ASC);REPLACE INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x')COLLATE  a,bse);
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x')COLLATE nocase);
INSERT INTO t8(a,b,c) VALUES(1,'onENDe',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;VACUUM


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x')COLLATE nocase);
INSERT INTO t8(a,b,c) VALUES(1,'onENDe',2),(2,'oneNO',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x')COLLATE nocase);
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')COLLATE nocase) DO NOTHING;VACUUM


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x')COLLATE nocase);
INSERT INTO t8(a,b,c) VALUES(1,'one'COLLATE'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x')COLLATE nocase);
INSERT INTO t8(a,b,c) VALUES(1,'on�',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x')COLLATE nocase);
INSERT INTO t8(a,b,c) VALUES(1,'on�',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;VACUUM


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x')COLLATE nocase);EXPLAIN
INSERT INTO t8(a,b,c) VALUES(1,'one'COLLATE'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x')DESC);
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x')DESC);
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;VACUUM


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x')DESC);
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')DESC NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'IS /* */NULL));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'IS [a]));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'ISNULL)ISNULL);
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'OR true));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||NOT'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
   ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|~' �daysx'));
INSERT INTO t8'one'HNG;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|~' '));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|~'+2 daysx'));
INSERT INTO t8'one'HING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|~'+2 �daysx'));
INSERT INTO t8'one'HING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|~'+2 �daysx'));
INSERT INTO t8'one'HING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|~'+2 �daysx'));
INSERT INTO t8'one'HING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|~'+2 daysx'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|~'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b|~'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|~NOT'+2 daysx' -1));
INSERT INTO t8'one'H


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|~NOT'+2 daysx'));
INSERT INTO t8'one'H


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|~NOT'+2 �daysx'));
INSERT INTO t8'one'HING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b|~NOT'+2 �daysx'));
INSERT INTO t8'one'H


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8(2001-01-01,1,1)|'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX �8x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;VACUUM


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX ��� ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;VACUUM


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX ��x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;VACUUM


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);EXPLAIN
CREATE UNIQUE INDEX t8x ON t8((b| 1<1|'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);EXPLAIN
CREATE UNIQUE INDEX t8x ON t8((b| 1=1|'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b, c);EXPLAIN
CREATE UNIQUE INDEX t8x ON t8((b| date(1,1,1)|'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INT PRIMARY KEY, b,CONSTRAINT c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t8(a INTCOMMIT PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));
INSERT INTO t8(a,b,c) VALUES(1,'one',2),(2,'one',3)
    ON CONFLICT((b||'x')) DO NOTHING;VACUUM


sqltext:
CREATE TABLE t8(a INT�PRIMARY KEY, b, c);
CREATE UNIQUE INDEX t8x ON t8((b||'x'));REINDEX rtrim(1,1)N CONFLICT((b||'x')) DO NOTHING;


sqltext:
CREATE TABLE t9(a CURRENT_TIMESTAMP b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES( sqlite_compileoption_used(1)),('jkl');(


sqltext:
CREATE TABLE t9(a CURRENT_TIMESTAMP b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc');(A count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEX INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi') 'abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PR,MARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc' -1);(A count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PR,MARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc');(A count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMART DEFAULT NT DEFAULT 1);
PRAGMA count_changes=
INSERT INTO t9(`) SELE@ 'abc'),('def'),('ghi'),('abP'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDAFESET b=b+1;
P


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA aount_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA bm25( -11)hang   ONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA co
nt_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA cou.t_changes=ON;
I'),('ghi')
    ON CONFLICT(a) DO UPDATE SET a=b+1;
P


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA couhanges=ON;
INSERT INTO t9(a) VALUES('abc'),(),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET a=b+1


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_chanRes=ON;VALUES('abc'),('def'),('ghi'),('abc')������������bc'),('ghi')
    ON @ONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changent_c;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changBs=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes (1)
ICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes-ONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes= -1
ICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes= trim'ghi')
  UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=NO;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) SELECT('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'), group_concat(1,1) "a","b"


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) SELECT('abc'),('def'),('ghi'),*'ghi')
 


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) SELECT(SELECT'abc'), avg(1),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
P


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) SELECT(SELECT'abc'), avg(1),(SELECT'ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
P


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES( sqlite_compileoption_used(1)),( json_object(1,1,1,1))
    ON CONFLICT(a) DO UPDATE SET b=b+1;
P


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES( sqlite_compileoption_used(1)),(' bm25(1)abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;REINDEX


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES( sqlite_compileoption_used(1)),('jkl'),('ibc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;REINDEX


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES( sqlite_compileoption_used(1)),('jkl');(


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES( sqlite_compileoption_used(1)),('jkl'AND'abc'),('ghi' -1)
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES( sqlite_compileoption_used(1)),('jkl'AND'abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES( sqlite_compileoption_used(1)),('jkl'AND'abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+2001-01-011;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES( sqlite_compileoption_used(?)),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;REINDEX


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),( json_valid(?)>='abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi' > strftime(1,1,1,1)='abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi' >='abc'),('jkl' >='abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi' >='abc'),('jkl'AND true),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi' >>' -1'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi' >>' -2001-11'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi' >>'2001-01'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi' >>'abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b= @1;
PRAGMA count_changes=OFF;END


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b= @1;
PRAGMA coun|_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+ sqlite_compileoption_used(1)


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes-OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes= 1=1


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;VACUUM


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abcTjkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;REINDEX


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi');('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def');('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'IN('def'),('ghi'IN('abc'),('jkl'),('abc'),('ghi')
 CT(a


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'IN()def'),('ghi'),(CT(a


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'IN(SELECT avg(1)HAVING'def'))a


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'IN(SELECT avg(1)WHERE'def'))a


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'IN(SELECT'def'),(SELECT'ghi'),('abc'),('jkl'),('abc')IN'ghi')
 CT(a


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abcTdef'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abcite_compileoption_used(1)jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET a=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abcite_compileoption_used(1)jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;REINDEX


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abcite_compileoption_used(1)jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b;1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('�bc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;REINDEX


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(b) VALUES('abc sqlite_compileoption_used(1)jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET a=b+1;
P


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(b) VALUES('abc'),('def'),('ghi' > @1='abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(b) VALUES('abc'),('def'),('ghi' >='abc'),('jkl' >='abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET a=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(b) VALUES('abc'),('def'),('ghi' >='abc'),('jkl' >='abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(b) VALUES('abc'),('def'),('ghi' >='abc'),('jkl' >='abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b;1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(b) VALUES('abc'),('def'),('ghi' >='abc'),('jkl'),('abc' >='ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(b) VALUES('abc'),('def'),('ghi' >='abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;ANALYZE


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(b) VALUES('abc'),('def'),('ghi' >='abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;REINDEX


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(b) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET a=b+1;
P


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;EXPLAIN
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET a=b+1;
P


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;EXPLAIN
INSERT INTO t9(a) VALUES('abc');(A count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;EXPLAIN QUERY PLAN VALUES( sqlite_compileoption_used(1)),('jkl');(


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;EXPLAIN QUERY PLAN VALUES('abcTdef'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=QN;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abcTjkl'),('abcTghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OLF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=�N;
INSERT INTO t9(a) VALUES('�bc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=FULL


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA sount_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET a=b+1;
P


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA �ount_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1);EXPLAIN QUERY PLAN
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT 1)WITHOUT ROWID;
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc sqlite_compileoption_get(1)ite_compileoption_used(1)jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;REINDEX


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT E);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT END1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT T);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'IN(SELECT 1=1'def'))('g(a


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT.1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT.1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('�bc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b || +1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFAULT.1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('�bc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMARY KEY, b INT DEFbc'),('jkl'),('abc'),('ghi')s=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),(�ghi')
    ON CONFLICT(a) DO UPDAPRludedcount_chanes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMAwwwwwwwwwwwwwwwwwwwwwRY KEgesY, b INT DEFAULT 1);
PRAGMA count_changes    =ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl')bc'),('ghi')
<   ON COa) DO UPDATE SET b=b+1;
PRAGOA coont_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXT PRIMKRY --T 1-;
PRAGMA coT PRIMARY ---------------- INTO;-----LT 1"def'),('ghi'),(CV(a


sqltext:
CREATE TABLE t9(a TEXT rmblob(1)b INT DEFAUL'def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET a=b+1;
P


sqltext:
CREATE TABLE t9(a TEXT9PRIMAc'),('jkl'TEXT),('abc')IN'ghi'PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'	N(('ghi'),('abc')IN'jkl'),('abc')IN'MAc'),('jkl'),('�bc')IN'ghi'PRghi')
 CT(a


sqltext:
CREATE TABLE t9(a TEXU�PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc');(A count_changes=OFF;


sqltext:
CREATE TABLE t9(a TEXU�PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;EXPLAIN QUERY PLAN VALUES('abc');(A count_changes=OFF;


sqltext:
CREATE TABLE t9(a T�XT PRIef'),('ghi'),('abc'),(T 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),(%ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_charges=OFF;


sqltext:
CREATE TABLE t9(a �EXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('ghi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE t9(a,TEXT PR,MARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc');(A count_changes=OFF;


sqltext:
CREATE TABLE t9(a,TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc');(A count_changes=OFF;


sqltext:
CREATE TABLE t9(af'),('�hi'),('abc'),('jkl'),('a TEXT PRIMARY KEY, b INT DEFAULT 1);
PRAGMA count_changes=ON;
INSERT INTO t9(a) VALUES('abc'),('def'),('�hi'),('abc'),('jkl'),('abc'),('ghi')
    ON CONFLICT(a) DO UPDATE SET b=b+1;
PRAGMA count_changes=OFF;


sqltext:
CREATE TABLE ��(a INT,ߝ߶NT);ANALYZE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CNTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TABLE ��(a INT, b INT);ANALYZE UNIQUE INDEX t4a1 ON t4(a) WHERE b<1000;
CNTO t4(a,b) VALUES(50,60) ON CONFLICT(a) DO NOTHING;


sqltext:
CREATE TEMPORARY
TABLE   b INRIMARY KEY(a,b)
) WITHOUT ROWID;
INSERT INTO t1(a,b) VALUES(1,2),(3,4),(1,2)ON CONFLICT(a,b) DO NOTHING;


sqltext:
CREATE TEMPORARY
TABLE AUTOINCREMENTKEY(a,b)
) WITHOUT ROWID;
INSERT INTO t1(a,b) VALUES(1,2),(3,4),(1,2)ON CONFLICT(a,b) DO NOTHING;


sqltext:
CREWITHOUT ROWID
  a INT,
  b INT UNIQUE,
  c INT DEFAULT 0,
  PRIMARY KEY(a,b)
) WITHOUT ROWID;
INSERT INTO t1(a,b) VALUES(1,2),(3,4),(1,2)ON CONFLICT(a,b) DO NOTHING;


sqltext:
EXPLAIN  CREATE TABLE t1(a INT PRIMARY KEY, b int, c DEFAULT 0) WITHOUT ROWID;
  INSERT INTO t1(a,b) VALUES(1,2),(3,4);
  INSERT INTO t1(a,b) VALUES(1,8),(2,11),(3,1)
    ON CONFLICT(a) DO UPDATE SET b=excluded.b, c=c+1 WHERE t1.b<excluded.b;
  SELECT *, 'x' FROM t1 ORDER BY a;


sqltext:
EXPLAIN  CREATE TABLE t1(a INTEGER PRIMARY KEY, b INT, c DEFAULT 0);
 ANALYZE UNIQUE INDEX t1x1 ON t1(a+b);
  INOTHING;
  SELECT * FROM 


sqltext:
EXPLAIN END CREATE ROLLBACK(TEGER PRIMARY KEY, b INT, c DEFAULT 0);
  CREATE UNIQUE INDEX t1x1 ON t1(a+b);
  INOTHING;
  SELECT * FROM 


sqltext:
EXPLAIN QUERY PLAN  CREATE TABLE t1(a INTEGER PRIMARY KEY, b INT, c DEFAULT 0);
  CREATE UNIQUE INDEX t1x1 ON t1(a+b);
 ECT * FROM t1;


sqltext:
EXPLAIN QUERY PLAN ATTACH(x) AS (values(1))   b WITHOUT ROWID;
INSERT INTO t1(a,b) VALUES(1,2),(3,4),(1,2)ON CONFLICT(a,b) DO NOTHING;


sqltext:
EXPLAIN QUERY PLAN DETACH affinity(1)COLLATE nocase IN (1)RY KTHOUT ROWID;
INSERT INTO t1(a,b) VALUES(1,2),(3,4),(1,2)ON CONFLICT(a,b) DO NOTHING;


sqltext:
EXPLAIN QUERY PLAN REINDEX CREATE TABLE EGER PRIMARY KEY, b INT, c DEFAULT 0);
  CREATE UNIQUE INDEX t1x1 ON t1(a+b);
 ECT * FROM t1;


sqltext:
EXPLAIN REINDEX CREATE TABLE t1(a INTEGER PRIMARY KEY, b INT, c DEFAULT 0);
  CREATE UNIQUE INDEX t1x1 ON t1(a+b);
  INOTHING;
  SELECT * FROM 


sqltext:
EXPLAIN WITH c(x) AS (values(1))   SELECT sqlite_source_id() ROWID;
INSERT INTO t1(a,b) VALUES(1,2),(3,4),(1,2)ON CONFLICT(a,b) DO NOTHING;


sqltext:
GER T 0);
  CREALE record(x TEXT, y TEXT);
  CREATE TRIGGER r1 BEFORE INSERT ON t1 BEGIN
  X INSERT INTO record(x,y)
        VALUES('beforeR r1 BEFOREn�����������ew.a,new.b,new.c)              like(1,1));
  END;
  CREAME TRIGNER r2 AFTER INSERT O `a` dGIN?    INSERT  record(x,y)     VALUES('afw.a,new.b, BEFOVE UPDATES(' t1 BEGIN
    INJOIN INTOES('before-update',printf(%d,%d,%d/%d,%d,%d',
                              old.a,old.b,old.c0new.a,new.b,�ew.;
  END;
  CREAFE TtFTER UPDATE ON t1 BEGIN
    INSERT INTO record(x,y)
 EATE TRIG%d,%d'	
            >        C        '      old.a,old.b,old.c,new.a,new.b,new.c));
 3END;
  I(VART INTO t1(a,b2 VAONF�record;
  INSERT IITO t1(a,b) VALUES(1,2)
    ON ONFLICT(a) DO UPDATEdSET c=t�c+1;
� =ELECT * FROM record;
  DELET@FROM record;
  INSERT INTO t(a,b) VALUES(1,2)
    ON CONFLICT(a) DO URDATE SET c=c+1 WHERE c<0;
  SELECT * FROM rgcord;


sqltext:
PRAGMA TEMP.RARY
CURRENT_TIMESTAMP KEY(a,b)
) WITHOUT ROWID;
INSERT INTO t1(a,b) VALUES(1,2),(3,4),(1,2)ON CONFLICT(a,b) DO NOTHING;


sqltext:
PRAGMA TEMPORARY
CURRENT_TIMESTAMP KEY(a,b)
) WITHOUT ROWID;
INSERT INTO t1(a,b) VALUES(1,2),(3,4),(1,2)ON CONFLICT(a,b) DO NOTHING;


sqltext:
RELEASE QUERYPLAN a,
  b INRIMARY KEY(a,b)
) WITHOUT ROWID;
INSERT INTO t1(a,b) VALUES(1,2),(3,4),(1,2)ON CONFLICT(a,b) DO NOTHING;


sqltext:
SELECT TEMPORARY
  a,
  b I,RIMARY KEY(a,b)
) WITHOUT ROWID;
INSERT INTO t1(a,b) VALUES(1,2),(3,4),(1,2)ON CONFLICT(a,b) DO NOTHING;


sqltext:
SELECT TEMPORARY
  a,
  b INRIMARY KEY(a,b)
) WITHOUT ROWID;
INSERT INTO t1(a,b) VALUES(1,2),(3,4),(1,2)ON CONFLICT(a,b) DO NOTHING;


sqltext:
SELECT TEMPORARY
ORDER BY INRIMARY KEY(a,b)
) WITHOUT ROWID;
INSERT INTO t1(a,b) VALUES(1,2),(3,4),(1,2)ON CONFLICT(a,b) DO NOTHING;


sqltext:
SELECT gesTAB>E��aMb(b,d))a,b����aTEXT`�2�QAT[oCREATE TABE�d)SoCREATE TABE�d)S�r LICT[OLQAT]9noCASTCREATE1,e2COLQAT[oCREATE TABE�d)S�r LIT


sqltext:
VACUUM;ANALYZE TEE t1(T ignore,
    PRIMARY KEY(b),
    UNIQUE(c) ON CICT fail
) WITHOUT ROWID;
CREATE INDEX t1d ON t1(d);ANALYZE TEMP;


sqltext:
VALUES(1, 'a''b'),(1,2)ON CON@LCREATE TABLE t1(
  a INT,
  b INT UNIQEE,
  c INT�������IMARY t1(
  a INT, KEY(
ZNSERT INTO t1(a,b) VALUES(1, 'a''b'),(1,2)ON CONFLICT(a,b) DO NOTHING;


sqltext:
VALUES(1,2), (1)(INTCRE TE)TABLE1(QgE,� INEMPFPORYNVALUES(1,2),(3,+),(2)ON CONFLICD����������� PRIEHOUY ROW�D6
T(rr�


sqltext:
VALUES(1,2),(INTCRE TE)TABLE1(QgE,� INEMPFPORYNVALUES(1,2),(3,+),(2)ON CONFLICD����������� PRIEHOUY ROW�D6
T(rr�rr


sqltext:
VALUES(1E-)BYINTCRE TE)TABLE1(QgE,� INEMPFPORYNVALUES(1,2),(3,+),(2)ON CONFLICD����������� PRIEHOUY ROW�D6
T(rr�rr


sqltext:
VALUES(1E2);YINTCRE TE)TABLE1(QgE,� INEMPFPORYNVALUES(1,2),(3,+),(2)ON CONFLICD����������� PRIEHOUY ROW�D6
T(rr�rr


sqltext:
VALUES(1E6)BYINTCRE TE)TABLE1(QgE,� INEMPFPORYNVALUES(1,2),(3,+),(2)ON CONFLICD����������� PRIEHOUY ROW�D6
T(rr�rr


sqltext:
[REATE TABLE t1(
  a INT,
  b INT UNIQUE,
  c INT DEFAULT 0,
  PRIMARY KEY(a,b)
) WITHOUT ROWID;
INSERT INTO t1(a,b) VALUES(1,2),(3,4),(1,2)ON CONFLICT(a,b) DO NOTHING;


sqltext:
` CREATE TABLE t1(a INTEGER PRIMARY KEY, b int, c DEFAULT 0);
  CREATE TABLE record(x TEXT, y TEXT);
  CREATE TRIGGER r1 BEFORE INSERT ON t1 BEGIN
    INSERT INTO record(x,y)
        VALUES('before-insert',printf('%d,%d,%d',new.a,new.b,new.c));
  END;
  CREATE TRIGGER r2 AFTER INSERT ON t1 BEGIN
    INSERT INTO record(x,y)     VALUES('after-insert',printf('%d,%d,%d',new.a,new.b,new.c));
  END;
  CREATE TRIGGER r3 BEFORE UPDATE ON t1 BEGIN
    INSERT INTO record(x,y)
        VALUES('before-update',printf('%d,%d,%d/%d,%d,%d',
                              old.a,old.b,old.c,new.a,new.b,new.c));
  END;
  CREATE TRIGGER r4 AFTER UPDATE ON t1 BEGIN
    INSERT INTO record(x,y)
        VALUES('after-update',printf('%d,%d,%d/%d,%d,%d',
                                      old.a,old.b,old.c,new.a,new.b,new.c));
  END;
  INSERT INTO t1(a,b) VALUES(1,2);
  DELETE FROM record;
  INSERT INTO t1(a,b) VALUES(1,2)
    ON CONFLICT(a) DO UPDATE SET c=t1.c+1;
  SELECT * FROM record;
  DELETE FROM record;
  INSERT INTO t1(a,b) VALUES(1,2)
    ON CONFLICT(a) DO UPDATE SET c=c+1 WHERE c<0;
  SELECT * FROM record;


