Bug #97716 Primary Key (Keyword)
Submitted: 20 Nov 2019 17:15 Modified: 20 Nov 2019 20:40
Reporter: NEERAJ RANA Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:8.0 OS:Windows
Assigned to: CPU Architecture:Any

[20 Nov 2019 17:15] NEERAJ RANA 
Description:
Created a table where no primary key was defined for a column, after table while altering the table to add a primary key to a column it shows multiple primary key defined. while describing the table no primary key is shown in the column. 

How to repeat:
Created a table where no primary key was defined for a column, after table while altering the table to add a primary key to a column it shows multiple primary key defined. while describing the table no primary key is shown in the column.

Suggested fix:
Add a varchar() like thing to store Cache and after every compilation the unwanted memory deletes.
[20 Nov 2019 17:21] NEERAJ RANA 
image for the bug

Attachment: MYSql Bug.PNG (image/png, text), 31.97 KiB.
[20 Nov 2019 17:21] NEERAJ RANA 
image for the bug

Attachment: MYSql Bug.PNG (image/png, text), 31.97 KiB.
[20 Nov 2019 17:21] NEERAJ RANA 
image for the bug

Attachment: MYSql Bug.PNG (image/png, text), 31.97 KiB.
[20 Nov 2019 17:21] NEERAJ RANA 
image for the bug

Attachment: MYSql Bug.PNG (image/png, text), 31.97 KiB.
[20 Nov 2019 20:40] 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.