SELECT * FROM bytecode('SELECT 1');
SELECT * FROM tables_used('SELECT * FROM sqlite_schema');
uint
collation sequence, which compares strings of digits in numeric order.SELECT decimal_add('2', '3');
returns 5.SELECT decimal_sub('2', '3');
returns -1.SELECT decimal_mul('2', '3');
returns 6.CREATE TABLE t(a blob);
INSERT INTO t VALUES (x'01020304');
SELECT readblob('main', 't', 'a', 1, 0, 4);
SELECT * FROM sqlite_dbdata();
SELECT * FROM sqlite_dbptr();
SELECT delta_apply(x'0102', delta_create(x'0102', x'0304'));
select sqlite3_filename_database('main');
select sqlite3_filename_journal('main');
select sqlite3_filename_wal('main');
SELECT uuid();
SELECT uuid_str(uuid());
SELECT uuid_blob(uuid());
SELECT prefixes('abcdefg');
SELECT prefix_length('abcdxxx', 'abcyy');
yields 3.SELECT IsoWeek('2019-01-01');
SELECT IsoWeekYear('2019-01-01');
CREATE VIRTUAL TABLE t1 USING csv(filename='thefile.csv');
SELECT data FROM sqlite_dbpage('main');
SELECT checkfreelist('main');
SELECT sha3('abc', 256);
SELECT sha1('abc');
SELECT json_extract('{“a”:2,“c”:[4,5,{“f”:7}]}', '$.c[2].f');
SELECT * FROM generate_series(0,100,5);
spellfix
virtual table.:memory:
).ROWID
, OID
, or _ROWID_
) are in use by the table. This sould be very rare, however.Thanks to all who have reported bugs, suggestions and ideas to SQLiteSpy!