Chapter 12: SQL pagination of invoices is non-deterministic and doesn't show all invoices
Open
Nobody has claimed this yet.
- Dominant language
- TypeScript
- Stars
- 4.8k
- Forks
- 2.2k
- PR merge metrics
- No merged PRs in 30d
Description
When creating new invoices, we truncate the Date to remove the timestamp resulting in all new invoices to have an identical value in our SQL database
When the invoices are then fetched, ordered, and limited to be displayed in a table, SQL does not have enough data to guarantee a unique ordering
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by locating the Chapter 12 invoice query that orders and limits records, then reproduce pagination with invoices sharing the same truncated date. Determine the intended deterministic ordering and verify that every invoice appears consistently across pages.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql, typescript
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100