(superset) 01/07: fix: Fixing incomplete string escaping. (#29772)

[michaelsmolina]

This is an automated email from the ASF dual-hosted git repository.

michaelsmolina pushed a commit to branch airbnb
in repository https://gitbox.apache.org/repos/asf/superset.git

commit bde69e4813c2cff758cce38f59d8469bfb5edb4a
Author: Evan Rusackas <e...@preset.io>
AuthorDate: Tue Jul 30 16:36:26 2024 -0600

    fix: Fixing incomplete string escaping.  (#29772)
    
    (cherry picked from commit 2bce20f790a31f3342bda61d830365e91e518fb3)
---
 superset-frontend/src/explore/exploreUtils/index.js | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/superset-frontend/src/explore/exploreUtils/index.js 
b/superset-frontend/src/explore/exploreUtils/index.js
index 4fc8147a18..f468854955 100644
--- a/superset-frontend/src/explore/exploreUtils/index.js
+++ b/superset-frontend/src/explore/exploreUtils/index.js
@@ -316,7 +316,7 @@ export const getSimpleSQLExpression = (subject, operator, 
comparator) => {
       .map(val => optionLabel(val))
       .map(
         val =>
-          `${quote}${isString ? String(val).replace("'", "''") : val}${quote}`,
+          `${quote}${isString ? String(val).replace(/'/g, "''") : 
val}${quote}`,
       );
     if (comparatorArray.length > 0) {
       expression += ` ${prefix}${formattedComparators.join(', ')}${suffix}`;