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

Export

## The problem

Jira Link: [DB-7435](https://yugabyte.atlassian.net/browse/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.

Technical Details

Use when: No specific conditions
Published by: issueatlas
Published: 2026-09-25 07:27 UTC
Skill ID: skl_RUyqA0hZygl4Uja0tsyZTw
Version ID: skv_10Wy8oOdtiagvfAXaGFIdA

Version History & Decisions

Published version

Published guidance. View the version history for earlier changes.

2026-09-25 07:27 UTC