SELECT statement fails with 'Expression evaluation caused an overflow'

Welcome, guest Sign in | Your Profile | Help

HOME

YOUR DASHBOARD

CONNECTION DIRECTORY

SQL Server Home Downloads Feedback Surveys

SELECT statement fails with 'Expression evaluation caused an overflow' by mokule

Active

Type:	Bug
ID:	508322
Opened:	11/4/2009 2:57:43 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

SELECT statement execution with ORDER BY clause and one of the columns numeric is causing the following error:
Major Error 0x80004005, Minor Error 25901
Expression evaluation caused an overflow. [ Name of function (if known) = ]
The error occurs only on some sets of data.
Detected on SQL Server CE 3.5 running on a PC.

Details (expand)

English

SQL Server Compact Edition

Windows XP SP2 Professional

Polish

In SSMS execute statement on provided database.
SELECT MAX(PrzLp) AS Lp, SUM(PrzKwota) As Suma
FROM SplPrzeplywy
GROUP BY PrzNumerDokumentu
ORDER BY Lp DESC
PrzKwota is numeric(18,2)
Not all sets of data cause the problem

Major Error 0x80004005, Minor Error 25901
> SELECT MAX(PrzLp) AS Lp, SUM(PrzKwota) As Suma
FROM SplPrzeplywy
GROUP BY PrzNumerDokumentu
ORDER BY Lp DESC
Expression evaluation caused an overflow. [ Name of function (if known) = ]

Some rows of data extracted from database table is expected according to SQL specification.

1 attachments

MyDatabase#0.sdf

Posted by Microsoft on 11/9/2009 at 4:00 AM

Thanks for logging the issue. We are analyzing the issue and we will post back the results of the analysis and the next steps

Regards

Ambrish

Posted by Microsoft on 11/9/2009 at 5:02 AM

Hi,

This bug has been fixed in the release of SQL Server Compact that will ship along with Visual Studio 2010 (version: Beta 2 onwards)

Only SQL Server compact SP2 beta 2 can be downloaded from: http://www.microsoft.com/downloads/details.aspx?FamilyID=411ba1c5-ba57-45b6-9148-91bed6e7a9f1&displaylang=en

Regards,
Vipul