apache / apache/pinot

Selecting from double dimension behaves differently with double vs single quote

Open
#6,231 0 comments 0 reactions 1 assignee Claimed by @xiangfu0 View on GitHub
Dominant language
Java
Stars
6.1k
Forks
1.5k
Avg merge
1d 21h
Merged PRs (30d)
189

Description

Hi everyone,

Along the same line of #6230 there's another potentially non-intuitive case:

`SELECT * FROM mytable WHERE dim_singleval_DOUBLE_rawencoding_rangeindex_column = 2518.9497060727695` (no quotes **AND** single quotes) errors out, while `SELECT * FROM mytable WHERE dim_singleval_DOUBLE_rawencoding_rangeindex_column = "2518.9497060727695"` (double quotes) works just fine.

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.