yesodweb / yesodweb/persistent

TimeOfDay no longer roundtrips through sqlite

Open
#1,500 4 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Haskell
Stars
486
Forks
306
PR merge metrics
No merged PRs in 30d

Description

Tried with latest master (434f49266749cad6f074920fb61ad3ec6ef90bea) as well as the version in lts-20.23:

When inserting 00:56:03.917384676344, I get out 00:56:03.

This is a regression and I'm surprised that this wasn't caught by tests.

This means I cannot upgrade from LTS 19 (nixos-22.11) to LTS 20 (nixos-23.05).

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the reported TimeOfDay roundtrip through SQLite on latest master and the lts-20.23 version. Trace the persistence path for the value and compare the stored and retrieved precision. Done means fractional seconds such as 00:56:03.917384676344 survive the roundtrip, with a regression test covering the case.

Written by the indexing model from the issue text.

Assessment

Tech stack
haskell, sqlite
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.