Hi, I've used the new UPSERT with success with a complex SELECT, then got to scratch my head for a while on a much simpler query, so assuming this might be a bug:
CREATE TABLE T2 (A INTEGER PRIMARY KEY); INSERT INTO T2 VALUES (1); CREATE TABLE T1 (A INTEGER PRIMARY KEY); INSERT INTO T1 VALUES (1); INSERT INTO T1 (A) SELECT A FROM T2 ON CONFLICT(A) DO NOTHING; An SQL error has occurred: near "DO": syntax error sqlite3_prepare_v2 actually stops the statement after DO, so that pzTail points to " NOTHING". More complex SELECT statements (seems anything after the table name, e.g. WHERE or LIMIT will suffice) works: INSERT INTO T1 (A) SELECT A FROM T2 WHERE 1=1 ON CONFLICT(A) DO NOTHING I'm sure others have found this already? Regards, Paul. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
