Bug: .Bind() is not working properly when selecting specific columns

[amangupta25]

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:

type LimitedInfo struct {
    ID      string `boil:"id"`
    Name    string `boil:"name"`
    EmailID string `boil:"email_id"`
}

var info []*LimitedInfo
var info1 []*LimitedInfo

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)
err = queries.Raw(`select user.id, user.name, user.email_id from user inner join contact ON user.contact_number = contact.contact_number`).Bind(ctx, d.db, &info1)

This results in:

info=[
  {
    ID="",
    Name="",
    EmailID="",
    
  },
  {
    ID="",
    Name="",
    EmailID="",
    
  }
]

info1=[
  {
    ID="1234",
    Name="abc",
    EmailID="abc@xyz"
  },
  {
    ID="5678",
    Name="def",
    EmailID="def@xyz"
  }
]

In the above results, 'info' has not been bound properly (its fields are not populated), but 'info1' has been bound properly.

[stephenafamo]

Can you turn on boil.DebugMode and share the generated queries for both?

[amangupta25]

These are the generated queries:

1. 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) :

Generated Query:
SELECT "user"."id" as "user.id", "user"."name" as "user.name", "user"."email_id" as "user.email_id" FROM "user" INNER JOIN contact ON user.contact_number = contact.contact_number;

2. err = queries.Raw(select user.id, user.name, user.email_id from user inner join contact ON user.contact_number = contact.contact_number).Bind(ctx, d.db, &info1) :

Generated Query:
select user.id, user.name, user.email_id from user inner join contact ON user.contact_number = contact.contact_number

[stephenafamo]

The issue is not the Bind the issue is the Join

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)