Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sql: float4 fidelity not maintained #41689

Open
asubiotto opened this issue Oct 17, 2019 · 0 comments
Open

sql: float4 fidelity not maintained #41689

asubiotto opened this issue Oct 17, 2019 · 0 comments
Labels
A-sql-pgcompat Semantic compatibility with PostgreSQL X-anchored-telemetry The issue number is anchored by telemetry references.
Projects
[DEPRECATED] Old SQLExec board. Don't...

Comments

@asubiotto
Copy link
Contributor

asubiotto commented Oct 17, 2019 •
edited by cockroach-jira-scripts

TestIssue196 in the lib/pq test suite fails when checking that the following query returns true, true:

row := db.QueryRow("SELECT float4 '0.10000122' = $1, float8 '35.03554004971999' = $2",
	float32(0.10000122), float64(35.03554004971999))

This doesn't seem to be reproducible through the shell.

Jira issue: CRDB-5419
@asubiotto asubiotto added A-sql-pgcompat Semantic compatibility with PostgreSQL X-anchored-telemetry The issue number is anchored by telemetry references. labels Oct 17, 2019
@asubiotto asubiotto moved this from Triage to [TENT] SQL Features in [DEPRECATED] Old SQLExec board. Don't move stuff here Apr 2, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
A-sql-pgcompat Semantic compatibility with PostgreSQL X-anchored-telemetry The issue number is anchored by telemetry references.
Projects
No open projects
[DEPRECATED] Old SQLExec board. Don't...
SQL Features Backlog
Milestone
No milestone
Development

No branches or pull requests
1 participant
@asubiotto