theory / tap-parser-sourcehandler-pgtap

TAP::Parser::SourceHandler::pgTAP
http://search.cpan.org/dist/TAP::Parser::SourceHandler::pgTAP
11 stars 13 forks source link

Missing order by statement for triggers #35

Closed kashiif closed 3 years ago

kashiif commented 3 years ago

Problem:

We keep the generated test files in git. On every database change, we run a docker container, apply migrations to it and then regenerate and commit the test files. However following statements are often out of order:

Figured out that this query is missing ORDER BY clause and causing this behavior.

Expected Behavior:

If the database structure is unchanged, the generated files should be identical.