useJoinTable: false on manyToOne relation break populate

[vietlongn]

Bug report

Required System information

• Node.js version: 16
• NPM version: 8.1.2
• Strapi version: 4.1.9
• Database: mysql/sqlite
• Operating system: windows

Describe the bug

Add "useJoinTable": false to manyToOne relation break population when combined with select

Steps to reproduce the behavior

1. Create audio content types with name attribute
2. Create playlist content type with name, format attributes
3. Create manyToOne relation on audio inversedBy audios on playlist, manually add "useJoinTable": false
4. Query make a simple query on audio, select name and populate playlist

const entries = await strapi.db.query('api::audio.audio').findMany({
      limit: 10,
      select: ['name'],
      populate: {
        playlist: {
          select: ['name']
        },
      },

    })

5. playlist not populated

[
  {
    "name": "a1",
    "id": 1,
    "playlist": null
  }
]

Expected behavior

playlist should be populated

[
  {
    "id": 1,
    "name": "a1",
    "playlist": {
      "name": "p1",
      "id": 1
    }
  }
]

Code snipets

audio schema:

{
  "kind": "collectionType",
  "collectionName": "audios",
  "info": {
    "singularName": "audio",
    "pluralName": "audios",
    "displayName": "audio",
    "description": ""
  },
  "options": {
    "draftAndPublish": true
  },
  "pluginOptions": {},
  "attributes": {
    "name": {
      "type": "string"
    },
    "playlist": {
      "type": "relation",
      "relation": "manyToOne",
      "target": "api::playlist.playlist",
      "inversedBy": "audios",
      "useJoinTable": false
    }
  }
}

playlist schema:

{
  "kind": "collectionType",
  "collectionName": "playlists",
  "info": {
    "singularName": "playlist",
    "pluralName": "playlists",
    "displayName": "playlist",
    "description": ""
  },
  "options": {
    "draftAndPublish": true
  },
  "pluginOptions": {},
  "attributes": {
    "name": {
      "type": "string"
    },
    "audios": {
      "type": "relation",
      "relation": "oneToMany",
      "target": "api::audio.audio",
      "mappedBy": "playlist"
    },
    "format": {
      "type": "enumeration",
      "enum": [
        "a",
        "b",
        "c"
      ]
    }
  }
}

Additional context

If select omitted, the playlist populated properly

[derrickmehaffy]

Where did you find the reference to "useJoinTable"? That's not an option we have documented and I'm about 95% sure it's not supported. 🤔

@alexandrebodin thoughts?

[vietlongn]

It's originally from here 12652

[alexandrebodin]

Hi this is an internal option you should not be using yourself indeed :)

[derrickmehaffy]

Going to mark this one as closed as usage of that flag is unstable and not supported.

[strapi-bot]

This issue has been mentioned on Strapi Community Forum. There might be relevant details there:

https://forum.strapi.io/t/relation-change-from-v3-to-v4/20609/7