Hi, While testing migration I found out that items deleted in BASE1 are migrated to BASE2. As I understand from documentation, BASE1 doesn't delete items from the database unless purgeDatabase.php script is executed. They are just flagged as deleted by setting remove value=2 (or > 1 maybe). Those that have removed flag set to 1 are marked for deletion (something equivalent to moving to trashcan). Other items have removed=0.
Migration code uses ResultSet.getBoolean() method to retrieve 'removed' value (which is smallint) and as I checked, it returns true only when removed==1. The consequence is that items marked for deletion go to trashcan as they suppose to, but those actually deleted get removed flag set to false and appear in BASE2 as not deleted. This could be due to postgres JDBC driver handling type mapping in different way than mysql driver, but I couldn't find any information on that. The quick solution is to run purgeDatabase.php before migration to remove deleted items from the database. All the best, Pawel ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ basedb-devel mailing list basedb-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/basedb-devel
