## Summary **No review yet** ## Minimized query ```sql BEGIN; ATTACH DATABASE ':memory:' AS aux99; CREATE TABLE "T" ( a INTEGER, b REAL ); INSERT INTO T VALUES (cos(radians(cos((atan2(-ceiling(2152360615332253255), 1) + 0.0)))),1.5), (2,-2.5), (3,0.0); CREATE INDEX c ON T(b); SELECT * FROM T WHERE b >= -2.5 AND b < 2.0; SAVEPOINT sp4239; .exit SAVEPOINT sp5255; PRAGMA synchronous = ('EXTRA' || ''); PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(x'1ed234f50577', (-(-(1)) + 0.0))),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE +rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0); SELECT * FROM T WHERE c < 2.0 ORDER BY c; INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; ROLLBACK TO sp5255; RELEASE sp5255; ROLLBACK TRANSACTION TO SAVEPOINT sp4239; RELEASE SAVEPOINT sp4239; DETACH DATABASE aux99; SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid; COMMIT; DELETE FROM T WHERE 0 RETURNING *; UPDATE T SET a = '' RETURNING *; SELECT * FROM T; ALTER TABLE T RENAME TO T_r4408; VACUUM; ALTER TABLE T ADD COLUMN extra_4934 TEXT DEFAULT (random()); ALTER TABLE T RENAME COLUMN b TO b_r7931; SELECT COUNT(*) FILTER (WHERE b IS NOT NULL), SUM(rowid) FILTER (WHERE b > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(b) FILTER (WHERE b > 0 AND b < 100), COUNT(*) FILTER (WHERE typeof(b) = "text") FROM T; ALTER TABLE T RENAME TO T_r5797; REINDEX T; SELECT COUNT(*) FROM T; SELECT * FROM (SELECT * FROM (SELECT * FROM T) AS inner1) AS inner2; INSERT INTO T SELECT * FROM T; WITH cte AS (SELECT "123" AS x) SELECT x + 0 FROM cte; REINDEX; VACUUM main; SELECT MAX(c) FROM T; DROP INDEX IF EXISTS T; BEGIN; ATTACH DATABASE ':memory:' AS aux99; CREATE TABLE "T" ( a INTEGER, b REAL ); INSERT INTO T VALUES (cos(radians(cos((atan2(-2152360615332253255, 1) + 0.0)))),1.5), (2,-2.5), (3,0.0); CREATE INDEX c ON T(b); SELECT * FROM T WHERE b >= -2.5 AND b < 2.0; SAVEPOINT sp4239; .exit SAVEPOINT sp5255; PRAGMA synchronous = ('EXTRA' || ''); PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(x'1ed234f50577', (-(-(1)) + 0.0))),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE +rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0); SELECT * FROM T WHERE c < 2.0 ORDER BY c; INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; ROLLBACK TO sp5255; RELEASE sp5255; ROLLBACK TRANSACTION TO SAVEPOINT sp4239; RELEASE SAVEPOINT sp4239; DETACH DATABASE aux99; SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid; COMMIT; DELETE FROM T WHERE 0 RETURNING *; UPDATE T SET a = '' RETURNING *; SELECT * FROM T; ALTER TABLE T RENAME TO T_r4408; VACUUM; ALTER TABLE T ADD COLUMN extra_4934 TEXT DEFAULT (random()); ALTER TABLE T RENAME COLUMN b TO b_r7931; SELECT COUNT(*) FILTER (WHERE b IS NOT NULL), SUM(rowid) FILTER (WHERE b > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(b) FILTER (WHERE b > 0 AND b < 100), COUNT(*) FILTER (WHERE typeof(b) = "text") FROM T; ALTER TABLE T RENAME TO T_r5797; REINDEX T; SELECT COUNT(*) FROM T; SELECT * FROM (SELECT * FROM (SELECT * FROM T) AS inner1) AS inner2; INSERT INTO T SELECT * FROM T; WITH cte AS (SELECT "123" AS x) SELECT x + 0 FROM cte; REINDEX; VACUUM main; SELECT MAX(c) FROM T; DROP INDEX IF EXISTS T; BEGIN; ATTACH DATABASE ':memory:' AS aux99; CREATE TABLE "T" ( a INTEGER, b REAL ); INSERT INTO T VALUES (cos(radians(cos((atan2(-2152360615332253255, 1) + 0.0)))),1.5), (2,-2.5), (3,0.0); CREATE INDEX c ON T(b); SELECT * FROM T WHERE b >= -2.5 AND b < 2.0; SAVEPOINT sp4239; .exit SAVEPOINT sp5255; PRAGMA synchronous = ('EXTRA' || ''); PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(x'1ed234f50577', (-(-(1)) + 0.0))),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE +rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0); SELECT * FROM T WHERE c < 2.0 ORDER BY c; INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; ROLLBACK TO sp5255; RELEASE sp5255; ROLLBACK TRANSACTION TO SAVEPOINT sp4239; RELEASE SAVEPOINT sp4239; DETACH DATABASE aux99; SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid; COMMIT; DELETE FROM T WHERE 0 RETURNING *; UPDATE T SET a = '' RETURNING *; SELECT * FROM T; ALTER TABLE T RENAME TO T_r4408; VACUUM; ALTER TABLE T ADD COLUMN extra_4934 TEXT DEFAULT (random()); ALTER TABLE T RENAME COLUMN b TO b_r7931; SELECT COUNT(*) FILTER (WHERE b IS NOT NULL), SUM(rowid) FILTER (WHERE b > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(b) FILTER (WHERE b > 0 AND b < 100), COUNT(*) FILTER (WHERE typeof(b) = "text") FROM T; ALTER TABLE T RENAME TO T_r5797; REINDEX T; SELECT COUNT(*) FROM T; SELECT * FROM (SELECT * FROM (SELECT * FROM T) AS inner1) AS inner2; INSERT INTO T SELECT * FROM T; WITH cte AS (SELECT "123" AS x) SELECT x + 0 FROM cte; REINDEX; VACUUM main; SELECT MAX(c) FROM T; DROP INDEX IF EXISTS T; BEGIN; ATTACH DATABASE ':memory:' AS aux99; CREATE TABLE "T" ( a INTEGER, b REAL ); INSERT INTO T VALUES (cos(radians(cos((atan2(-2152360615332253255, 1) + 0.0)))),1.5), (2,-2.5), (3,0.0); CREATE INDEX c ON T(b); SELECT * FROM T WHERE b >= -2.5 AND b < 2.0; SAVEPOINT sp4239; .exit SAVEPOINT sp5255; PRAGMA synchronous = ('EXTRA' || ''); PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(x'1ed234f50577', (-(-(1)) + 0.0))),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE +rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0); SELECT * FROM T WHERE c < 2.0 ORDER BY c; INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; ROLLBACK TO sp5255; RELEASE sp5255; ROLLBACK TRANSACTION TO SAVEPOINT sp4239; RELEASE SAVEPOINT sp4239; DETACH DATABASE aux99; SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid; COMMIT; DELETE FROM T WHERE 0 RETURNING *; UPDATE T SET a = '' RETURNING *; SELECT * FROM T; ALTER TABLE T RENAME TO T_r4408; VACUUM; ALTER TABLE T ADD COLUMN extra_4934 TEXT DEFAULT (random()); ALTER TABLE T RENAME COLUMN b TO b_r7931; SELECT COUNT(*) FILTER (WHERE b IS NOT NULL), SUM(rowid) FILTER (WHERE b > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(b) FILTER (WHERE b > 0 AND b < 100), COUNT(*) FILTER (WHERE typeof(b) = "text") FROM T; ALTER TABLE T RENAME TO T_r5797; REINDEX T; SELECT COUNT(*) FROM T; SELECT * FROM (SELECT * FROM (SELECT * FROM T) AS inner1) AS inner2; INSERT INTO T SELECT * FROM T; WITH cte AS (SELECT "123" AS x) SELECT x + 0 FROM cte; REINDEX; VACUUM main; SELECT MAX(c) FROM T; DROP INDEX IF EXISTS T; BEGIN; ATTACH DATABASE ':memory:' AS aux99; CREATE TABLE "T" ( a INTEGER, b REAL ); INSERT INTO T VALUES (cos(radians(cos((atan2(-2152360615332253255, 1) + 0.0)))),1.5), (2,-2.5), (3,0.0); CREATE INDEX c ON T(b); SELECT * FROM T WHERE b >= -2.5 AND b < 2.0; SAVEPOINT sp4239; .exit SAVEPOINT sp5255; PRAGMA synchronous = ('EXTRA' || ''); PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(x'1ed234f50577', (-(-(1)) + 0.0))),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE +rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',0.0); SELECT * FROM T WHERE c < 2.0 ORDER BY c; INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; PRAGMA secure_delete; PRAGMA writable_schema = TRUE; SAVEPOINT sp6571; .output blablabla.whatever CREATE TABLE [T] ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (ln(log(CAST(nullif('same', x'6d5f') AS CHARINT))),'a',floor(substr(6182170659521273916, 1)),-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) = 5 AND ABS(d) > 5; INSERT INTO T DEFAULT VALUES; DELETE FROM T WHERE rowid = 63 RETURNING *; ROLLBACK TRANSACTION TO SAVEPOINT sp6571; RELEASE SAVEPOINT sp6571; ROLLBACK TO sp5255; RELEASE sp5255; ROLLBACK TRANSACTION TO SAVEPOINT sp4239; RELEASE SAVEPOINT sp4239; DETACH DATABASE aux99; SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid; COMMIT; DELETE FROM T WHERE 0 RETURNING *; UPDATE T SET a = '' RETURNING *; SELECT * FROM T; ALTER TABLE T RENAME TO T_r4408; VACUUM; ALTER TABLE T ADD COLUMN extra_4934 TEXT DEFAULT (random()); ALTER TABLE T RENAME COLUMN b TO b_r7931; SELECT COUNT(*) FILTER (WHERE b IS NOT NULL), SUM(rowid) FILTER (WHERE b > 0), COUNT(*) FILTER (WHERE 1=0), COUNT(*) FILTER (WHERE 1=1), COUNT(*) FILTER (WHERE NULL), AVG(b) FILTER (WHERE b > 0 AND b < 100), COUNT(*) FILTER (WHERE typeof(b) = "text") FROM T; ALTER TABLE T RENAME TO T_r5797; REINDEX T; SELECT COUNT(*) FROM T; SELECT * FROM (SELECT * FROM (SELECT * FROM T) AS inner1) AS inner2; INSERT INTO T SELECT * FROM T; WITH cte AS (SELECT "123" AS x) SELECT x + 0 FROM cte; REINDEX; VACUUM main; SELECT MAX(c) FROM T; DROP INDEX IF EXISTS T; SELECT * FROM T AS a INNER JOIN T AS b ON a.rowid = b.rowid; ``` ## Actual output ```sql Usage: /home/test/sqlite3-src/build/sqlite3 [OPTIONS] FILENAME [SQL] FILENAME is the name of an SQLite database. A new database is created if the file does not previously exist. OPTIONS include: -append append the database to the end of the file -ascii set output mode to 'ascii' -bail stop after hitting an error -batch force batch I/O -box set output mode to 'box' -column set output mode to 'column' -cmd COMMAND run "COMMAND" before reading stdin -csv set output mode to 'csv' -deserialize open the database using sqlite3_deserialize() -echo print commands before execution -init FILENAME read/process named file -[no]header turn headers on or off -help show this message -html set output mode to HTML -interactive force interactive I/O -json set output mode to 'json' -line set output mode to 'line' -list set output mode to 'list' -lookaside SIZE N use N entries of SZ bytes for lookaside memory -markdown set output mode to 'markdown' -maxsize N maximum size for a --deserialize database -memtrace trace all memory allocations and deallocations -mmap N default mmap size set to N -newline SEP set output row separator. Default: '\n' -nofollow refuse to open symbolic links to database files -nonce STRING set the safe-mode escape nonce -nullvalue TEXT set text string for NULL values. Default '' -pagecache SIZE N use N slots of SZ bytes each for page cache memory -quote set output mode to 'quote' -readonly open the database read-only -safe enable safe-mode -separator SEP set output column separator. Default: '|' -stats print memory stats before each finalize -table set output mode to 'table' -tabs set output mode to 'tabs' -version show SQLite version -vfs NAME use NAME as the default VFS ``` ## Expectation ```sql ``` ## Flag ``` -help ```