-
Notifications
You must be signed in to change notification settings - Fork 531
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Bug: .Bind() is not working properly when selecting specific columns #1309
Comments
Can you turn on |
These are the generated queries:
Generated Query:
Generated Query: |
The issue is not the When there is a join, the columns are aliased because it is assumed that you want to select values from multiple tables. Try something like this: type LimitedInfo struct {
ID string `boil:"id"`
Name string `boil:"name"`
EmailID string `boil:"email_id"`
}
var info []*Struct{
LimitedInfo `boil:"user,bind"`
}
err = db_models.NewQuery(qm.Select("user.id", "user.name", "user.email_id"), qm.From("user"), qm.InnerJoin("contact ON user.contact_number = contact.contact_number")).Bind(ctx, d.db, &info) |
What version of SQLBoiler are you using (
sqlboiler --version
)?SQLBoiler v4.15.0
What is your database and version (eg. Postgresql 10)
psql (PostgreSQL) 15.4
If this happened at generation time what was the full SQLBoiler command you used to generate your models? (if not applicable leave blank)
If this happened at runtime what code produced the issue? (if not applicable leave blank)
What is the output of the command above with the
-d
flag added to it? (Provided you are comfortable sharing this, it contains a blueprint of your schema)Please provide a relevant database schema so we can replicate your issue (Provided you are comfortable sharing this)
Further information. What did you do, what did you expect?
I am trying to execute sql query using db_models.NewQuery(..).Bind(...) to select some specific columns (not all '*') from my psql table but it is returning me results with all fields set to the default value of their datatype and not the actual value fetched from the table. However, when i am using queries.Raw(..).Bind(..) with the same query, it is working as expected and returning correct results. Below is the struct and the code snippet that i am executing:
This results in:
In the above results, 'info' has not been bound properly (its fields are not populated), but 'info1' has been bound properly.
The text was updated successfully, but these errors were encountered: