[teiid-issues] [JBoss JIRA] Commented: (TEIID-1181) Teiid Pushdown queries producing unexpected results (Sybase 12.5)

[Steve Hawkins (JIRA)]

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

Steve Hawkins commented on TEIID-1181:
--------------------------------------

The error indicating 123 is not a valid format should be a KI for Sybase older than version 15, for which we will not currently support timestamp to string conversion.

The JZ0TE errors are happening in the Sybase driver, which doesn't seem to support a call to getByte() - are you using the EAP supported driver?

The errors about bit being a non-null type can be easily fixed.

> Teiid Pushdown queries producing unexpected results (Sybase 12.5)
> -----------------------------------------------------------------
>
>                 Key: TEIID-1181
>                 URL: https://jira.jboss.org/browse/TEIID-1181
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.1
>         Environment: Teiid 7.1
>            Reporter: Warren Gibson
>            Assignee: Steve Hawkins
>         Attachments: jconn3.jar, QT_Syb125_Push.vdb, QT_Sybase_Push-ds.xml, sybase125_queries.ods
>
>
> The attached sampling of 43 queries submitted against Sybase 12.5 are producing unexpected results in Teiid pushdown query testing but are producing expected results when submitted straight to the source through Squirrel.  Column A of the attached spreadsheet contains the query and my comments.  Columns B & C contains info from the query testing run.  I am attaching the VDB, ds, and driver.  If I can provide any additional information please let me know.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira