jakartaee/data

[clarification]: Can I mix parameters in the Query?

Closed this issue · 2 comments

otaviojava commented

Specification

https://github.com/jakartaee/data/blob/main/spec/src/main/asciidoc/query-language.asciidoc#parameters

I need clarification on ...

The spec does not clarify whether we can combine the original with the named parameter.

I did not find any combination on the internet or in our specs, so I assume they cannot mix.

Based on my understanding, if there is an ordinal, all parameters should be ordinal. This is my current interpretation of the situation.

Does it make sense?

Additional information

No response

gavinking commented

Ah, this is a very good point. Nice catch.

So, in our implementation we do let you mix named and positional parameters.

However, the JPA spec says:

Positional and named parameters must not be mixed in a single query.

(Section 4.7.4 of JPA 3.2.)

So we should add that same restriction to the spec for JDQL.

  • 👍1
otaviojava commented

Ah, this is a very good point. Nice catch.

So, in our implementation we do let you mix named and positional parameters.

However, the JPA spec says:

Positional and named parameters must not be mixed in a single query.

(Section 4.7.4 of JPA 3.2.)

So we should add that same restriction to the spec for JDQL.

Ok, I will open a PR with this information.