-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
aaron@svn.wikimedia.org wrote:
$SQLqueries = array();// Redirect subqueries have an upper limit for perfomance.
Subqueries aren't supported by MySQL 4.0.
I've reverted SpecialWhatlinkshere.php to the pre-r35371 state so it works again on Wikimedia.
- -- brion vibber (brion @ wikimedia.org)
On Tue, May 27, 2008 at 4:18 PM, Brion Vibber brion@wikimedia.org wrote:
aaron@svn.wikimedia.org wrote:
$SQLqueries = array();// Redirect subqueries have an upper limit for perfomance.Subqueries aren't supported by MySQL 4.0.
I've reverted SpecialWhatlinkshere.php to the pre-r35371 state so it works again on Wikimedia.
I don't see any subqueries that this runs, only unions. I think that comment is using "subquery" loosely to mean "one of the queries in a union". The docs say that UNION is available beginning in MySQL 4.0.0. What query gave an error?
Well the query was on the merged UNION result, which makes it a subquery. I'll see if 4 supports more explicit temporary table syntax as a work around.
Simetrical-3 wrote:
On Tue, May 27, 2008 at 4:18 PM, Brion Vibber brion@wikimedia.org wrote:
aaron@svn.wikimedia.org wrote:
$SQLqueries = array();// Redirect subqueries have an upper limit for perfomance.Subqueries aren't supported by MySQL 4.0.
I've reverted SpecialWhatlinkshere.php to the pre-r35371 state so it works again on Wikimedia.
I don't see any subqueries that this runs, only unions. I think that comment is using "subquery" loosely to mean "one of the queries in a union". The docs say that UNION is available beginning in MySQL 4.0.0. What query gave an error?
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l
On Tue, May 27, 2008 at 7:42 PM, Voice of All jschulz_4587@msn.com wrote:
Well the query was on the merged UNION result, which makes it a subquery. I'll see if 4 supports more explicit temporary table syntax as a work around.
Ah, that's a pain, didn't realize you couldn't do that, but it makes sense, I guess. You can of course CREATE TEMPORARY TABLE, but I don't think that's replication-safe (because the table is lost if the slave crashes). Do we use temporary tables anywhere? If not, you could just do it on the app side, which is how I guess we do it now.
wikitech-l@lists.wikimedia.org