SQL版产生重复ID

[ap0405140]

按 https://github.com/yitter/IdGenerator/blob/master/SQL/sqlserver.sql 的脚本创建函数, 测试产生有重复ID.
测试脚本如下:

-- 建测试表,并产生1000个ID
if object_id('tempdb..#r') is not null
drop table #r

create table #r
(
rn int identity(1,1) not null,
id bigint not null
)

set nocount on
declare @A int,@b int
select @A=1,@b=1000
while(@A<=@b)
begin
insert into #r(id)
select id=dbo.Fn_NextSnowId(rand())
select @A=@A+1
end
set nocount off

-- 结果有重复
select id,count(1)
from #r
group by id
having count(1)>1

[yitter]

SQL版本理论上会产生重复数，不要用于高并发生产环境