This is an automated email from the ASF dual-hosted git repository. beto pushed a commit to branch fix-values-for-column in repository https://gitbox.apache.org/repos/asf/superset.git
commit 345dde099f497ac87e7a983ba9dcd8042fa5d94c Author: Beto Dealmeida <[email protected]> AuthorDate: Mon Apr 29 17:25:04 2024 -0400 fix: % replace in values_for_column --- superset/models/helpers.py | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/superset/models/helpers.py b/superset/models/helpers.py index 4165f874a0..2aa0845572 100644 --- a/superset/models/helpers.py +++ b/superset/models/helpers.py @@ -1381,6 +1381,10 @@ class ExploreMixin: # pylint: disable=too-many-public-methods sql = self._apply_cte(sql, cte) sql = self.database.mutate_sql_based_on_config(sql) + # pylint: disable=protected-access + if engine.dialect.identifier_preparer._double_percents: + sql = sql.replace("%%", "%") + df = pd.read_sql_query(sql=sql, con=engine) # replace NaN with None to ensure it can be serialized to JSON df = df.replace({np.nan: None})
