https://bugzilla.wikimedia.org/show_bug.cgi?id=45129

       Web browser: ---
            Bug ID: 45129
           Summary: SMWSQLStore3Readers::fetchSemanticData() should in
                    fact use DISTINCT for blobs
           Product: MediaWiki extensions
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: Unprioritized
         Component: Semantic MediaWiki
          Assignee: [email protected]
          Reporter: [email protected]
                CC: [email protected], [email protected],
                    [email protected], [email protected]
    Classification: Unclassified
   Mobile Platform: ---

Hi,

There has been an issue with Semantic Forms and SQLStore3 since SQLStore3 was
first released: in autocompletion, some values show up multiple times. (This
may also happen for dropdowns and other input types; I'm not sure.) I finally
looked into this today, and figured out the issue: on line 314 of
includes/storage/SQLStore/SMW_SQLStore3_Readers.php, there's the following:

                        // Don't use DISTINCT with text blobs:
                        if ( $typeid == 'l' ) $usedistinct = false;

I don't know who exactly introduced this line, since it looks like it was there
since the SQLStore3 code was first added (though Markus added the comment
line). But I would recommend to either remove it, or have it only called if
$object is null - either way would fix the problem.

-Yaron

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to