Hello  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





Treat yourself at a restaurant, spa, resort and much more with Rediff Deal ho jaye!