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

AV when both function and dependent table are dropped in the same transaction #8020

Closed
hvlad opened this issue Feb 27, 2024 · 3 comments
Closed

Comments

@hvlad
Copy link
Member

hvlad commented Feb 27, 2024

  1. create metadata and disconnect
set autoddl off;
set term ^;

create function f(x int)
  returns int
as
begin
  return x;
end
^
create table t_fn (x int, fx computed by (f(x)))
^
commit
^
set term ;^
exit;
  1. connect and drop objects
set autoddl off;
drop function f;
drop table t_fn;
commit;
@pavel-zotov
Copy link

Script shows on 6.0.0.269:

SQLSTATE = 39000 / unsuccessful metadata update / -DROP TABLE T_FN failed / -invalid request BLR at offset 1 / -function F is not defined

Is it expected ?

@hvlad
Copy link
Member Author

hvlad commented Feb 28, 2024

Script shows on 6.0.0.269:

SQLSTATE = 39000 / unsuccessful metadata update / -DROP TABLE T_FN failed / -invalid request BLR at offset 1 / -function F is not defined

Is it expected ?

See #8021.
This (#8020) issue was about AV.

@pavel-zotov
Copy link

QA issue: test need to be adjusted after #8021 will be fixed (DROP statements must be in DSQL form rather than be 'enclosed' in EB and begin/end with suppressing exceptions). See notes.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants