Skip to content

Exception thrown when mysql function name as a column name #2

@geshen

Description

@geshen

For example:

match is a mysql function, if some table include match as its column, then start_createindex.sh will throw a exception that tells synctax error around
select count(distinct(match)) from table_name.

In fact, the correct syntax should be select count(distinct(match)) from table_name.

Solution may be:

  1. setup a rule that column name can't be any function name
  2. add necessary quote for this kind of column

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions