Hi Sean, old OrientDB parser is very sensitive to white spaces. In 2.1 we completely rewrote it, to solve this and many other problems.
Regards Luigi 2015-03-08 6:32 GMT+01:00 sean lee <[email protected]>: > orientdb-community-2.0.4 > > first: > > orientdb {db=test}> select * from BasAddress where idnum<100 limit 1; > > Error: com.orientechnologies.orient.core.sql.OCommandSQLParsingException: > Error on parsing command at position #38: Invalid keyword '100' > Command: select * from BasAddress where idnum<100 limit 1 > ----------------------------------------------^ > > second: > > orientdb {db=test}> select * from BasAddress where idnum < 100 limit 1; > > > ----+----+------------+-----+-------+--------+------------+-------------+---------+----------+-------- > # |@RID|@CLASS |idnum|start |end |`strstart `|`strend ` > |`type `|`province`|`remark` > > ----+----+------------+-----+-------+--------+------------+-------------+---------+----------+-------- > 0 |#9:0|BasAddress |1 |0 |16777215|0.0.0.0 |0.255.255.255| > | | > > ----+----+------------+-----+-------+--------+------------+-------------+---------+----------+-------- > > 1 item(s) found. Query executed in 0.005 sec(s). > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
