Do you have any index on _bb_order.id? Try with: EXPLAIN select from _bb_order where id="24937309-9189-484d-b406-6302b2ce9b6f"
2014-07-14 6:06 GMT+02:00 kishy kumar <[email protected]>: > Hi, > > I am using OrientDB v1.7-rc1. > > I have posted my problem to stackoverflow as well for better formatting: > > http://stackoverflow.com/questions/24728466/orientdb-where-clause-not-returning-the-record > > Problem: > > I am trying to get a record using the id field from orientdb database, but > it's not returning the record. > > Here is the record (it works on a simple select): > > orientdb {baasbox}> select from _bb_order > ----+-----+-----+------+------+------+-------+--------+---------+---------+---------+----- > ----+---------+---------+---------+---------+-------------# |@RID > |price|_links|_allow|_audit|_author|verbatim|timestamp|audioLeng|orderURI > |transcrip|_creation|id |fileId |feedbackI|status > ----+-----+-----+------+------+------+-------+--------+---------+---------+---------+---------+---------+---------+---------+---------+-------------0 > |#22:1|0 |#11:9 |[1] |#3:7 |k |false |false |60 > |TC0448...| |2014-0...|249373...|8a9ca9...|0540df...|Order rece... > ----+-----+-----+------+------+------+-------+--------+---------+---------+---------+---------+---------+---------+---------+---------+------------- > > 1 item(s) found. Query executed in 0.003 sec(s). > > When I select the id from _bb_order schema, I can get the record. > > orientdb {baasbox}> select id from _bb_order > ----+-----+------------------------------------# |@RID |id > ----+-----+------------------------------------0 > |#-2:1|24937309-9189-484d-b406-6302b2ce9b6f > ----+-----+------------------------------------ > > 1 item(s) found. Query executed in 0.003 sec(s). > > BUT, I canNOT recover the record when I use a where clause on the 'id' > attribute. > > orientdb {baasbox}> select from _bb_order where > id="24937309-9189-484d-b406-6302b2ce9b6f" > > 0 item(s) found. Query executed in 0.001 sec(s). > > I can get the record when I use some other attribute, like fileId. > > orientdb {baasbox}> select from _bb_order where > fileId="8a9ca9d2-bbe2-4326-aa2b-bad5f2032fbd" > ----+-----+-----+------+------+------+-------+--------+---------+---------+---------+---------+---------+---------+---------+---------+-------------# > |@RID > |price|_links|_allow|_audit|_author|verbatim|timestamp|audioLeng|orderURI > |transcrip|_creation|fileId |id |feedbackI|status > ----+-----+-----+------+------+------+-------+--------+---------+---------+---------+---------+---------+---------+---------+---------+-------------0 > |#22:1|0 |#11:9 |[1] |#3:7 |k |false |false |60 > |TC0448...| |2014-0...|8a9ca9...|249373...|0540df...|Order rece... > ----+-----+-----+------+------+------+-------+--------+---------+---------+---------+---------+---------+---------+---------+---------+------------- > > 1 item(s) found. Query executed in 0.002 sec(s). > > Confirmed that the Id field is stored as a String in the code. > > Any thoughts on why this would be happening? > > -- > > --- > 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.
