[teiid-issues] [JBoss JIRA] (TEIID-1864) TIMESTAMPADD of SQL_TSI_FRAC_SECOND fails for Sybase 15 with JConnect 6.0.5 driver

[Paul Nittel (Commented) (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-1864?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12651057#comment-12651057 ] 

Paul Nittel commented on TEIID-1864:
------------------------------------

Yes, Steve, it's limited to fractional seconds.
                
> TIMESTAMPADD of SQL_TSI_FRAC_SECOND fails for Sybase 15 with JConnect 6.0.5 driver
> ----------------------------------------------------------------------------------
>
>                 Key: TEIID-1864
>                 URL: https://issues.jboss.org/browse/TEIID-1864
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.6
>            Reporter: Paul Nittel
>            Assignee: Steven Hawkins
>
> Executing this query:
> SELECT intkey, timestampvalue, TIMESTAMPADD(SQL_TSI_FRAC_SECOND,123,TIMESTAMPVALUE) FROM BQT1.SMALLA WHERE INTKEY < 10 ORDER BY INTKEY
> errors in the following fashion:
> [JDBCExecutionException] 0: Error Code:0 Message:'JZ0SI: A static function escape timestampaddsql_tsi_frac_second was used which is not supported by this server.' error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.IntKey AS c_0, g_0.TimestampValue AS c_1, {fn timestampadd(SQL_TSI_FRAC_SECOND, 123, g_0.TimestampValue)} AS c_2 FROM SmallA g_0 WHERE g_0.IntKey < 10 ORDER BY c_0]
> 1 [SQLException]JZ0SI: A static function escape timestampaddsql_tsi_frac_second was used which is not supported by this server.
>         at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:90)
>         at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:272)
>         at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:342)
>         at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:138)
>         at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:135)
>         at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
>         at java.util.concurrent.FutureTask.run(FutureTask.java:138)
>         at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:118)
>         at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:232)
>         at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)
>         at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
>         at java.lang.Thread.run(Thread.java:662)
> Caused by: java.sql.SQLException: JZ0SI: A static function escape timestampaddsql_tsi_frac_second was used which is not supported by this server.
>         at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
>         at com.sybase.jdbc3.jdbc.SybStatement.processEscapes(Unknown Source)
>         at com.sybase.jdbc3.jdbc.SybStatement.doEscapeProcessing(Unknown Source)
>         at com.sybase.jdbc3.jdbc.SybPreparedStatement.<init>(Unknown Source)
>         at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
>         at com.sybase.jdbc3.jdbc.SybConnection.prepareStatement(Unknown Source)
>         at com.sybase.jdbc3.jdbc.SybConnection.prepareStatement(Unknown Source)
>         at com.sybase.jdbc3.jdbc.SybConnection.prepareStatement(Unknown Source)
>         at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:465)
>         at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:460)
>         at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:243)
>         at org.teiid.translator.jdbc.JDBCBaseExecution.getPreparedStatement(JDBCBaseExecution.java:172)
>         at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:84)
>         ... 13 more
> Executing the same query using the JTDS 1.2.5 driver works correctly.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira