Changeset: 4b923b30c82c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4b923b30c82c
Added Files:
        
sql/test/BugTracker-2018/Tests/insert-null-second-interval-0.Bug-6515.sql
Modified Files:
        sql/test/BugTracker-2018/Tests/All
Branch: Jul2017
Log Message:

Added test for bug 6515


diffs (22 lines):

diff --git a/sql/test/BugTracker-2018/Tests/All 
b/sql/test/BugTracker-2018/Tests/All
--- a/sql/test/BugTracker-2018/Tests/All
+++ b/sql/test/BugTracker-2018/Tests/All
@@ -3,3 +3,4 @@ sqlitelogictest-wrong-aggregation-count.
 sqlitelogictest-wrong-select-not-between.Bug-6511
 sqlitelogictest-wrong-mal-function-generation.Bug-6513
 sqlitelogictest-select-range-null.Bug-6514
+insert-null-second-interval-0.Bug-6515
diff --git 
a/sql/test/BugTracker-2018/Tests/insert-null-second-interval-0.Bug-6515.sql 
b/sql/test/BugTracker-2018/Tests/insert-null-second-interval-0.Bug-6515.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2018/Tests/insert-null-second-interval-0.Bug-6515.sql
@@ -0,0 +1,9 @@
+CREATE TABLE testnullsa (a boolean, b text, c tinyint, d smallint, e int, f 
bigint, g real, h double, i blob);
+INSERT INTO testnullsa VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 
NULL);
+SELECT a, b, c, d, e, f, g, h, i FROM testnullsa;
+DROP TABLE testnullsa;
+
+CREATE TABLE testnullsb (a date, b time, c time with time zone, d timestamp, e 
timestamp with time zone, f INTERVAL year to month, g INTERVAL minute to 
second, h decimal);
+INSERT INTO testnullsb VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
+SELECT a, b, c, d, e, f, g, h FROM testnullsb;
+DROP TABLE testnullsb;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to