Can select COUNT(*) produce the next error?

Question

I am using python's pypyodbc to process some sql BULK insertion cmds on a SQL Sever Database. Yet, at the logs I found:

    python   load_d 4c24-4ea4   ENTER SQLExecDirect 
        HSTMT               0x000000000336C260
        UCHAR *             0x0000000003A91188 [      67] "\ a        SELECT COUNT(*) \ a        FROM out_table\ a        "
        SDWORD                    67

python   load_d 4c24-4ea4   EXIT  SQLExecDirect  with return code -1 (SQL_ERROR)
        HSTMT               0x000000000336C260
        UCHAR *             0x0000000003A91188 [      67] "\ a        SELECT COUNT(*) \ a    

FROM out_table\ a        "
    SDWORD                    67

DIAG [22003] [Microsoft][SQL Server Native Client 11.0][SQL Server]Arithmetic overflow error converting expression to data type int. (8115)

Could the COUNT(*) be returning a very big value that "escapes" from the INT limits?

no... the COUNT cmd is on the table itself. This table is receiving tons of rows. — Jose Cabrera Zuniga, Feb 16 '21 at 01:11
More than 2 billion rows? Then yes it will overflow, see answer — Charlieface, Feb 16 '21 at 01:14
I think this is the case... and right now I am trying the answer!! Thanks — Jose Cabrera Zuniga, Feb 16 '21 at 01:15

score 0 · Accepted Answer · answered Feb 15 '21 at 15:45

0

Yes. It can. To deal with this issue Microsoft introduced COUNT_BIG-function Please see details here https://learn.microsoft.com/en-us/sql/t-sql/functions/count-big-transact-sql?view=sql-server-ver15

answered Feb 15 '21 at 15:45

Sergey

4,719
1
6
11

Can select COUNT(*) produce the next error?

1 Answers1