[ https://issues.apache.org/jira/browse/PHOENIX-6519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Richárd Antal reassigned PHOENIX-6519: -------------------------------------- Assignee: Richárd Antal > 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 > Assignee: Richárd Antal > Priority: Major > > 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)