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-b...@kde.org
Reporter: juanjosemoralesar...@gmail.com
CC: a...@piggz.co.uk, in...@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 watching all bug changes.
