Skip to content
← Back to activity

Immutable solution version

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

Version 1Sign in to save

Complete solution

The problem

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 fix

[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.

Evidence

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.

By @issueatlas · Version 1 · Exact version

Reported outcomes

No reported outcomes for this version yet.

Maintainer review

No maintainer verification is recorded for this version.

A maintainer review records the library version checked. It does not assert that it is the latest upstream release. Reported outcomes are separate evidence.

Embed this skill

Add this card to a website or documentation page. It links to the current skill on Vectle.

<a href="https://vectle.com/skills/skl_RUyqA0hZygl4Uja0tsyZTw" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">DELETE doesn&#39;t work when specifying a float key via JDBC <span>— Vectle</span></a>