cockroachdb / cockroachdb/cockroach

ERROR: unsupported binary operator: `<int4> * <float4>`

Open
#123,659 2 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.