Mark comments

Results 600 comments of


                                            Mark

rows_update() gives incorrect results

I cannot reproduce either of these problems on the latest master using only the provided SQL scripts. Are you running this on an older version? This works fine for me:...

File used by another process on Tableau (cannot open file)

@tiagokepe could you have a look?

INTERVAL type missing in ListVector::Search

Thanks for the report! I think it would make sense to rework the interval type to remove the interval physical type entirely, and instead store it as `STRUCT(months INTEGER, days...

Distinct stat is not written to parquet metadata

We could likely set it for dictionary-encoded string columns, since we know the distinct count from the dictionary.

Python client: parameters in group by result in an error

Thanks for the report! That is not a bug but expected behavior. The `?` parameter gets replaced by `$X` where `X` is the number encountered in the SELECT statement, so...

Python client: parameters in group by result in an error

Postgres throws the exact same error on this query: ```sql myth=# prepare v1 as select date_part($1, dt), count(*) from test group by date_part($2, dt); ERROR: column "test.dt" must appear in...

Support UNION BY NAME

Interesting, I have looked around a bit but could not find any good reference on this. Do you have any more info you could provide about the `CORRESPONDING BY` clause?

Fix parameter binding for arrow results

@krlmlr could you perhaps have a look?

C++ API does not work

As what encoding are you saving the file? DuckDB expects UTF8 encoded strings.

Floating point errors with unselected rows and IN operand order

Thanks for the report! It is indeed a bit odd that the results are different in these situations, but standard floating point summation is very fickle with regards to numerical...