<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">No, it's not a bug. Here are 2 outputs from the same search at different starts: </p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;"><span style="font-family:Monospace;">MariaDB [digikam]> SELECT * FROM ImageSimilarity;</span></p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">+----------+----------+-----------+--------------------+</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| imageid1 | imageid2 | algorithm | value |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">+----------+----------+-----------+--------------------+</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92937 | 92938 | 1 | 0.7276767902341286 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92908 | 92928 | 1 | 0.7030320169782883 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92931 | 92932 | 1 | 0.8336685456455954 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92933 | 92934 | 1 | 0.6706040721483033 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92900 | 92913 | 1 | 0.7505396291793182 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92905 | 92915 | 1 | 0.7405491284049031 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92904 | 92905 | 1 | 0.7127389155463217 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92907 | 92908 | 1 | 0.8155335605445546 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92909 | 92910 | 1 | 0.7758440327474614 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92899 | 92900 | 1 | 0.6565841722229999 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">+----------+----------+-----------+--------------------+</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">10 rows in set (0.001 sec)</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">MariaDB [digikam]> SELECT * FROM ImageSimilarity;</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">+----------+----------+-----------+--------------------+</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| imageid1 | imageid2 | algorithm | value |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">+----------+----------+-----------+--------------------+</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92905 | 92915 | 1 | 0.7405491284049031 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92900 | 92913 | 1 | 0.7505396291793182 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92908 | 92927 | 1 | 0.669382620559168 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92927 | 92928 | 1 | 0.732409125233628 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92899 | 92903 | 1 | 0.6504303766351522 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92909 | 92910 | 1 | 0.7560619468353904 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92907 | 92908 | 1 | 0.8155335605445546 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92904 | 92905 | 1 | 0.7127389155463217 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92934 | 92935 | 1 | 0.671921833944039 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92933 | 92934 | 1 | 0.6706040721483033 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92931 | 92932 | 1 | 0.8449821703465952 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">| 92937 | 92938 | 1 | 0.7095138493232303 |</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">+----------+----------+-----------+--------------------+</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">12 rows in set (0.000 sec)</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Although the 2nd output has 2 more lines, there are no Image IDs that are not also present in the first output, some are now duplicates because of a different order compared to other pairs formed.</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">There is a different order not only because of the QSet, but would also arise if you were to rename images. All results are in the range of 65%-100%. </p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Maik</p>
<br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Am Sonntag, 23. Januar 2022, 13:51:27 CET schrieb digikam-users.johnny1000@spamgourmet.com:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Thank you Maik for taking the time :o)</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Is it a bug then, so I should open a bug report?</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> I think I understand most of what you explain about QSet, since I know</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> sets from Python, and they too are unordered and use hashes for their</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> internal logistics.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> The difference between GUI and database is a different matter, but it's</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> a waste of time to go further into that if the behaviour I see is simply</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> a bug :o)</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Best regards :o)</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Johnny :o)</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> Den 22.01.2022 kl. 15.44 skrev Maik Qualmann - metzpinguin@gmail.com:</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > Well, the result you see in the GUI certainly won't differ. The entries</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > you</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > see in the ImageSimilarity table are not the complete end result.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > Why are there different entries in this table? We use a QSet to store the</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > image IDs. QSet is unordered and uses a hash to store the information.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > Therefore, the order of the image IDs in the QSet is never the same across</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > program starts. This results in the fact that the same images are never</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > always compared with one another. This can result in additional entries</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > in the table, but they have the same search range. The end result is</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > always the same.</p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > </p>
<p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">> > Maik</p>
<br /><br /></body>
</html>