Hi,
I am using OrientDB v1.7. Today, I perform a query via API
with OSQLSynchQuery, it returns a wrong result.
SELECT @rid AS __x0, ifnull(Name,'',Name) AS __x1,
ifnull(CreationDate,'',CreationDate) AS __x2,
ifnull(LastActivityDate,'',LastActivityDate) AS __x3,
ifnull(NumActiveContacts,'',NumActiveContacts) AS __x4,
ifnull(NumContacts,'',NumContacts) AS __x5,
ifnull(NumSegments,'',NumSegments) AS __x6, ifnull(Segments,'',Segments) AS
__x7 FROM (SELECT expand($c) LET $a = (SELECT FROM [#22:4]), $b = (SELECT
FROM ContactList WHERE (@rid not in [#22:4]) AND (Creator = #19:0) ORDER
BY CreationDate DESC), $c = UNIONALL($a,$b)) skip 0 limit 5
The both of OrientDB Studio and Console return 5 records (Corrected!), but
the OSQLSynchQuery only returns 3 records with same query.
{
"result": [
{
"@type": "d",
"@rid": "#-2:1",
"@version": 0,
"__x0": "#22:4",
"__x1": "test 2",
"__x2": "2014-06-09 04:58:49",
"__x3": "2014-04-19 04:58:48",
"__x4": 1,
"__x5": 12,
"__x6": 0,
"__x7": [
0
],
"@fieldTypes": "__x2=t,__x3=t,__x7=e"
},
{
"@type": "d",
"@rid": "#-2:2",
"@version": 0,
"__x0": "#22:11",
"__x1": "Test (demo)",
"__x2": "2014-06-09 04:58:56",
"__x3": "2014-06-09 04:58:56",
"__x4": 11,
"__x5": 11,
"__x6": 0,
"__x7": [
0
],
"@fieldTypes": "__x2=t,__x3=t,__x7=e"
},
{
"@type": "d",
"@rid": "#-2:3",
"@version": 0,
"__x0": "#22:10",
"__x1": "Hung's list",
"__x2": "2014-06-09 04:58:54",
"__x3": "2014-04-03 04:58:48",
"__x4": 1,
"__x5": 1,
"__x6": 0,
"__x7": [
0
],
"@fieldTypes": "__x2=t,__x3=t,__x7=e"
},
{
"@type": "d",
"@rid": "#-2:4",
"@version": 0,
"__x0": "#22:9",
"__x1": "test test 9",
"__x2": "2014-06-09 04:58:50",
"__x3": "2014-06-09 04:58:48",
"__x4": 0,
"__x5": 0,
"__x6": 2,
"__x7": [
2
],
"@fieldTypes": "__x2=t,__x3=t,__x7=e"
},
{
"@type": "d",
"@rid": "#-2:5",
"@version": 0,
"__x0": "#22:8",
"__x1": "test 4",
"__x2": "2014-06-09 04:58:49",
"__x3": "2014-04-23 04:58:48",
"__x4": 1,
"__x5": 14,
"__x6": 0,
"__x7": [
0
],
"@fieldTypes": "__x2=t,__x3=t,__x7=e"
}
],
"notification": "Query executed in 0.075 sec. Returned 5 record(s)"
}
Any help will be very appreciated!
My Best,
Hung Tran
--
---
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 orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
