Home Dashboard Directory Help
Search

CHECKSUM Returns Same Value for Decimals by F_clef


Status: 

Active


1
2
Sign in
to vote
Type: Bug
ID: 785295
Opened: 4/22/2013 9:27:01 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

The CHECKSUM() function returns the same value for decimals. Example: CHECKSUM(1.23) = CHECKSUM(123.00)
Details
Sign in to post a comment.
Posted by F_clef on 4/30/2013 at 9:20 AM
That's such a copout. I expected better.
Posted by Vladimir Moldovanenko on 4/23/2013 at 5:37 AM
This is expected; checksum() is not guaranteed to produce unique results. See SQL BOL for more.
Sign in to post a workaround.