cockroachdb / cockroachdb/cockroach
ERROR: unsupported binary operator: `<int4> * <float4>`
Open
C-bug
O-community
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
**Describe the problem**
Multiplication of an `int4` with a `float4` fails with: `ERROR: unsupported binary operator: * `
**To Reproduce**
Run a query e.g. `select cast((p1_0.id*?) as float(53)) from Person p1_0` where the `id` column is an `int4` and the parameter is bound as float4.
**Expected behavior**
No error.
**Environment:**
- CockroachDB version 23.1.12
- Server OS: Ubuntu Docker container
- Client app JDBC
Jira issue: CRDB-38456
Contributor guide
Assessment
This issue has not been assessed yet.