Default pivot table is not well referenced for ManyToMany relationship

[tnga]

Package version

14.2.0

Node.js and npm version

node 14.16.0 & npm 6.14.11

Given the following code with ManyToMany relationship between users table and roles table through user_role table,
Adonis may understand to reference the table user_role by default but it seems to reference a the table user_user_role instead. Maybe a double concatenation issue of the pivotForeign table (here the table users) ?

Sample Code (to reproduce the issue)

/// UserModel.ts
import {
  BaseModel,
  manyToMany,
  ManyToMany,
} from '@ioc:Adonis/Lucid/Orm'

import UserRole from 'App/Models/UserRole'
export default class User extends BaseModel {
  @manyToMany(() => UserRole)
  public roles: ManyToMany<typeof UserRole>
}

/// UserSeeder.ts
 import BaseSeeder from '@ioc:Adonis/Lucid/Seeder'
 import Role from 'App/Models/Role'
 import User from 'App/Models/User'

 export default class ManagerSeeder extends BaseSeeder {
  public async run() {
   const admin = new User()
   const admRole = await Role.findBy('tag', 'administrator')
   await admin.save()
   await admin.related('roles').attach([admRole.id]) // got error
   // error: insert into `user_user_role` (`user_id`, `user_role_id`) values (1, 3) 
   // - ER_NO_SUCH_TABLE: Table 'projectdb.user_user_role' doesn't exist
  }
 }

NB: The alternative solution is to use custom pivotTable. But the default behavior have to be sufficient.

[RomainLanz]

Hey @tnga! 👋

Table's name are defined from the model name.

Since your model is named UserRole, the table will be named user_roles. Therefore, a ManyToMany with User will ended up being user_user_role.

[thetutlage]

Closing since not actionable. Please use discussion threads to clear your doubts

[tnga]

Yah! thanks @RomainLanz , well notice @thetutlage .