View Issue Details

IDProjectCategoryView StatusLast Update
0003549Composrcorepublic2022-08-15 15:47
ReporterChris GrahamAssigned ToPatrick Schmalstig 
SeverityFeature-request 
Status resolvedResolutionfixed 
Product Version 
Fixed in Version 
Summary0003549: 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
Time estimation (hours)2
Sponsorship open

Relationships

related to 0004717 non-assigned GUIDs instead of auto-incrementing IDs 

Activities

Chris Graham

2022-07-28 02:43

administrator   ~0007397

f_poll_answers is being resolved in 0004776.

Chris Graham

2022-08-09 16:52

administrator   ~0007413

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 0003147
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 0003147
2021-07-23 22:38 Chris Graham Assigned To => Patrick Schmalstig
2021-07-23 22:38 Chris Graham Status non-assigned => assigned
2021-11-18 01:04 Chris Graham Relationship added related to 0004717
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 Patrick Schmalstig Status assigned => resolved
2022-08-09 20:31 Patrick Schmalstig Resolution open => fixed
2022-08-15 15:47 Chris Graham Tag Detached: Roadmap: v12