You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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:
setup a rule that column name can't be any function name
add necessary quote for this kind of column
The text was updated successfully, but these errors were encountered:
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:
The text was updated successfully, but these errors were encountered: