diff options
author | mattab <matthieu.aubry@gmail.com> | 2016-02-13 13:58:44 +0300 |
---|---|---|
committer | mattab <matthieu.aubry@gmail.com> | 2016-02-13 13:58:44 +0300 |
commit | 055839d047c1d0b3ba36a5447e40ebee507a0b74 (patch) | |
tree | 60bf3e8788ef406575d768e213f1fe1b49c68f13 /plugins/Live/tests/Integration | |
parent | 5164862249eaf7af69f0ca6470d4f5e42784725b (diff) |
Apply offset and limit correctly to the Visitor Log SQL queries
Diffstat (limited to 'plugins/Live/tests/Integration')
-rw-r--r-- | plugins/Live/tests/Integration/ModelTest.php | 9 |
1 files changed, 4 insertions, 5 deletions
diff --git a/plugins/Live/tests/Integration/ModelTest.php b/plugins/Live/tests/Integration/ModelTest.php index 355f1fb777..828d3865f0 100644 --- a/plugins/Live/tests/Integration/ModelTest.php +++ b/plugins/Live/tests/Integration/ModelTest.php @@ -53,7 +53,7 @@ class ModelTest extends IntegrationTestCase AND log_visit.visit_last_action_time >= ? AND log_visit.visit_last_action_time <= ? ORDER BY idsite, visit_last_action_time DESC - LIMIT 100 + LIMIT 0, 100 ) AS sub GROUP BY sub.idvisit ORDER BY sub.visit_last_action_time DESC @@ -93,7 +93,7 @@ class ModelTest extends IntegrationTestCase AND log_visit.visit_last_action_time >= ? AND log_visit.visit_last_action_time <= ? ORDER BY visit_last_action_time DESC - LIMIT 100 + LIMIT 0, 100 ) AS sub GROUP BY sub.idvisit ORDER BY sub.visit_last_action_time DESC @@ -154,7 +154,7 @@ class ModelTest extends IntegrationTestCase $period = 'month', $date = '2010-01-01', $segment = 'customVariablePageName1==Test', - $offset = 0, + $offset = 10, $limit = 100, $visitorId = 'abc', $minTimestamp = false, @@ -175,10 +175,9 @@ class ModelTest extends IntegrationTestCase AND log_visit.visit_last_action_time <= ? ) AND ( log_link_visit_action.custom_var_k1 = ? ) ORDER BY idsite, visit_last_action_time DESC - LIMIT 100 + LIMIT 10, 100 ) AS log_inner ORDER BY idsite, visit_last_action_time DESC - LIMIT 100 ) AS sub GROUP BY sub.idvisit ORDER BY sub.visit_last_action_time DESC |