enzo-dechaene opened a new issue, #22626:
URL: https://github.com/apache/superset/issues/22626
#### 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.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
