duckdb-r icon indicating copy to clipboard operation
duckdb-r copied to clipboard

handle data frames with 0 columns in `rel_from_df()`

Open romainfrancois opened this issue 9 months ago • 3 comments

related to https://github.com/hannes/duckdb-rfuns/pull/91#discussion_r1592100105

romainfrancois avatar May 07 '24 16:05 romainfrancois

Thanks, seems like we have to revisit the question of whether we want to allow zero-column result sets, as I recall last time we discussed this we decided not to have those but circumstances may have changed.

hannes avatar May 08 '24 07:05 hannes

Found this document I wrote when we first encountered the question.

https://docs.google.com/document/d/1oKaCP62b8tjkOooX7rNUVGwF3waM3PhBMzuB-PLxqtc/edit?usp=sharing

It seems like for aggregations with no groups, results are inconsistent between DuckDB/sqlite and dplyr

Tmonster avatar May 08 '24 08:05 Tmonster

Thanks, Tom. Aggregation with no groups is different, this is about data frames without columns.

krlmlr avatar May 08 '24 11:05 krlmlr