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

[Steve Hawkins (JIRA)]

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

Steve Hawkins commented on TEIID-1175:
--------------------------------------

Do you at least have the vdb?

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