pixie icon indicating copy to clipboard operation
pixie copied to clipboard

Incorrect field names quatation in query

Open Napas opened this issue 8 years ago • 7 comments

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`

Napas avatar Apr 03 '17 09:04 Napas

Thanks for reporting @Napas . Will take a look.

usmanhalalit avatar Apr 03 '17 09:04 usmanhalalit

@usmanhalalit is alive xD

eL-Prova avatar Apr 03 '17 09:04 eL-Prova

@eL-Prova hehe 😄 . Yep, coming back. Had serious eye surgeries, I had a retinal detachment.

usmanhalalit avatar Apr 03 '17 09:04 usmanhalalit

(Y) I hope you are doing well

eL-Prova avatar Apr 03 '17 10:04 eL-Prova

Any luck?

Napas avatar Apr 13 '17 14:04 Napas

@Napas can you show us a practical use case where it is important to specify the database name? Thank you.

TCB13 avatar Nov 25 '17 13:11 TCB13

@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.

Napas avatar Dec 13 '17 12:12 Napas