[teiid-issues] [JBoss JIRA] Commented: (TEIID-1175) SqlServer 2005 - Queries failing due to negative values being treated as positive values
Steve Hawkins (JIRA)
jira-events at lists.jboss.org
Tue Aug 3 10:07:49 EDT 2010
[ https://jira.jboss.org/browse/TEIID-1175?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12542762#action_12542762 ]
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
More information about the teiid-issues
mailing list