You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
would generate something like this: SELECT * FROM v_messages AS messages LEFT JOIN v_user AS v_alias ON v_alias.id = v_messages.user_id
but I think SELECT * FROM v_messages AS messages LEFT JOIN v_user AS alias ON alias.id = messages.user_id
would be the logically expected version.
The text was updated successfully, but these errors were encountered:
When using a table prefix and join aliases, the prefix gets added to the aliases. I think this is a bug.
This example code:
would generate something like this:
SELECT * FROM v_messages AS messages LEFT JOIN v_user AS v_alias ON v_alias.id = v_messages.user_id
but I think
SELECT * FROM v_messages AS messages LEFT JOIN v_user AS alias ON alias.id = messages.user_id
would be the logically expected version.
The text was updated successfully, but these errors were encountered: