[TRAFODION-1938] Create index failure in schema using delimited identifier

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 1.3-incubating, 2.0-incubating
• Fix Version/s: 2.0-incubating
• Component/s: sql-cmp
• Environment: Probably all; encountered on a development workstation
• Assignee: Dave Birdsall
• Reporter: Dave Birdsall
• Created: 18/Apr/16 20:25
• Updated: 07/Jun/16 17:13
• Resolved: 07/Jun/16 17:13

Description

The following sqlci session output demonstrates the problem. We create a schema using a delimited identifier for the schema name. Then we create a table in that schema, then put some data in it, then attempt to create an index on it. The CREATE INDEX fails in the code to load the data in the index. (Note: If there is no data in the table, CREATE INDEX succeeds.) This will be an issue in the future, for example, if we decided to add an index to an existing metadata table as part of a software upgrade.

>>create schema "Wolfman_Jack";

— SQL operation complete.
>>set schema "Wolfman_Jack";

— SQL operation complete.
>>create table t1 (a int not null, b int not null, c int);

— SQL operation complete.
>>drop table t1;

— SQL operation complete.
>>fc create
>>create table t1 (a int not null, b int not null, c int);
.. i, primary key (a)
>>create table t1 (a int not null, b int not null, c int, primary key (a));
..

— SQL operation complete.
>>insert into t1 values (1,2,3),(4,5,6),(7,8,0);

— 3 row(s) inserted.
>>create index it1 on t1(b);

• • • ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::doBulkLoad returned error HBASE_DOBULK_LOAD_ERROR(-715). Cause:
      java.lang.IllegalArgumentException: Illegal character code:34, <"> at 10. User-space table qualifiers can only contain 'alphanumeric characters': i.e. [a-zA-Z_0-9-.]: TRAFODION."Wolfman_Jack".IT1
      org.apache.hadoop.hbase.TableName.isLegalTableQualifierName(TableName.java:195)
      org.apache.hadoop.hbase.TableName.isLegalTableQualifierName(TableName.java:149)
      org.apache.hadoop.hbase.TableName.<init>(TableName.java:308)
      org.apache.hadoop.hbase.TableName.createTableNameIfNecessary(TableName.java:344)
      org.apache.hadoop.hbase.TableName.valueOf(TableName.java:431)
      org.apache.hadoop.hbase.client.HTable.<init>(HTable.java:160)
      org.trafodion.sql.HBulkLoadClient.doBulkLoad(HBulkLoadClient.java:457)
      .

• • • ERROR[1081] Loading of index TRAFODION."Wolfman_Jack".IT1 failed unexpectedly.

— SQL operation failed with errors.
>>