search

crossdb-org / crossdb

Ultra High-performance Lightweight Embedded and Server OLTP RDBMS✨
https://crossdb.org
Mozilla Public License 2.0
184 stars 12 forks source link

Parser errors with inequalities #13

Closed mripley closed 2 months ago

mripley commented 2 months ago

It appears that nothing besides = is supported

XDB> create table t1 (c1 int); 
Query OK, 0 row affected (2.217 ms)

XDB> insert into t1 values (0),(1); 
Query OK, 2 rows affected (0.254 ms)

XDB> select c1 from t1 where c1 > 10; 
ERROR 3: Miss =

XDB> select c1 from t1 where c1 < 10; 
ERROR 3: Miss =
jcwangxp commented 2 months ago

Will support more operators in next release.

jcwangxp commented 2 months ago

support: >, >=, <, <=, !=, <> support 'c1 < 10', and '10 > c1'.