Dynamically Filter not working (only happen with more than 1000 values)

[enzo-dechaene]

How to reproduce the bug

1. Create a Dashboard
2. Click on 'Filters => add filter
3. Scroll down to 'Filter Settings'
4. Click on 'Dynamically search all filter values' (only for filters with more than 1000 values)
5. Write any text on the filter value
6. See error

Expected results

It suppose to display the list of values in response of the regex string

Actual results

Actually return an sql error.

Here is the query doing by the worker :

Query SELECT libelleSite FROM "indicateur-compte-v2"."indicateur-compte-v2" WHERE libelleSite != 'null' AND lower(libelleSite) LIKE lower('%Lyc%') GROUP BY libelleSite ORDER BY libelleSite ASC LIMIT 1000 on schema indicateur-compte-v2 failed

Here is the stacktrace inside log of the worker : [2023-01-05 20:21:34,811: ERROR/MainProcess] Task load_chart_data_into_cache[f87746c9-1f4c-43e7-be81-3b542fb8736e] raised unexpected: Error: unsupported format character 'y' (0x79) at index 145 Traceback (most recent call last): File "/usr/local/lib/python3.8/site-packages/celery/app/trace.py", line 451, in trace_task R = retval = fun(*args, **kwargs) File "/app/superset/initialization/__init__.py", line 105, in __call__ return task_base.__call__(self, *args, **kwargs) File "/usr/local/lib/python3.8/site-packages/celery/app/trace.py", line 734, in __protected_call__ return self.run(*args, **kwargs) File "/app/superset/tasks/async_queries.py", line 102, in load_chart_data_into_cache raise ex File "/app/superset/tasks/async_queries.py", line 84, in load_chart_data_into_cache result = command.run(cache=True) File "/app/superset/charts/data/commands/get_data_command.py", line 52, in run raise ChartDataQueryFailedError(f"Error: {query['error']}") superset.charts.commands.exceptions.ChartDataQueryFailedError: Error: unsupported format character 'y' (0x79) at index 145

Screenshots

Environment

• Kubernetes cluster version: 1.24.8
• browser type and version: Brave/v1.46.144
• superset version: 2.0.1 but same for 2.0.0
• python version: 3.8.12
• any feature flags active:

  "DASHBOARD_NATIVE_FILTERS": True "ENABLE_TEMPLATE_PROCESSING": True "GLOBAL_ASYNC_QUERIES": True

Checklist

Make sure to follow these steps before submitting your issue - thank you!

• [x] I have checked the superset logs for python stacktraces and included it here as text if there are any.
• [x] I have reproduced the issue with at least the latest released version of superset.
• [x] I have checked the issue tracker for the same issue and I haven't found one similar.

[rusackas]

Closing this as stale since it's been silent for so long, and we're trying to steer toward a more actionable Issues backlog. If people are still encountering this in current versions (currently 3.x) please re-open this issue, open a new Issue with updated context, or raise a PR to address the problem. Thanks!