They way how passed (named/positional) paramaters are represented in a resulting SQL command is determined by a parameter's type. If the parameter's type is String than it ends up in query as string wrapped in quotation marks. So for example String: 11:0 passed as parameter will end up in query like this: "11:0", which is not a right format for record identifier in a query. On the other hand the parameter of type ORecordId will end up in query as ID without quotation marks, which is the right format for record identifier in a query. However if you use string concatenation to build your SQL query instead of passing parameters, than concatenating string 11:0 is fine, because you're not concatenating any additional quotation marks into resulting query (that would be neccessary for example for property value of a string type).
Dne sobota 3. října 2015 15:33:28 UTC+2 Tsadok Levi Firseck napsal(a): > > Does it mean that when we query against some record identity (rid) we > should not pass the identity as a string? > > We are using getIdentity().toString() to get the rid and then combine it > in the sql statement. > > Will it produce other results? Why? > > Tsadok > > -- --- 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.
