On 1/12/07, Neil Aggarwal <[EMAIL PROTECTED]> wrote:
The identifier quote character is the backtick ('`'):
mysql> SELECT * FROM `select` WHERE `select`.id > 100;
If the ANSI_QUOTES SQL mode is enabled,
The end of this sentence is interesting: "If the ANSI_QUOTES SQL mode
is enabled, it is also allowable to quote identifiers within double
quotes:".
One more time, MySQL chooses to not follow the spec by default. I'm
not sure the problem is in JPOX itself, perhaps, the MySQL JDBC driver
added them by itself. I did not find any backtick in JPOX source code.
Emmanuel, do you think you can consider the backtick like the double
quotes if MySQL is used? I did not take a look yet to the code which
manages this parsing, can you point it to me? I'd like to understand
how you do it.
--
Guillaume
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
