Changeset: a10b2f79880e for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a10b2f79880e
Modified Files:
sql/test/BugTracker-2014/Tests/stringfloatshtcompare.Bug-3512.sql
Branch: default
Log Message:
Merge with Jan2014 branch.
diffs (23 lines):
diff --git a/sql/test/BugTracker-2014/Tests/stringfloatshtcompare.Bug-3512.sql
b/sql/test/BugTracker-2014/Tests/stringfloatshtcompare.Bug-3512.sql
--- a/sql/test/BugTracker-2014/Tests/stringfloatshtcompare.Bug-3512.sql
+++ b/sql/test/BugTracker-2014/Tests/stringfloatshtcompare.Bug-3512.sql
@@ -1,6 +1,18 @@
START TRANSACTION;
CREATE TABLE bug3512 (a VARCHAR(100) ) ;
+
+INSERT INTO bug3512 (a) VALUES ('9999') ;
+INSERT INTO bug3512 (a) VALUES ('32767') ;
+INSERT INTO bug3512 (a) VALUES ('32768') ;
+INSERT INTO bug3512 (a) VALUES ('327670') ;
+-- this fails because values > 32767 cannot be represented as short
+-- and MonetDB tries to cast the col to short
+SELECT * FROM bug3512 WHERE a > 8888;
+
+INSERT INTO bug3512 (a) VALUES ('0.0');
INSERT INTO bug3512 (a) VALUES ('0.10');
INSERT INTO bug3512 (a) VALUES ('9999.00') ;
-UPDATE bug3512 SET a = NULL WHERE a IN ( 9999 ) ;
+
+-- this fails because decimal numbers cannot be cast to short
+SELECT * FROM bug3512 WHERE a = 9999;
ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
