Bad case:
haha
| extend p = 1 + 2, lines = 3 + 2
| extend q = p + lines
| take 100
q1 as (with q0 as (select 1 + 2 as p, 3 + 2 as lines, * from ku_cli_mcpxw3gjzWAA7F5KnFa3F_haha) select p + lines as q, * from q0) select * from q1 limit 100
This will yield:
Where lines:1 is generated by sqlite, to distinct duplicated column names (ref). We should remove this column from the output. However, we need the "original column" information from the C API to filter this out.
Bad case:
This will yield:
Where
lines:1is generated by sqlite, to distinct duplicated column names (ref). We should remove this column from the output. However, we need the "original column" information from the C API to filter this out.