SQLite Forum

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

20 most recent forum posts

2024-05-04
01:34 Post: DB file size increases 10x size of data added with FTS5 table (artifact: 3ef2ebd994 user: anonymous)
2024-05-03
23:50 Reply: Result of JSON aggregate functions when WHERE clause is false (artifact: 264b5b32a8 user: anonymous)
18:34 Reply: sqlite >=3.44 - create table is 1000x slower when table name begins with a number (artifact: 07f1f957c3 user: stephan)
17:16 Reply: Result of JSON aggregate functions when WHERE clause is false (artifact: 8b89372e67 user: anonymous)
17:10 Reply: sqlite >=3.44 - create table is 1000x slower when table name begins with a number (artifact: db507c2ab1 user: lcarlp)
16:41 Reply: SELECT TYPEOF(CAST(NULL AS TEXT)); gives "null", not "text" (artifact: 19f9cfb830 user: lexfiend)
13:39 Reply: Result of JSON aggregate functions when WHERE clause is false (artifact: 286d818d7f user: dan)
11:42 Reply: Result of JSON aggregate functions when WHERE clause is false (artifact: 10c1078f7e user: stephan)
10:39 Reply: Result of JSON aggregate functions when WHERE clause is false (artifact: 1bd699cb1e user: drh)
10:36 Reply: Smalltime as primary key (artifact: 70546b1d23 user: punkish)
08:25 Reply: Casting a column in ORDER BY of UNION ALL doesn't recognize column name (artifact: 88af44ad68 user: anonymous)
03:52 Post: Casting a column in ORDER BY of UNION ALL doesn't recognize column name (artifact: 03912b5617 user: anonymous)
01:55 Post: Result of JSON aggregate functions when WHERE clause is false (artifact: ca2ed111bb user: anonymous)
2024-05-02
22:44 Reply: Smalltime as primary key (artifact: 9e05525ac7 user: stephancb)
19:51 Reply: SELECT TYPEOF(CAST(NULL AS TEXT)); gives "null", not "text" (artifact: bc099bd847 user: stephan)
19:39 Reply: SELECT TYPEOF(CAST(NULL AS TEXT)); gives "null", not "text" (artifact: 16444e95c2 user: NickCrews)
19:24 Reply: SELECT TYPEOF(CAST(NULL AS TEXT)); gives "null", not "text" (artifact: 49964f06d4 user: NickCrews)
19:21 Reply: SELECT TYPEOF(CAST(NULL AS TEXT)); gives "null", not "text" (artifact: c499fd1ceb user: drh)
19:16 Reply: SELECT TYPEOF(CAST(NULL AS TEXT)); gives "null", not "text" (artifact: 924fa80c47 user: NickCrews)
18:55 Reply: Smalltime as primary key (artifact: ffc2139f05 user: punkish)