Page MenuHomePhabricator

D9315.diff
No OneTemporary

D9315.diff

diff --git a/src/applications/diffusion/fact/PhabricatorFactLintEngine.php b/src/applications/diffusion/fact/PhabricatorFactLintEngine.php
--- a/src/applications/diffusion/fact/PhabricatorFactLintEngine.php
+++ b/src/applications/diffusion/fact/PhabricatorFactLintEngine.php
@@ -159,25 +159,22 @@
$raw_trends = queryfx_all(
$conn,
- 'SELECT stringA AS path, SUM(valueX) AS n
- FROM %T AS x
- WHERE factType = %s
- AND objectPHID = %s
- AND stringA IN (%Ls)
- AND epoch = (
- SELECT MAX(epoch)
- FROM %T AS a
- WHERE factType = %s
- AND objectPHID = %s
- AND a.stringA = x.stringA)
- GROUP BY path',
+ 'SELECT a.stringA AS path, a.valueX AS n
+ FROM %T AS a
+ INNER JOIN (
+ SELECT t.stringA, MAX(t.epoch) AS epoch
+ FROM %T AS t
+ WHERE t.factType = %s
+ AND t.objectPHID = %s
+ AND t.stringA IN (%Ls)
+ AND t.valueX != 0
+ GROUP BY t.stringA) AS x
+ ON x.stringA = a.stringA AND x.epoch = a.epoch',
$table_name,
- self::TYPE_LINT_COUNT_BY_PATH,
- $branch->getPHID(),
- $prefixed_paths,
$table_name,
self::TYPE_LINT_COUNT_BY_PATH,
- $branch->getPHID());
+ $branch->getPHID(),
+ $prefixed_paths);
$trends = array();
foreach ($raw_trends as $value) {

File Metadata

Mime Type
text/plain
Expires
Sun, Jun 9, 5:32 AM (3 w, 1 d ago)
Storage Engine
blob
Storage Format
Encrypted (AES-256-CBC)
Storage Handle
6275928
Default Alt Text
D9315.diff (1 KB)

Event Timeline