WebSockets: Empty string or invalid numeric value in executePreparedStatement() leads to an internal error
Details
| Detail name | Value |
|---|---|
| Changelog Number | 10103 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | EXASOL 6.0.0, Exasol 6.1.0, Exasol 6.2.0, Exasol 7.0.beta1 |
| Fix Versions | Exasol 7.0.0, Exasol 6.1.10, Exasol 6.2.8, Exasol 7.0.rc1 |
| Resolution Date | 2020-07-01 |
Issue:
Providing an empty string or invalid value for a numeric column (e.g. '' or 'x') in executePreparedStatement() leads to an internal error without a proper exception message being sent to the client.
Fix:
- An empty string will be accepted as NULL.
- An exception message will be sent to the client for an invalid value. For example:
invalid character value for cast; Value: 'x'
Workaround:
Use NULL instead of an empty string ('') to represent a NULL value.
