After an error with the DuckDB backend, TidierDB is unable to proceed even when fixing the error

[kdheepak]

I have code that works:

But when I cause an error:

And after causing an error when I revert back to the code that works, it still continues to fail with the same old error:

Here's a video of that in action:

julia-tidierdata-error.mov

It continues to work if I recreate the connection and table.

[drizk1]

So as far as the table goes, **tables (sorry for the initial misspelling) are stored as mutable structs.

So after you save the table, you need to use t(table_name) starting to change. Otherwise you will alter the underlying struct.

Resave the table and then as long as you refer to it with @chain DB.t(table) rest of code this should fix this issue where it will no longer happen if you make changes and rerun w new edits

[kdheepak]

That resolves this thank you!