Crash on single-argument COALESCE

[alanpaulkwan]

I can PM someone the data. This is the valid query:

res=dbGetQuery(con,"select recipient_duns,count() as n_contracts,sum(coalesce(potential_total_value_of_award,0)) as award,
              max(action_date_fiscal_year) as year_max,
              min(action_date_fiscal_year) as year_min,
              sum(case when place_of_manufacture like '%OUTSIDE%U%S%' then 1 else 0 end) contracts_outside_usa,
              sum(case when place_of_manufacture like '%OUTSIDE%U%S%' then coalesce(potential_total_value_of_award,0) else 0 end) dollarval_contracts_outside_usa
           from parquet_scan('*201[5-9]*/*parquet') group by recipient_duns")

This is the errant query. It should just complain but rather R crashes giving me an option to core dump. The errant query is in the phrase coalesce(potential_total_value_of_award0) e.g. no comma

res=dbGetQuery(con,"select recipient_duns,count() as n_contracts,sum(coalesce(potential_total_value_of_award,0)) as award,
              max(action_date_fiscal_year) as year_max,
              min(action_date_fiscal_year) as year_min,
              sum(case when place_of_manufacture like '%OUTSIDE%U%S%' then 1 else 0 end) contracts_outside_usa,
              sum(case when place_of_manufacture like '%OUTSIDE%U%S%' then coalesce(potential_total_value_of_award0) else 0 end) dollarval_contracts_outside_usa
           from parquet_scan('*201[5-9]*/*parquet') group by recipient_duns")

[hannes]

Already seeing the issue on select coalesce(1), so no need to share the data for now

[hannes]

@alanpaulkwan can you please check and confirm if this is indeed fixed on master?

[alanpaulkwan]

@hannesmuehleisen i just installed the bleeding edge via R. It is not as select coalesce(1) just crashed everything.

[hannes]

@alanpaulkwan sorry I can't parse that sentence. If it still crashes please do share your files to hannes@cwi.nl

[alanpaulkwan]

Sorry, what I mean was: I just reinstalled the latest version via the install instructions on your DuckDB page. I get the below, which suggests it was not fixed, as of a rebuild I did yesterday per your request. Rebuilding again right now just to check.

[hannes]

This works fine for me, I suspect you still have an old version. Whats your output of dbGetQuery(con, "pragma version")? I get

  library_version source_id
1    0.2.4-dev103 5eff21830

[alanpaulkwan]

Works fine now!

…

On Tue, Dec 15, 2020 at 5:12 PM Hannes Mühleisen ***@***.***> wrote: This works fine for me, I suspect you still have an old version. Whats your output of dbGetQuery(con, "pragma version")? I get library_version source_id 1 0.2.4-dev103 5eff218 — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#1222 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AB7PRZBKRL23MMVFK5QQOULSU4SAJANCNFSM4UZJXYOA> .