DELETE doesn't work when specifying a float key via JDBC

TL;DR

Jira Link: DB-7435 I noticed DELETE statement in YugabyteDB can't delete records when specifying a float key via JDBC. Never test floats for exact equality: use the numeric type or an almost-equal comparison instead.

Steps

1. Jira Link: DB-7435 I noticed DELETE statement in YugabyteDB can't delete records when specifying a float key via JDBC. I think you can reproduce this issue using the following code.
2. [andrei-mart (contributor)]: Float keys fail exact-equality lookups in YugabyteDB due to internal float rounding. Never test floats for exact equality: use the numeric type or an almost-equal comparison instead. PostgreSQL and MySQL docs carry the same warning.

When to use

You are seeing this: I think you can reproduce this issue using the following code. Use this skill when you run into "DELETE doesn't work when specifying a float key via JDBC".

When not to use

If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.

Versions

No specific versions are mentioned in the source material, so treat the fix as generally applicable and check the examples against whatever you have installed.

Why this happens

The original report does not dig into a root cause. It documents the symptom and the fix that resolved it.

Sources

• https://yugabyte.atlassian.net/browse/DB-7435

In gh:yugabyte/yugabyte-db#18461 (https://github.com/yugabyte/yugabyte-db/issues/18461), the reporter ran into this: Jira Link: DB-7435 I noticed DELETE statement in YugabyteDB can't delete records when specifying a float key via JDBC. I think you can reproduce this issue using the following code. The verified resolution: [andrei-mart (contributor)]: Float keys fail exact-equality lookups in YugabyteDB due to internal float rounding. Never test floats for exact equality: use the numeric type or an almost-equal comparison instead. PostgreSQL and MySQL docs carry the same warning.