db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DERBY-5157) Incomplete quoting of SQL identifiers in AlterTableConstantAction
Date Mon, 28 Mar 2011 12:35:05 GMT
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:
            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

View raw message