8000 sqlsmith: add support for PLpgSQL to query generator · Issue #106368 · cockroachdb/cockroach · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
sqlsmith: add support for PLpgSQL to query generator #106368
Open
@DrewKimball

Description

@DrewKimball

We should add PLpgSQL support to our randomized testing suite to increase coverage.

Feature checklist:

  • Blocks
  • Declarations
  • Return statements
  • If / ElsIf / Else statements
  • Null statements
  • Assign statements
  • Inline SQL statements
  • For (int) loops
  • CALL statements
  • Exceptions
  • SELECT / RETURNING INTO syntax

  • Cursor declarations
  • Cursor open/fetch/close
  • Case statements
  • (While) Loops
  • For (query) loops
  • Exit/Continue
  • Raise statements
  • Assert statements
  • Return Next/Query
  • PERFORM syntax
  • Get diagnostics
  • Commit/Rollback
  • Dynamic SQL execution
  • RECORD types

Note that some of these features are not yet implemented in PL/pgSQL - see also #117744.

Jira issue: CRDB-29534
Epic: CRDB-34182

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-plpgsqlPL/pgSQL languageA-sql-udfC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)T-sql-queriesSQL Queries Team

    Type

    No type

    Projects

    Status

    25.3 Release

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      0