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

Thu Jul 29 11:08:33 EDT 2010

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

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

Can you supply the pushdown query, the vdb, etc.?  For example if the pushdown query is the same as you issued against the source, then there is something else going on.

> 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 straight to source returns:
> 36
> 37
> 38
> Query results from 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