One Case
This title could be clearer and more informative.Try out Clickbait Shieldfor free (5 uses left this month).
A short WTF-style post showcasing a SQL query that uses a CASE statement to map document type values by incrementing each one individually (2→3, 3→4, etc.) instead of simply adding 1. The author speculates on possible historical reasons for this oddity, such as database merges or legacy spreadsheet origins, while noting the ELSE clause suggests the pattern isn't universal.
Sort: