Bug #54507 AUTO_INCREMENT =

• Submitted: 15 Jun 2010 8:41
• Modified: 18 Jun 2010 7:55
• Reporter: Dima Popov
• Status: Duplicate
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: 5.2.22
• OS: Windows (XP)
• CPU Architecture: Any
• Tags: AUTO_INCREMENT =

[15 Jun 2010 8:41] Dima Popov

Description:
AUTO_INCREMENT =  ;

How to repeat:
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='TRADITIONAL';
ALTER TABLE `forcombase`.`city` AUTO_INCREMENT =  ;
ALTER TABLE `forcombase`.`client` AUTO_INCREMENT =  ;
ALTER TABLE `forcombase`.`departament` AUTO_INCREMENT =  ;

[15 Jun 2010 8:49] Valeriy Kravchuk

Please, provide problematic .mwb file or give some details on what to do to see the problem.

[15 Jun 2010 10:08] Valeriy Kravchuk

What exact change should I make in the model before syncronization? What version of MySQL server are you working with?

[15 Jun 2010 10:22] Dima Popov

Server MySQL 5.1.46. Создайте базу данных из этой схемы, добавьте данные в любую таблицу "city" или любую другую, потом сделайте синхронизацию, появится ошибка

Executing SQL script in server

ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

ALTER TABLE `forcombase`.`city` AUTO_INCREMENT =  
SQL script execution finished: statements: 3 succeeded, 1 failed

[15 Jun 2010 13:57] MySQL Verification Team

I only got the below error:

Executing SQL script in server

ERROR: Error 1305: FUNCTION forcombase.Order_Number does not exist

<cut>

SQL script execution finished: statements: 54 succeeded, 1 failed

[16 Jun 2010 3:54] Dima Popov

Надо сначало добавлять Procedure а потом View... Так как сам Workbench непонимает что доложно добавляться первым. Не проводится анализ кода на порядок добавления.

[17 Jun 2010 7:15] Sveta Smirnova

Thank you for the feedback.

Please use English for all communication in the bugs database: users and developers are from different countries and only few of the understand Russian.

Translation of the last comment:

You should add Procedure first, then View. Because Workbench itself does not understand what should be added first: no code analysis for order of how objects should be placed done.

[18 Jun 2010 7:55] Mike Lischke

Duplicate of Bug #54319