unable to cast <nil> of type <nil> to float64

[ajnavarro]

This error is happening on this query:

SELECT
    added,
    deleted,
    commit_author_when,
    commit_hash,
    repository_id,
    CASE WHEN deleted < (added+deleted)*0.1 THEN 'Added' WHEN added < (added+deleted)*0.1 THEN 'Deleted' ELSE 'Changed' END AS commit_type
FROM (
        SELECT 
            JSON_EXTRACT(stats, "$.Total.Additions") as added,  
            JSON_EXTRACT(stats, "$.Total.Deletions") as deleted, 
            commit_author_when, 
            commit_hash,
            repository_id
        FROM (
            SELECT 
                repository_id,
                commit_author_when,
                commit_hash,
                commit_stats(repository_id, commit_hash) as stats 
            FROM refs 
            natural join ref_commits 
            natural join commits 
            --where refs.ref_name="HEAD"
        ) q
) q2;

[erizocosmico]

Can't reproduce on master, can you provide a list of repositories to reproduces this?

[ajnavarro]

I was able to reproduce the error with a simpler query: SELECT (NULL+1)