I didn't think to check the next case in the examples that I sent in my
previous post.
For completeness the following query also produces the same SQL
Exception which announces Column "TS" not found
ResultSet resultSet = statement.executeQuery("select TS '2015-03-16
12:12:12.12'");
On 3/17/15 11:29 AM, Fred&Dani&Pandora&Aquiles wrote:
Hi,
The following tests are working for me in latest version:
select TS '2090-01-01 00:00:00.0';
select TIMESTAMP '2090-01-01 00:00:00.0';
Can you post the complete stack trace?
Regards,
Fred
2015-03-13 15:44 GMT-03:00 Andy Glick <[email protected]
<mailto:[email protected]>>:
We are using Eclipselink 2.6.0.RC1 with H2 1.4.180 and most of the
SQL for a large application is being generated by Eclipselink and
is working fine.
Starting with versions greater than 1.4.180 and I not exactly sure
which, the SQL that Eclipselink is generating is being rejected by
H2 as invalid SQL. Looking at the SQL that is failing indicates
that Eclipselink is generating requests to convert a String to a
Timestamp as follows:
TS '2090-01-01 00:00:00.0'
when I am using H2 version 1.4.186 queries using TS as the name of
the Timestamp conversion function fail, but for the same query if
the name of the Timestamp conversion function is changed to
TIMESTAMP then the query executes successfully.
From everything I can determine this change is intentional and a
breaking change. Releases from somewhere around1.4.180 and before
do not support TIMESTAMP as the name of the String to Timestamp
conversion function and releases somewhere after 1.4.180 do not
support TS as the name of the String to Timestamp conversion function.
So this looks like a breaking change, but your documentation
hasn't announced that such a change has been made to the code base.
1) Have you changed the behavior of the code and introduced a
non-backward compatible breaking change?
2) If the behavior has changed when will you document the behavior?
--
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]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
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]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
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/d/optout.
