List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:September 21 2005 10:58am
Subject:Re: Federated engine and "comment"???
View as plain text  

> > On Wednesday 21 September 2005 11:23, Martijn Tonies typed:
> > > Hi there,
> > >
> > > Did I just see in the documentation that the "comment" clause
> > > is being misused to supply a connection string for the federated
> > > engine?
> > >
> > > If so, I sure hope it will be changed before the final 5.0 release.
> > >
> > > "comment" is next to useless like this. It's already being misused
> > > by InnoDB to describe the FK constraints...
>
> Urm, where does it do that - my 4.1 server says
>   CONSTRAINT `login_properties_ibfk_1` FOREIGN KEY (`prop_login_id`)
> REFERENCES `login_master` (`login_id`) ON DELETE CASCADE ON UPDATE
CASCADE,
>   CONSTRAINT `login_properties_ibfk_2` FOREIGN KEY (`ref_prop_name`)
> REFERENCES `login_properties_master` (`prop_name`) ON DELETE CASCADE ON
> UPDATE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Properties for a login'
>
> nothing in the comment field about key constraints - or is that new in 5?

show table status

eg:
InnoDB free: 10240 kB; (`card_id`) REFER `test/card`(`pkey`) ON DELETE NO
ACTION ON UPDATE NO ACTION; (`card_id`) REFER `test/card`(`pkey`) ON DELETE
NO ACTION ON UPDATE NO ACTION; (`trans_id`) REFER `test/trans`(`pkey`) ON
DELETE NO ACTION ON UPDATE NO ACTION


Where's my original comment, if any?

All in all, bad!

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Thread
Federated engine and "comment"???Martijn Tonies21 Sep
  • Re: Federated engine and "comment"???Duncan Hill21 Sep
    • Re: Federated engine and "comment"???Duncan Hill21 Sep
  • Re: Federated engine and "comment"???Martijn Tonies21 Sep
  • Re: Federated engine and "comment"???Jim Winstead21 Sep
  • Re: Federated engine and "comment"???Martijn Tonies21 Sep