Error DBNAME.TABLE_NAME: Duplicate column name 'COLUMN_NAME'

[Azhar Mat Zin]

Error DBNAME.TABLE_NAME: Duplicate column name 'COLUMN_NAME'

1) Let say there is old development db, mysql 8 community edition, there is a lot of test db/schemas and test tables in it. accumulated over the years.

2) I wanted to create a table, and I get "Duplicate column name" error

3) There is NO duplicate column name in the table I wanted to create.

Searching for this error mostly lead to solution to point 3, in which the answer thinking the user are making this mistake, which I didn't.

There is no constraint in the table that I wanted to create.

Where should I start my investigation? (I have experiences in Oracle db but new in MySQL).