Re: MySQL and Generate SQL, and inline bindings problems
Re: MySQL and Generate SQL, and inline bindings problems
- Subject: Re: MySQL and Generate SQL, and inline bindings problems
- From: Lachlan Deck <email@hidden>
- Date: Fri, 10 Oct 2008 13:24:41 +1100
On 06/10/2008, at 4:23 PM, Guido Neitzer wrote:
On 05.10.2008, at 17:37, Thomas Worrall wrote:
When I go to do Generate SQL for my EOModel, it does not escape the
table or field names in backticks (`). Because of this, table names
like Order cause SQL errors.
The problem is, that the MySQL plugin doesn't support identifier
quoting. The plugin overall is quite rudimentary ... I guess none of
the "know suspects" in the Wonder team uses MySQL, so there is not
even a Wonder MySQL plugin. Probably because the one from Apple
mainly works as long as you deal with the shortcomings.
In googling, all I could find was a suggestion to name my tables
something else. I can do that, but it seems I shouldn't have to:
regardless of what words are reserved, putting them all in
backticks would solve the problem entirely. Why doesn't EO do that?
Because nobody in the community bothered creating a new plugin for
MySQL when there is an incredibly good and widely supported plugin
for PostgreSQL ... and for the cases when people have to or want to
use MySQL they use the provided one and live with it.
Yep, I've been living with it - or lumping it really. I started having
a look at porting the postgresql plugin a few weeks back but got bored
-- er distracted by work.
Anyone willing to collaborate on this?
You can probably build one yourself. It's not too hard, or file a
bug report with Apple, maybe they invest some time into that.
with regards,
--
Lachlan Deck
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden