Re: [hibernate-dev] Various "row value construct" alike syntax and Dialect class

2012-05-26 Thread Steve Ebersole
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

Re: [hibernate-dev] Various "row value construct" alike syntax and Dialect class

2012-05-26 Thread Łukasz Antoniak
One additional note: Where clause| Oracle | PostgreSQL | MySQL -- WHERE (a1, b1) = ( 1, 1 ) | Fail | Pass| Pass -