Skip to content

sql_metadata.get_query_columns result error  #125

@chen-ABC

Description

@chen-ABC

demo

sql_metadata.get_query_columns("select max(col3)+avg(col)+1+sum(col2) from dual")
// result :  ['col3', 'avg', 'col', 'sum', 'col2'].   avg sum  shouldn't be a column

sql_metadata.get_query_columns("select avg(col)+sum(col2) from dual")
// result: ['avg', 'col', 'sum', 'col2']  avg sum  shouldn't be a column

sql_metadata.get_query_columns("select count(col)+max(col2)+ min(col3)+ count(distinct  col4) + custom_func(col5) from dual")
// result ['col', 'col2', 'col3', 'col4', 'custom_func', 'col5']   custom_func shouldn't be a column

it looks like function matching by keyword, I recommend matching by function pattern

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions