????? ????????? ?????? ??? ?????? FIX: ???? ???? ????? ???? ?????? ????? ????? ??? ?????

?????? ????????? ?????? ?????????
???? ???????: 288957 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 236595 (SHILOH_BUGS)
????? ???? | ?? ????

?? ??? ??????

???????

?? ???? SQL Server ?????? ????? ??? ????? ??????? ????????? ??? ????? ???? ?????? ???????:
  • ????? ????????? ??? ????? ?? ???? ?? ????? ??? ???? ???????.
  • ?????? ??? ??????? ????????? ?????? ?????? ??? ??????? ?? ??????? ??? ???? ?????? ?? ??? ???????? (UDF).
  • ????? ????????? ??? UDF ??? ????? ?????.
  • ???? UDF ????? ?? ???? ?? ???????? ???????? ???? ???? ?????? ????? ??? ???? ??? ???????? ???????.

?????

????? ???? ???????? ????? ?? ??????? ????????? ????? ?? ????????? ???? ??? ??? ???? ??????? ????? ??? ??? ?????. ??? ??? ????????? ???????? ?? ??? ?? ???????? ???????? ???????? ???? ?? ??? ??????? ??? UDF ?????? ?? ???? ??? ???? ??????? ????? ??????.

????

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? Microsoft SQL Server 2000. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
290211INF: ????? ?????? ??? ???? ???? ???? ??????? SQL Server 2000

?????????

??????: ?? ?????? ?? ??????? ?????? ?????? ??? ??? Microsoft SQL Server 2000 Service Pack 1.

??? ?? ???? ?????? ?????????? ?? ??? ??????? ???? ??????? ??????? ?? ????:
   Version      File name       Platform
   -------------------------------------

   8.00.251     s80251i.exe     x86

				

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ????? ??? ???????. ?? ????? ??? ??????? ???? ??? ?? Microsoft SQL Server 2000 Service Pack 1.

??????? ????

???? ?????? ?????? ???????.

CREATE TABLE functest (c1 int NULL, c2 int NULL, c3 int NULL,
 c4 int NULL, c5 int NULL, c6 int NULL)
GO
INSERT INTO functest VALUES(1,2,3,4,5,6)
go
CREATE FUNCTION t3 (@one int, @two int, @three int) RETURNS int AS
BEGIN
  RETURN (@one*@two*@three)
END
GO
--This works correctly, returns 720
SELECT avg(dbo.t3(c1,c2,c3)) * avg(dbo.t3(c4,c5,c6)) correct FROM functest
go
--This is incorrect, returns 36, should be 180
SELECT avg(dbo.t3(c1,c2,c3)) * avg(dbo.t3(c1,c5,c6)) incorrect FROM functest
go
--If you swap c1 and c6, the results are correct! (180)
SELECT avg(dbo.t3(c1,c2,c3)) * avg(dbo.t3(c6,c5,c1)) correct FROM functest
				
???? ????? ??? ????? ??? ????? ??? ??? ??? ??? ????? UDF ????? ??????? ?????? ??? ??? ??? ???? ?? ?????? ??????? ??? ??????.

???????

???? ???????: 288957 - ????? ??? ??????: 12/?????/1424 - ??????: 3.1
????? ???
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbbug kbfix kbqfe kbsqlserv2000sp1fix KB288957 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????288957

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com