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

the from clause of as changelog does not support fully qualified path #18747

Open
ly9chee opened this issue Sep 27, 2024 · 0 comments
Open

the from clause of as changelog does not support fully qualified path #18747

ly9chee opened this issue Sep 27, 2024 · 0 comments
Labels
type/bug Something isn't working
Milestone

Comments

@ly9chee
Copy link
Contributor

ly9chee commented Sep 27, 2024

Describe the bug

create table public.t1 (
    id bigint primary key,
    value text
);

create materialized view public.mv1 as
with sub as changelog from public.t1
select
    *
from sub;

[2024-09-27 17:07:06] [XX000] ERROR: Failed to prepare the statement
[2024-09-27 17:07:06] Caused by:
[2024-09-27 17:07:06] sql parser error: expected SELECT, VALUES, or a subquery in the query body, found: .
[2024-09-27 17:07:06] LINE 2: with sub as changelog from public.t1
[2024-09-27 17:07:06] ^

but bellow will work

create materialized view public.mv1 as
with sub as changelog from t1
select
    *
from sub;

this requires that the t1 must be in the search_path

Error message/log

No response

To Reproduce

No response

Expected behavior

No response

How did you deploy RisingWave?

No response

The version of RisingWave

PostgreSQL 13.14.0-RisingWave-2.0.1 (83e9be4)

Additional context

No response

@ly9chee ly9chee added the type/bug Something isn't working label Sep 27, 2024
@github-actions github-actions bot added this to the release-2.1 milestone Sep 27, 2024
yihong0618 added a commit to yihong0618/risingwave that referenced this issue Oct 2, 2024
Close issue risingwavelabs#18747 by using ObjectName for table instead of Ident.

Signed-off-by: yihong0618 <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant