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

[Hung Tran]

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]

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]

Hi Luigi,

An issue is created.

https://github.com/orientechnologies/orientdb/issues/5572

My Best,

Hung Tran