[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1175) SqlServer 2005 - Queries failing due to negative values being treated as positive values

Tue Aug 10 06:08:26 EDT 2010

     [ https://jira.jboss.org/browse/TEIID-1175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Hawkins resolved TEIID-1175.
----------------------------------

    Resolution: Done

The issue with strings was addressed with the connection property.  Other issues were seen with other types when converting to byte, since tinyint in SQLServer is unsigned.  This was addressed with the Sybase getByte checkin.

> SqlServer 2005 - Queries failing due to negative values being treated as positive values
> ----------------------------------------------------------------------------------------
>
>                 Key: TEIID-1175
>                 URL: https://jira.jboss.org/browse/TEIID-1175
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.1
>            Reporter: Warren Gibson
>            Assignee: Steve Hawkins
>         Attachments: QT_sqls2005ds_Push-ds.xml, QT_sqls2005ds_Push.vdb
>
>
> It appears results are being returned without consideration for the negative(-) sign
>  - RDBMS_Test_Queries_1000_TestQuery169
> SELECT SmallA.IntKey FROM SmallA WHERE SmallA.StringNum > 11 AND SmallA.StringNum < 15 ORDER BY IntKey
> Query suite is expecting 3 rows returned.
> Query results using Squirrel straight to source returns:
> 36
> 37
> 38
> Query results using Squirrel to Teiid:
> 10
> 11
> 12
> 13
> 36
> 37
> 38
> Source contains the following for IntKey and StringNum
> IntKey   StringNum
> 0	-24
> 1	<null>
> 2	-22
> 3	-21
> 4	-20
> 5	-19
> 6	-18
> 7	-17
> 8	-16
> 9	-15
> 10	-14
> 11	-13
> 12	-12
> 13	-11
> 14	-10
> 15	-9
> 16	-8
> 17	<null>
> 18	-6
> 19	-5
> 20	-4
> 21	-3
> 22	-2
> 23	-1
> 24	0
> 25	1
> 26	2
> 27	3
> 28	4
> 29	5
> 30	6
> 31	7
> 32	8
> 33	<null>
> 34	10
> 35	11
> 36	12
> 37	13
> 38	14
> 39	15
> 40	16
> 41	17
> 42	18
> 43	19
> 44	20
> 45	21
> 46	22
> 47	23
> 48	24

-- 
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