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.

Sign up for GitHub

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

Jump to bottom

sql: consider allowing referencing temp tables in routines #121375

Open
yuzefovich opened this issue Mar 29, 2024 · 0 comments
Open

sql: consider allowing referencing temp tables in routines #121375

yuzefovich opened this issue Mar 29, 2024 · 0 comments
Labels
A-sql-pgcompat Semantic compatibility with PostgreSQL A-sql-routine UDFs and Stored Procedures C-cleanup Tech debt, refactors, loose ends, etc. Solution not expected to significantly change behavior. docs-done docs-known-limitation T-sql-queries SQL Queries Team

Comments

@yuzefovich
Copy link
Member

yuzefovich commented Mar 29, 2024 •
edited
Loading

We currently prohibit creation of routines that reference temporary tables which Postgres allows. This restriction is the reason for several tests skipped in pgjdbc roachtest (5 in ProcedureTransactionTest and 33 in Jdbc3CallableStatementTest).

Jira issue: CRDB-37216
@yuzefovich yuzefovich added C-cleanup Tech debt, refactors, loose ends, etc. Solution not expected to significantly change behavior. T-sql-queries SQL Queries Team A-sql-routine UDFs and Stored Procedures labels Mar 29, 2024
@github-project-automation github-project-automation bot moved this to Triage in SQL Queries Mar 29, 2024
@yuzefovich yuzefovich added the A-sql-pgcompat Semantic compatibility with PostgreSQL label Mar 29, 2024
@yuzefovich yuzefovich mentioned this issue Mar 29, 2024
Closed
@yuzefovich yuzefovich moved this from Triage to New Backlog in SQL Queries Apr 2, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
A-sql-pgcompat Semantic compatibility with PostgreSQL A-sql-routine UDFs and Stored Procedures C-cleanup Tech debt, refactors, loose ends, etc. Solution not expected to significantly change behavior. docs-done docs-known-limitation T-sql-queries SQL Queries Team
Projects
SQL Queries
Status: Backlog
Milestone
No milestone
Development

No branches or pull requests
2 participants
@yuzefovich @taroface