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

Variables inside DO block not detected #549

Open
timvandam opened this issue Nov 17, 2023 · 0 comments
Open

Variables inside DO block not detected #549

timvandam opened this issue Nov 17, 2023 · 0 comments
Labels
bug Something isn't working

Comments

@timvandam
Copy link

timvandam commented Nov 17, 2023

Describe the bug
Variables inside of DO blocks (psql) are not detected, but it does compile just fine.

Expected behavior
It should give the correct type for the query by detecting the variable

Test case

/* @name createNamedSequenceIfNotExists */
DO LANGUAGE plpgsql $$
BEGIN
    EXECUTE FORMAT('CREATE SEQUENCE IF NOT EXISTS %I', :sequenceName!);
END;
$$;

It generates the type

export type ICreateNamedSequenceIfNotExistsParams = void;
@timvandam timvandam added the bug Something isn't working label Nov 17, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant