Fix avg(), total(), count() default value on empty set

penberg / limbo

Limbo is a work-in-progress, in-process OLTP database management system, compatible with SQLite.

MIT License

896 stars 49 forks source link

Fix avg(), total(), count() default value on empty set #120

Closed benclmnt closed 1 month ago

benclmnt commented 1 month ago

Closes #118

Ramkarthik commented 1 month ago

Thank you, @benclmnt. This fixes #118 except the compatibility with SQLite for the sum, min, max, and avg functions which outputs blank instead of NULL. @penberg can confirm if we want to handle that as part of this PR.

penberg commented 1 month ago

@Ramkarthik Let's just fix it incrementally.