Hi,
i try execute (example) SQL statement:
CREATE TABLE "TableT1"
(
"MT_ID" Fixed (10,0) NOT NULL DEFAULT SERIAL (1),
"MT_Name" Varchar (200) UNICODE NOT NULL,
"MT_Value" Fixed (15,5) NOT NULL DEFAULT 1.00000,
PRIMARY KEY ("MT_ID"),
CONSTRAINT "CS_Value" CHECK "MT_Value" <> 0
)
//
ALTER TABLE "TableT1" MODIFY ("MT_Name" VARCHAR (60) UNICODE)
//
ALTER TABLE "TableT1" MODIFY ("MT_Name" VARCHAR (80) UNICODE)
//
drop table "TableT1"
and I get error:
Auto Commit: On, SQL Mode: Internal, Isolation Level: Serializable
Syntax error or access violation;-3014 POS(2) Invalid end of SQL statement
Question is:
1. why constraint prevents from second alter table?
2. why MT_Value (not "MT_Value") works fine?
It is a bug?
Best regards,
Lukasz
Tested on:
MAXDB 7.6.00.34, WIN XP Prof,
MAXDB 7.6.00.37, WIN XP Prof,
SQL Studio 7.6.00.27 (123692)
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
