On Sun 27 May 2012 02:52:23 AM CDT, Łukasz Antoniak wrote:
> The initial question here is how to distinguish dialects that support
> statements like:
> update ParentEntity_AUD set REVEND=? where (id, REV) IN (select id,
> REV from HT_ChildEntity_AUD)
Ok. And this form comes about because of the m
The initial question here is how to distinguish dialects that support
statements like:
update ParentEntity_AUD set REVEND=? where (id, REV) IN (select id, REV from
HT_ChildEntity_AUD)
For example H2 fails:
Caused by: org.h2.jdbc.JdbcSQLException: Podzapytanie nie jest zapytaniem
opartym o jedna
On Fri 25 May 2012 02:19:29 PM CDT, Łukasz Antoniak wrote:
> Hello Community,
>
> Really quick question. There are quite few SQL syntax tricks similar to "row
> value construct".
>
> CREATE TABLE test ( a1 NUMBER, b1 NUMBER );
> SELECT * FROM test WHERE (a1, b1) = ( 1, 1 ); -- Fails on Oracle
> S
One additional note:
Where clause| Oracle | PostgreSQL | MySQL
--
WHERE (a1, b1) = ( 1, 1 ) | Fail | Pass| Pass
-
Hello Community,
Really quick question. There are quite few SQL syntax tricks similar to "row
value construct".
CREATE TABLE test ( a1 NUMBER, b1 NUMBER );
SELECT * FROM test WHERE (a1, b1) = ( 1, 1 ); -- Fails on Oracle
SELECT * FROM test WHERE (a1, b1) IN ( ( 1, 1 ), ( 2, 2 ) ); -- Passes on O
