[Bug 27659] USE INDEX is inserted in the wrong place when left joining in other tables

2012-11-11 Thread bugzilla-daemon 
https://bugzilla.wikimedia.org/show_bug.cgi?id=27659

duplicate...@googlemail.com changed:

   What|Removed |Added

 CC||duplicate...@googlemail.com

--- Comment #2 from duplicate...@googlemail.com 2012-11-11 11:32:06 UTC ---
Sounds like bug 22613

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

[Bug 27659] USE INDEX is inserted in the wrong place when left joining in other tables

2011-02-23 Thread bugzilla-daemon 
https://bugzilla.wikimedia.org/show_bug.cgi?id=27659

--- Comment #1 from Reedy  2011-02-23 13:01:54 UTC ---
if ( !empty( $conds ) ) {
if ( is_array( $conds ) ) {
$conds = $this->makeList( $conds, LIST_AND );
}
$sql = "SELECT $startOpts $vars $from $useIndex WHERE $conds
$preLimitTail";
} else {
$sql = "SELECT $startOpts $vars $from $useIndex $preLimitTail";
}

$from is only right when not LEFT JOIN'ing in tables

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
You are on the CC list for the bug.

___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l