List:MaxDB« Previous MessageNext Message »
From:Lukasz Misztal Date:June 21 2007 7:48am
Subject:Constraint & Alter Table on VarChar Field
View as plain text  
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)




Thread
Constraint & Alter Table on VarChar FieldLukasz Misztal21 Jun
  • RE: Constraint & Alter Table on VarChar FieldThomas Anhaus21 Jun
    • SQL Studio and lowercase name of objectsLukasz Misztal21 Jun
      • AW: SQL Studio and lowercase name of objectsWolfgang Auer21 Jun