Date: 2020-06-10 17:02:10 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.37.7 (Jun2020)

Last updated: 2020-07-27 09:30:11 +0200

Comment 27818

Date: 2020-06-10 17:02:10 +0200
From: @PedroTadim

User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36
Build Identifier:

Run the statements below:

Reproducible: Always

Steps to Reproduce:

1. CREATE TABLE another_T (col1 INT, col2 INT, col3 INT, col4 INT, col5 INT, col6 INT, col7 INT, col8 INT);
2. INSERT INTO another_T VALUES (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888);
3. INSERT INTO another_t(col4) VALUES(-589206676), (-1557408577);
4. DELETE FROM another_t WHERE ((another_t.col8)<=(+ (another_t.col8)));
5. ALTER TABLE another_t ADD UNIQUE(col8, col1, col6, col3);

Actual Results:

Can not create object error

Expected Results:

The ALTER statement to succeed