Skip to content

Problems Report When [] and [] Are Pure Numbers in Indexed Columns #972

Open
@HappyToSummer

Description

@HappyToSummer

When I use [] to concatenate a field in an index, such as [123]ningyangxian, after the index is created, this column is only [123], and the ningyangxian behind is lost. Only when all the [] symbols are numbers appear.

my sql:

select CONCAT(CONCAT(CONCAT('[', b.NAME), ']'), g.NAME) AS goods_name from my_table b

when b.NAME is numbers,This problem can be reproduced

elasticsearch-jdbc-2.2.1.0
ES Version:2.2.1
java version "1.8.0_92"
Java(TM) SE Runtime Environment (build 1.8.0_92-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.92-b14, mixed mode)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions