You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
With a column of type "timestamp with time zone", like in the following table, sqlite3 doesn't convert it into a time.Time and scanning such a row into a time.Time field therefore fails.
createtablesnippets(
id binary(16) primary key,
content textnot null,
created_at timestamp with time zonenot null default CURRENT_TIMESTAMP
);
I traced this to SQLiteRows.nextSyncLocked() where you check whether rc.decltype[i] is any of date, datetime or timestamp but in my case it's timestamp with time zone causing the value to not be converted from a string.
With a column of type "timestamp with time zone", like in the following table, sqlite3 doesn't convert it into a time.Time and scanning such a row into a time.Time field therefore fails.
I traced this to
SQLiteRows.nextSyncLocked()
where you check whetherrc.decltype[i]
is any ofdate
,datetime
ortimestamp
but in my case it'stimestamp with time zone
causing the value to not be converted from a string.go version:
go version go1.21.3 darwin/arm64
Code
The text was updated successfully, but these errors were encountered: