Hello,
I'm using MaxDB 7.5.00.15 on fedora core 2. There is constraint defined for
one table (see below).
Sometimes, when I insert values into this table (via JDBC prepared
statement), I get error 300. What is interesting, that most often insert
statements work OK, but sometimes this constraint stops insertion. I'm sure,
that data is OK (program is checking this before insertion).
Regards,
Donatas
------------------------------------------------------------
CREATE TABLE "ADMIN"."KORTELE"
(
"K_ID" Integer NOT NULL,
"K_NR" Integer NOT NULL,
"K_DATA" Date NOT NULL,
...
"K_DARBU_ATLIKIMO_METAI" Smallint NOT NULL,
...
PRIMARY KEY ("K_ID"),
CONSTRAINT "CNSTR_DARBU_ATLIKIMO_METAI" CHECK
"K_DARBU_ATLIKIMO_METAI" = YEAR(K_DATA),
...
)
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
