[jira] [Comment Edited] (PHOENIX-6343) Phoenix allows duplicate column names when one of them is a primary key

["Viraj Jasani (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-6343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17282384#comment-17282384 ] 

Viraj Jasani edited comment on PHOENIX-6343 at 2/10/21, 11:27 AM:
------------------------------------------------------------------

[~elserj] Are you fine with this approach? I was thinking maybe we can checkin this in a couple of days. If [~larsh] gets a chance to take a look at this after some days and has additional suggestions, will incorporate his feedback.


was (Author: vjasani):
[~elserj] Are you fine with this approach? I was thinking maybe we can checkin this in a couple of days.

> Phoenix allows duplicate column names when one of them is a primary key
> -----------------------------------------------------------------------
>
>                 Key: PHOENIX-6343
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6343
>             Project: Phoenix
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 5.0.0, 4.15.0
>            Reporter: Istvan Toth
>            Assignee: Viraj Jasani
>            Priority: Major
>             Fix For: 5.1.0, 4.16.0
>
>
> {code:sql}
> CREATE TABLE IF NOT EXISTS test_duplicate_columns (
> name VARCHAR NOT NULL PRIMARY KEY,
> city VARCHAR, name VARCHAR);
> {code}
> {noformat}
> select * from test_duplicate_columns;
> +------+------+------+
> | NAME | CITY | NAME |
> +------+------+------+
> +------+------+------+
> No rows selected (0.015 seconds)
> {noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)