Gigasecond: Tests passing locally and failing on the website

Programming SQLite
1

In a visual/manual check, all tests also passed.

Has anyone else experienced something like this?

2

Are you running the tests locally? Care to share your code and the test output? It’s pretty hard to debug issues without seeing any details. The more details you can provide, the better able we are to help you!

(Please use codeblocks to share text and not screenshots!!)

3

Sorry for that!

Here’s my code:

UPDATE gigasecond
   SET result =
       STRFTIME('%FT%T', DATETIME(UNIXEPOCH(moment) + 1000000000, 'UNIXEPOCH'))
;

and here the local output:

main: "" r/w
+-------------------------------------------------+--------+---------+
|                      name                       | status | message |
+-------------------------------------------------+--------+---------+
| date only specification of time                 | pass   | null    |
| second test for date only specification of time | pass   | null    |
| third test for date only specification of time  | pass   | null    |
| full time specified                             | pass   | null    |
| full time with day roll-over                    | pass   | null    |
+-------------------------------------------------+--------+---------+

The website reports that all tests failed, but doesn’t give me any clues as to what’s wrong.

4

I still have not yet messed around with the test runners. @glennj would you perhaps have time to poke at this? I see failed tests but no details. We may not be generating the json report correctly.

1 Like
5

If I run this locally, stderr is empty, stdout is:

gigasecond: testing...
gigasecond: done

and results.json is:

{
  "version": 1,
  "status": "fail",
  "message": ""
}
7

The 3.44.0 change log includes:

New conversion letters on the strftime() SQL function: %e %F %I %k %l %p %P %R %T %u

Those might not be supported on the test runner.

1 Like
8

The installation doc says,

Testing for this track is based on version 3.37.

3.38 change log says,

Added the unixepoch() function.

1 Like
9

Thank you for your help!

10

The test runner is running on alpine 3.18.

Alpine 3.18 uses sqlite 3.41.2

1 Like
11

I can dig into the test runner with that specific sqlite version, but not today.

2 Likes