Omitted rows from result / results returned on error

[jonathanswenson]

What happens?

When I run the following query on duckdb shell, I get different results than when I run it in the CLI

with data as ( 
  select 2 as "col1" 
  union all 
  select 1 
  union all 
  select 0 
  union all 
  select -1
) select col1, ln(col1) from data;

In shell / wasm I get a result back, but for some reason it only has a single row and does not show any error

In the cli I get an error (I think that's what expected).

v0.8.2-dev1764 07b0b0a2a4
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
D with data as ( select 2 as "col1" union all select 1 union all select 0 union all select -1) select col1, ln(col1) from data;
Error: Out of Range Error: cannot take logarithm of zero

To Reproduce

with data as ( 
  select 2 as "col1" 
  union all 
  select 1 
  union all 
  select 0 
  union all 
  select -1
) select col1, ln(col1) from data;

Browser/Environment:

Chrome 114

Device:

Macbook Pro M1

DuckDB-Wasm Version:

v0.8.2-dev1585

DuckDB-Wasm Deployment:

shell.duckdb.org

Full Name:

Jonathan Swenson

Affiliation:

Omni

[carlopi]

Update: this now makes a bit more sense, see https://shell.duckdb.org/#queries=v0,with-data-as-(-%0A--select-2-as-%22col1%22-%0A--union-all-%0A--select-1-%0A--union-all-%0A--select-0-%0A--union-all-%0A--select-%201%0A)-select-col1%2C-ln(col1)-from-data~, where an empty result is shown instead of a broken ones.

Still is not ideal, we need to find where the ConversionErrors disappears.