We are using SQL Server 2012 with a unique identifier and we've noticed that when doing selects with additional characters added onto the end (so not 36 chars) it still returns a match to a UUID.
select * from some_table where uuid = '7DA26ECB-D599-4469-91D4-F9136EC0B4E8'
returns the row with uuid
But if you run:
select * from some_table where uuid = '7DA26ECB-D599-4469-91D4-F9136EC0B4E8EXTRACHARS'
it also returns the row with the uuid
SQL Server seems to ignore all characters beyond the 36 when doing its selects. Is this a bug/feature or something that can configured?
It's not a massive issue as we have validation on the front end for the length but it doesn't seem correct behaviour to me.