[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1175) SqlServer 2005 - Queries failing due to negative values being treated as positive values

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