Skip to content

Server query with <column> = <column> for string column throws number format exception #10600

@elonazoulay

Description

@elonazoulay

The following query fails with a NumberFormatException for string columns:

select * from table where <string_column> = <string_column>

The message is logged in the server but silently fails, returning an empty result set.
Here is the log message, not the "string_0" is one of the values:

2023/04/13 10:00:16.013 ERROR [BaseCombineOperator] [pool-5-thread-10] Caught exception while processing query: QueryContext{_tableName='alltypes_REALTIME', _subquery=null, _se> java.lang.NumberFormatException: For input string: "string_0"

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions