[ 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-unsubscr...@db.apache.org For additional commands, e-mail: torque-dev-h...@db.apache.org