db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "srgrocks " <mailsr...@rediffmail.com>
Subject Bug report for Apache Derby 10.4.x and onwards
Date Fri, 12 Aug 2011 09:41:51 GMT
Hello&nbsp; Apache Derby team , 

This is to bring to your kind attention the fact that Apache Derby 10.6.2.1 , the version
I am using is giving a error on using the ON UPDATE CASCADE statement .

Here is the SQL statement in Java DB 

create table "book"
(
Booking_ID varchar(255) primary key,
Customer_ID varchar(255) references "customer" ON UPDATE CASCADE ON DELETE CASCADE,
Hotel_ID varchar(255) references "hotel" ON UPDATE CASCADE ON DELETE CASCADE,
Date_Of_Booking varchar(255),
Check_In_Date varchar(255),
Check_Out_Date varchar(255),
No_Of_Rooms_Booked int ,
Total_Price varchar(255),
Status varchar(255)
)

The bug thrown is :

Error code -1, SQL state 42X01: Syntax error: Encountered "CASCADE" at line 4, column 58.
Line 1, column 1




Mime
View raw message