Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

information_schema.tables missing last_altered column #134

Open
DanCardin opened this issue Sep 3, 2024 · 1 comment
Open

information_schema.tables missing last_altered column #134

DanCardin opened this issue Sep 3, 2024 · 1 comment

Comments

@DanCardin
Copy link
Contributor

I eluded to this issue in #122 (comment), but not all of duckdb's exactly match snowflakes.

Now, at least, I actually have a concrete location in which it negatively affects my ability to test 😆, i.e. information_schema.tables's missing last_altered column.

My first thoughts would be:

  • I assume we can't mutate the duckdb information_schema
  • if this is something you want to support fixing, I could attempt creating a _fs_information_schema with at least a view pointing at the original with the missing column
    • Seems impractical to actually support the semantics behind, for example, that column(?)
  • Search every query for table references and swap any that point at information_schema to the new schema?
    • or perhaps just .tables in the short term, since it would otherwise require stubs for every information_schema table, not sure off the top of my head how many there are
@tekumara
Copy link
Owner

tekumara commented Sep 3, 2024

Yes that makes sense and follows the exisiting pattern 😊

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants