Níže uvedený script způsobí na MSSQL 2017 havárii a odpojení klienta.

-- Verze MSSQL

Microsoft SQL Server 2017 (RTM-CU31-OD) (KB5050533) - 14.0.3490.10 (X64)

Feb 19 2025 12:19:28 

Copyright (C) 2017 Microsoft Corporation

Standard Edition (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: ) (Hypervisor)

-- T-SQL script

create table TEST(

         uid smallint not null

        ,klic_volbahodn int not null

        ,ps_md money not null

        ,ps_dal money not null

        ,castka_md money not null

        ,castka_dal money not null)

go

insert TEST(uid, klic_volbahodn, ps_md, ps_dal, castka_md, castka_dal) select 1,28862,9560,0,0,0

insert TEST(uid, klic_volbahodn, ps_md, ps_dal, castka_md, castka_dal) select 1,28863,0,0,1433360.9700,1433360.9700

insert TEST(uid, klic_volbahodn, ps_md, ps_dal, castka_md, castka_dal) select 7,28862,9560,0,0,0

insert TEST(uid, klic_volbahodn, ps_md, ps_dal, castka_md, castka_dal) select 7,28863,0,0,1433360.9700,1433360.9700

go

select GL.uid

    ,rok_md = GL.castka_md - GL.ps_md

   ,rok_dal = GL.castka_dal - GL.ps_dal

from TEST GL

go

-- Result

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).

Server: Msg 11, Level 16, State 1, Line 0

Došlo k obecné chybě sítě. Informace naleznete v dokumentaci k síti.