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

Thu Jul 29 10:01:33 EDT 2010

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