[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive

2024-02-20 Thread Viraj Jasani (Jira) 


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Viraj Jasani updated PHOENIX-5400:
--
Fix Version/s: (was: 4.17.0)
   (was: 5.2.0)
   (was: 4.16.2)

> Table name while selecting index state is case sensitive
> 
>
> Key: PHOENIX-5400
> URL: https://issues.apache.org/jira/browse/PHOENIX-5400
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.13.0, 4.14.2
>Reporter: Ashutosh Parekh
>Assignee: Swaroopa Kadam
>Priority: Minor
>
> Initially, the following query is executed:
>  
> {code:java}
> CREATE TABLE IF NOT EXISTS us_population (
>  state CHAR(2) NOT NULL,
>  city VARCHAR NOT NULL,
>  population BIGINT,
>  CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0;
> UPSERT INTO us_population VALUES('NY','New York',8143197);
> UPSERT INTO us_population VALUES('CA','Los Angeles',3844829);
> UPSERT INTO us_population VALUES('IL','Chicago',2842518);
> UPSERT INTO us_population VALUES('TX','Houston',2016582);
> UPSERT INTO us_population VALUES('PA','Philadelphia',1463281);
> UPSERT INTO us_population VALUES('AZ','Phoenix',1461575);
> UPSERT INTO us_population VALUES('TX','San Antonio',1256509);
> UPSERT INTO us_population VALUES('CA','San Diego',1255540);
> UPSERT INTO us_population VALUES('TX','Dallas',1213825);
> UPSERT INTO us_population VALUES('CA','San Jose',912332);
> CREATE VIEW us_population_global_view (name VARCHAR,
>  age BIGINT) AS
> SELECT * FROM us_population
> WHERE state = 'CA';
> CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include 
> (city) async;
> {code}
>  
> Then,
> {code:java}
> org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code}
> is run.
> After that, The following queries then lead to a different output:
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='us_population_gv_gi_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> +--+
> No rows selected (0.076 seconds){code}
> and
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='US_POPULATION_GV_GI_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> | b |
> | |
> | |
> | |
> | |
> +--+
> 5 rows selected (0.063 seconds){code}
> Only the case in which the table is mentioned in different in the above 
> queries.
> Need an appropriate resolution for this.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive

2021-06-07 Thread Ankit Singhal (Jira) 


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ankit Singhal updated PHOENIX-5400:
---
Fix Version/s: (was: 5.1.2)

> Table name while selecting index state is case sensitive
> 
>
> Key: PHOENIX-5400
> URL: https://issues.apache.org/jira/browse/PHOENIX-5400
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.13.0, 4.14.2
>Reporter: Ashutosh Parekh
>Assignee: Swaroopa Kadam
>Priority: Minor
> Fix For: 4.17.0, 5.2.0, 4.16.2
>
>
> Initially, the following query is executed:
>  
> {code:java}
> CREATE TABLE IF NOT EXISTS us_population (
>  state CHAR(2) NOT NULL,
>  city VARCHAR NOT NULL,
>  population BIGINT,
>  CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0;
> UPSERT INTO us_population VALUES('NY','New York',8143197);
> UPSERT INTO us_population VALUES('CA','Los Angeles',3844829);
> UPSERT INTO us_population VALUES('IL','Chicago',2842518);
> UPSERT INTO us_population VALUES('TX','Houston',2016582);
> UPSERT INTO us_population VALUES('PA','Philadelphia',1463281);
> UPSERT INTO us_population VALUES('AZ','Phoenix',1461575);
> UPSERT INTO us_population VALUES('TX','San Antonio',1256509);
> UPSERT INTO us_population VALUES('CA','San Diego',1255540);
> UPSERT INTO us_population VALUES('TX','Dallas',1213825);
> UPSERT INTO us_population VALUES('CA','San Jose',912332);
> CREATE VIEW us_population_global_view (name VARCHAR,
>  age BIGINT) AS
> SELECT * FROM us_population
> WHERE state = 'CA';
> CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include 
> (city) async;
> {code}
>  
> Then,
> {code:java}
> org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code}
> is run.
> After that, The following queries then lead to a different output:
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='us_population_gv_gi_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> +--+
> No rows selected (0.076 seconds){code}
> and
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='US_POPULATION_GV_GI_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> | b |
> | |
> | |
> | |
> | |
> +--+
> 5 rows selected (0.063 seconds){code}
> Only the case in which the table is mentioned in different in the above 
> queries.
> Need an appropriate resolution for this.



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

[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive

2021-05-21 Thread Viraj Jasani (Jira) 


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Viraj Jasani updated PHOENIX-5400:
--
Fix Version/s: (was: 4.16.1)
   4.16.2
   5.1.2
   5.2.0

> Table name while selecting index state is case sensitive
> 
>
> Key: PHOENIX-5400
> URL: https://issues.apache.org/jira/browse/PHOENIX-5400
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.13.0, 4.14.2
>Reporter: Ashutosh Parekh
>Assignee: Swaroopa Kadam
>Priority: Minor
> Fix For: 4.17.0, 5.2.0, 5.1.2, 4.16.2
>
>
> Initially, the following query is executed:
>  
> {code:java}
> CREATE TABLE IF NOT EXISTS us_population (
>  state CHAR(2) NOT NULL,
>  city VARCHAR NOT NULL,
>  population BIGINT,
>  CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0;
> UPSERT INTO us_population VALUES('NY','New York',8143197);
> UPSERT INTO us_population VALUES('CA','Los Angeles',3844829);
> UPSERT INTO us_population VALUES('IL','Chicago',2842518);
> UPSERT INTO us_population VALUES('TX','Houston',2016582);
> UPSERT INTO us_population VALUES('PA','Philadelphia',1463281);
> UPSERT INTO us_population VALUES('AZ','Phoenix',1461575);
> UPSERT INTO us_population VALUES('TX','San Antonio',1256509);
> UPSERT INTO us_population VALUES('CA','San Diego',1255540);
> UPSERT INTO us_population VALUES('TX','Dallas',1213825);
> UPSERT INTO us_population VALUES('CA','San Jose',912332);
> CREATE VIEW us_population_global_view (name VARCHAR,
>  age BIGINT) AS
> SELECT * FROM us_population
> WHERE state = 'CA';
> CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include 
> (city) async;
> {code}
>  
> Then,
> {code:java}
> org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code}
> is run.
> After that, The following queries then lead to a different output:
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='us_population_gv_gi_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> +--+
> No rows selected (0.076 seconds){code}
> and
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='US_POPULATION_GV_GI_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> | b |
> | |
> | |
> | |
> | |
> +--+
> 5 rows selected (0.063 seconds){code}
> Only the case in which the table is mentioned in different in the above 
> queries.
> Need an appropriate resolution for this.



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

[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive

2020-11-03 Thread Xinyi Yan (Jira) 


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Xinyi Yan updated PHOENIX-5400:
---
Fix Version/s: (was: 4.15.1)

> Table name while selecting index state is case sensitive
> 
>
> Key: PHOENIX-5400
> URL: https://issues.apache.org/jira/browse/PHOENIX-5400
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.13.0, 4.14.2
>Reporter: Ashutosh Parekh
>Assignee: Swaroopa Kadam
>Priority: Minor
> Fix For: 5.1.1, 4.16.1, 4.17.0
>
>
> Initially, the following query is executed:
>  
> {code:java}
> CREATE TABLE IF NOT EXISTS us_population (
>  state CHAR(2) NOT NULL,
>  city VARCHAR NOT NULL,
>  population BIGINT,
>  CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0;
> UPSERT INTO us_population VALUES('NY','New York',8143197);
> UPSERT INTO us_population VALUES('CA','Los Angeles',3844829);
> UPSERT INTO us_population VALUES('IL','Chicago',2842518);
> UPSERT INTO us_population VALUES('TX','Houston',2016582);
> UPSERT INTO us_population VALUES('PA','Philadelphia',1463281);
> UPSERT INTO us_population VALUES('AZ','Phoenix',1461575);
> UPSERT INTO us_population VALUES('TX','San Antonio',1256509);
> UPSERT INTO us_population VALUES('CA','San Diego',1255540);
> UPSERT INTO us_population VALUES('TX','Dallas',1213825);
> UPSERT INTO us_population VALUES('CA','San Jose',912332);
> CREATE VIEW us_population_global_view (name VARCHAR,
>  age BIGINT) AS
> SELECT * FROM us_population
> WHERE state = 'CA';
> CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include 
> (city) async;
> {code}
>  
> Then,
> {code:java}
> org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code}
> is run.
> After that, The following queries then lead to a different output:
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='us_population_gv_gi_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> +--+
> No rows selected (0.076 seconds){code}
> and
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='US_POPULATION_GV_GI_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> | b |
> | |
> | |
> | |
> | |
> +--+
> 5 rows selected (0.063 seconds){code}
> Only the case in which the table is mentioned in different in the above 
> queries.
> Need an appropriate resolution for this.



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

[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive

2020-10-27 Thread Xinyi Yan (Jira) 


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Xinyi Yan updated PHOENIX-5400:
---
Fix Version/s: 4.17.0

> Table name while selecting index state is case sensitive
> 
>
> Key: PHOENIX-5400
> URL: https://issues.apache.org/jira/browse/PHOENIX-5400
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.13.0, 4.14.2
>Reporter: Ashutosh Parekh
>Assignee: Swaroopa Kadam
>Priority: Minor
> Fix For: 4.15.1, 5.1.1, 4.16.1, 4.17.0
>
>
> Initially, the following query is executed:
>  
> {code:java}
> CREATE TABLE IF NOT EXISTS us_population (
>  state CHAR(2) NOT NULL,
>  city VARCHAR NOT NULL,
>  population BIGINT,
>  CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0;
> UPSERT INTO us_population VALUES('NY','New York',8143197);
> UPSERT INTO us_population VALUES('CA','Los Angeles',3844829);
> UPSERT INTO us_population VALUES('IL','Chicago',2842518);
> UPSERT INTO us_population VALUES('TX','Houston',2016582);
> UPSERT INTO us_population VALUES('PA','Philadelphia',1463281);
> UPSERT INTO us_population VALUES('AZ','Phoenix',1461575);
> UPSERT INTO us_population VALUES('TX','San Antonio',1256509);
> UPSERT INTO us_population VALUES('CA','San Diego',1255540);
> UPSERT INTO us_population VALUES('TX','Dallas',1213825);
> UPSERT INTO us_population VALUES('CA','San Jose',912332);
> CREATE VIEW us_population_global_view (name VARCHAR,
>  age BIGINT) AS
> SELECT * FROM us_population
> WHERE state = 'CA';
> CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include 
> (city) async;
> {code}
>  
> Then,
> {code:java}
> org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code}
> is run.
> After that, The following queries then lead to a different output:
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='us_population_gv_gi_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> +--+
> No rows selected (0.076 seconds){code}
> and
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='US_POPULATION_GV_GI_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> | b |
> | |
> | |
> | |
> | |
> +--+
> 5 rows selected (0.063 seconds){code}
> Only the case in which the table is mentioned in different in the above 
> queries.
> Need an appropriate resolution for this.



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

[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive

2020-05-06 Thread Xinyi Yan (Jira) 


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Xinyi Yan updated PHOENIX-5400:
---
Fix Version/s: 4.16.1

> Table name while selecting index state is case sensitive
> 
>
> Key: PHOENIX-5400
> URL: https://issues.apache.org/jira/browse/PHOENIX-5400
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.13.0, 4.14.2
>Reporter: Ashutosh Parekh
>Assignee: Swaroopa Kadam
>Priority: Minor
> Fix For: 4.15.1, 5.1.1, 4.16.1
>
>
> Initially, the following query is executed:
>  
> {code:java}
> CREATE TABLE IF NOT EXISTS us_population (
>  state CHAR(2) NOT NULL,
>  city VARCHAR NOT NULL,
>  population BIGINT,
>  CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0;
> UPSERT INTO us_population VALUES('NY','New York',8143197);
> UPSERT INTO us_population VALUES('CA','Los Angeles',3844829);
> UPSERT INTO us_population VALUES('IL','Chicago',2842518);
> UPSERT INTO us_population VALUES('TX','Houston',2016582);
> UPSERT INTO us_population VALUES('PA','Philadelphia',1463281);
> UPSERT INTO us_population VALUES('AZ','Phoenix',1461575);
> UPSERT INTO us_population VALUES('TX','San Antonio',1256509);
> UPSERT INTO us_population VALUES('CA','San Diego',1255540);
> UPSERT INTO us_population VALUES('TX','Dallas',1213825);
> UPSERT INTO us_population VALUES('CA','San Jose',912332);
> CREATE VIEW us_population_global_view (name VARCHAR,
>  age BIGINT) AS
> SELECT * FROM us_population
> WHERE state = 'CA';
> CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include 
> (city) async;
> {code}
>  
> Then,
> {code:java}
> org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code}
> is run.
> After that, The following queries then lead to a different output:
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='us_population_gv_gi_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> +--+
> No rows selected (0.076 seconds){code}
> and
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='US_POPULATION_GV_GI_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> | b |
> | |
> | |
> | |
> | |
> +--+
> 5 rows selected (0.063 seconds){code}
> Only the case in which the table is mentioned in different in the above 
> queries.
> Need an appropriate resolution for this.



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

[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive

2019-09-18 Thread Lars Hofhansl (Jira) 


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Lars Hofhansl updated PHOENIX-5400:
---
Fix Version/s: (was: 5.1.0)
   (was: 4.15.0)
   5.1.1
   4.15.1

> Table name while selecting index state is case sensitive
> 
>
> Key: PHOENIX-5400
> URL: https://issues.apache.org/jira/browse/PHOENIX-5400
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.13.0, 4.14.2
>Reporter: Ashutosh Parekh
>Assignee: Swaroopa Kadam
>Priority: Minor
> Fix For: 4.15.1, 5.1.1
>
>
> Initially, the following query is executed:
>  
> {code:java}
> CREATE TABLE IF NOT EXISTS us_population (
>  state CHAR(2) NOT NULL,
>  city VARCHAR NOT NULL,
>  population BIGINT,
>  CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0;
> UPSERT INTO us_population VALUES('NY','New York',8143197);
> UPSERT INTO us_population VALUES('CA','Los Angeles',3844829);
> UPSERT INTO us_population VALUES('IL','Chicago',2842518);
> UPSERT INTO us_population VALUES('TX','Houston',2016582);
> UPSERT INTO us_population VALUES('PA','Philadelphia',1463281);
> UPSERT INTO us_population VALUES('AZ','Phoenix',1461575);
> UPSERT INTO us_population VALUES('TX','San Antonio',1256509);
> UPSERT INTO us_population VALUES('CA','San Diego',1255540);
> UPSERT INTO us_population VALUES('TX','Dallas',1213825);
> UPSERT INTO us_population VALUES('CA','San Jose',912332);
> CREATE VIEW us_population_global_view (name VARCHAR,
>  age BIGINT) AS
> SELECT * FROM us_population
> WHERE state = 'CA';
> CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include 
> (city) async;
> {code}
>  
> Then,
> {code:java}
> org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code}
> is run.
> After that, The following queries then lead to a different output:
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='us_population_gv_gi_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> +--+
> No rows selected (0.076 seconds){code}
> and
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='US_POPULATION_GV_GI_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> | b |
> | |
> | |
> | |
> | |
> +--+
> 5 rows selected (0.063 seconds){code}
> Only the case in which the table is mentioned in different in the above 
> queries.
> Need an appropriate resolution for this.



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

[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive

2019-07-31 Thread Swaroopa Kadam (JIRA) 


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Swaroopa Kadam updated PHOENIX-5400:

Affects Version/s: 4.14.2

> Table name while selecting index state is case sensitive
> 
>
> Key: PHOENIX-5400
> URL: https://issues.apache.org/jira/browse/PHOENIX-5400
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.13.0, 4.14.2
>Reporter: Ashutosh Parekh
>Assignee: Swaroopa Kadam
>Priority: Minor
> Fix For: 4.15.0, 5.1.0
>
>
> Initially, the following query is executed:
>  
> {code:java}
> CREATE TABLE IF NOT EXISTS us_population (
>  state CHAR(2) NOT NULL,
>  city VARCHAR NOT NULL,
>  population BIGINT,
>  CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0;
> UPSERT INTO us_population VALUES('NY','New York',8143197);
> UPSERT INTO us_population VALUES('CA','Los Angeles',3844829);
> UPSERT INTO us_population VALUES('IL','Chicago',2842518);
> UPSERT INTO us_population VALUES('TX','Houston',2016582);
> UPSERT INTO us_population VALUES('PA','Philadelphia',1463281);
> UPSERT INTO us_population VALUES('AZ','Phoenix',1461575);
> UPSERT INTO us_population VALUES('TX','San Antonio',1256509);
> UPSERT INTO us_population VALUES('CA','San Diego',1255540);
> UPSERT INTO us_population VALUES('TX','Dallas',1213825);
> UPSERT INTO us_population VALUES('CA','San Jose',912332);
> CREATE VIEW us_population_global_view (name VARCHAR,
>  age BIGINT) AS
> SELECT * FROM us_population
> WHERE state = 'CA';
> CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include 
> (city) async;
> {code}
>  
> Then,
> {code:java}
> org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code}
> is run.
> After that, The following queries then lead to a different output:
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='us_population_gv_gi_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> +--+
> No rows selected (0.076 seconds){code}
> and
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='US_POPULATION_GV_GI_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> | b |
> | |
> | |
> | |
> | |
> +--+
> 5 rows selected (0.063 seconds){code}
> Only the case in which the table is mentioned in different in the above 
> queries.
> Need an appropriate resolution for this.



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)

[jira] [Updated] (PHOENIX-5400) Table name while selecting index state is case sensitive

2019-07-31 Thread Swaroopa Kadam (JIRA) 


 [ 
https://issues.apache.org/jira/browse/PHOENIX-5400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Swaroopa Kadam updated PHOENIX-5400:

Fix Version/s: 5.1.0
   4.15.0

> Table name while selecting index state is case sensitive
> 
>
> Key: PHOENIX-5400
> URL: https://issues.apache.org/jira/browse/PHOENIX-5400
> Project: Phoenix
>  Issue Type: Bug
>Affects Versions: 4.13.0
>Reporter: Ashutosh Parekh
>Assignee: Swaroopa Kadam
>Priority: Minor
> Fix For: 4.15.0, 5.1.0
>
>
> Initially, the following query is executed:
>  
> {code:java}
> CREATE TABLE IF NOT EXISTS us_population (
>  state CHAR(2) NOT NULL,
>  city VARCHAR NOT NULL,
>  population BIGINT,
>  CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0;
> UPSERT INTO us_population VALUES('NY','New York',8143197);
> UPSERT INTO us_population VALUES('CA','Los Angeles',3844829);
> UPSERT INTO us_population VALUES('IL','Chicago',2842518);
> UPSERT INTO us_population VALUES('TX','Houston',2016582);
> UPSERT INTO us_population VALUES('PA','Philadelphia',1463281);
> UPSERT INTO us_population VALUES('AZ','Phoenix',1461575);
> UPSERT INTO us_population VALUES('TX','San Antonio',1256509);
> UPSERT INTO us_population VALUES('CA','San Diego',1255540);
> UPSERT INTO us_population VALUES('TX','Dallas',1213825);
> UPSERT INTO us_population VALUES('CA','San Jose',912332);
> CREATE VIEW us_population_global_view (name VARCHAR,
>  age BIGINT) AS
> SELECT * FROM us_population
> WHERE state = 'CA';
> CREATE INDEX us_population_gv_gi_1 ON us_population_global_view(age) include 
> (city) async;
> {code}
>  
> Then,
> {code:java}
> org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter{code}
> is run.
> After that, The following queries then lead to a different output:
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='us_population_gv_gi_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> +--+
> No rows selected (0.076 seconds){code}
> and
> {code:java}
> SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE 
> TABLE_NAME='US_POPULATION_GV_GI_1';{code}
> Output:
> {code:java}
> +--+
> | INDEX_STATE |
> +--+
> | b |
> | |
> | |
> | |
> | |
> +--+
> 5 rows selected (0.063 seconds){code}
> Only the case in which the table is mentioned in different in the above 
> queries.
> Need an appropriate resolution for this.



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)