« first day (4345 days earlier)
← previous day
next day →
last day (524 days later) »
Paul White
5:10 AM
That was golf though
13 hours later…
Erik Darling
6:02 PM
Golf has always been great
Paul White
This is hopeless
dbfiddle.uk/MArD2bRI
ypercubeᵀᴹ
haha
Arithmetic overflow error for type varchar
@PaulWhite only fails for style 3?
Paul White
6:21 PM
@ypercubeᵀᴹ Yes, the other styles use less precision. We're supposed to use 3 to ensure a round-trip representation
The
max
variant doesn't account for the space needed by the sign 😭
ypercubeᵀᴹ
@PaulWhite but you can convert to varchar(8000) - or varchar(30) - and then to varchar(max)? weird
Paul White
Yep, it's stupid
Also, the error message reports an inaccurate value
An
imprecise
value, I should say
The true representation being
-999999.999999999883584678173065185546875
(closest double precision value)
ypercubeᵀᴹ
eh, the diff is less than a satoshi coin ;)
your value has been taxed by 0.0000000000000116415321826934814453125%
Paul White
6:51 PM
true
but this isn't helpful:
> Msg 232 Level 16 State 2 Line 3
Arithmetic overflow error for type varchar, value = -1000000.000000.
Erik Darling
@PaulWhite fewer
2
ypercubeᵀᴹ
@PaulWhite it's a catch-22 situation.
Spain - Germany is about to start
Paul White
7:15 PM
They're always about to kick off those two
Good job France keeps them apart
I see Morocco beat Belgium
ypercubeᵀᴹ
7:51 PM
heh,
twitter.com/adamthealright/status/1431960178249842694
2
seen on the SE announcement of
deactivation of the Windows Phone SE site
2
3 hours later…
Erik Darling
10:28 PM
@ypercubeᵀᴹ that’s a good one
« first day (4345 days earlier)
← previous day
next day →
last day (524 days later) »
all rooms
Transcript for
Nov
26
Nov '22
27
Nov
28
The Heap™ – Consultancy ©®
General on- and off-site discussion for
dba.stackexchange.com
....
6
frogs
mysql
nosql
oracle
postgresql
sqlite
sql-server
join this room
about this room
00:00
06:00
12:00
18:00
all times are UTC
site design / logo © 2024 Stack Exchange Inc;
legal
mobile