Comment 11 for bug 1689253

Revision history for this message
Cedato Ops (cedato) wrote :

it looks like symbols ? cause to mess things ...

see an example, i replaced inappropriate valued insert to ? and put ? in quotes.

MariaDB [vrtb]> EXPLAIN SELECT /*nibble boundary 0*/ `day`,`playerid`,`subid`,`vastid`,`domain`,`requests`,`impressions`,`imptime`,`completed`,`errors`,`rev`,`loadreqs`,`loaded`,`actualrequests`,`firstquarter`,`midpoint`,`thirdquarter`,`click`,`viewable`,`mouse_event`,`custom1`,`custom2` FROM `vrtb`.`playerVastsStatsByDomain` FORCE INDEX (`PRIMARY`) WHERE (((`day` > '20170507') OR (`day` = '20170507' AND `playerid` > '547781985') OR (`day` = '20170507' AND `playerid` = '547781985' AND `subid` > 'http://anything2mp3.com/batch?op=start&id=250351607') OR (`day` = '547781985' AND `playerid` = 'http://anything2mp3.com/batch?op=start&id=250351607' AND `subid` = '20170507' AND `vastid` > '547781985') OR (`day` = 'http://anything2mp3.com/batch?op=start&id=250351607' AND `playerid` = '$$custom_param_esc(pageurl)$$' AND `subid` = '?' AND `vastid` = '?' AND `domain` >= '?')) AND ((`day` < '20170507') OR (`day` = '20170507' AND `playerid` < '547781985') OR (`day` = '20170507' AND `playerid` = '547781985' AND `subid` < 'http://anything2mp3.com/batch?op=start&id=250360017') OR (`day` = '547781985' AND `playerid` = 'http://anything2mp3.com/batch?op=start&id=250360017' AND `subid` = '20170507' AND `vastid` < '547781985') OR (`day` = 'http://anything2mp3.com/batch?op=start&id=250360017' AND `playerid` = '$$custom_param_esc(pageurl)$$' AND `subid` = '?' AND `vastid` = '?' AND `domain` <= '?'))) ORDER BY `day`,`playerid`,`subid`,`vastid`,`domain` LIMIT 99999, 1;
+------+-------------+--------------------------+-------+---------------+---------+---------+------+-------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+--------------------------+-------+---------------+---------+---------+------+-------+-------------+
| 1 | SIMPLE | playerVastsStatsByDomain | range | PRIMARY | PRIMARY | 270 | NULL | 17393 | Using where |
+------+-------------+--------------------------+-------+---------------+---------+---------+------+-------+-------------+