Hi,
thank you for your elaboration on the issue.
I already posted in the Hibernate forum about this issue but it seems they
are not reacting act the moment (did not receive any comment on it).
I saw the same issue happening with the H2Dialect "on commit drop" which
was indicated by others but
... I'm sorry, I was missing the fact that you were using Hibernate. I
guess Hibernate will have to be fixed according to what I mentioned below...
Am Mittwoch, 25. September 2013 07:29:36 UTC+2 schrieb Lukas Eder:
>
> Hello
>
> The odd background-info from me ;-)
>
> This is called an IN predica
Hello
The odd background-info from me ;-)
This is called an IN predicate on row value expressions. I have brought
this up before on this user group, as I think that true row value
expression support would be a good feature addition for H2:
https://groups.google.com/d/msg/h2-database/XlRLHjytKiE
Hi,
No, I'm sorry, I don't have a solution for this. Patches are welcome!
According to my test, MySQL, PostgreSQL, and HSQLDB support this. Apache
Derby and H2 do not. I think the typical solution would be to use a join.
Regards,
Thomas
On Fri, Sep 20, 2013 at 6:38 PM, Markus Waltl wrote:
>
Looks good.
Thank you,
Gili
On 24/09/2013 1:29 PM, Thomas Mueller wrote:
Hi,
You would need a unique index on the column "email". For H2, you could
use a combination of:
insert into employee(email) select ? from dual where not exists(select
* from employee where email=?);
select id
Hi,
There were a few issues about parameter indexes in combination with views
or subqueries in the past, it's possible that there are remaining issues.
> I can provide a standalone, albeit complicated test case for this issue.
That would be great! I wouldn't want to change the code without havi
Hi,
You would need a unique index on the column "email". For H2, you could use
a combination of:
insert into employee(email) select ? from dual where not exists(select *
from employee where email=?);
select id from employee where email=?
This could be written as a user defined function. This sho