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.

Reply via email to