The bug that only showed up once strangers could paste a schema

– albertoarena.it - submitted by Alberto Arena

A schema viewer that had only ever read a live database connection was quietly relying on that connection being trustworthy. Letting people paste a mysqldump instead turned up three assumptions that broke silently: identifiers written straight into the diagram definition, unrecognised statements skipped without a word, and relationship inference presenting a guess as a fact. Plus a fourth bug that the regex-based tests could not see, because a regex has no concept of a tag still being open ten lines later.

Read more [albertoarena.it]