Hi, I had found a elusive bug ordering queries over views by fields not included in the select list, as this:
create table T ( A int, B int, C int ); create view V as ( select C,B from T ); select C from V order by B ; On simple queries or simple views that case work fine , but in complex queries or views that fail wih an error: Error "Order by expression "THE_ORDERING_FIELD" must be in the result list in this case" [90068-139] SQLState: 90068 ErrorCode: 90068 I only can reproduce this error with a real case and model that's very large to attach. Regards, Dario -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
