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

Case Statement in postgresql not supported #267

Open
erwin-frohsinn opened this issue Jul 7, 2024 · 0 comments
Open

Case Statement in postgresql not supported #267

erwin-frohsinn opened this issue Jul 7, 2024 · 0 comments

Comments

@erwin-frohsinn
Copy link

Describe the bug
The following is not parsed. Seems that the "case" statement is not supported.

create table pole.t_spiel (
    id               varchar(10)               not null
        constraint t_spiel_pk
            primary key,
    v_id             varchar(10) generated always as (
        CASE
            WHEN ((id)::text ~ '^\d+$'::text) THEN (lpad((id)::text, 2, '0'::text))::character varying
            ELSE id
            END) stored
);

To Reproduce
Steps to reproduce the behavior:
Parse with simple_ddl_parser

Desktop (please complete the following information):

  • OS: Kubuntu
  • Python 3.12
  • Postgres
@erwin-frohsinn erwin-frohsinn changed the title Case Satement in postgresql not supported Case Statement in postgresql not supported Jul 7, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant