
One interesting thing that came up though: thanks to the Machinery of Government changes announced the week before last, our official abbreviation is now four characters - in both previous incarnations, it was three. The data in the system I work on includes what is basically a representation of the structure of the entire department, as viewed in financial terms (it’s called a “chart of account” apparently), and many of the things in there include the abbreviation in their names. So is there any code that for some reason digs into those names to find parts thereof, and will break once that bit of the names becomes one character longer?

No, is the answer, because neither I nor any of the other people who’ve worked on it over the years would do it that way. In fact, none of the code cares about those names at all; they’re just for display purposes, and the data we generate with a script for our development environments just uses things like “Group 1” and so on. But while digging through the code just in case, it did occur to me that there might be something with a long enough name that adding one character would make it overflow the size of its column in the database. So tomorrow, I shall have some SQL fun constructing a query to identify any columns in any rows in all the tables that might be at risk




.


Leave a comment: