> 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Properties for a login'
nothing in the comment field about key constraints - or is that new in 5?