#28 MySQL 5 compatibility problems in IPPlan v4.45

closed
nobody
None
5
2005-09-11
2005-08-18
No

IPPlan tries to use a table named 'schema', which is
NOT a good idea. It is reserved by mysql 5 as well as
in other database engines. There is an ugly work
around in the code for some engines, but just adding
mysql in there won't be enough.

One workaround that should fix this issue for good
would be to always refenrence this table using
databasename.schema. This fixes things at least for
mysql, and it might fix it for good in the other
database engines as well.

Discussion

  • Richard Ellerbrock

    Logged In: YES
    user_id=230197

    This is a problem. Your suggestion does not work on v4.1 of
    MySQL:

    mysql> create database test1;
    Query OK, 1 row affected (0.00 sec)

    mysql> use test1;
    Database changed
    mysql> CREATE TABLE `ipplan.schema` (
    -> version INTEGER NOT NULL DEFAULT 0
    -> )TYPE=INNODB;
    ERROR 1103 (42000): Incorrect table name 'ipplan.schema'

    And to change the name of the table will break any future
    upgrades of IPplan. Any other suggestions? I hate it when
    they change reserved words!

     
  • Henrique de Moraes Holschuh

    Logged In: YES
    user_id=1010847

    Try it without the `` and it will work.

    Whether that is good SQL or not, I don't know :(

     
  • Richard Ellerbrock

    Logged In: YES
    user_id=230197

    Don't think it worked with out `` either (got an error), but
    will try again.

     
  • Richard Ellerbrock

    Logged In: YES
    user_id=230197

    Yes, it works without the quotes on table names, but what is
    the correct behaviour? The quotes are automatically added by
    the adodb database layer. I have posted a message about this
    to the adodb forum - lets see what they say.

    They use a generic NameQuote function which I do not want to
    modify as I am not sure how it will affect other databases.

     
  • Richard Ellerbrock

    • status: open --> closed
     
  • Richard Ellerbrock

    Logged In: YES
    user_id=230197

    Required a patch to the adodb mysql datadict driver - fixed
    in CVS.

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks