Incorrect field names quatation in query
When using 'database_name.table_name.field_name' as a field name in query it becomes
`database_name`.`table_name.field_name`.
Should be:
`database_name`.`table_name`.`field_name`
Thanks for reporting @Napas . Will take a look.
@usmanhalalit is alive xD
@eL-Prova hehe 😄 . Yep, coming back. Had serious eye surgeries, I had a retinal detachment.
(Y) I hope you are doing well
Any luck?
@Napas can you show us a practical use case where it is important to specify the database name? Thank you.
@TCB13 Joining tables from different databases.
QB::table('db1.some_table')->innerJoin( 'db2.some_table', 'db1.some_table.foreign_key', '=', 'db2.some_table.primary_key' )
Aliasing table names might be a workaround for that, but still, it is a workaround.