Open WestleyK opened 7 months ago
When using InnerJoin(), pika will sometimes rename the table name in the query. This can cause an issue when you want to filter by a value in that table, you need to manually debug the query to see what pika changed the table name too.
InnerJoin()
https://github.com/ctrliq/pika/blob/main/pika_psql_test.go#L1475C50-L1475C50
Notice join_model_foreign vs joinModelForeign.
join_model_foreign
joinModelForeign
CC @ikaneshiro, @mstg
When using
InnerJoin()
, pika will sometimes rename the table name in the query. This can cause an issue when you want to filter by a value in that table, you need to manually debug the query to see what pika changed the table name too.https://github.com/ctrliq/pika/blob/main/pika_psql_test.go#L1475C50-L1475C50
Notice
join_model_foreign
vsjoinModelForeign
.CC @ikaneshiro, @mstg