search

exercism / sqlite

Exercism exercises in SQLite.
https://exercism.org/tracks/sqlite
MIT License
6 stars 7 forks source link

feat: add grains exercise #42

Closed vaeng closed 8 months ago

glennj commented 8 months ago 
grains: testing...
/home/runner/work/sqlite/sqlite/exercises/practice/grains
Test failed for grains - failing tests:
{
  "name": "returns the total number of grains on the board",
  "message": null
}

Are we overflowing here? SET result = POWER(2, 64) - 1

vaeng commented 8 months ago

Are we overflowing here? 

❯ sqlite3
SQLite version 3.37.2 2022-01-06 13:25:41
sqlite> select POWER(2, 64) - 1;
1.84467440737096e+19
sqlite> .quit
❯ python3
Python 3.10.12 (main, Nov 20 2023, 15:14:05) [GCC 11.4.0] on linux
>>> 2**64 -1
18446744073709551615

@glennj seems okay, I can't find any hard limits.