[teiid-issues] [JBoss JIRA] Updated: (TEIID-1175) SqlServer 2005 - Queries failing due to negative values being treated as positive values
Warren Gibson (JIRA)
jira-events at lists.jboss.org
Thu Jul 29 12:13:49 EDT 2010
[ https://jira.jboss.org/browse/TEIID-1175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Warren Gibson updated TEIID-1175:
---------------------------------
Description:
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 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
was:
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
> 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 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
More information about the teiid-issues
mailing list