[teiid-issues] [JBoss JIRA] Commented: (TEIID-1175) SqlServer 2005 - Queries failing due to negative values being treated as positive values
[
https://jira.jboss.org/browse/TEIID-1175?page=com.atlassian.jira.plugin.s...
]
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