[Digikam-devel] [digikam] [Bug 325655] MIGRATION : after MySQL to Sqlite database conversion, random tags are assigned to new images
    via KDE Bugzilla 
    bugzilla_noreply at kde.org
       
    Thu Jul 21 18:31:37 BST 2016
    
    
  
https://bugs.kde.org/show_bug.cgi?id=325655
--- Comment #5 from swatilodha27 at gmail.com ---
Thomas,
Foreign key constraint is now in DB schema (Current version 5.0.0), as a result
DB can't contain tags for non existing images.So,  I was unable to reproduce
this issue. 
Also, I used the SQL query to verify the same:
//
MariaDB [digikam]> select count(*) from ImageTags Left Join Images on
imageid=id where id is Null;
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.01 sec)
//
The result was 0 even for ImageMetadata and ImageInformation tables.
Please try with the recent version again, and report updates if any.
-- 
You are receiving this mail because:
You are the assignee for the bug.
    
    
More information about the Digikam-devel
mailing list