Hi Gaurav, Please can you execute the same without the ending ";" and send back the protocol dump?
Lvc@ On 29 July 2014 14:58, Gaurav Dhiman <[email protected]> wrote: > Luca, removing ; that did not help, rather it was without ; initially. I > added that later to ust try with ; > > I enabled the OrientDB binary logging and got the below log trail, which > shows that OrientDB receives the SQL command (marked in *bold red* below) > properly but somehow it returns the results without honoring FetchPlan. > Kindly check below log trail, I hope it will help to investigate the issue. > > 2014-07-29 15:29:14:795 INFO /127.0.0.1:51327 - Reading byte (1 byte)... > [OChannelBinaryServer] > 2014-07-29 15:29:14:799 INFO /127.0.0.1:51327 - Read byte: 41 > [OChannelBinaryServer] > 2014-07-29 15:29:14:800 INFO /127.0.0.1:51327 - Reading int (4 bytes)... > [OChannelBinaryServer] > 2014-07-29 15:29:14:800 INFO /127.0.0.1:51327 - Read int: 23 > [OChannelBinaryServer] > 2014-07-29 15:29:14:800 INFO /127.0.0.1:51327 - Reading byte (1 byte)... > [OChannelBinaryServer] > 2014-07-29 15:29:14:801 INFO /127.0.0.1:51327 - Read byte: 115 > [OChannelBinaryServer] > 2014-07-29 15:29:14:801 INFO /127.0.0.1:51327 - Reading chunk of bytes. > Reading chunk length as int (4 bytes)... [OChannelBinaryServer] > 2014-07-29 15:29:14:801 INFO /127.0.0.1:51327 - Read chunk lenght: 117 > [OChannelBinaryServer] > 2014-07-29 15:29:14:801 INFO /127.0.0.1:51327 - Reading 117 bytes... > [OChannelBinaryServer] > 2014-07-29 15:29:14:801 INFO /127.0.0.1:51327 - Read 117 bytes: > 1com.orientechnologies.orient.core.sql.OCommandSQL :*SELECT FROM OUser > ORDER BY name ASC FETCHPLAN password:-2;* [OChannelBinaryServer] > 2014-07-29 15:29:14:805 INFO /127.0.0.1:51327 - Writing byte (1 byte): 0 > [OChannelBinaryServer] > 2014-07-29 15:29:14:805 INFO /127.0.0.1:51327 - Writing int (4 bytes): 23 > [OChannelBinaryServer] > 2014-07-29 15:29:14:805 INFO /127.0.0.1:51327 - Writing byte (1 byte): > 108 [OChannelBinaryServer] > 2014-07-29 15:29:14:806 INFO /127.0.0.1:51327 - Writing int (4 bytes): 4 > [OChannelBinaryServer] > 2014-07-29 15:29:14:806 INFO /127.0.0.1:51327 - Writing short (2 bytes): > 0 [OChannelBinaryServer] > 2014-07-29 15:29:14:806 INFO /127.0.0.1:51327 - Writing byte (1 byte): > 100 [OChannelBinaryServer] > 2014-07-29 15:29:14:806 INFO /127.0.0.1:51327 - Writing short (2 bytes): > 5 [OChannelBinaryServer] > 2014-07-29 15:29:14:806 INFO /127.0.0.1:51327 - Writing cluster position > (8 bytes) : 3.... [OChannelBinaryServer] > 2014-07-29 15:29:14:807 INFO /127.0.0.1:51327 - Writing int (4 bytes): 1 > [OChannelBinaryServer] > 2014-07-29 15:29:14:807 INFO /127.0.0.1:51327 - Writing bytes (4+132=136 > bytes): [79, 85, 115, 101, 114, 64, 110, 97, 109, 101, 58, 34, 97, 100, > 109, 105, 110, 34, 44, 112, 97, 115, 115, 119, 111, 114, 100, 58, 34, 123, > 83, 72, 65, 45, 50, 53, 54, 125, 56, 67, 54, 57, 55, 54, 69, 53, 66, 53, > 52, 49, 48, 52, 49, 53, 66, 68, 69, 57, 48, 56, 66, 68, 52, 68, 69, 69, 49, > 53, 68, 70, 66, 49, 54, 55, 65, 57, 67, 56, 55, 51, 70, 67, 52, 66, 66, 56, > 65, 56, 49, 70, 54, 70, 50, 65, 66, 52, 52, 56, 65, 57, 49, 56, 34, 44, > 115, 116, 97, 116, 117, 115, 58, 34, 65, 67, 84, 73, 86, 69, 34, 44, 114, > 111, > 108, 101, 115, 58, 60, 35, 52, 58, 48, 62] [OChannelBinaryServer] > 2014-07-29 15:29:14:807 INFO /127.0.0.1:51327 - Writing short (2 bytes): > 0 [OChannelBinaryServer] > 2014-07-29 15:29:14:808 INFO /127.0.0.1:51327 - Writing byte (1 byte): > 100 [OChannelBinaryServer] > 2014-07-29 15:29:14:808 INFO /127.0.0.1:51327 - Writing short (2 bytes): > 5 [OChannelBinaryServer] > 2014-07-29 15:29:14:808 INFO /127.0.0.1:51327 - Writing cluster position > (8 bytes) : 0.... [OChannelBinaryServer] > 2014-07-29 15:29:14:808 INFO /127.0.0.1:51327 - Writing int (4 bytes): > 125 [OChannelBinaryServer] > 2014-07-29 15:29:14:809 INFO /127.0.0.1:51327 - Writing bytes (4+399=403 > bytes): [79, 85, 115, 101, 114, 64, 101, 109, 97, 105, 108, 79, 84, 80, 58, > 34, 34, 44, 109, 111, 98, 105, 108, 101, 79, 84, 80, 58, 34, 34, 44, 110, > 97, 109, 101, 58, 34, 103, 97, 117, 114, 97, 118, 64, 116, 101, 99, 104, > 122, 117, 108, 108, 97, 46, 99, 111, 109, 34, 44, 109, 111, 98, 105, 108, > 101, 78, 117, 109, 98, 101, 114, 58, 34, 57, 49, 57, 56, 55, 56, 57, 54, 54, > 52, 52, 57, 34, 44, 112, 97, 115, 115, 119, 111, 114, 100, 58, 34, 123, > 83, 72, 65, 45, 50, 53, 54, 125, 57, 70, 56, 54, 68, 48, 56, 49, 56, 56, 52, > 67, 55, 68, 54, 53, 57, 65, 50, 70, 69, 65, 65, 48, 67, 53, 53, 65, 68, > 48, 49, 53, 65, 51, 66, 70, 52, 70, 49, 66, 50, 66, 48, 66, 56, 50, 50, 67, > 68, 49, 53, 68, 54, 67, 49, 53, 66, 48, 70, 48, 48, 65, 48, 56, 34, 44, > 115, 116, 97, 116, 117, 115, 58, 34, 65, 67, 84, 73, 86, 69, 34, 44, 114, > 111, 108, 101, 115, 58, 60, 35, 52, 58, 48, 62, 44, 102, 105, 114, 115, > 116, 78, 97, 109, 101, 58, 34, 71, 97, 117, 114, 97, 118, 34, 44, 105, 115, > 65, 117, 116, 111, 83, 99, 97, 110, 69, 110, 97, 98, 108, 101, 100, 58, > 102, 97, 108, 115, 101, 44, 98, 117, 115, 105, 110, 101, 115, 115, 101, > 115, 58, 60, 35, 49, 48, 58, 48, 62, 44, 108, 97, 115, 116, 85, 115, 101, > 100, 67, 117, 114, 114, 101, 110, 99, 121, 58, 35, 49, 53, 58, 48, 44, 108, > 97, 115, > 116, 78, 97, 109, 101, 58, 34, 68, 104, 105, 109, 97, 110, 34, 44, 105, > 109, 103, 85, 82, 76, 58, 34, 105, 109, 103, 47, 117, 115, 101, 114, 115, > 47, 53, 45, 48, 34, 44, 108, 97, 115, 116, 77, 111, 100, 105, 102, 105, 99, > 97, 116, 105, 111, 110, 84, 105, 109, 101, 115, 116, 97, 109, 112, 58, 49, > 52, 48, 48, 50, 51, 55, 57, 53, 49, 48, 48, 48, 116, 44, 105, 115, 80, 97, > 115, 115, 119, 111, 114, 100, 82, 101, 115, 101, 116, 58, 102, 97, 108, > 115, 101, 44, 114, 112, 58, 34, 116, 101, 115, 116, 34] > [OChannelBinaryServer] > 2014-07-29 15:29:14:810 INFO /127.0.0.1:51327 - Writing short (2 bytes): > 0 [OChannelBinaryServer] > 2014-07-29 15:29:14:810 INFO /127.0.0.1:51327 - Writing byte (1 byte): > 100 [OChannelBinaryServer] > 2014-07-29 15:29:14:810 INFO /127.0.0.1:51327 - Writing short (2 bytes): > 5 [OChannelBinaryServer] > 2014-07-29 15:29:14:811 INFO /127.0.0.1:51327 - Writing cluster position > (8 bytes) : 1.... [OChannelBinaryServer] > 2014-07-29 15:29:14:811 INFO /127.0.0.1:51327 - Writing int (4 bytes): 1 > [OChannelBinaryServer] > 2014-07-29 15:29:14:811 INFO /127.0.0.1:51327 - Writing bytes (4+133=137 > bytes): [79, 85, 115, 101, 114, 64, 110, 97, 109, 101, 58, 34, 114, 101, > 97, 100, 101, 114, 34, 44, 112, 97, 115, 115, 119, 111, 114, 100, 58, 34, > 123, 83, 72, 65, 45, 50, 53, 54, 125, 51, 68, 48, 57, 52, 49, 57, 54, 52, > 65, > 65, 51, 69, 66, 68, 67, 66, 48, 48, 67, 67, 69, 70, 53, 56, 66, 49, 66, > 66, 51, 57, 57, 70, 57, 70, 56, 57, 56, 52, 54, 53, 69, 57, 56, 56, 54, 68, > 53, 65, 69, 67, 55, 70, 51, 49, 48, 57, 48, 65, 48, 70, 66, 51, 48, 34, 44, > 115, 116, 97, 116, 117, 115, 58, 34, 65, 67, 84, 73, 86, 69, 34, 44, 114, > 111, 108, 101, 115, 58, 60, 35, 52, 58, 49, 62] [OChannelBinaryServer] > 2014-07-29 15:29:14:811 INFO /127.0.0.1:51327 - Writing short (2 bytes): > 0 [OChannelBinaryServer] > 2014-07-29 15:29:14:812 INFO /127.0.0.1:51327 - Writing byte (1 byte): > 100 [OChannelBinaryServer] > 2014-07-29 15:29:14:812 INFO /127.0.0.1:51327 - Writing short (2 bytes): > 5 [OChannelBinaryServer] > 2014-07-29 15:29:14:812 INFO /127.0.0.1:51327 - Writing cluster position > (8 bytes) : 2.... [OChannelBinaryServer] > 2014-07-29 15:29:14:812 INFO /127.0.0.1:51327 - Writing int (4 bytes): 3 > [OChannelBinaryServer] > 2014-07-29 15:29:14:813 INFO /127.0.0.1:51327 - Writing bytes (4+169=173 > bytes): [79, 85, 115, 101, 114, 64, 110, 97, 109, 101, 58, 34, 119, 114, > 105, 116, 101, 114, 34, 44, 112, 97, 115, 115, 119, 111, 114, 100, 58, 34, > 123, 83, 72, 65, 45, 50, 53, 54, 125, 66, 57, 51, 48, 48, 54, 55, 55, 52, > 67, 66, 68, 68, 52, 66, 50, 57, 57, 51, 56, 57, 65, 48, 51, 65, 67, 51, 68, > 56, 56, 67, 51, 65, 55, 54, 66, 52, 54, 48, 68, 53, 51, 56, 55, 57, 53, 66, > 67, 49, 50, 55, 49, 56, 48, 49, 49, 65, 57, 48, 57, 70, 66, 65, 53, 34, > 44, 115, 116, 97, 116, 117, 115, 58, 34, 65, 67, 84, 73, 86, 69, 34, 44, > 114, 111, 108, 101, 115, 58, 60, 35, 52, 58, 50, 62, 44, 109, 111, 98, 105, > 108, 101, 78, 117, 109, 98, 101, 114, 58, 34, 49, 50, 51, 34, 44, 102, 105, > 114, 115, 116, 78, 97, 109, 101, 58, 34, 116, 101, 115, 116, 34] > [OChannelBinaryServer] > 2014-07-29 15:29:14:813 INFO /127.0.0.1:51327 - Writing byte (1 byte): 0 > [OChannelBinaryServer] > 2014-07-29 15:29:14:813 INFO /127.0.0.1:51327 - Flush > [OChannelBinaryServer] > 2014-07-29 15:29:14:814 INFO /127.0.0.1:51327 - Reading byte (1 byte)... > [OChannelBinaryServer] > > > Regards, > Gaurav > > > > On Tuesday, July 29, 2014 5:02:38 PM UTC+5:30, Lvc@ wrote: > >> Hi Gaurav, >> Try to remove ; at the end. Only the console eats ";" to separate >> commands, for the rest no other components knows about it. >> >> Lvc@ >> >> >> On 29 July 2014 12:13, Gaurav Dhiman <[email protected]> wrote: >> >>> I am writing a waterline adapter for SailsJS which can talk to >>> OrientDB. My code is based on Oriento (NodeJS plugin for OrientDB). >>> I am facing a strange problem, will appreciate if some one can help. >>> >>> When I make call from Oriento using below SQL command, FETCHPLAN is not >>> honored. >>> SELECT FROM OUser ORDER BY name ASC FETCHPLAN password:-2; >>> >>> Below is the result (password is not omitted) of above SQL when called >>> through Oriento: >>> >>> Sending query - SELECT FROM OUser ORDER BY name ASC FETCHPLAN >>> password:-2; >>> Returned result from server: >>> [ { '@type': 'd', >>> '@class': 'OUser', >>> name: 'admin', >>> password: '{SHA-256}8C6976E5B5410415BDE908BD4DEE15 >>> DFB167A9C873FC4BB8A81F6F2AB448A918', >>> status: 'ACTIVE', >>> roles: [ [Object] ], >>> '@rid': { cluster: 5, position: 3 } }, >>> { '@type': 'd', >>> '@class': 'OUser', >>> name: 'reader', >>> password: '{SHA-256}3D0941964AA3EBDCB00CCEF58B1BB3 >>> 99F9F898465E9886D5AEC7F31090A0FB30', >>> status: 'ACTIVE', >>> roles: [ [Object] ], >>> '@rid': { cluster: 5, position: 1 } }, >>> { '@type': 'd', >>> '@class': 'OUser', >>> name: 'writer', >>> password: '{SHA-256}B93006774CBDD4B299389A03AC3D88 >>> C3A76B460D538795BC12718011A909FBA5', >>> status: 'ACTIVE', >>> roles: [ [Object] ], >>> mobileNumber: '123', >>> firstName: 'test', >>> '@rid': { cluster: 5, position: 2 } } ] >>> >>> >>> If I run the same query in studio, it runs fine with password attribute >>> / field not sent back by server. >>> Can someone help me to figure out the issue. Well, I am going to drop >>> email to Oriento developers too. >>> >>> Regards, >>> Gaurav >>> >>> -- >>> >>> --- >>> 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. > -- --- 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.
