Philippe Chal�at wrote :

>Hello,

>I've a SQL script to initialize a schema. It's made of DROP TABLE + 
>CREATE TABLE + ALTER TABLE (for FK) + CREATE INDEX.

>If  I run the script twice, the kernel crashes during the drop table 
>sequence.

>If I remove the ALTER TABLE and CREATE INDEX sequence, the script can be 
>run many times without any problem.

>I can send some kernel trace, but I think the easiest way to understand 
>the problem is to reproduce with my script. I can send it directly by 
>mail (but I don't want to put it on the list).

>Thanks in advance

>Philippe

This is a bug in the drop table implementation. The problem may occur,
if a table contains many (more than 30) foreign key constraints.  
We will fix the bug as soon as possible with one of the
next versions.
Thanks to Philippe for the script reproducing the problem.

Thomas 

-- 
Thomas Anhaus
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general



--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to