bookshelf generating wrong query in strapi v3.2.0

[marefati110]

Describe the bug

i update strapi from 3.1.7 to 3.2.0 and have a problem with bookshelf
bookshelf generate wrong query

query = await strapi
      .query('doctor')
      .model.query((qb) => {
        qb.where('doctors.id', '=', doctor);
      })
      .fetch({
        withRelated: [
          {
            'offices.healthcenter': (qb) => {
              qb.debug();
              qb.columns([
                'healthcenters.id',
                'healthcenters.name',
                'healthcenters.about',
                'healthcenters.adress',
                'healthcenters.location',
                'healthcenters.type',
              ]);
            },
          },
        ],
      });

in strapi v3.1.7 generate this query

select `healthcenters`.`id`, `healthcenters`.`name`, `healthcenters`.`about`, `healthcenters`.`adress`, `healthcenters`.`location`, `healthcenters`.`type` from `healthcenters` where `healthcenters`.`id` in (?)

and its right
but in strapi v3.2.0 generate this query

select `healthcenters`.`id`, `healthcenters`.`name`, `healthcenters`.`about`, `healthcenters`.`adress`, `healthcenters`.`location`, `healthcenters`.`type` from `offices` where `offices`.`doctor` in (?)

so make error

error Error: select `healthcenters`.`id`, `healthcenters`.`name`, `healthcenters`.`about`, `healthcenters`.`adress`, `healthcenters`.`location`, `healthcenters`.`type` from `offices` where `offices`.`doctor` in (308519) - ER_BAD_FIELD_ERROR: Unknown column 'healthcenters.id' in 'field list'

when i change strapi to 3.1.7 there is no problem

Expected behavior
Expected that generate same sql query

System

• Node.js version: v12
• NPM version: v6
• Strapi version: v3.2.0
• Database: mysql
• Operating system: centos7

[alexandrebodin]

Hello, thanks for the report, can you share your Model.settings.json for thos three models so we can reproduce it ?

[marefati110]

@alexandrebodin i build a repo that have models
https://github.com/marefati110/models