Hi, I have experienced a strange behaviour in H2 1.3.172 CREATE TABLE X ( num INT, str VARCHAR(50) );
INSERT INTO X VALUES(10, 'aaa'); INSERT INTO X VALUES(20, 'xxx'); SELECT x.str, x.num FROM X x WHERE num > 0 UNION SELECT x.str, x.num FROM X x WHERE num > 1 ORDER BY *x.*num; DROP TABLE X; This does not work! If I remove the table name *x.* however, the query works. The error is: Order by expression "X.NUM" must be in the result list in this case; SQL statement: SELECT x.str, x.num FROM X x WHERE num > 0 UNION SELECT x.str, x.num FROM X x WHERE num > 1 ORDER BY x.num [90068-172]<http://localhost:11111/query.do?jsessionid=ca37a3a91abb2da95e36d51c726d9d42#> 90068/90068 Is this behaviour expected or a bug? I have tested 1.3.154 - it works, 1.3.170 it does not, neither 171. Regards, Kornel -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
