Skip to main content
22 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
677 views

I am loading the New York Trip data (https://www.nyc.gov/site/tlc/about/tlc-trip-record-data.page) from parquet files to to an Azure SQL database. The date is in the format TIMESTAMP_MICROS, what ...
denzel's user avatar
  • 33
2 votes
1 answer
2k views

In Databricks SQL editor , I am trying to get the SUM of few 'Bigint' and 'Double' data type columns of a table. But am getting below error. Job aborted due to stage failure: Task 0 in stage 29.0 ...
kiruba's user avatar
  • 139
1 vote
1 answer
340 views

I'm getting this error but only when grouping by specific columns: Arithmetic overflow error converting expression to data type int. And I can't wrap my head around why. This is the query causing it (...
Johan's user avatar
  • 1,532
1 vote
2 answers
212 views

I have a class that has two int fields x and y, and a method Increment that increments both of these fields by dx and dy respectively. I would like to prevent the state of my class to become corrupted ...
Theodor Zoulias's user avatar
  • 46.1k
0 votes
2 answers
533 views

This should simply be adding 1 to an unsigned int: prev = nums[nextIndex + 1]; but it gives a warning saying Arithmetic overflow: Using operator '+' on a 4 byte value and then casting the result to a ...
Tristan367's user avatar
  • 35
-2 votes
1 answer
1k views

I'm getting this error while running Update-Database in EF Core: Arithmetic overflow error converting numeric to data type numeric. The statement has been terminated. This SQL segment is also ...
user2721794's user avatar
  • 423
0 votes
1 answer
391 views

(I'm using Rust 1.44.1) The following example fails to build (debug mode) because of arithmetic overflow (and I understand why) : fn main() { let i: u8 = 255 + 1; } error: this arithmetic ...
norbjd's user avatar
  • 11.4k
1 vote
1 answer
599 views

I am experiencing this issue in SQL Server 2012 but it is also manifest in SQL Server 2017. My database table, call it MyTable, contains a decimal(18,6) column, new_balance, which is not nullable. The ...
Steve Byfield's user avatar
  • 21
0 votes
1 answer
156 views

I've spent an inordinate amount of time on getting this one stored proc to work, it's basically putting results from the query into an html format that is getting emailed. The query that the proc ...
BG1's user avatar
  • 5
0 votes
3 answers
215 views

I want to calculate a voltage using ADC peripheral of PIC18F14K50. The result ranges between 0-1023 (10-bit). So I used this simple calculation: uint16_t voltage = ADC_Result * 5000 / 1023; However, ...
AmirSina Mashayekh's user avatar
  • 532
-2 votes
1 answer
310 views

This is the code for the Triangle problem in codility that is throwing me an arithmetic overflow error. int solution(vector<int> &A) { int i, n; n=A.size(); sort(A.begin(), A....
monkikat's user avatar
  • 33
0 votes
1 answer
2k views

I have the value as 2800320 which I need to insert to table for numeric(9, 4) datatype. In the code I have given as float.Parse(record.Substring(i, 8)).When I insert to sql arithmetic overflow error ...
Anjana Jain's user avatar
  • 43
2 votes
0 answers
110 views

I’m having a bug after compiling the below piece of code with /O2, /Ob2, /arch:AVX2 flags. I am using Microsoft Visual Studio Community 2019 Version 16.4.6 on a Win64. Running the below piece of code ...
addeconinck's user avatar
  • 31
2 votes
3 answers
1k views

So I have a code that adds two integers and prints the result: Console.WriteLine("enter number: "); int intTemp = Convert.ToInt32(Console.ReadLine()); long sum = intTemp + 5; Console....
Buda Gavril's user avatar
  • 21.7k
0 votes
1 answer
2k views

I am trying to write a code that makes it possible to add 2 numbers, even if they are 32 bits long. However my program won't work if I add two 32 bits numbers, or if I add two numbers that make a 32 ...
Ana Laura Chioca Vieira's user avatar
  • 15
0 votes
2 answers
1k views

Why some numbers are defined as not a number(NaN) in floating point arithmetic? (Although they can be represented by IEEE format and indeed are real numbers)
Lavlesh Mishra's user avatar
  • 11
3 votes
1 answer
9k views

I know that similar questions have been asked again in the past, but I think my case is slightly different. I have a column which has Logarithmic values and I'm trying to invert them using the ...
gkoul's user avatar
  • 1,337
0 votes
0 answers
82 views

I originally imported these files using the Import and Export Wizard from a fixed width file. I had planned to have the field in question, firms, as numeric (8,0) but I was getting an error about data ...
Tim Wilcox's user avatar
  • 1,351
0 votes
1 answer
88 views

I am facing an issue in Arithmetic overflow, I have posted the detail in this question [Dictionary to ToList ArithmeticFlowException however I have found the reason, when I call the method Global....
bilal's user avatar
  • 658
7 votes
2 answers
6k views

Calling the JDKs Instant.toEpochMilli() could result in an arithmetic overflow/underflow (e.g. Instant.MAX.toEpochMilli() or Instant.MIN.toEpochMilli()). I am looking for a simple way to avoid the ...
Nathan's user avatar
  • 9,111
1 vote
2 answers
641 views

I'm working with a code analysis tool called Polyspace. I got a "possible overflow" notification on one code section and just can figure it out :) Error : operation [conversion from unsigned int32 ...
Sergiu's user avatar
  • 31
140 votes
8 answers
485k views

I keep getting this error message everytime I run this query: Msg 8115, Level 16, State 8, Line 33 Arithmetic overflow error converting numeric to data type numeric. The statement has been terminated. ...
user572984's user avatar
  • 1,409