Summary
It seems that the markdown flag is supported, but the "COALESCE" is buggy. It is a logic bug because the output is different
Minimized query
CREATE TABLE T (
a TEXT,
b TEXT,
c REAL
);
INSERT INTO T VALUES ('a','b',concat_ws('|', 'a', NULL, 'b')), ('a','c',-1.0), ('b','d',0.0);
SELECT
COALESCE(a,'e') AS d,
COALESCE(b,'f') AS e,
SUM(c) AS f
FROM T
GROUP BY a,b;
WITH cte(a, b, c) AS (SELECT b, b, b FROM T) SELECT a, b, c FROM cte;
SELECT COUNT(*) FROM T;
SELECT RANK() OVER (ORDER BY c RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T;
CREATE VIEW IF NOT EXISTS v_T_9129 AS SELECT b FROM T;
INSERT INTO T SELECT * FROM T;
Actual output
| COUNT(*) |
|----------|
| 0 |
Expectation
| d | e | f |
|---|---|------|
| a | b | 0.0 |
| a | c | -1.0 |
| b | d | 0.0 |
| a | b | c |
|---|---|---|
| b | b | b |
| c | c | c |
| d | d | d |
| COUNT(*) |
|----------|
| 3 |
| RANK() OVER (ORDER BY c RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) |
|--------------------------------------------------------------------|
| 1 |
| 2 |
| 3 |
Flag
-markdown