#2116 InnoDB relation view messed up with MySQL 3.23.56

2.8.0.3
wont-fix
5
2013-06-11
2006-04-18
No

phpMyAdmin - 2.8.0.3
MySQL client version: 3.23.49
Used PHP extensions: mysql
----------
MySQL - 3.23.56-Max
Protocol version: 10
Server: Localhost via UNIX socket
----------
Given InnoDB table "order_picture" with referential
constraints "(order) REFER foobar/orders(id);
(picture) REFER foobar/picture(id)" as reported
in "structure view".

In "relation view", both referenced columns show up
as "picture->id". This is wrong. Furthermore, it is
impossible to update the relations with this view
(otherwise constraints are duplicated). This problem
also impacts data insertion and update.

This problem does not prevent referential constraints
from working if they are managed through direct SQL.
But it prevents PMA from managing referencing tables.

This problem also occurs with all other databases and
tables on the same database server. It does not occur
on MySQL 4.x. However MySQL 3.23.56 is a legacy
production server that cannot be replaced at this
time.

Discussion

  • Marc Delisle

    Marc Delisle - 2006-05-25

    Logged In: YES
    user_id=210714

    We don't really have time to fix this kind of problems on
    older MySQL versions. If you can send a patch, fine,
    otherwise I feel like closing this report without a fix.

     
  • Francis PALLINI

    Francis PALLINI - 2006-05-25

    Logged In: YES
    user_id=805069

    Ok I will try to have a look. As you say it's a matter of
    time.

     
  • Francis PALLINI

    Francis PALLINI - 2006-05-26

    Logged In: YES
    user_id=805069

    Actually InnoDB does not offer a mean to drop foreign keys
    before MySQL 4.0.13 and it does accept duplicate
    constraints at least with MySQL 3.23.56-58. Doomed.

     
  • Marc Delisle

    Marc Delisle - 2006-05-26

    Logged In: YES
    user_id=210714

    Can I (or you) close this?

     
  • Marc Delisle

    Marc Delisle - 2006-05-26
    • assigned_to: nobody --> lem9
     
  • Francis PALLINI

    Francis PALLINI - 2006-05-26
    • status: open --> closed-wont-fix
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-wont-fix --> wont-fix
     

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

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks