Changeset: 04636df9c241 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=04636df9c241
Added Files:
sql/test/BugTracker-2014/Tests/uppercaseboolean.Bug-3519.sql
Branch: Jan2014
Log Message:
Test for Bug #3519
Unterschiede (27 Zeilen):
diff --git a/sql/test/BugTracker-2014/Tests/uppercaseboolean.Bug-3519.sql
b/sql/test/BugTracker-2014/Tests/uppercaseboolean.Bug-3519.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2014/Tests/uppercaseboolean.Bug-3519.sql
@@ -0,0 +1,22 @@
+start transaction;
+create table bug3519(a boolean);
+-- works
+insert into bug3519 values (true),(false),(TRUE),(FALSE);
+insert into bug3519 values ('true'),('false');
+insert into bug3519 values (1),(0),(NULL),('1'),('0');
+COPY 5 RECORDS INTO bug3519 FROM stdin NULL as '';
+true
+false
+1
+0
+
+select * from bug3519;
+
+-- does not work
+insert into bug3519 values ('TRUE'),('FALSE');
+COPY 2 RECORDS INTO bug3519 FROM stdin;
+TRUE
+FALSE
+
+select * from bug3519;
+rollback;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
