[PHOENIX-5400] Table name while selecting index state is case sensitive

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Not A Bug
• Affects Version/s: 4.13.0, 4.14.2
• Assignee: Swaroopa Kadam
• Reporter: Ashutosh Parekh
• Created: 18/Jul/19 16:55
• Updated: 21/Feb/24 06:27
• Resolved: 07/Jun/22 18:27

Description

Initially, the following query is executed:

 

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;

 

Then,

org.apache.phoenix.mapreduce.index.automation.PhoenixMRJobSubmitter

is run.

After that, The following queries then lead to a different output:

SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE TABLE_NAME='us_population_gv_gi_1';

Output:

+--------------+
| INDEX_STATE |
+--------------+
+--------------+
No rows selected (0.076 seconds)

and

SELECT INDEX_STATE FROM SYSTEM.CATALOG WHERE TABLE_NAME='US_POPULATION_GV_GI_1';

Output:

+--------------+
| INDEX_STATE |
+--------------+
| b |
| |
| |
| |
| |
+--------------+
5 rows selected (0.063 seconds)

Only the case in which the table is mentioned in different in the above queries.

Need an appropriate resolution for this.