View Issue Details

IDProjectCategoryView StatusLast Update
3549Composrcorepublic2022-08-15 15:47
ReporterChris Graham Assigned ToPDStig  
PrioritynormalSeverityfeature 
Status resolvedResolutionfixed 
Summary3549: Don't rely on ID sorting for these tables
DescriptionThere are a couple of tables that have sorting based on ID, which assumes ID is sequential. This is not the case on the XML DB driver, and may not be on other exotic databases.

seo_meta_keywords
f_poll_answers
shopping_cart

Usually we don't need to do this as we store add time, or can reasonably order by title. But these are cases of us storing basic sorted lists.

For the XML DB driver I am temporarily sorting alphabetically.
TagsType: Cloudification
Attach Tags
Time estimation (hours)2
Sponsorship open

Sponsor

Date Added Member Amount Sponsored

Relationships

related to 4717 Not AssignedGuest GUIDs instead of auto-incrementing IDs 

Activities

Chris Graham

2022-07-28 02:43

administrator   ~7397

f_poll_answers is being resolved in 4776.

Chris Graham

2022-08-09 16:52

administrator   ~7413

I think you can mark this resolved Patrick?

Issue History

Date Modified Username Field Change
2018-02-26 17:49 Chris Graham New Issue
2018-02-27 13:38 Chris Graham Summary Don't rely on ID sorting for tables => Don't rely on ID sorting for these tables
2019-07-20 02:46 Chris Graham Relationship added related to 3147
2019-11-15 20:51 Chris Graham Tag Attached: Roadmap: v12
2020-11-07 20:11 Chris Graham Tag Attached: Type: Cloudification
2020-11-07 20:12 Chris Graham Relationship deleted related to 3147
2021-07-23 22:38 Chris Graham Assigned To => user4172
2021-07-23 22:38 Chris Graham Status Not Assigned => Assigned
2021-11-18 01:04 Chris Graham Relationship added related to 4717
2022-07-28 02:43 Chris Graham Note Added: 0007397
2022-08-09 16:52 Chris Graham Note Added: 0007413
2022-08-09 20:31 PDStig Status Assigned => Resolved
2022-08-09 20:31 PDStig Resolution open => fixed
2022-08-15 15:47 Chris Graham Tag Detached: Roadmap: v12