[BEAM-12925] JdbcIo readRows does not handle null numerical values properly

• Type: Bug
• Status: Triage Needed
• Priority: P2
• Resolution: Fixed
• Affects Version/s: 2.32.0
• Fix Version/s: Missing
• Component/s: io-java-jdbc

Language

java

• Assignee: Unassigned
• Reporter: Chris Gray
• Created: 21/Sep/21 17:16
• Updated: 13/Apr/23 11:07
• Resolved: 10/Nov/21 18:39

Description

Numerical values that are SQL NULL in the database are converted to 0 when read by `readRows`.  This appears to be caused by SchemaUtil.java not checking `ResultSet::wasNull` at line 253 in version 2.32.0.  

Issue Links

• links to: GitHub Pull Request #15566