SPs do not get dropped properly
- Dominant language
- C
- Stars
- 1.5k
- Forks
- 243
- Avg merge
- 2d 2h
- Merged PRs (30d)
- 37
Description
```
nctdb> select count(*) from comdb2_procedures;
(count(*)=0)
[select count(*) from comdb2_procedures] rc 0
nctdb> create procedure proc {
...> local function main()
...> print('foo')
...> end
...> }$$
(version='1')
[create procedure proc {
local function main()
print('foo')
end
}] rc 0
nctdb> select * from comdb2_procedures;
(name='proc', version='1', client_versioned='N', default='Y', src='
local function main()
print('foo')
end
')
[select * from comdb2_procedures] rc 0
nctdb> create procedure proc {
...> local function main()
...> print('bar')
...> end
...> } $$
(version='2')
[create procedure proc {
local function main()
print('bar')
end
}] rc 0
nctdb> select * from comdb2_procedures;
(name='proc', version='1', client_versioned='N', default='Y', src='
local function main()
print('foo')
end
')
(name='proc', version='2', client_versioned='N', default='N', src='
local function main()
print('bar')
end
')
[select * from comdb2_procedures] rc 0
nctdb> drop procedure proc 2;
[drop procedure proc 2] rc 0
nctdb> drop procedure proc 1;
[drop procedure proc 1] rc 0
nctdb> select count(*) from comdb2_procedures;
(count(*)=1)
[select count(*) from comdb2_procedures] rc 0
nctdb> select * from comdb2_procedures;
(name='proc', version=NULL, client_versioned=NULL, default='N', src=NULL)
```
Contributor guide
Assessment
This issue has not been assessed yet.