Bug #108482 REPLACE INTO
Submitted: 14 Sep 2022 11:48 Modified: 14 Sep 2022 11:50
Reporter: GANESA KUMAR Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: DML Severity:S1 (Critical)
Version:8 OS:Windows
Assigned to: CPU Architecture:Any

[14 Sep 2022 11:48] GANESA KUMAR
Description:
Hi Team,

I have written data integration stored procedure.
There I have used REPLACE INTO (INSERT) STATEMENT .
(Assumed all the target table is having UNIQUE KEY)

Since all my target table is FACT kind of table , I won't have any primary key, only I can create composite unique key.

But new case has come, One target table has been created with 20 columns.  Here is the problem come into picture . I could not create UNIQUE KEY for more than 16 columns (Composite UNIQUE KEY).  

Now how can i handle this situation?  

I don't want to write separate delete and insert .

Please advice for my cases and let me know if need more information.

How to repeat:
Composite UNIQUE CREATE with more than 16 columns
[14 Sep 2022 11:50] MySQL Verification Team
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Thank you for your interest in MySQL.