List:General Discussion« Previous MessageNext Message »
From:Duncan Hill Date:September 21 2005 10:35am
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?
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