mattn / mattn/go-sqlite3

storing driver.Value type string into type *time.Time

Open
#951 5 comments 8 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
C
Stars
9.2k
Forks
1.2k
Avg merge
19m
Merged PRs (30d)
4

Description

Hello all,
I am trying to rebuild an application with the RETURNING clause introduced in version 3.35.

https://www.sqlite.org/lang_returning.html

However, I always get an error that it does not match the data types unsupported Scan, storing driver.Value type string into type *time.Time.

I have reproduced the whole thing in the following projects and would like you to have a look at it to tell me if it is a bug of mine or if the library can't handle it.

https://github.com/volker-raschek/go-sqlite3-time

Contributor guide

No contributing guide indexed for this repository

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 with the linked go-sqlite3-time reproduction and trace the SQLite RETURNING result through database/sql scanning. Compare the returned value with the destination *time.Time and determine whether the driver mishandles it or the reproduction is incorrect; done means the cause is established and a fix or clear guidance is identified.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, sqlite
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.