problem/bug with query parameters using LIKE operand

[is_maximum <mn...@gmail.com>]

Hello

I have a tree structure in a table and in order to high performance we
featured it with a position field or so-called material path. In a specific
state we have a position say, 1.1.2.3.1 and we need all its parent nodes to
the root, in this example we need positions: 1 - 1.1 - 1.1.2 - 1.1.2.3 and
the same 1.1.2.3.1

to get this result the query should be like this:

select e from MyTreeTable as e
	where ?1 like CONCAT(e.position, '%') 
	and ?2 not like e.position 

[params: ?1 = '1.1.2.3.1' and ?2 = '1.1.2.3.1%' ]

But unfortunately this query doesn't work. OpenJPA complains if I bring the
parameter before LIKE keyword while in all databases we can use this syntax.
if we substitute the operands of the LIKE the query won't work correct.

Thanks a lot
-- 
View this message in context: http://n2.nabble.com/problem-bug-with-query-parameters-using-LIKE-operand-tp2177216p2177216.html
Sent from the OpenJPA Developers mailing list archive at Nabble.com.