Roadmap 0.9, Fixes

FX.99 Account database update stamps never moved forward: SQLite MAX() compared the bound stamp as text

  • Fix
  • Built · Live
  • SuperCad Studio

PDO binds numbers as text, and in SQLite any text sorts above any integer, so MAX(?, updated_at + 1) always chose "now". Fixed with CAST(? AS INTEGER). Found by the last-writer tests.

Add a comment

Community comments

No comments yet

Add detail as we go: how you would use it, files or steps that show the problem, what other programs do. The team reads every comment.

Sign in or create a free account to add a comment.