db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Fox (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (TORQUE-203) Quote table names in creation
Date Fri, 08 Jun 2012 03:17:22 GMT

    [ https://issues.apache.org/jira/browse/TORQUE-203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13291525#comment-13291525

Thomas Fox commented on TORQUE-203:

All databases we support in 4.0 support quoting.
But as always, different database vendors implement things different. E.g.
MySQL: create table `book` (id integer not null); 
  select * from `book`; ->OK
  select * fron book; ->OK
Oracle: create table "book" (id number not null); 
  select * from "book"; ->OK
  select * fron book; -> Table not found
So quoting is not a solution IMHO.
As a user I'd not accept defining a table book and then find the table name to be "book" (with
double quotes, as in Oracle).
> Quote table names in creation
> -----------------------------
>                 Key: TORQUE-203
>                 URL: https://issues.apache.org/jira/browse/TORQUE-203
>             Project: Torque
>          Issue Type: Improvement
>            Reporter: Thomas Fox
> For some databases, table names can be quoted in the sql create scripts to avoid collisions
with predefined names. Where possible, such quotation should be used.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org

View raw message