Follow

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:

```sql
SELECT * FROM DB.TABLE WHERE DATECOL is NOT NULL
```
And the JDBC provided results contain nulls in that column 🤪

Sign in to participate in the conversation
Fosstodon

Fosstodon is an English speaking Mastodon instance that is open to anyone who is interested in technology; particularly free & open source software.