SQL Server - Fatal error with select stmt

Asked By Scott

06-Jul-07 03:32 PM

Our Windows Mobile 5 application bombs when SQL Server Mobile Edition
3.00.5206.00 throws a message:
ExceptionCode: 0xc0000005
ExceptionAddress: 0x0125aa68
Reading: 0x005ef000

The query (below) is generated dynamically (may be one or more filter
clauses, hence 'WHERE 1=1' is always generated and the AND clauses are
appendeded as appropriate.

Really odd: When I run this in Query Analyzer on the device, it also blows
up when run as-is.  However, if I comment out any of the AND clauses, then
run (I get a result set) then uncomment the clause and now run the original
query, it works!  If I disconnect and reconnect and run the full query again,
boom.

SELECT	DISTINCT s.supplier_id, s.supplier_name, s.phone, s.fax, s.email,
s.contact_name, s.address1, s.notes
FROM        insp_defect d
INNER JOIN supplier s ON d.assigned_supplier_id = s.supplier_id
INNER JOIN job j ON d.job_id = j.job_id
INNER JOIN job_user ju on j.job_id = ju.job_id
LEFT OUTER JOIN job_task jt ON d.task_id = jt.task_id
WHERE 1=1
AND ju.user_id = 176
AND j.subdivision_id =19
AND j.status = 'A'
AND jt.task_status in ('B', 'D')

Any help would be greatly appreciated (hate to use my support incidents so
quickly).

Scott

18-Jul-07 05:24 AM

Scott,

I tried to reproduce your problem with Northwind database, but
unsuccessfully. If you can give a sample database that i can work on, it will
help diagnose the problem faster. You can mail me at pragya dot agarwal at
microsoft dot com.

The query i used was:
SELECT
DISTINCT   s.[supplier id], s.[company name],
s.phone, s.fax, s.[contact name], s.address
FROM products d
INNER JOIN suppliers s ON d.[supplier id]= s.[supplier id]
INNER JOIN [order details] j ON d.[product id]= j.[product id]
INNER JOIN orders ju on j.[order id]= ju.[order id]
LEFT OUTER JOIN categories jt ON d.[category id]= jt.[category id]
WHERE 1=1
AND ju.[employee id]= 1
AND j.[unit price] =13
AND j.quantity= 30
AND jt.[category name] in ('beverages', 'seafood', 'condiments')

Thanks
-Pragya