Fun times dealing with a legacy system:
Apparently there's a distinction between NULL, "nothing" and data but JDBC treats "nothing" as NULL.
This results in the fun exercise where I can run a query like:
SELECT * FROM DB.TABLE WHERE DATECOL is NOT NULL
And the JDBC provided results contain nulls in that column 🤪
Fosstodon is an English speaking Mastodon instance that is open to anyone who is interested in technology; particularly free & open source software.