SQLite Forum

'values' with no args : has to be syntax error?
Login
Additionally: I was wrong about the exact equivalence of the "SELECT 1 WHERE 1=0".
In that - this is actually doing the equivalent of this:

```
with a("1") as (values(1)) select * from a;
```

That is: it names the column - not as 'column1' (as 'values' does) but by the value of the row.