fix: MySQL does not support DROP INDEX IF EXISTS syntax

YassinNouh21 · YassinNouh21 · commit bcaa701e7381 · 2026-04-07T11:10:19.000+02:00
Use try/except instead since the index may not exist when dropping
versioned tables discovered from information_schema.

Signed-off-by: yassinnouh21 &lt;yassinnouh21@gmail.com&gt;
diff --git a/sdk/python/feast/infra/online_stores/mysql_online_store/mysql.py b/sdk/python/feast/infra/online_stores/mysql_online_store/mysql.py
@@ -323,7 +323,10 @@ def _drop_all_version_tables(cur: Cursor, project: str, table: FeatureView) -> N
         (base, f"^{base}_v[0-9]+$"),
     )
     for (name,) in cur.fetchall():
-        cur.execute(f"DROP INDEX IF EXISTS {name}_ek ON {name};")
+        try:
+            cur.execute(f"DROP INDEX {name}_ek ON {name};")
+        except Exception:
+            pass
         cur.execute(f"DROP TABLE IF EXISTS {name}")
 
 
