cast an invalid string to DATETIME returns NULL in normal SELECT, but triggers an error in prepared SELECT
Open
contribution
severity/moderate
sig/execution
type/bug
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Bug Report
Please answer these questions before submitting your issue. Thanks!
### 1. Minimal reproduce step (Required)
Hi,
In the following test case, there are two equivalent SELECTs, the normal SELECT returns NULL, but the prepared SELECT triggers an error.
```
CREATE TABLE t0(c0 BLOB);
INSERT INTO t0(c0) VALUES ('5{8**
Release Version: v9.0.0-beta.2.pre-551-g71caddf56d\nEdition: Community\nGit Commit Hash: 71caddf56d9c1887650568101590417558149e3f\nGit Branch: master\nUTC Build Time: 2025-10-11 06:46:47\nGoVersion: go1.23.12\nRace Enabled: false\nCheck Table Before Drop: false\nStore: unistore\nKernel Type: Classic
Contributor guide
Assessment
This issue has not been assessed yet.