Changeset: 4a95e4894d4f for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4a95e4894d4f
Added Files:
sql/test/BugTracker-2014/Tests/duplicate_primary_keys.Bug-3474.sql
Modified Files:
sql/test/BugTracker-2014/Tests/All
Branch: Oct2014
Log Message:
Add another unsolved error test file
diffs (30 lines):
diff --git a/sql/test/BugTracker-2014/Tests/All
b/sql/test/BugTracker-2014/Tests/All
--- a/sql/test/BugTracker-2014/Tests/All
+++ b/sql/test/BugTracker-2014/Tests/All
@@ -44,3 +44,4 @@ aggr-with-limit.Bug-3498
sign-sorted.Bug-3594
nil_2dec_lng.Bug-3592
manifold.Bug-3556
+duplicate_primary_keys.Bug-3474
diff --git a/sql/test/BugTracker-2014/Tests/duplicate_primary_keys.Bug-3474.sql
b/sql/test/BugTracker-2014/Tests/duplicate_primary_keys.Bug-3474.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2014/Tests/duplicate_primary_keys.Bug-3474.sql
@@ -0,0 +1,17 @@
+create table x ( a clob, b clob, c timestamp);
+alter table x add primary key (a,b,c);
+
+create table y ( a clob, b clob, c timestamp);
+insert into y values ('FIAM','HHZ', '2010-04-25T14:00:00.000');
+
+insert into x (select * from y);
+
+-- this query should fail but doesn't:
+insert into x values ('FIAM','HHZ', '2010-04-25T14:00:00.000');
+
+-- and this one generates proper error message
+insert into x (select * from y);
+
+select * from x;
+drop table x;
+drop table y;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
