You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@empire-db.apache.org by "Jörg Reiher (JIRA)" <em...@incubator.apache.org> on 2008/08/26 15:35:44 UTC
[jira] Created: (EMPIREDB-3) Add "useQuote" property to DBColum
class so columns with SQL keywords as names get properly "escaped"
Add "useQuote" property to DBColum class so columns with SQL keywords as names get properly "escaped"
-----------------------------------------------------------------------------------------------------
Key: EMPIREDB-3
URL: https://issues.apache.org/jira/browse/EMPIREDB-3
Project: Empire-DB
Issue Type: Improvement
Affects Versions: empire-db-2.0.3-incubating
Reporter: Jörg Reiher
Priority: Minor
Fix For: empire-db-2.0.3-incubating
HSQLDB doesn't like "COUNT" as an SQL column name, because it is also a function.
So it would be helpful to add a property "useQuote" to the DBColumn class so that if set to "true" the column in the generated SQL statement gets surrounded by quotation marks. This allows the use of "keywords" as column names.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (EMPIREDB-3) Add "useQuote" property to DBColum
class so columns with SQL keywords as names get properly "escaped"
Posted by "Jörg Reiher (JIRA)" <em...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/EMPIREDB-3?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jörg Reiher updated EMPIREDB-3:
-------------------------------
Component/s: Core
> Add "useQuote" property to DBColum class so columns with SQL keywords as names get properly "escaped"
> -----------------------------------------------------------------------------------------------------
>
> Key: EMPIREDB-3
> URL: https://issues.apache.org/jira/browse/EMPIREDB-3
> Project: Empire-DB
> Issue Type: Improvement
> Components: Core
> Affects Versions: empire-db-2.0.3-incubating
> Reporter: Jörg Reiher
> Priority: Minor
> Fix For: empire-db-2.0.3-incubating
>
>
> HSQLDB doesn't like "COUNT" as an SQL column name, because it is also a function.
> So it would be helpful to add a property "useQuote" to the DBColumn class so that if set to "true" the column in the generated SQL statement gets surrounded by quotation marks. This allows the use of "keywords" as column names.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (EMPIREDB-3) Add "useQuote" property to DBColum
class so columns with SQL keywords as names get properly "escaped"
Posted by "Jörg Reiher (JIRA)" <em...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/EMPIREDB-3?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jörg Reiher resolved EMPIREDB-3.
--------------------------------
Resolution: Fixed
Added "useQuotes" property to DBColumn.
> Add "useQuote" property to DBColum class so columns with SQL keywords as names get properly "escaped"
> -----------------------------------------------------------------------------------------------------
>
> Key: EMPIREDB-3
> URL: https://issues.apache.org/jira/browse/EMPIREDB-3
> Project: Empire-DB
> Issue Type: Improvement
> Components: Core
> Affects Versions: empire-db-2.0.3-incubating
> Reporter: Jörg Reiher
> Priority: Minor
> Fix For: empire-db-2.0.3-incubating
>
>
> HSQLDB doesn't like "COUNT" as an SQL column name, because it is also a function.
> So it would be helpful to add a property "useQuote" to the DBColumn class so that if set to "true" the column in the generated SQL statement gets surrounded by quotation marks. This allows the use of "keywords" as column names.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.