[PHOENIX-6343] Phoenix allows duplicate column names when one of them is a primary key

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.0.0, 4.15.0
• Fix Version/s: 5.1.1, 4.16.0, 5.2.0
• Component/s: core
• Release Note: Although user provided CF can have same column name as one of primary keys, default CF is no longer supported to have same column name as primary key columns.
• Assignee: Viraj Jasani
• Reporter: Istvan Toth
• Created: 27/Jan/21 15:09
• Updated: 15/Feb/21 21:23
• Resolved: 14/Feb/21 07:25

Description

CREATE TABLE IF NOT EXISTS test_duplicate_columns (
name VARCHAR NOT NULL PRIMARY KEY,
city VARCHAR, name VARCHAR);

select * from test_duplicate_columns;
+------+------+------+
| NAME | CITY | NAME |
+------+------+------+
+------+------+------+
No rows selected (0.015 seconds)

Issue Links

• links to: GitHub Pull Request #1117
• links to: GitHub Pull Request #1118