Richárd Antal created PHOENIX-6519:
--------------------------------------
Summary: Make SchemaTool work with lower case table and column
names
Key: PHOENIX-6519
URL: https://issues.apache.org/jira/browse/PHOENIX-6519
Project: Phoenix
Issue Type: Task
Components: core
Reporter: Richárd Antal
I wrote this test as part of a PR for PHOENIX-6518 and it fails.
{code:java}
@Test
public void testCreateTableStatementLowerCase() throws Exception {
String tableName = "lowecasetbl1";
String schemaName = "lowecaseschemaname1";
String pTableFullName = SchemaUtil.getEscapedTableName(schemaName,
tableName);
String createTableStmt = "CREATE TABLE "+ pTableFullName + "(\"smallK\"
VARCHAR NOT NULL PRIMARY KEY, "
+ "V1 VARCHAR, V2 VARCHAR) TTL=2592000, IMMUTABLE_ROWS=TRUE,
DISABLE_WAL=TRUE";
List<String> queries = new ArrayList<String>(){};
queries.add(createTableStmt);
String result = runSchemaExtractionTool("\"" + schemaName + "\"", "\""
+ tableName + "\"", null, queries);
Assert.assertEquals(createTableStmt, result.toUpperCase());
}{code}
Expected:
{code:java}
CREATE TABLE "lowecaseschemaname1"."lowecasetbl1"("smallK" VARCHAR NOT NULL
PRIMARY KEY, V1 VARCHAR, V2 VARCHAR) TTL=2592000, IMMUTABLE_ROWS=TRUE,
DISABLE_WAL=TRUE{code}
Actual result:
{code:java}
CREATE TABLE LOWECASESCHEMANAME1.LOWECASETBL1(SMALLK VARCHAR NOT NULL PRIMARY
KEY, V1 VARCHAR, V2 VARCHAR) TTL=2592000, IMMUTABLE_ROWS=TRUE,
DISABLE_WAL=TRUE{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
