Incomplete quoting of SQL identifiers in AlterTableConstantAction
-----------------------------------------------------------------
Key: DERBY-5157
URL: https://issues.apache.org/jira/browse/DERBY-5157
Project: Derby
Issue Type: Bug
Components: SQL
Affects Versions: 10.7.1.1
Reporter: Knut Anders Hatlen
Assignee: Knut Anders Hatlen
AlterTableConstantAction generates SQL statements various places. Identifiers
(schema names, table names, column names) are surrounded with double quotes in
case they contain special characters. This is not enough if the identifiers
contain double quotes, as can be seen with this example:
ij> create table t(x int);
0 rows inserted/updated/deleted
ij> alter table t add column """" int default 42;
ERROR 42X01: Syntax error: Encountered "\"" at line 1, column 22.
I've found three places where AlterTableConstantAction generates SQL
statements: updateNewColumnToDefault(), updateNewAutoincrementColumn(),
getColumnMax(). All three places suffer from this problem.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
