MonetDB: Jun2020 - SQLancer error on ALTER ADD UNIQUE constraint

[Pedro Ferreira]

Changeset: 4d994b8d0c44 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4d994b8d0c44
Modified Files:
        sql/test/SQLancer/Tests/sqlancer01.sql
Branch: Jun2020
Log Message:

SQLancer error on ALTER ADD UNIQUE constraint


diffs (14 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer01.sql 
b/sql/test/SQLancer/Tests/sqlancer01.sql
--- a/sql/test/SQLancer/Tests/sqlancer01.sql
+++ b/sql/test/SQLancer/Tests/sqlancer01.sql
@@ -27,6 +27,10 @@ SELECT i from integers order by i;
        -- 0
 select reverse('8 \rcr੧[bp1eMY쫺4j5s뮯!<Rn4*}');
 
+-- Bug 6886
+INSERT INTO another_t(col4) VALUES(-589206676), (-1557408577);
+DELETE FROM another_t WHERE ((another_t.col8)<=(+ (another_t.col8)));
+ALTER TABLE another_t ADD UNIQUE(col8, col1, col6, col3);
 ROLLBACK;
 
 DROP TABLE tbl_ProductSales;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list