- marked as enhancement
mysql reflection should use only show create table
Pull reflection information from a single SHOW CREATE TABLE
Generally expand roundtrip-ability of freaky option parsing, currently limited to the storage engine.
Comments (6)
-
reporter -
reporter Also be sure to handle schema= on tables being reflected
-
repo owner 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.
-
reporter - changed title to mysql reflection should use only show create table
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.
-
reporter - changed status to resolved
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.
-
repo owner - removed milestone
Removing milestone: 0.4.0 (automated comment)
- Log in to comment