thanks!
On Tuesday, August 6, 2019 at 6:55:09 PM UTC+5:30, Evgenij Ryazanov wrote:
>
> BTW, take a look on the section “Prepared Statements and IN(...)” in the
> documentation:
> https://h2database.com/html/performance.html#database_performance_tuning
> Please note that ANY(?) is a non-standard
BTW, take a look on the section “Prepared Statements and IN(...)” in the
documentation:
https://h2database.com/html/performance.html#database_performance_tuning
Please note that ANY(?) is a non-standard PostgreSQL-style feature that is
supported since H2 1.4.197. It can be not suitable for
Thank you Evgenij, Life saver.
On Tuesday, August 6, 2019 at 6:43:24 PM UTC+5:30, Evgenij Ryazanov wrote:
>
> Hello.
>
> IN predicate with empty list is not valid according to the SQL Standard.
> However, some databases, including H2, support it.
>
> H2 1.4.193 and later versions don't allow it
Hello.
IN predicate with empty list is not valid according to the SQL Standard.
However, some databases, including H2, support it.
H2 1.4.193 and later versions don't allow it in DB2, MySQL, Oracle, and
PostgreSQL compatibility modes because these databases don't allow it.
When you use a