index with schema

chartdb · Sep 7, 2024 · 1810d60 · 1810d60
1 parent aeb3096
commit 1810d60
Showing 1 changed file with 8 additions and 3 deletions.
diff --git a/src/lib/domain/db-table.ts b/src/lib/domain/db-table.ts
@@ -60,9 +60,14 @@ export const createTablesFromMetadata = ({
             (pk) => pk.table === tableInfo.table
         );
 
-        const tableIndexes = indexes.filter(
-            (idx) => idx.table === tableInfo.table
-        );
+        const tableIndexes = indexes.filter((idx) => {
+            const indexSchema =
+                (idx.schema ?? '').trim() === '' ? undefined : idx.schema;
+            return (
+                idx.table === tableInfo.table &&
+                indexSchema === tableInfo.schema
+            );
+        });
 
         const fields: DBField[] = sortedColumns.map(
             (col: ColumnInfo): DBField => ({