Comments (3)
To complete this:
DB.Where(models.User{Email: ""}).First(&user)
will also return the first user, that's really not a good idea :)
from gorm.
This is caused by golang's limitation, string's default value is "" but not nil. so for gorm
DB.Where(models.User{Email: ""}).First(&user)
is same as
DB.Where(models.User{}).First(&user)
in order to avoid this issue, you should write the query like this:
DB.Where("email = ?", "").First(&user)
But please reopen the issue if you have any suggestions, thank you.
from gorm.
Thanks for the explanation!
This could have maybe a small reference in the readme?
from gorm.
Related Issues (20)
- Duplicate records with the same primary key returned in a short period of time HOT 2
- postgres use gorm v1.25.9 生成的update语句有误 HOT 4
- i get a error : ERROR: prepared statement "lrupsc_1_20" already exists, and plansource is not the same. HOT 1
- AutoMigrate to add primary key is not working HOT 3
- how do hook before select query on target tables HOT 2
- Support cloudflare D1 database
- How to access other field of the model in custom serializer HOT 1
- Behavior of `.Not(Where().Or())` has changed HOT 1
- Many2Many Relation Produces Unwanted `where` Condition HOT 14
- ON DUPLICATE KEY UPDATE 未按预期工作 HOT 1
- sqlite: primary key contstraint gets lost when embedded struct also contains primary key HOT 2
- ID Primary Key of type string does not return value on DB.Create() HOT 2
- [signal SIGSEGV: segmentation violation code=0x80 addr=0x0 pc=0x7e2fda HOT 2
- Error 1064 (HY000): Unsupported command(COM_STMT_PREPARE) HOT 2
- sqlite automirate failed by "near "unsigned": syntax error" HOT 3
- Support for Many to Many Preload Joins
- GORM可以只创建表不创建索引么? HOT 6
- Noticed a bug with embedded structs not being nil HOT 1
- `unsupported data` error with nested joins/preloads
- Correlate BelongTo HOT 12
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 gorm.