[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:
--------------------------------------
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