skeema / tengo / 54

88%

main: 94%

push

travis-ci

Fix sort order for foreign keys, especially re: underscores

SHOW CREATE TABLE shows foreign keys sorted by name, which Go La Tengo attempts
to reproduce when performing schema introspection. However, a BINARY sort order
is needed to correctly match the order in SHOW CREATE TABLE. In particular,
underscores need to be sorted as they are in ascii (after uppercase chars but
before lowercase chars), rather than as they are in non-binary MySQL collations
(after all chars regardless of case).

This commit also has TengoIntegrationSuite.TestInstanceSchemaIntrospection() now
confirm that foreign keys are in the correct order, by virtue of adding several
foreign keys to a fixture table that trigger the previous bug condition.

1 of 1 new or added line in 1 file covered. (100.0%)

1755 of 2002 relevant lines covered (87.66%)

104.8 hits per line