## Summary **No review yet** ## Minimized query ```sql PRAGMA collation_list; PRAGMA table_info(users); ATTACH DATABASE ':memory:' AS aux70; CREATE TABLE [T1] ( a INTEGER, b TEXT ); CREATE TABLE T2 ( a INTEGER, b TEXT ); CREATE TABLE T ( a TEXT, b TEXT, c REAL ); INSERT INTO T VALUES ('a','b',datetime(date(json_insert(trim(NULL), '$.key', 1.5), 'start of month'), '+1 day')), ('a','c',-2.25), ('b','b',4.75); SELECT a, SUM(CASE WHEN b='b' THEN c ELSE 0 END) AS d, SUM(CASE WHEN b='c' THEN c ELSE 0 END) AS e FROM T GROUP BY a; INSERT INTO T1 VALUES (-2938525077890873167,'a'),(2,'b'); INSERT INTO T2 VALUES (1,'c'),(1,'d'); SELECT T1.b, ( SELECT GROUP_CONCAT(b,',') FROM T2 WHERE NOT T2.a=T1.a ) AS c FROM T1; SELECT * FROM T2; WITH RECURSIVE r AS (SELECT a FROM T1 UNION ALL SELECT a FROM T1 LIMIT 5) SELECT * FROM r; DELETE FROM T1 WHERE 0 RETURNING *; VACUUM; ANALYZE; INSERT INTO T2 DEFAULT VALUES; SELECT * FROM T1 NATURAL JOIN T2; WITH cte AS (SELECT NULL AS x, NULL AS y) SELECT x, y, x IS NULL FROM cte; DETACH DATABASE aux70; INSERT INTO T1 VALUES (NULL, NULL); INSERT INTO T1 SELECT * FROM T1; DELETE FROM T WHERE rowid = 10; SELECT * FROM T2 WHERE b = (SELECT SUM(b) FROM T2); CREATE TEMPORARY VIEW IF NOT EXISTS v_T2_6336 AS SELECT b FROM T2; SELECT * FROM T2; SELECT GROUP_CONCAT(a, '.') OVER (PARTITION BY a ORDER BY a) FROM T; ALTER TABLE T1 ADD COLUMN extra_9519 CHAR(10) COLLATE RTRIM; WITH cte AS (SELECT NULL AS x) SELECT COALESCE(x, 0) FROM cte; REINDEX; ``` ## Actual output ```sql 0|decimal 1|uint 2|RTRIM 3|NOCASE 4|BINARY a|0|-2.25 b|4.75|0 a|c,d b|c,d 1|c 1|d -2938525077890873167 2 -2938525077890873167 2 ||1 1|c 1|d | a.a a.a b 0 ``` ## Expectation ```sql 0|decimal 1|BINARY 2|NOCASE 3|RTRIM 4|uint a|0|-2.25 b|4.75|0 a|c,d b|c,d 1|c 1|d -2938525077890873167 2 -2938525077890873167 2 ||1 1|c 1|d | a.a a.a b 0 ``` ## Flag ``` ```