mysql reflection should use only show create table

[jek]

Pull reflection information from a single SHOW CREATE TABLE

Generally expand roundtrip-ability of freaky option parsing, currently limited to the storage engine.

was "use information_schema for mysql reflection"

[jek]

Also be sure to handle schema= on tables being reflected

[Mike Bayer]

we used to do this with postgres. it was a disaster, information_schema was incomplete, overly complicated, extremely slow, and each DB vendor implements it differently anyway. i dont see any advantages to having MySQL do it.

[jek]

yeah, reflecting from only SHOW CREATE TABLE is the fastest. it requires a sizable parser but it seems to be the most complete and backward compatible approach.

[jek]

ok, this is in 7a545a886973d76f934e0c234b69be8938cc9b20. its more fragile than the information schema or DESCRIBE approaches and could use some additional edge case tests.

also some table options should be silently dropped on reflection and that blacklist will probably need some tuning.

[Mike Bayer]

Removing milestone: 0.4.0 (automated comment)