From: Lukasz Misztal (miszlukgmail.com)
Date: Thu Jun 21 2007 - 02:48:00 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]