bugfix: index names overlapped with table names on MySQL import

martin-pabst · martin-pabst · commit 77d1b5eb31e3 · 2025-04-10T21:28:19.000+02:00
diff --git a/src/client/compiler/parser/Parser.ts b/src/client/compiler/parser/Parser.ts
@@ -845,7 +845,7 @@ export class Parser {
 
         let index = { index_name: "", column: "", unique: unique }
         if (this.tt == TokenType.identifier) {
-            index.index_name = <string>this.cct.value;
+            index.index_name = <string>this.cct.value + '_idx';
             this.nextToken();
         } else {
             this.pushError("Erwartet wird der Bezeichner des Index.");
diff --git a/src/client/tools/MySqlImporter.ts b/src/client/tools/MySqlImporter.ts
@@ -162,7 +162,7 @@ export class MySqlImporter {
                             unique: index.unique,
                             position: null, endPosition: null, symbolTable: null
                         },
-                        sql: `create ${index.unique ? 'unique ' : ''} index ${index.index_name} on ${tmn.tableIdentifier}(${index.column});`,
+                        sql: `create ${index.unique ? 'unique ' : ''}index ${index.index_name} on ${tmn.tableIdentifier}(${index.column});`,
                         resultTypes: []
                     })
                 }

Original file line number	Diff line number	Diff line change
`@@ -162,7 +162,7 @@ export class MySqlImporter {`
`162`	`162`	`unique: index.unique,`
`163`	`163`	`position: null, endPosition: null, symbolTable: null`
`164`	`164`	`},`
`165`		- sql: `create ${index.unique ? 'unique ' : ''} index ${index.index_name} on ${tmn.tableIdentifier}(${index.column});`,
	`165`	+ sql: `create ${index.unique ? 'unique ' : ''}index ${index.index_name} on ${tmn.tableIdentifier}(${index.column});`,
`166`	`166`	`resultTypes: []`
`167`	`167`	`})`
`168`	`168`	`}`