empire-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shaun Forbes (JIRA)" <empire-db-...@incubator.apache.org>
Subject [jira] [Created] (EMPIREDB-209) Using a reserved word as a column alias in a select statement.
Date Wed, 20 Aug 2014 11:19:26 GMT
Shaun Forbes created EMPIREDB-209:

             Summary: Using a reserved word as a column alias in a select statement.
                 Key: EMPIREDB-209
                 URL: https://issues.apache.org/jira/browse/EMPIREDB-209
             Project: Empire-DB
          Issue Type: New Feature
          Components: Core
    Affects Versions: empire-db-2.4.2
            Reporter: Shaun Forbes
            Priority: Minor

I believe it's possible in sql to use a reserved word as an alias in a select statement if
it's correctly quoted (it is for the databases I've tested anyway).
Checking for and quoting reserved word aliases does not currently appear to be implemented.

To overcome this limitation I've added an method to the DBDatabaseDriver class to add the
alias and perform any required quoting and altered the DBAliasExpr class to delegate the adding
of the alias to the DBDatabaseDriver class.

The character I'm using for quoting is determined from the getIdentifierQuoteString() method
of the database connection metadata class, and I've used the detectQuoteName(String name)
method in DBDatabaseDriver to determine if the alias needs to be quoted.

Patches available if required.

This message was sent by Atlassian JIRA

View raw message