Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Gazetteer wildcard query error; #945

Closed
cityremade opened this issue Oct 3, 2023 · 1 comment
Closed

Gazetteer wildcard query error; #945

cityremade opened this issue Oct 3, 2023 · 1 comment
Assignees
Labels
Bug A genuine bug. There must be some form of error exception to work with.

Comments

@cityremade
Copy link
Member

cityremade commented Oct 3, 2023

Gazetteer with default wildcard parameter and several datasets to search.
I typed in asterisk by mistake W* and it blew up the "gaz query".
Found on branch main;

q: '\n' +
    '  SELECT \n' +
    '   AS label,\n' +
    '  id AS id\n' +
    '  FROM table\n' +
    '  WHERE ::text ILIKE $1\n' +
    '   \n' +
    '      \n' +
    '      \n' +
    '  LIMIT 10;',
  arr: [ 'w1%' ]
}
{
  err: error: syntax error at or near "AS"
Screenshot 2023-10-03 at 16 00 04
@cityremade cityremade added the Bug A genuine bug. There must be some form of error exception to work with. label Oct 3, 2023
@dbauszus-glx dbauszus-glx self-assigned this Oct 3, 2023
@dbauszus-glx
Copy link
Member

What is the error message? I don't think this is related to the wildcard. Providing additional wildcards shouldn't do anything.

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug A genuine bug. There must be some form of error exception to work with.
Projects
None yet
Development

No branches or pull requests

2 participants