Cannot use + or append() for string operations in naming parameters

36 views
Skip to first unread message

Hung Tran

unread,
Jan 7, 2016, 5:05:08 AM1/7/16
to OrientDB
Hi,

I am migrating from version 1.7.8 to version 2.1.8, I get an error with such query in version 2.1.8

select from User where Account.Name like :name + '%'

it's also getting same error with

select from User where Account.Name like :name.append('%')

it's only working with this

select from User where Account.Name like :name

Remarks, when I set off for strictSql, the old style query is working. Is there any performance issue when strictSql is off?

My Best,
Hung Tran

Luigi Dell'Aquila

unread,
Jan 7, 2016, 9:22:59 AM1/7/16
to orient-...@googlegroups.com
Hi,

it's quite strange, strictSql should make this kind of operations simpler. Could you please open an issue about this?

Thanks

Luigi


--

---
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-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hung Tran

unread,
Jan 8, 2016, 12:46:45 PM1/8/16
to OrientDB
Hi Luigi,

An issue is created.


My Best,
Hung Tran
Reply all
Reply to author
Forward
0 new messages