propellerjet opened a new issue, #32394: URL: https://github.com/apache/superset/issues/32394
### Bug description **How to reproduce the bug** 1. Add RLS rule for dataset on Posgres  3. Create chart using this dataset 4. Try to apply filter on the chart As you can see on screeshot, no values are loaded for this column  error:  error in logs "ERROR:flask_appbuilder.api:dict is not a sequence" It is possible to type values manually and it will work  Dashboard filters also work correctly and load all available values. ### Screenshots/recordings _No response_ ### Superset version 4.1.1 ### Python version 3.9 ### Node version I don't know ### Browser Chrome ### Additional context We face such error only with datasets on Posgresql full log 213:ERROR:flask_appbuilder.api:dict is not a sequence Traceback (most recent call last): File "/app/venv/lib64/python3.9/site-packages/flask_appbuilder/api/__init__.py", line 111, in wraps return f(self, *args, **kwargs) File "/app/superset/views/base_api.py", line 119, in wraps duration, response = time_function(f, self, *args, **kwargs) File "/app/superset/utils/core.py", line 1364, in time_function response = func(*args, **kwargs) File "/app/superset/utils/log.py", line 303, in wrapper value = f(*args, **kwargs) File "/app/superset/datasource/api.py", line 120, in get_column_values payload = datasource.values_for_column( File "/app/superset/models/helpers.py", line 1372, in values_for_column df = pd.read_sql_query(sql=sql, con=engine) File "/app/venv/lib64/python3.9/site-packages/pandas/io/sql.py", line 469, in read_sql_query return pandas_sql.read_query( File "/app/venv/lib64/python3.9/site-packages/pandas/io/sql.py", line 1738, in read_query result = self.execute(sql, params) File "/app/venv/lib64/python3.9/site-packages/pandas/io/sql.py", line 1562, in execute return self.con.exec_driver_sql(sql, *args) File "/app/venv/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1770, in exec_driver_sql return self._exec_driver_sql( File "/app/venv/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1674, in _exec_driver_sql ret = self._execute_context( File "/app/venv/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1953, in _execute_context self._handle_dbapi_exception( File "/app/venv/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 2138, in _handle_dbapi_exception util.raise_(exc_info[1], with_traceback=exc_info[2]) File "/app/venv/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 211, in raise_ raise exception File "/app/venv/lib64/python3.9/site-packages/sqlalchemy/engine/base.py", line 1910, in _execute_context self.dialect.do_execute( File "/app/venv/lib64/python3.9/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute cursor.execute(statement, parameters) TypeError: dict is not a sequence ### Checklist - [x] I have searched Superset docs and Slack and didn't find a solution to my problem. - [x] I have searched the GitHub issue tracker and didn't find a similar bug report. - [x] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section. -- 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]
