[kexi] [Bug 365469] New: When I try to create a simple table fail for SQL syntaxys error.

[Juan José Morales via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=365469

            Bug ID: 365469
           Summary: When I try to create a simple table fail for SQL
                    syntaxys error.
           Product: kexi
           Version: 2.9.7
          Platform: Ubuntu Packages
                OS: Linux
            Status: UNCONFIRMED
          Severity: major
          Priority: NOR
         Component: KexiDB
          Assignee: kexi-bugs at kde.org
          Reporter: juanjosemoralesarias at gmail.com
                CC: adam at piggz.co.uk, inksi at fables.co.za

When I try to create a new database with some fields it fail for sql syntax.

allo al guardar la definición del objeto.
La creación de la tabla falló. Error durante la ejecución de una declaración
SQL. 
Mensaje del servidor: 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
'UNSIGNED(255) UNIQUE NOT NULL, `name` VARCHAR(255), last_name VARCHAR(255),
birt' at line 1
Sentencia SQL: CREATE TABLE users (id2 INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
id INT UNSIGNED UNIQUE NOT NULL, document_type VARCHAR(255), document VARCHAR
UNSIGNED(255) UNIQUE NOT NULL, `name` VARCHAR(255), last_name VARCHAR(255),
birth DATE, description VARCHAR(255))
Resultado del servidor: 1064

Reproducible: Always

Steps to Reproduce:
1.Create a new project with a local MySql  server
2. Create a simple table with many field including number, text, date and a
primary key
3. try to save it

Actual Results:  
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 'UNSIGNED(255) UNIQUE NOT
NULL, `name` VARCHAR(255), last_name VARCHAR(255), birt' at line 1

Expected Results:  
Table created sucefull

-- 
You are receiving this mail because:
You are the assignee for the bug.