Bug #1155

schema-export.php can't export constraint 'ON DELETE CASCADE'

Added by Dong Ma over 1 year ago. Updated 10 months ago.

Status:Closed Start date:02/20/2012
Priority:Normal Due date:
Assignee:Mark Donohoe % Done:

0%
Category:DataBase
Target version:2.1.0
Rank: Tester:

Description

On a running system, use schema-export.php -f new-schema.dat
Compare with src/www/ui/core-schema.dat, the 'ON DELETE CASCADE' constraint removed from new-schema.dat

History

#1
Updated by Bob Gobeille over 1 year ago

  • Status changed from New to Resolved

fixed in svn 5566

#2
Updated by larry shi about 1 year ago

  • Status changed from Resolved to Feedback

On a running system, use schema-export -f new-schema.dat
Compare with src/www/ui/core-schema.dat, lots of difference from new-schema.dat,
anyone know how to messure if this defect is fixed?

#3
Updated by Bob Gobeille about 1 year ago

The defect was that 'ON DELETE CASCADE' was not showing up in new-schema.dat.
If you do a schema-export today you will see that it does show up now.

#4
Updated by larry shi about 1 year ago

  • Status changed from Feedback to Resolved

fixed it svn 5744

still one difference, but I think both are correct, so did not do any change.

< $Schema["VIEW"]["uploadtree_tag_file_inner"] = "CREATE VIEW \"uploadtree_tag_file_inner\" AS
SELECT uploadtree.ufile_mode, uploadtree.ufile_name, uploadtree.uploadtree_pk, uploadtree.lft, uploadtree.rgt, uploadtree.parent, uploadtree.pfile_fk, uploadtree.upload_fk, tag_file.tag_file_pk, tag_file.tag_file_date, tag_file.tag_file_text, tag_file.tag_fk FROM (uploadtree JOIN tag_file ON ((uploadtree.pfile_fk = tag_file.pfile_fk)));";
---

$Schema["VIEW"]["uploadtree_tag_file_inner"] = "CREATE VIEW \"uploadtree_tag_file_inner\" AS SELECT uploadtree.pfile_fk, uploadtree.uploadtree_pk, uploadtree.parent, uploadtree.upload_fk, uploadtree.ufile_mode, uploadtree.lft, uploadtree.rgt, uploadtree.ufile_name, tag_file.tag_file_pk, tag_file.tag_fk, tag_file.tag_file_date, tag_file.tag_file_text FROM (uploadtree JOIN tag_file USING (pfile_fk));";

#5
Updated by larry shi about 1 year ago

  • Status changed from Resolved to In Progress

I reverted svn 5744, the new check in is svn 5755, so I say this issue is not fixed.

#6
Updated by larry shi about 1 year ago

  • Status changed from In Progress to Closed

verified in 5756, this defect is fixed.

also svn 5730 fix http://www.fossology.org/issues/1389
the Change tag.tag from character to character varying

#7
Updated by Mary Laser 10 months ago

  • Target version changed from 2.0.1 to 2.1.0

Also available in: Atom PDF