Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 CROSS APPLY on single UDF causes severe error

Author  Topic 

acd
Starting Member

6 Posts
Posted - 2009-09-29 : 07:34:16
Following sql causes very ugly error on my sql machine. Is there any fix for that. My sql server is Sql Server 2005 SP3


	drop FUNCTION Crash_A 
	GO 
	create FUNCTION Crash_A() 
	RETURNS int --type used doesnt vary
	AS 
	BEGIN 
	  RETURN 0 
	END 
	GO 

	select 
	  * -- error 
	from 
	( 
	  select a = dbo.Crash_A() 
	) at 
	cross apply 
	( 
	  select 
		  x = a -- this works fine
		  --,r = isnull(a,a) -- causes error 
		  ,r = a+a -- causes error 
		  --,r = a+0 -- causes error 
	) rt



result: 


	Msg 0, Level 11, State 0, Line 0
	A severe error occurred on the current command. The results, if any, should be discarded.
	Msg 0, Level 20, State 0, Line 0
	A severe error occurred on the current command. The results, if any, should be discarded.


sql server log last message:

Date 2009-09-29 13:28:38
Log SQL Server (Current - 2009-09-29 13:28:00)

Source Server

Message
A user request from the session with SPID 56 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.


sql server log all related entries:


	Date,Source,Severity,Message
	09/29/2009 13:28:38,Server,Unknown,A user request from the session with SPID 56 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
	09/29/2009 13:28:38,Server,Unknown,Error: 17310<c/> Severity: 20<c/> State: 1.
	09/29/2009 13:28:38,spid56,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
	09/29/2009 13:28:36,spid56,Unknown,Stack Signature for the dump is 0xFA20AE4C
	09/29/2009 13:28:36,spid56,Unknown,78132A47 Module(MSVCR80+00002A47)
	09/29/2009 13:28:36,spid56,Unknown,781329BB Module(MSVCR80+000029BB)
	09/29/2009 13:28:36,spid56,Unknown,010DACF1 Module(sqlservr+000DACF1)
	09/29/2009 13:28:36,spid56,Unknown,010DAB54 Module(sqlservr+000DAB54)
	09/29/2009 13:28:36,spid56,Unknown,010DAE8C Module(sqlservr+000DAE8C)
	09/29/2009 13:28:36,spid56,Unknown,010DAF6C Module(sqlservr+000DAF6C)
	09/29/2009 13:28:36,spid56,Unknown,01006609 Module(sqlservr+00006609)
	09/29/2009 13:28:36,spid56,Unknown,010068F9 Module(sqlservr+000068F9)
	09/29/2009 13:28:36,spid56,Unknown,010067D3 Module(sqlservr+000067D3)
	09/29/2009 13:28:36,spid56,Unknown,01040EC3 Module(sqlservr+00040EC3)
	09/29/2009 13:28:36,spid56,Unknown,010411FB Module(sqlservr+000411FB)
	09/29/2009 13:28:36,spid56,Unknown,010228AE Module(sqlservr+000228AE)
	09/29/2009 13:28:36,spid56,Unknown,01375B48 Module(sqlservr+00375B48)
	09/29/2009 13:28:36,spid56,Unknown,01434208 Module(sqlservr+00434208)
	09/29/2009 13:28:36,spid56,Unknown,01375499 Module(sqlservr+00375499)
	09/29/2009 13:28:36,spid56,Unknown,01374C69 Module(sqlservr+00374C69)
	09/29/2009 13:28:36,spid56,Unknown,0137DB41 Module(sqlservr+0037DB41)
	09/29/2009 13:28:36,spid56,Unknown,0137D64D Module(sqlservr+0037D64D)
	09/29/2009 13:28:36,spid56,Unknown,011AB689 Module(sqlservr+001AB689)
	09/29/2009 13:28:36,spid56,Unknown,01376554 Module(sqlservr+00376554)
	09/29/2009 13:28:36,spid56,Unknown,01378278 Module(sqlservr+00378278)
	09/29/2009 13:28:36,spid56,Unknown,01445598 Module(sqlservr+00445598)
	09/29/2009 13:28:36,spid56,Unknown,010E8166 Module(sqlservr+000E8166)
	09/29/2009 13:28:36,spid56,Unknown,01378278 Module(sqlservr+00378278)
	09/29/2009 13:28:36,spid56,Unknown,013764F5 Module(sqlservr+003764F5)
	09/29/2009 13:28:36,spid56,Unknown,011ABBB7 Module(sqlservr+001ABBB7)
	09/29/2009 13:28:36,spid56,Unknown,* Short Stack Dump
	09/29/2009 13:28:36,spid56,Unknown,* -------------------------------------------------------------------------------
	09/29/2009 13:28:36,spid56,Unknown,* *******************************************************************************
	09/29/2009 13:28:36,spid56,Unknown,*      SegSs: 00000023:
	09/29/2009 13:28:36,spid56,Unknown,*        Esp: 63F3F248:  118E8178  118E8168  0F554430  00000000  63F3F2F0  013764F5
	09/29/2009 13:28:36,spid56,Unknown,*     EFlags: 00010206:  006F0050  006E0069  00650074  00490072  0044006E  006C0065
	09/29/2009 13:28:36,spid56,Unknown,*      SegCs: 0000001B:
	09/29/2009 13:28:36,spid56,Unknown,*        Ebp: 63F3F258:  63F3F2F0  013764F5  00000000  118E8178  118B7390  63F3F598
	09/29/2009 13:28:36,spid56,Unknown,*        Eip: 011ABBB7:  B8910489  00000001  12430166  5F0C4301  E58B5B5E  0010C25D
	09/29/2009 13:28:36,spid56,Unknown,*        Edx: 00000000:
	09/29/2009 13:28:36,spid56,Unknown,*        Ecx: 00000000:
	09/29/2009 13:28:36,spid56,Unknown,*        Ebx: 0F554430:  0137492C  0F555FF0  00580200  00000002  00000004  0F5544E0
	09/29/2009 13:28:36,spid56,Unknown,*        Eax: 0000000C:
	09/29/2009 13:28:36,spid56,Unknown,*        Esi: 0F554508:  010304FE  FFFFFFE8  00000003  00000000  00000000  00000000
	09/29/2009 13:28:36,spid56,Unknown,*        Edi: 00000003:
	09/29/2009 13:28:36,spid56,Unknown,*
	09/29/2009 13:28:36,spid56,Unknown,* dbghelp                        6BEC0000  6BFD4FFF  00115000
	09/29/2009 13:28:36,spid56,Unknown,* msmdsrv                        6AA30000  6AAC2FFF  00093000
	09/29/2009 13:28:36,spid56,Unknown,* msxml6                         6A2D0000  6A41CFFF  0014d000
	09/29/2009 13:28:36,spid56,Unknown,* mlang                          6A190000  6A222FFF  00093000
	09/29/2009 13:28:36,spid56,Unknown,* XMLRWBIN                       78BA0000  78BBFFFF  00020000
	09/29/2009 13:28:36,spid56,Unknown,* XMLRW                          78B50000  78B79FFF  0002a000
	09/29/2009 13:28:36,spid56,Unknown,* WINHTTP                        67F30000  67F8CFFF  0005d000
	09/29/2009 13:28:36,spid56,Unknown,* msolap90                       67AF0000  67F20FFF  00431000
	09/29/2009 13:28:36,spid56,Unknown,* comsvcs                        677A0000  678E4FFF  00145000
	09/29/2009 13:28:36,spid56,Unknown,* OLEDB32R                       67780000  67790FFF  00011000
	09/29/2009 13:28:36,spid56,Unknown,* MSDART                         63770000  63789FFF  0001a000
	09/29/2009 13:28:36,spid56,Unknown,* oledb32                        67580000  675F8FFF  00079000
	09/29/2009 13:28:36,spid56,Unknown,* System.Configuration           67480000  674EBFFF  0006c000
	09/29/2009 13:28:36,spid56,Unknown,* System.Xml                     67230000  67427FFF  001f8000
	09/29/2009 13:28:36,spid56,Unknown,* System.Security                671A0000  671E1FFF  00042000
	09/29/2009 13:28:36,spid56,Unknown,* System                         66E90000  67193FFF  00304000
	09/29/2009 13:28:36,spid56,Unknown,* System.Security.ni             67920000  679C8FFF  000a9000
	09/29/2009 13:28:36,spid56,Unknown,* System.Transactions            67AA0000  67AE2FFF  00043000
	09/29/2009 13:28:36,spid56,Unknown,* System.ni                      7A440000  7ABC4FFF  00785000
	09/29/2009 13:28:36,spid56,Unknown,* System.Data                    665E0000  668B3FFF  002d4000
	09/29/2009 13:28:36,spid56,Unknown,* mscorjit                       79060000  790BAFFF  0005b000
	09/29/2009 13:28:36,spid56,Unknown,* SqlAccess                      65ED0000  65F25FFF  00056000
	09/29/2009 13:28:36,spid56,Unknown,* SensApi                        65BC0000  65BC4FFF  00005000
	09/29/2009 13:28:36,spid56,Unknown,* cryptnet                       65BA0000  65BB1FFF  00012000
	09/29/2009 13:28:36,spid56,Unknown,* mscorsec                       65B70000  65B82FFF  00013000
	09/29/2009 13:28:36,spid56,Unknown,* mscorlib.ni                    790C0000  79BB6FFF  00af7000
	09/29/2009 13:28:36,spid56,Unknown,* mscorwks                       79E70000  7A3FFFFF  00590000
	09/29/2009 13:28:36,spid56,Unknown,* xplog70                        63E20000  63E22FFF  00003000
	09/29/2009 13:28:36,spid56,Unknown,* xplog70                        63E00000  63E0BFFF  0000c000
	09/29/2009 13:28:36,spid56,Unknown,* xpstar90                       63DD0000  63DF5FFF  00026000
	09/29/2009 13:28:36,spid56,Unknown,* odbcint                        63DB0000  63DC6FFF  00017000
	09/29/2009 13:28:36,spid56,Unknown,* ATL80                          7C630000  7C64AFFF  0001b000
	09/29/2009 13:28:36,spid56,Unknown,* BatchParser90                  63C80000  63C9EFFF  0001f000
	09/29/2009 13:28:36,spid56,Unknown,* ODBC32                         63C40000  63C7CFFF  0003d000
	09/29/2009 13:28:36,spid56,Unknown,* SQLSCM90                       63C20000  63C28FFF  00009000
	09/29/2009 13:28:36,spid56,Unknown,* xpstar90                       63BC0000  63C0AFFF  0004b000
	09/29/2009 13:28:36,spid56,Unknown,* xpsqlbot                       63BA0000  63BA5FFF  00006000
	09/29/2009 13:28:36,spid56,Unknown,* msftepxy                       63650000  63664FFF  00015000
	09/29/2009 13:28:36,spid56,Unknown,* SQLNCLIR                       00870000  008A2FFF  00033000
	09/29/2009 13:28:36,spid56,Unknown,* comdlg32                       762B0000  762F8FFF  00049000
	09/29/2009 13:28:36,spid56,Unknown,* COMCTL32                       77530000  775C6FFF  00097000
	09/29/2009 13:28:36,spid56,Unknown,* sqlncli                        63220000  63446FFF  00227000
	09/29/2009 13:28:36,spid56,Unknown,* CLBCatQ                        777B0000  77832FFF  00083000
	09/29/2009 13:28:36,spid56,Unknown,* xpsp2res                       62F50000  63214FFF  002c5000
	09/29/2009 13:28:36,spid56,Unknown,* ntdsapi                        766F0000  76703FFF  00014000
	09/29/2009 13:28:36,spid56,Unknown,* SAMLIB                         7E020000  7E02EFFF  0000f000
	09/29/2009 13:28:36,spid56,Unknown,* NTMARTA                        77E00000  77E20FFF  00021000
	09/29/2009 13:28:36,spid56,Unknown,* wshtcpip                       71AE0000  71AE7FFF  00008000
	09/29/2009 13:28:36,spid56,Unknown,* hnetcfg                        62EF0000  62F49FFF  0005a000
	09/29/2009 13:28:36,spid56,Unknown,* dssenh                         68100000  68126FFF  00027000
	09/29/2009 13:28:36,spid56,Unknown,* comctl32                       77420000  77522FFF  00103000
	09/29/2009 13:28:36,spid56,Unknown,* SHLWAPI                        77DA0000  77DF1FFF  00052000
	09/29/2009 13:28:36,spid56,Unknown,* SHELL32                        7C8D0000  7D0CEFFF  007ff000
	09/29/2009 13:28:36,spid56,Unknown,* imagehlp                       76C10000  76C37FFF  00028000
	09/29/2009 13:28:36,spid56,Unknown,* WINTRUST                       76BB0000  76BDAFFF  0002b000
	09/29/2009 13:28:36,spid56,Unknown,* dbghelp                        62B70000  62C84FFF  00115000
	09/29/2009 13:28:36,spid56,Unknown,* msfte                          62910000  62B68FFF  00259000
	09/29/2009 13:28:36,spid56,Unknown,* security                       622A0000  622A3FFF  00004000
	09/29/2009 13:28:36,spid56,Unknown,* rasadhlp                       76F80000  76F84FFF  00005000
	09/29/2009 13:28:36,spid56,Unknown,* WLDAP32                        76F10000  76F3DFFF  0002e000
	09/29/2009 13:28:36,spid56,Unknown,* winrnr                         76F70000  76F76FFF  00007000
	09/29/2009 13:28:36,spid56,Unknown,* DNSAPI                         76ED0000  76EF9FFF  0002a000
	09/29/2009 13:28:36,spid56,Unknown,* mswsock                        71B20000  71B60FFF  00041000
	09/29/2009 13:28:36,spid56,Unknown,* RESUTILS                       74EF0000  74F02FFF  00013000
	09/29/2009 13:28:36,spid56,Unknown,* CLUSAPI                        74DE0000  74DF1FFF  00012000
	09/29/2009 13:28:36,spid56,Unknown,* WSOCK32                        71BB0000  71BB8FFF  00009000
	09/29/2009 13:28:36,spid56,Unknown,* VERSION                        77B90000  77B97FFF  00008000
	09/29/2009 13:28:36,spid56,Unknown,* MTXCLU                         74F40000  74F58FFF  00019000
	09/29/2009 13:28:36,spid56,Unknown,* msvcp60                        61E00000  61E64FFF  00065000
	09/29/2009 13:28:36,spid56,Unknown,* OLEAUT32                       77D00000  77D8AFFF  0008b000
	09/29/2009 13:28:36,spid56,Unknown,* MSDTCPRX                       61D80000  61DF8FFF  00079000
	09/29/2009 13:28:36,spid56,Unknown,* XOLEHLP                        61D70000  61D75FFF  00006000
	09/29/2009 13:28:36,spid56,Unknown,* COMRES                         77010000  770D5FFF  000c6000
	09/29/2009 13:28:36,spid56,Unknown,* CRYPT32                        761B0000  76242FFF  00093000
	09/29/2009 13:28:36,spid56,Unknown,* schannel                       76750000  76777FFF  00028000
	09/29/2009 13:28:36,spid56,Unknown,* MSASN1                         76190000  761A1FFF  00012000
	09/29/2009 13:28:36,spid56,Unknown,* kerberos                       61CC0000  61D18FFF  00059000
	09/29/2009 13:28:36,spid56,Unknown,* iphlpapi                       76CF0000  76D09FFF  0001a000
	09/29/2009 13:28:36,spid56,Unknown,* WS2HELP                        71BF0000  71BF7FFF  00008000
	09/29/2009 13:28:36,spid56,Unknown,* WS2_32                         71C00000  71C16FFF  00017000
	09/29/2009 13:28:36,spid56,Unknown,* cryptdll                       766E0000  766EBFFF  0000c000
	09/29/2009 13:28:36,spid56,Unknown,* msv1_0                         76C90000  76CB7FFF  00028000
	09/29/2009 13:28:36,spid56,Unknown,* ole32                          77670000  777A8FFF  00139000
	09/29/2009 13:28:36,spid56,Unknown,* MSCOREE                        79000000  79045FFF  00046000
	09/29/2009 13:28:36,spid56,Unknown,* AUTHZ                          76C40000  76C53FFF  00014000
	09/29/2009 13:28:36,spid56,Unknown,* rsaenh                         68000000  68034FFF  00035000
	09/29/2009 13:28:36,spid56,Unknown,* sqlevn70                       4F610000  4F7B8FFF  001a9000
	09/29/2009 13:28:36,spid56,Unknown,* instapi                        48060000  48069FFF  0000a000
	09/29/2009 13:28:36,spid56,Unknown,* psapi                          76B70000  76B7AFFF  0000b000
	09/29/2009 13:28:36,spid56,Unknown,* USP10                          75490000  754F4FFF  00065000
	09/29/2009 13:28:36,spid56,Unknown,* LPK                            7F000000  7F008FFF  00009000
	09/29/2009 13:28:36,spid56,Unknown,* IMM32                          76290000  762ACFFF  0001d000
	09/29/2009 13:28:36,spid56,Unknown,* NETAPI32                       71C40000  71C96FFF  00057000
	09/29/2009 13:28:36,spid56,Unknown,* opends60                       333E0000  333E6FFF  00007000
	09/29/2009 13:28:36,spid56,Unknown,* WINMM                          76AA0000  76ACCFFF  0002d000
	09/29/2009 13:28:36,spid56,Unknown,* GDI32                          77C00000  77C48FFF  00049000
	09/29/2009 13:28:36,spid56,Unknown,* USER32                         77380000  77410FFF  00091000
	09/29/2009 13:28:36,spid56,Unknown,* USERENV                        76920000  769E1FFF  000c2000
	09/29/2009 13:28:36,spid56,Unknown,* sqlos                          344D0000  344D4FFF  00005000
	09/29/2009 13:28:36,spid56,Unknown,* Secur32                        76F50000  76F62FFF  00013000
	09/29/2009 13:28:36,spid56,Unknown,* RPCRT4                         77C50000  77CEEFFF  0009f000
	09/29/2009 13:28:36,spid56,Unknown,* ADVAPI32                       7D1E0000  7D27BFFF  0009c000
	09/29/2009 13:28:36,spid56,Unknown,* MSVCP80                        7C420000  7C4A6FFF  00087000
	09/29/2009 13:28:36,spid56,Unknown,* msvcrt                         77BA0000  77BF9FFF  0005a000
	09/29/2009 13:28:36,spid56,Unknown,* MSVCR80                        78130000  781CAFFF  0009b000
	09/29/2009 13:28:36,spid56,Unknown,* kernel32                       77E40000  77F41FFF  00102000
	09/29/2009 13:28:36,spid56,Unknown,* ntdll                          7C800000  7C8C1FFF  000c2000
	09/29/2009 13:28:36,spid56,Unknown,* sqlservr                       01000000  02C1FFFF  01c20000
	09/29/2009 13:28:36,spid56,Unknown,*  MODULE                          BASE      END       SIZE
	09/29/2009 13:28:36,spid56,Unknown,*
	09/29/2009 13:28:36,spid56,Unknown,*
	09/29/2009 13:28:36,spid56,Unknown,*  --<c/>r = a+0 -- causes error  ) rt
	09/29/2009 13:28:36,spid56,Unknown,*  <c/>r = isnull(a<c/>a) -- causes error        <c/>r = a+a -- causes error
	09/29/2009 13:28:36,spid56,Unknown,*  ) at  cross apply  (    select        x = a -- this works fine        --
	09/29/2009 13:28:36,spid56,Unknown,*               select    * -- error  from  (    select a = dbo.Crash_A()
	09/29/2009 13:28:36,spid56,Unknown,* Input Buffer 498 bytes -
	09/29/2009 13:28:36,spid56,Unknown,*   Access Violation occurred writing address 00000000
	09/29/2009 13:28:36,spid56,Unknown,*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
	09/29/2009 13:28:36,spid56,Unknown,*   Exception Address = 011ABBB7 Module(sqlservr+001ABBB7)
	09/29/2009 13:28:36,spid56,Unknown,*
	09/29/2009 13:28:36,spid56,Unknown,*
	09/29/2009 13:28:36,spid56,Unknown,*   09/29/09 13:28:36 spid 56
	09/29/2009 13:28:36,spid56,Unknown,* BEGIN STACK DUMP:
	09/29/2009 13:28:36,spid56,Unknown,*
	09/29/2009 13:28:36,spid56,Unknown,* *******************************************************************************
	09/29/2009 13:28:36,spid56,Unknown,SqlDumpExceptionHandler: Process 56 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
	09/29/2009 13:28:36,spid56,Unknown,***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0007.txt
	09/29/2009 13:28:36,spid56,Unknown,Using 'dbghelp.dll' version '4.0.5'
	09/29/2009 13:18:36,Server,Unknown,A user request from the session with SPID 56 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.
	09/29/2009 13:18:36,Server,Unknown,Error: 17310<c/> Severity: 20<c/> State: 1.
	09/29/2009 13:18:36,spid56,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
	09/29/2009 13:18:29,spid56,Unknown,Stack Signature for the dump is 0xFA20AE4C
	09/29/2009 13:18:29,spid56,Unknown,78132A47 Module(MSVCR80+00002A47)
	09/29/2009 13:18:29,spid56,Unknown,781329BB Module(MSVCR80+000029BB)
	09/29/2009 13:18:29,spid56,Unknown,010DACF1 Module(sqlservr+000DACF1)
	09/29/2009 13:18:29,spid56,Unknown,010DAB54 Module(sqlservr+000DAB54)
	09/29/2009 13:18:29,spid56,Unknown,010DAE8C Module(sqlservr+000DAE8C)
	09/29/2009 13:18:29,spid56,Unknown,010DAF6C Module(sqlservr+000DAF6C)
	09/29/2009 13:18:29,spid56,Unknown,01006609 Module(sqlservr+00006609)
	09/29/2009 13:18:29,spid56,Unknown,010068F9 Module(sqlservr+000068F9)
	09/29/2009 13:18:29,spid56,Unknown,010067D3 Module(sqlservr+000067D3)
	09/29/2009 13:18:29,spid56,Unknown,01040EC3 Module(sqlservr+00040EC3)
	09/29/2009 13:18:29,spid56,Unknown,010411FB Module(sqlservr+000411FB)
	09/29/2009 13:18:29,spid56,Unknown,010228AE Module(sqlservr+000228AE)
	09/29/2009 13:18:29,spid56,Unknown,01375B48 Module(sqlservr+00375B48)
	09/29/2009 13:18:29,spid56,Unknown,01434208 Module(sqlservr+00434208)
	09/29/2009 13:18:29,spid56,Unknown,01375499 Module(sqlservr+00375499)
	09/29/2009 13:18:29,spid56,Unknown,01374C69 Module(sqlservr+00374C69)
	09/29/2009 13:18:29,spid56,Unknown,0137DB41 Module(sqlservr+0037DB41)
	09/29/2009 13:18:29,spid56,Unknown,0137D64D Module(sqlservr+0037D64D)
	09/29/2009 13:18:29,spid56,Unknown,011AB689 Module(sqlservr+001AB689)
	09/29/2009 13:18:29,spid56,Unknown,01376554 Module(sqlservr+00376554)
	09/29/2009 13:18:29,spid56,Unknown,01378278 Module(sqlservr+00378278)
	09/29/2009 13:18:29,spid56,Unknown,01445598 Module(sqlservr+00445598)
	09/29/2009 13:18:29,spid56,Unknown,010E8166 Module(sqlservr+000E8166)
	09/29/2009 13:18:29,spid56,Unknown,01378278 Module(sqlservr+00378278)
	09/29/2009 13:18:29,spid56,Unknown,013764F5 Module(sqlservr+003764F5)
	09/29/2009 13:18:29,spid56,Unknown,011ABBB7 Module(sqlservr+001ABBB7)
	09/29/2009 13:18:29,spid56,Unknown,* Short Stack Dump
	09/29/2009 13:18:29,spid56,Unknown,* -------------------------------------------------------------------------------
	09/29/2009 13:18:29,spid56,Unknown,* *******************************************************************************
	09/29/2009 13:18:29,spid56,Unknown,*      SegSs: 00000023:
	09/29/2009 13:18:29,spid56,Unknown,*        Esp: 63B8F248:  1193C178  1193C168  09340430  00000000  63B8F2F0  013764F5
	09/29/2009 13:18:29,spid56,Unknown,*     EFlags: 00010206:  006F0050  006E0069  00650074  00490072  0044006E  006C0065
	09/29/2009 13:18:29,spid56,Unknown,*      SegCs: 0000001B:
	09/29/2009 13:18:29,spid56,Unknown,*        Ebp: 63B8F258:  63B8F2F0  013764F5  00000000  1193C178  11939390  63B8F598
	09/29/2009 13:18:29,spid56,Unknown,*        Eip: 011ABBB7:  B8910489  00000001  12430166  5F0C4301  E58B5B5E  0010C25D
	09/29/2009 13:18:29,spid56,Unknown,*        Edx: 00000000:
	09/29/2009 13:18:29,spid56,Unknown,*        Ecx: 00000000:
	09/29/2009 13:18:29,spid56,Unknown,*        Ebx: 09340430:  0137492C  09341FF0  00580200  00000002  00000004  093404E0
	09/29/2009 13:18:29,spid56,Unknown,*        Eax: 0000000C:
	09/29/2009 13:18:29,spid56,Unknown,*        Esi: 09340508:  010304FE  FFFFFFE8  00000003  00000000  00000000  00000000
	09/29/2009 13:18:29,spid56,Unknown,*        Edi: 00000003:
	09/29/2009 13:18:29,spid56,Unknown,*
	09/29/2009 13:18:29,spid56,Unknown,* dbghelp                        6BEC0000  6BFD4FFF  00115000
	09/29/2009 13:18:29,spid56,Unknown,* msmdsrv                        6AA30000  6AAC2FFF  00093000
	09/29/2009 13:18:29,spid56,Unknown,* msxml6                         6A2D0000  6A41CFFF  0014d000
	09/29/2009 13:18:29,spid56,Unknown,* mlang                          6A190000  6A222FFF  00093000
	09/29/2009 13:18:29,spid56,Unknown,* XMLRWBIN                       78BA0000  78BBFFFF  00020000
	09/29/2009 13:18:29,spid56,Unknown,* XMLRW                          78B50000  78B79FFF  0002a000
	09/29/2009 13:18:29,spid56,Unknown,* WINHTTP                        67F30000  67F8CFFF  0005d000
	09/29/2009 13:18:29,spid56,Unknown,* msolap90                       67AF0000  67F20FFF  00431000
	09/29/2009 13:18:29,spid56,Unknown,* comsvcs                        677A0000  678E4FFF  00145000
	09/29/2009 13:18:29,spid56,Unknown,* OLEDB32R                       67780000  67790FFF  00011000
	09/29/2009 13:18:29,spid56,Unknown,* MSDART                         63770000  63789FFF  0001a000
	09/29/2009 13:18:29,spid56,Unknown,* oledb32                        67580000  675F8FFF  00079000
	09/29/2009 13:18:29,spid56,Unknown,* System.Configuration           67480000  674EBFFF  0006c000
	09/29/2009 13:18:29,spid56,Unknown,* System.Xml                     67230000  67427FFF  001f8000
	09/29/2009 13:18:29,spid56,Unknown,* System.Security                671A0000  671E1FFF  00042000
	09/29/2009 13:18:29,spid56,Unknown,* System                         66E90000  67193FFF  00304000
	09/29/2009 13:18:29,spid56,Unknown,* System.Security.ni             67920000  679C8FFF  000a9000
	09/29/2009 13:18:29,spid56,Unknown,* System.Transactions            67AA0000  67AE2FFF  00043000
	09/29/2009 13:18:29,spid56,Unknown,* System.ni                      7A440000  7ABC4FFF  00785000
	09/29/2009 13:18:29,spid56,Unknown,* System.Data                    665E0000  668B3FFF  002d4000
	09/29/2009 13:18:29,spid56,Unknown,* mscorjit                       79060000  790BAFFF  0005b000
	09/29/2009 13:18:29,spid56,Unknown,* SqlAccess                      65ED0000  65F25FFF  00056000
	09/29/2009 13:18:29,spid56,Unknown,* SensApi                        65BC0000  65BC4FFF  00005000
	09/29/2009 13:18:29,spid56,Unknown,* cryptnet                       65BA0000  65BB1FFF  00012000
	09/29/2009 13:18:29,spid56,Unknown,* mscorsec                       65B70000  65B82FFF  00013000
	09/29/2009 13:18:29,spid56,Unknown,* mscorlib.ni                    790C0000  79BB6FFF  00af7000
	09/29/2009 13:18:29,spid56,Unknown,* mscorwks                       79E70000  7A3FFFFF  00590000
	09/29/2009 13:18:29,spid56,Unknown,* xplog70                        63E20000  63E22FFF  00003000
	09/29/2009 13:18:29,spid56,Unknown,* xplog70                        63E00000  63E0BFFF  0000c000
	09/29/2009 13:18:29,spid56,Unknown,* xpstar90                       63DD0000  63DF5FFF  00026000
	09/29/2009 13:18:29,spid56,Unknown,* odbcint                        63DB0000  63DC6FFF  00017000
	09/29/2009 13:18:29,spid56,Unknown,* ATL80                          7C630000  7C64AFFF  0001b000
	09/29/2009 13:18:29,spid56,Unknown,* BatchParser90                  63C80000  63C9EFFF  0001f000
	09/29/2009 13:18:29,spid56,Unknown,* ODBC32                         63C40000  63C7CFFF  0003d000
	09/29/2009 13:18:29,spid56,Unknown,* SQLSCM90                       63C20000  63C28FFF  00009000
	09/29/2009 13:18:29,spid56,Unknown,* xpstar90                       63BC0000  63C0AFFF  0004b000
	09/29/2009 13:18:29,spid56,Unknown,* xpsqlbot                       63BA0000  63BA5FFF  00006000
	09/29/2009 13:18:29,spid56,Unknown,* msftepxy                       63650000  63664FFF  00015000
	09/29/2009 13:18:29,spid56,Unknown,* SQLNCLIR                       00870000  008A2FFF  00033000
	09/29/2009 13:18:29,spid56,Unknown,* comdlg32                       762B0000  762F8FFF  00049000
	09/29/2009 13:18:29,spid56,Unknown,* COMCTL32                       77530000  775C6FFF  00097000
	09/29/2009 13:18:29,spid56,Unknown,* sqlncli                        63220000  63446FFF  00227000
	09/29/2009 13:18:29,spid56,Unknown,* CLBCatQ                        777B0000  77832FFF  00083000
	09/29/2009 13:18:29,spid56,Unknown,* xpsp2res                       62F50000  63214FFF  002c5000
	09/29/2009 13:18:29,spid56,Unknown,* ntdsapi                        766F0000  76703FFF  00014000
	09/29/2009 13:18:29,spid56,Unknown,* SAMLIB                         7E020000  7E02EFFF  0000f000
	09/29/2009 13:18:29,spid56,Unknown,* NTMARTA                        77E00000  77E20FFF  00021000
	09/29/2009 13:18:29,spid56,Unknown,* wshtcpip                       71AE0000  71AE7FFF  00008000
	09/29/2009 13:18:29,spid56,Unknown,* hnetcfg                        62EF0000  62F49FFF  0005a000
	09/29/2009 13:18:29,spid56,Unknown,* dssenh                         68100000  68126FFF  00027000
	09/29/2009 13:18:29,spid56,Unknown,* comctl32                       77420000  77522FFF  00103000
	09/29/2009 13:18:29,spid56,Unknown,* SHLWAPI                        77DA0000  77DF1FFF  00052000
	09/29/2009 13:18:29,spid56,Unknown,* SHELL32                        7C8D0000  7D0CEFFF  007ff000
	09/29/2009 13:18:29,spid56,Unknown,* imagehlp                       76C10000  76C37FFF  00028000
	09/29/2009 13:18:29,spid56,Unknown,* WINTRUST                       76BB0000  76BDAFFF  0002b000
	09/29/2009 13:18:29,spid56,Unknown,* dbghelp                        62B70000  62C84FFF  00115000
	09/29/2009 13:18:29,spid56,Unknown,* msfte                          62910000  62B68FFF  00259000
	09/29/2009 13:18:29,spid56,Unknown,* security                       622A0000  622A3FFF  00004000
	09/29/2009 13:18:29,spid56,Unknown,* rasadhlp                       76F80000  76F84FFF  00005000
	09/29/2009 13:18:29,spid56,Unknown,* WLDAP32                        76F10000  76F3DFFF  0002e000
	09/29/2009 13:18:29,spid56,Unknown,* winrnr                         76F70000  76F76FFF  00007000
	09/29/2009 13:18:29,spid56,Unknown,* DNSAPI                         76ED0000  76EF9FFF  0002a000
	09/29/2009 13:18:29,spid56,Unknown,* mswsock                        71B20000  71B60FFF  00041000
	09/29/2009 13:18:29,spid56,Unknown,* RESUTILS                       74EF0000  74F02FFF  00013000
	09/29/2009 13:18:29,spid56,Unknown,* CLUSAPI                        74DE0000  74DF1FFF  00012000
	09/29/2009 13:18:29,spid56,Unknown,* WSOCK32                        71BB0000  71BB8FFF  00009000
	09/29/2009 13:18:29,spid56,Unknown,* VERSION                        77B90000  77B97FFF  00008000
	09/29/2009 13:18:29,spid56,Unknown,* MTXCLU                         74F40000  74F58FFF  00019000
	09/29/2009 13:18:29,spid56,Unknown,* msvcp60                        61E00000  61E64FFF  00065000
	09/29/2009 13:18:29,spid56,Unknown,* OLEAUT32                       77D00000  77D8AFFF  0008b000
	09/29/2009 13:18:29,spid56,Unknown,* MSDTCPRX                       61D80000  61DF8FFF  00079000
	09/29/2009 13:18:29,spid56,Unknown,* XOLEHLP                        61D70000  61D75FFF  00006000
	09/29/2009 13:18:29,spid56,Unknown,* COMRES                         77010000  770D5FFF  000c6000
	09/29/2009 13:18:29,spid56,Unknown,* CRYPT32                        761B0000  76242FFF  00093000
	09/29/2009 13:18:29,spid56,Unknown,* schannel                       76750000  76777FFF  00028000
	09/29/2009 13:18:29,spid56,Unknown,* MSASN1                         76190000  761A1FFF  00012000
	09/29/2009 13:18:29,spid56,Unknown,* kerberos                       61CC0000  61D18FFF  00059000
	09/29/2009 13:18:29,spid56,Unknown,* iphlpapi                       76CF0000  76D09FFF  0001a000
	09/29/2009 13:18:29,spid56,Unknown,* WS2HELP                        71BF0000  71BF7FFF  00008000
	09/29/2009 13:18:29,spid56,Unknown,* WS2_32                         71C00000  71C16FFF  00017000
	09/29/2009 13:18:29,spid56,Unknown,* cryptdll                       766E0000  766EBFFF  0000c000
	09/29/2009 13:18:29,spid56,Unknown,* msv1_0                         76C90000  76CB7FFF  00028000
	09/29/2009 13:18:29,spid56,Unknown,* ole32                          77670000  777A8FFF  00139000
	09/29/2009 13:18:29,spid56,Unknown,* MSCOREE                        79000000  79045FFF  00046000
	09/29/2009 13:18:29,spid56,Unknown,* AUTHZ                          76C40000  76C53FFF  00014000
	09/29/2009 13:18:29,spid56,Unknown,* rsaenh                         68000000  68034FFF  00035000
	09/29/2009 13:18:29,spid56,Unknown,* sqlevn70                       4F610000  4F7B8FFF  001a9000
	09/29/2009 13:18:29,spid56,Unknown,* instapi                        48060000  48069FFF  0000a000
	09/29/2009 13:18:29,spid56,Unknown,* psapi                          76B70000  76B7AFFF  0000b000
	09/29/2009 13:18:29,spid56,Unknown,* USP10                          75490000  754F4FFF  00065000
	09/29/2009 13:18:29,spid56,Unknown,* LPK                            7F000000  7F008FFF  00009000
	09/29/2009 13:18:29,spid56,Unknown,* IMM32                          76290000  762ACFFF  0001d000
	09/29/2009 13:18:29,spid56,Unknown,* NETAPI32                       71C40000  71C96FFF  00057000
	09/29/2009 13:18:29,spid56,Unknown,* opends60                       333E0000  333E6FFF  00007000
	09/29/2009 13:18:29,spid56,Unknown,* WINMM                          76AA0000  76ACCFFF  0002d000
	09/29/2009 13:18:29,spid56,Unknown,* GDI32                          77C00000  77C48FFF  00049000
	09/29/2009 13:18:29,spid56,Unknown,* USER32                         77380000  77410FFF  00091000
	09/29/2009 13:18:29,spid56,Unknown,* USERENV                        76920000  769E1FFF  000c2000
	09/29/2009 13:18:29,spid56,Unknown,* sqlos                          344D0000  344D4FFF  00005000
	09/29/2009 13:18:29,spid56,Unknown,* Secur32                        76F50000  76F62FFF  00013000
	09/29/2009 13:18:29,spid56,Unknown,* RPCRT4                         77C50000  77CEEFFF  0009f000
	09/29/2009 13:18:29,spid56,Unknown,* ADVAPI32                       7D1E0000  7D27BFFF  0009c000
	09/29/2009 13:18:29,spid56,Unknown,* MSVCP80                        7C420000  7C4A6FFF  00087000
	09/29/2009 13:18:29,spid56,Unknown,* msvcrt                         77BA0000  77BF9FFF  0005a000
	09/29/2009 13:18:29,spid56,Unknown,* MSVCR80                        78130000  781CAFFF  0009b000
	09/29/2009 13:18:29,spid56,Unknown,* kernel32                       77E40000  77F41FFF  00102000
	09/29/2009 13:18:29,spid56,Unknown,* ntdll                          7C800000  7C8C1FFF  000c2000
	09/29/2009 13:18:29,spid56,Unknown,* sqlservr                       01000000  02C1FFFF  01c20000
	09/29/2009 13:18:29,spid56,Unknown,*  MODULE                          BASE      END       SIZE
	09/29/2009 13:18:29,spid56,Unknown,*
	09/29/2009 13:18:29,spid56,Unknown,*
	09/29/2009 13:18:29,spid56,Unknown,*  --<c/>r = a+0 -- causes error  ) rt
	09/29/2009 13:18:29,spid56,Unknown,*  <c/>r = isnull(a<c/>a) -- causes error        <c/>r = a+a -- causes error
	09/29/2009 13:18:29,spid56,Unknown,*  ) at  cross apply  (    select        x = a -- this works fine        --
	09/29/2009 13:18:29,spid56,Unknown,*               select    * -- error  from  (    select a = dbo.Crash_A()
	09/29/2009 13:18:29,spid56,Unknown,* Input Buffer 498 bytes -
	09/29/2009 13:18:29,spid56,Unknown,*   Access Violation occurred writing address 00000000
	09/29/2009 13:18:29,spid56,Unknown,*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
	09/29/2009 13:18:29,spid56,Unknown,*   Exception Address = 011ABBB7 Module(sqlservr+001ABBB7)
	09/29/2009 13:18:29,spid56,Unknown,*
	09/29/2009 13:18:29,spid56,Unknown,*
	09/29/2009 13:18:29,spid56,Unknown,*   09/29/09 13:18:29 spid 56
	09/29/2009 13:18:29,spid56,Unknown,* BEGIN STACK DUMP:
	09/29/2009 13:18:29,spid56,Unknown,*
	09/29/2009 13:18:29,spid56,Unknown,* *******************************************************************************
	09/29/2009 13:18:29,spid56,Unknown,SqlDumpExceptionHandler: Process 56 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
	09/29/2009 13:18:29,spid56,Unknown,***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0006.txt
	09/29/2009 13:18:29,spid56,Unknown,Using 'dbghelp.dll' version '4.0.5'




	select @@version

	Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) 
		Nov 24 2008 13:01:59 
		Copyright (c) 1988-2005 Microsoft Corporation
		Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2009-09-29 : 07:40:36
whats the purpose of query? you're just using value as its inside cross apply. is that done for some testing?
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2009-09-29 : 07:41:50
Works fine for me.
Which version are you using?

SELECT @@VERSION

drop FUNCTION Crash_A 
	GO 
	create FUNCTION Crash_A() 
	RETURNS int --type used doesnt vary 
	AS 
	BEGIN 
	  RETURN 5
	END 
	GO 

	select 
	  * -- error 
	from 
	( 
	  select a = dbo.Crash_A() 
	) at 
	cross apply 
	( 
	  select 
		  x = a -- this works fine 
		  ,r1 = isnull(a,a) -- causes error 
		  ,r2 = a+a -- causes error 
		  ,r3 = a+0 -- causes error 
	) rt


N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

acd
Starting Member

6 Posts
Posted - 2009-09-29 : 08:01:12
quote:
Originally posted by Peso

Works fine for me.
Which version are you using?

SELECT @@VERSION
N 56°04'39.26"
E 12°55'05.63"



	select @@version

	Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) 
		Nov 24 2008 13:01:59 
		Copyright (c) 1988-2005 Microsoft Corporation
		Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
Go to Top of Page

acd
Starting Member

6 Posts
Posted - 2009-09-29 : 08:03:17
quote:
Originally posted by visakh16

whats the purpose of query? you're just using value as its inside cross apply. is that done for some testing?


visakh16: Original query was far larger. I cropped it into minimal query that still causes error
Go to Top of Page

acd
Starting Member

6 Posts
Posted - 2009-09-30 : 09:48:48
quote:
Originally posted by Peso

Works fine for me.


Peso: Whats your version?
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2009-09-30 : 09:54:41
2008.
I can reproduce the failure with SQL Server 2005 version 9.0.4035.

N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page

acd
Starting Member

6 Posts
Posted - 2009-10-06 : 11:46:40
Anyone knows how to fix it on sql 2005 ?
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site