ucast icon indicating copy to clipboard operation
ucast copied to clipboard

Published 20 hours ago • verified publisher icon stalniy

Columns reference can be ambigous

Open ccatterina opened this issue 3 years ago • 3 comments

Interpreter can translate a condition in a SQL Query with ambigous column names. This can happen when the condition is based on both a related table fields and the main table fields.

A solution could be to prefix all the fields in the where condition with the main table alias. What do you think about it?

ccatterina avatar Jun 21 '21 14:06 ccatterina

There is alpha branch, I think it should be fixed there.

stalniy avatar Jun 22 '21 06:06 stalniy

It has more changes than you can see in master. But they all relates to sql generation not to ORM integrations so very likely ORM parts should be adjusted

stalniy avatar Jun 22 '21 06:06 stalniy

Yeah, I saw the alpha branch, I've made the last tests with that. This issue and #25 refer to the alpha branch.

BTW: Thank you for your work on casl, it's really awesome! 😃

ccatterina avatar Jun 22 '21 07:06 ccatterina