Elliot Chance
Elliot Chance
The underlying walker does support range queries, but the planner does not understand how to set the lower and upper bounds, like: ```sql CREATE TABLE t1 (x INT, PRIMARY KEY(x));...
At the moment only one column is allowed.
```sql CREATE TABLE t1 (x INT, b INT, PRIMARY KEY(x)); EXPLAIN SELECT * FROM t1 WHERE x = 10 AND b = 20; ```
``` ::= | ::= [ ... ] ::= ::= ::= /* ::= */ ::= [ { | }... ] !! See the Syntax Rules. ```
CHAR(n) requires that the value be a fixed length and should be right padded with spaces. Actually I'm not sure about the padding, need to check that as well.
`VALUES` is a helpful shorthand that doesn't require a temporary table to be created if you just want to SELECT an expression.
The `TABLE ...` statement is another form of `SELECT * FROM ...`.
A response can contain a message, like "CREATE TABLE 1". However, right now this comes back as a fake table response instead which confuses the protocol and user. A response...