Vitor-Avila commented on PR #33542: URL: https://github.com/apache/superset/pull/33542#issuecomment-2923182197
Ok, it's not only with 1=1 -- just created a new RLS with `OrderID =101` and the same error happens: <img width="631" alt="image" src="https://github.com/user-attachments/assets/2f893c81-c62f-4326-8032-b0d9811aa723"; /> Full stack trace: ``` 2025-05-30 15:47:38,584:WARNING:superset.views.error_handling:SupersetErrorsException Traceback (most recent call last): File "/Users/vitoravila/.pyenv/versions/3.11.10/envs/superset-oss/lib/python3.11/site-packages/flask/app.py", line 1484, in full_dispatch_request rv = self.dispatch_request() ^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/vitoravila/.pyenv/versions/3.11.10/envs/superset-oss/lib/python3.11/site-packages/flask/app.py", line 1469, in dispatch_request return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/vitoravila/.pyenv/versions/3.11.10/envs/superset-oss/lib/python3.11/site-packages/flask_appbuilder/security/decorators.py", line 109, in wraps return f(self, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/vitoravila/code/superset/superset/views/base_api.py", line 120, in wraps duration, response = time_function(f, self, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/vitoravila/code/superset/superset/utils/core.py", line 1371, in time_function response = func(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^ File "/Users/vitoravila/code/superset/superset/views/base_api.py", line 92, in wraps return f(self, *args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/vitoravila/code/superset/superset/utils/log.py", line 304, in wrapper value = f(*args, **kwargs) ^^^^^^^^^^^^^^^^^^ File "/Users/vitoravila/code/superset/superset/sqllab/api.py", line 406, in execute_sql_query command_result: CommandResult = command.run() ^^^^^^^^^^^^^ File "/Users/vitoravila/code/superset/superset/utils/decorators.py", line 271, in wrapped return on_error(ex) ^^^^^^^^^^^^ File "/Users/vitoravila/code/superset/superset/utils/decorators.py", line 236, in on_error raise ex File "/Users/vitoravila/code/superset/superset/utils/decorators.py", line 264, in wrapped result = func(*args, **kwargs) ^^^^^^^^^^^^^^^^^^^^^ File "/Users/vitoravila/code/superset/superset/commands/sql_lab/execute.py", line 105, in run status = self._run_sql_json_exec_from_scratch() ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/vitoravila/code/superset/superset/commands/sql_lab/execute.py", line 158, in _run_sql_json_exec_from_scratch return self._sql_json_executor.execute( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/Users/vitoravila/code/superset/superset/sqllab/sql_json_executer.py", line 110, in execute raise SupersetErrorsException( superset.exceptions.SupersetErrorsException: [SupersetError(message='Boolean value of this clause is not defined', error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR: 'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, extra={'engine_name': 'Microsoft SQL Server', 'issue_codes': [{'code': 1002, 'message': 'Issue 1002 - The database returned an unexpected error.'}]})] 2025-05-30 15:47:38,586:INFO:werkzeug:127.0.0.1 - - [30/May/2025 15:47:38] "POST /api/v1/sqllab/execute/ HTTP/1.1" 500 - ``` Screenshot from `master`: <img width="809" alt="image" src="https://github.com/user-attachments/assets/b59562a7-6a0d-485c-bb4e-7f3ac4f0b95c"; /> -- 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]
