Comments (10)
So are these fields NULL
?
from mysql.
It's a database/sql
issue, which provides no NullTimeValue
.
Have a look at issue #9 (esp. the part The driver gets no information about the destination type).
from mysql.
Yes it's NULL. As for not being able handle this kind of renders the time.Time support useless? Unless there is some workaround that does indeed use the recently added support for time.Time as oppose to manual string conversion.
from mysql.
You could make the timestamp non-null in the table and use a "marker time". It could even be faster that way.
I know, this advice sucks - but database/sql
is not that good at supporting NULL
able columns (yet?).
from mysql.
I'll add a NullTime
type to the driver later
from mysql.
Just for reference:
The PostreSQL driver uses this NullTime
from mysql.
Thanks for that bit of info.. but I really am not sure how to implement this so I will just wait for an official fix to this repo and in the meantime will make the mysql field as non-NULL. This defaults to 0000-00-00 00:00:00
from mysql.
That was intended as a reference for whoever implements NullTime (probably Julien), not for users of the driver 😀 .
from mysql.
*Juli_e_n
See #63 ;)
from mysql.
Your issue would be...? (thank the Octocat for the edit function...)
from mysql.
Related Issues (20)
- Cut a new v1.7.2 release HOT 14
- Potential out of bound access in `(*mysqlConn).handleErrorPacket` HOT 7
- Toggle Click in Leaderboards
- mysql startWatcher panic error HOT 3
- Bizarre hanging issue in rows.Close() HOT 7
- Can't Install, bug in edwards25519/scalar.go HOT 1
- Likely race that can prevent to recycle closed connections HOT 5
- Return timeout error instead of Invalid connection err when read packet network timeout HOT 5
- 保存时报错:Prepared statement contains too many placeholders
- too may ram usage when lost connection HOT 13
- SEGV writing packet HOT 1
- Connection liveness/goodeness check and AWS Aurora HOT 1
- Data race between mysqlConn watcher and okHandler during context cancellation HOT 3
- v1.6.0 get error
- Data race between mysqlConn.cleanup() and writeHandshakeResponsePacket HOT 2
- MaxOpenConns is not working
- Receiving "(using password: NO)" when password was given HOT 2
- Why must use port 3306?
- Scanner should return one of int64,float64,bool,[]byte,string,time.Time,nil , but I got uint64 HOT 3
- Do I need logic backup mysql data using mysqldump while I have master-slave mysql cluster.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mysql.