diff options
author | mattpiwik <matthieu.aubry@gmail.com> | 2012-10-24 08:43:38 +0400 |
---|---|---|
committer | mattpiwik <matthieu.aubry@gmail.com> | 2012-10-24 08:43:38 +0400 |
commit | 438d64e01e9f385b29acd89da4debc705f1125a2 (patch) | |
tree | b1c1b1d6a3ffffc966405c44e6906bca1c5184d7 /core | |
parent | f27e248230999ef888f7b828d47a7854941b7e53 (diff) |
Fixes #3453 Compatibility with ANSI_QUOTES
If the ANSI_QUOTES SQL mode is enabled, string literals can be quoted only within single quotes because a string quoted within double quotes is interpreted as an identifier.
git-svn-id: http://dev.piwik.org/svn/trunk@7293 59fd770c-687e-43c8-a1e3-f5a4ff64c105
Diffstat (limited to 'core')
-rw-r--r-- | core/RankingQuery.php | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/core/RankingQuery.php b/core/RankingQuery.php index a743f898d3..df4ca44cf9 100644 --- a/core/RankingQuery.php +++ b/core/RankingQuery.php @@ -288,7 +288,7 @@ class Piwik_RankingQuery { $labelColumnsOthersSwitch[] = " CASE - WHEN counter = $limit THEN \"{$this->othersLabelValue}\" + WHEN counter = $limit THEN '".$this->othersLabelValue."' ELSE `$column` END AS `$column` "; @@ -351,7 +351,8 @@ class Piwik_RankingQuery FROM ( $withCounter ) AS withCounter GROUP BY $groupBy "; - + + var_dump($groupOthers); return $groupOthers; } |