Guillaume: I am using MySQL 5.0.26.
This page: http://dev.mysql.com/doc/refman/5.0/en/identifiers.html States: The identifier quote character is the backtick ('`'): mysql> SELECT * FROM `select` WHERE `select`.id > 100; If the ANSI_QUOTES SQL mode is enabled, I did not generate the back quotes, jpox did that. Thanks, Neil -- Neil Aggarwal, (214)986-3533, www.JAMMConsulting.com FREE! Eliminate junk email and reclaim your inbox. Visit http://www.spammilter.com for details. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Guillaume Smet Sent: Friday, January 12, 2007 5:17 AM To: Sequoia general mailing list Subject: Re: [Sequoia] Table names are lowercase when using Sequoia from jpox On 1/12/07, Emmanuel Cecchet <[EMAIL PROTECTED]> wrote: > I guess we could update the regexp to strip the back-quote, however if > this was used to force the use of a reserved keyword that may fool the > parser anyway. I don't think it's a good idea to implement it if it's not part of the standard. It throws an error with PostgreSQL and probably with other major RDBMS. I agree with you that it may cause more problems than it solves. Neil, could you tell us which database backend do you use which supports back-quotes? Did you add the back-quotes manually or did JPOX add them for you? -- Guillaume _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia _______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
