Does anyone know why a null column is behaving differently from a not null column when summing values in a calculation view?
In my transaction table I have two record counters type TINYINT with always value 1. One counter is a NULL column, the other a NOT NULL column.
When I preview the data from the table I see the correct sum of close to 4 million records for both counters. However when I include this in a simple calculation view then I get the below numeric overflow error for the NOT NULL column. The NULL column gives the correct sum without an error.
I understand that the conversion to tinyint causes an error, just don't understand why only in case of a NOT NULL column.
By the way, I do expect a sum to not be limited by the data type of the column.
Error: : numeric overflow: 3746903 at function to_tinyint()