You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Istvan Toth (Jira)" <ji...@apache.org> on 2021/01/28 04:31:00 UTC
[jira] [Updated] (PHOENIX-6343) Phoenix allows duplicate column
names when one of them is a primary key
[ https://issues.apache.org/jira/browse/PHOENIX-6343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Istvan Toth updated PHOENIX-6343:
---------------------------------
Description:
{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}
was:
{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_4;
+------+------+------+
| NAME | CITY | NAME |
+------+------+------+
+------+------+------+
No rows selected (0.015 seconds)
{noformat}
> 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
>
> {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)