Experiencing sorting problems with bigint columns
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2025 09:31 PM
Experiencing sorting problems with bigint columns across tables tested.
Example:
In the table the projectid (bigint as per schema - which is correct) yet when sorted in SQL is sorting as per a string value
1000903 is returned as the minimum projectid value
998401 is returned as the maximum projectid value.
