Skip to content

NH-2208 - Error with filters on joined-subclass as many-to-one #1215

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
nhibernate-bot opened this issue Oct 12, 2017 · 1 comment · Fixed by #2545
Closed

NH-2208 - Error with filters on joined-subclass as many-to-one #1215

nhibernate-bot opened this issue Oct 12, 2017 · 1 comment · Fixed by #2545
Labels
c: Core migrated p: Major r: Fixed t: Bug
Milestone
5.4

Comments

@nhibernate-bot
Copy link
Collaborator

nhibernate-bot commented Oct 12, 2017 •
edited by hazzik
Loading

felice Pollano created an issue — 24th May 2010, 8:34:39:

Using filters on entities, when those entities belong to a
hierarchy, and we query for another entity having many-to-one
association to the "filtered" entity, we obtain the following error:

----> System.Data.SqlClient.SqlException : The multi-part identifier
"subofrefer1_1_.P1 does not exist"

Attached there is a unit test to dempostrate the issue. The test requires a Database named FILTERS on a local MSSQL(Express) instance. One of the test creates the DB schema required, the other show the exception.

Fabio Maulo added a comment — 27th July 2010, 13:19:34:

Decoded failing test committed on trunk
@bahusoid
Copy link
Member

Looks very similar to #1209

This was referenced Sep 10, 2020
Merged
Merged
hazzik pushed a commit that referenced this issue Oct 23, 2020
@bahusoid
Add support for table group joins for subclasses in Criteria (#2545)
f98c463 
Fixes #1209, fixes #1215
@hazzik hazzik added this to the next minor milestone Oct 23, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
c: Core migrated p: Major r: Fixed t: Bug
Projects
None yet
Milestone
5.4
Development

Successfully merging a pull request may close this issue.

Table group joins for subclasses in Criteria bahusoid/nhibernate-core
3 participants
@hazzik @nhibernate-bot @bahusoid