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

Markus Krötzsch <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|ASSIGNED                    |RESOLVED
         Resolution|                            |FIXED

--- Comment #11 from Markus Krötzsch <[email protected]> 2010-05-27 
14:03:08 UTC ---
The proposed query did not work in MySQL, since it does not include
smw_tmp_unusedprops in the USING part. Trying to find a query that works in
either case, I came up with the following:

DELETE FROM smw_tmp_unusedprops
 USING smw_tmp_unusedprops INNER JOIN smw_rels2 INNER JOIN smw_ids
 ON p_id=smw_id AND title=smw_title AND smw_iw='';

I hope this still works on Postgres (if not, please re-open the bug).

The next SMW release 1.5.1 that will include this change is scheduled for
Monday, May 31.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to