bloomberg / bloomberg/comdb2

SPs do not get dropped properly

Open
#786 1 comment 0 reactions 0 assignees View on GitHub
bug
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.