Rami,
I think that problem is "inverted" convert as Thomas says
here<https://groups.google.com/forum/?fromgroups#%21searchin/h2-database/joseaio/h2-database/0tASw3Tuczw/238RU-5gZBUJ>
I sure that exist another point on code where expect normal convert
function ("inverted" convert is mandatory for Sybase and SQL Server
compatibility modes)
Normal convert function is CONVERT(VALUE, TYPE) and "inverted" is
CONVERT(TYPE,VALUE)
On Wednesday, June 13, 2012 1:31:09 PM UTC+2, Rami Ojares wrote:
>
>
> > I can't reduce this query to simple case of error... sorry
>
> Does it appear if you only run the inner select?
> Try taking pieces out of the query and see what removal makes it work
> again.
> That's how you can narrow down on the problem.
>
> - Rami
>
On Wednesday, June 13, 2012 1:31:09 PM UTC+2, Rami Ojares wrote:
>
>
> > I can't reduce this query to simple case of error... sorry
>
> Does it appear if you only run the inner select?
> Try taking pieces out of the query and see what removal makes it work
> again.
> That's how you can narrow down on the problem.
>
> - Rami
>
On Wednesday, June 13, 2012 1:31:09 PM UTC+2, Rami Ojares wrote:
>
>
> > I can't reduce this query to simple case of error... sorry
>
> Does it appear if you only run the inner select?
> Try taking pieces out of the query and see what removal makes it work
> again.
> That's how you can narrow down on the problem.
>
> - Rami
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/Kv-BXdrYnjUJ.
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.
