Skip to content
New issue

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

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

Already on GitHub? Sign in to your account

Improve error msg when an INSERT INTO ... SELECT ... uses a source #26990

Open
ggevay opened this issue May 8, 2024 · 0 comments
Open

Improve error msg when an INSERT INTO ... SELECT ... uses a source #26990

ggevay opened this issue May 8, 2024 · 0 comments
Labels
A-ADAPTER Topics related to the ADAPTER layer

Comments

@ggevay
Copy link
Contributor

ggevay commented May 8, 2024

It's not allowed for an INSERT INTO ... SELECT ... to (transitively) refer to any sources. The error msg is currently:

Error: invalid selection: operation may only refer to user-defined tables

It would be good to clarify:

  • This is a limitation of INSERT INTO ... SELECT ... queries. (and maybe other similar things, e.g., some UPDATE?)
  • Which are the problematic objects.
  • The operation may only refer to user-defined tables is not so clear: it's actually ok to refer to views, mat views, etc., but the final transitive dependencies at the end are what count.

A confused user:
https://materializeinc.slack.com/archives/C053EPHMU05/p1715181840656969?thread_ts=1715181618.113209&cid=C053EPHMU05

@ggevay ggevay added the A-ADAPTER Topics related to the ADAPTER layer label May 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-ADAPTER Topics related to the ADAPTER layer
Projects
None yet
Development

No branches or pull requests

1 participant