[JBoss JIRA] Created: (TEIID-1175) SqlServer 2005 - Queries failing due to negative values being treated as positive values
9:01 a.m.
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
10:08 a.m.
New subject: [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
11:13 a.m.
New subject: [JBoss JIRA] Updated: (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...
]
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
11:15 a.m.
New subject: [JBoss JIRA] Updated: (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...
]
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 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
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 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
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
7:43 p.m.
New subject: [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:
--------------------------------------
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
7:56 p.m.
New subject: [JBoss JIRA] Updated: (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...
]
Warren Gibson updated TEIID-1175:
---------------------------------
Attachment: QT_sqls2005ds_Push.vdb
QT_sqls2005ds_Push-ds.xml
Sorry, I meant to attach the VDB when I submitted this.
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
Attachments: QT_sqls2005ds_Push-ds.xml, QT_sqls2005ds_Push.vdb
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
8:07 p.m.
New subject: [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...
]
Warren Gibson commented on TEIID-1175:
--------------------------------------
The query submitted straight to the SqlServer source through squirrel is the Description.
The query used in Teiid pushdown is: <query name="TestQuery169">SELECT
BQT1.SmallA.IntKey FROM BQT1.SmallA WHERE BQT1.SmallA.StringNum > 11 AND
BQT1.SmallA.StringNum < 15 ORDER BY IntKey</query>
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
Attachments: QT_sqls2005ds_Push-ds.xml, QT_sqls2005ds_Push.vdb
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
9:07 a.m.
New subject: [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:
--------------------------------------
This is not a Teiid issue. There is a behavioral difference with SQL Server when using a
PreparedStatement vs. a non-PreparedStatement. I'm not sure if this is the driver or
the server itself.
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
Attachments: QT_sqls2005ds_Push-ds.xml, QT_sqls2005ds_Push.vdb
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
11:39 a.m.
New subject: [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:
--------------------------------------
Specifically for string bind parameters, the fix for this is to set the
sendStringParametersAsUnicode=false connection property. By default the driver is
treating the bind value as unicode and causing the comparison to function differently.
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
Attachments: QT_sqls2005ds_Push-ds.xml, QT_sqls2005ds_Push.vdb
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
5:08 a.m.
New subject: [JBoss JIRA] Resolved: (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 resolved TEIID-1175.
----------------------------------
Resolution: Done
The issue with strings was addressed with the connection property. Other issues were seen
with other types when converting to byte, since tinyint in SQLServer is unsigned. This
was addressed with the Sybase getByte checkin.
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
Attachments: QT_sqls2005ds_Push-ds.xml, QT_sqls2005ds_Push.vdb
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
1:11 p.m.
New subject: [JBoss JIRA] Closed: (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 closed TEIID-1175.
--------------------------------
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
Attachments: QT_sqls2005ds_Push-ds.xml, QT_sqls2005ds_Push.vdb
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
5052
days inactive
5071
days old
10 comments
2 participants
participants (2)
-
Steve Hawkins (JIRA) -
Warren Gibson (JIRA)