You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT q1.repository_id, when_max, lines,
CASE WHEN when_max < DATE_SUB(NOW(), INTERVAL 3 MONTH) THEN 'unmaintained' ELSE 'maintained' END
FROM (
SELECT rc.repository_id, MAX(c.commit_author_when) AS when_max
FROM ref_commits rc
NATURAL JOIN commits c
WHERE rc.ref_name = 'HEAD'
GROUP BY rc.repository_id
) q1 JOIN (
SELECT rf.repository_id, SUM(ARRAY_LENGTH(SPLIT(f.blob_content, '\n'))-1) as lines
FROM refs rf
NATURAL JOIN commits c
NATURAL JOIN commit_files cf
NATURAL JOIN files f
WHERE rf.ref_name = 'HEAD'
AND f.file_path NOT REGEXP '^vendor.*'
AND NOT IS_BINARY(f.blob_content)
GROUP BY rf.repository_id
) q2 ON q1.repository_id = q2.repository_id
returns
unknown error: table "" does not have column "MAX(commits.commit_author_when)"
but it was working on v0.20-rc1.
The text was updated successfully, but these errors were encountered:
smacker
changed the title
table "" does not have column "MAX(commits.commit_author_when)"
regression: table "" does not have column "MAX(commits.commit_author_when)"
May 31, 2019
Query:
returns
but it was working on v0.20-rc1.
The text was updated successfully, but these errors were encountered: