Page 1 of 1
GRANT/CREATE PROCEDURE fails Prepare
Posted: Mon 02 Jan 2006 10:55
by upscene
Hi,
When issueing a GRANT or CREATE PROCEDURE statement and doing a Prepare, this fails with error:
#HY000This command is not supported in the prepared statement protocol yet
Given generic code (that is: ALL statements are prepared), perhaps this should be silently ignored?
I'm using MySQL 5.
--
Martijn Tonies
Upscene Productions
Posted: Tue 03 Jan 2006 16:00
by Ikar
This is MySQL server error message. We can't advise any solution to avoid this problem.
Posted: Wed 04 Jan 2006 10:32
by upscene
How about just ignoring it silently?
For example, how does it work on MySQL 4, which, I believe, doesn't have the prepare protocol yet?
--
Martijn Tonies
Upscene Productions
Posted: Wed 04 Jan 2006 14:41
by Ikar
In our opinion it isn't good way to silent ignore user code.
Posted: Wed 04 Jan 2006 15:31
by upscene
I guess that depends on your way of seeing the "prepare".
For MySQL 4, a Delphi-side "prepare" doesn't do a thing cause it doesn't support the MySQL native Prepare Protocol, right?
So for statements that not (yet) support a MySQL server-side prepare, why not ignore the error as well?
--
Martijn Tonies
Upscene Productions
Posted: Thu 05 Jan 2006 09:44
by Ikar
We do not think there are major advantages of this approach. We will remain consistent with existing functionality.
Posted: Thu 05 Jan 2006 13:36
by upscene
Well, for one thing, it avoids people have to check if their code runs against 4.1 (and calling Prepare as always) or running against 4.0 (and NOT calling Prepare). Or - as I got a confirmation by e-mail earlier - will it ignore the Prepare when running against 4.0.
Another "plus": people don't have to check the statement type and can call Prepare always, even though MySQL itself doesn't support it for that particular statment type.
--
Martijn Tonies
Upscene Productions