Description:
The option seems to have no effect, if I understand what it should do correctly. After choosing the option and continuing through the synhronisation wizard, the "preview of the SQL that will be created" continues to show me the schema name in the generated SQL.
How to repeat:
Create or import a project, set a schema name. Click:
Database » Synchronize model » Set parameters for connecting to DBMS » Set options for synchronisation Script
Tick the "Omit Schema qualifier in object names" option
Proceed through the wizard to the "Preview Database Changes to be Applied" page.
The schema name is still in the generated SQL, for example:
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
CREATE TABLE IF NOT EXISTS `sys`.`agence` (
`id_agence` INT(11) NOT NULL AUTO_INCREMENT,
`reference` VARCHAR(45) NULL DEFAULT NULL,
`date_creation` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
`nom_agence` VARCHAR(45) NULL DEFAULT NULL,
`adresse` VARCHAR(45) NULL DEFAULT NULL,
`compte_agence` INT(11) NULL DEFAULT NULL,
PRIMARY KEY (`id_agence`),
UNIQUE INDEX `reference_UNIQUE` (`reference` ASC) VISIBLE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb4
COLLATE = utf8mb4_0900_ai_ci;
