Relationship with different types of column

[alexandre-freret]

Package version

21.1.0

Describe the bug

Hello,

I have a problem when i used relationship with 2 differents types of columns. The database used is not mine. I recreate 2 tables to explain the problem.

Example : Table teams:

• id_varchar (varchar(3))
• id_char (char(3))
• name (varchar(250))

Table users:

• id (int)
• name (varchar(250))
• team (char(3))

In the teams table, the id_varchar has a space at the end, and it's the problem, when i preload the relationship with the id_char it's works, but when i preload with id_varchar it's doesn't works. When i execute the query like SELECT * from `teams` where `id_varchar` in ('01', '02') it's works.

Do you have any idea ? There is a repo with my example code, with the sql too : https://github.com/alexandre-freret/adonis-example

Thanks

Reproduction repo

https://github.com/alexandre-freret/adonis-example

[thetutlage]

This is not possible at the Lucid level and we might never support it. Sorry, the datatypes have to be the same