Thread: [nhibernate-issues] [JIRA] Created: (NH-1642) one-to-many collection doesn't work if the child is m

Brought to you by: ayenderahien, bahusoid, fabiomaulo, fdelaporte, and 5 others

nhibernate-issues

[nhibernate-issues] [JIRA] Created: (NH-1642) one-to-many collection doesn't work if the child is mapped using table per class

From: NHibernate J. <nh...@gm...> - 2009-01-10 01:50:33

one-to-many collection doesn't work if the child is mapped using table per class
--------------------------------------------------------------------------------

                 Key: NH-1642
                 URL: http://jira.nhibernate.org/browse/NH-1642
             Project:  NHibernate
          Issue Type: Bug
          Components: Core
    Affects Versions:  2.0.1.GA
            Reporter: Kiran Gawde
            Priority: Major
         Attachments: KGTest.rar

In the attached example, I have parent object TrafficRuleSet. It contains list of TrafficRule. TrafficRule has a backpointer to TrafficRuleSet. Also, TrafficRule is subclassed from AbstractRule. These are represented with three different tables.

Now, when you try to retrieve the TrafficRuleSet and associated TrafficRules, it generates following query:
select * from Traffic_RuleSet where gr.ruleset_id = '3'
select * from Generic_Rule gr inner join Traffic_Rule tr on gr.rule_id = tr.rule_id where gr.ruleset_id = '3'
(Note: Above sqls are simplied for clarity.)

The second sql above is wrong. It should have been:
select * from Generic_Rule gr inner join Traffic_Rule tr on gr.rule_id = tr.rule_id where tr.ruleset_id = '3'


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Commented: (NH-1642) one-to-many collection doesn't work if the child is mapped using table per class

From: NHibernate J. <nh...@gm...> - 2009-01-10 22:08:06

    [ http://jira.nhibernate.org/browse/NH-1642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17461#action_17461 ] 

Fabio Maulo commented on NH-1642:
---------------------------------

Please, do you can send us a NUnit testCase instead a complete solution including R# files ?

This link may help you:
http://nhforge.org/blogs/nhibernate/archive/2008/10/04/the-best-way-to-solve-nhibernate-bugs-submit-good-unit-test.aspx

Thanks.



> one-to-many collection doesn't work if the child is mapped using table per class
> --------------------------------------------------------------------------------
>
>                 Key: NH-1642
>                 URL: http://jira.nhibernate.org/browse/NH-1642
>             Project:  NHibernate
>          Issue Type: Bug
>          Components: Core
>    Affects Versions:  2.0.1.GA
>            Reporter: Kiran Gawde
>            Priority: Major
>         Attachments: KGTest.rar
>
>
> In the attached example, I have parent object TrafficRuleSet. It contains list of TrafficRule. TrafficRule has a backpointer to TrafficRuleSet. Also, TrafficRule is subclassed from AbstractRule. These are represented with three different tables.
> Now, when you try to retrieve the TrafficRuleSet and associated TrafficRules, it generates following query:
> select * from Traffic_RuleSet where gr.ruleset_id = '3'
> select * from Generic_Rule gr inner join Traffic_Rule tr on gr.rule_id = tr.rule_id where gr.ruleset_id = '3'
> (Note: Above sqls are simplied for clarity.)
> The second sql above is wrong. It should have been:
> select * from Generic_Rule gr inner join Traffic_Rule tr on gr.rule_id = tr.rule_id where tr.ruleset_id = '3'

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Updated: (NH-1642) one-to-many collection doesn't work if the child is mapped using table per class

From: NHibernate J. <nh...@gm...> - 2009-05-17 21:39:39

     [ http://nhjira.koah.net/browse/NH-1642?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tuna Toksoz updated NH-1642:
----------------------------

    Issue Type: Sub-task  (was: Bug)
        Parent: NH-1747

> one-to-many collection doesn't work if the child is mapped using table per class
> --------------------------------------------------------------------------------
>
>                 Key: NH-1642
>                 URL: http://nhjira.koah.net/browse/NH-1642
>             Project:  NHibernate
>          Issue Type: Sub-task
>          Components: Core
>    Affects Versions:  2.0.1.GA
>            Reporter: Kiran Gawde
>            Priority: Major
>         Attachments: KGTest.rar
>
>
> In the attached example, I have parent object TrafficRuleSet. It contains list of TrafficRule. TrafficRule has a backpointer to TrafficRuleSet. Also, TrafficRule is subclassed from AbstractRule. These are represented with three different tables.
> Now, when you try to retrieve the TrafficRuleSet and associated TrafficRules, it generates following query:
> select * from Traffic_RuleSet where gr.ruleset_id = '3'
> select * from Generic_Rule gr inner join Traffic_Rule tr on gr.rule_id = tr.rule_id where gr.ruleset_id = '3'
> (Note: Above sqls are simplied for clarity.)
> The second sql above is wrong. It should have been:
> select * from Generic_Rule gr inner join Traffic_Rule tr on gr.rule_id = tr.rule_id where tr.ruleset_id = '3'

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://nhjira.koah.net/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Commented: (NH-1642) one-to-many collection doesn't work if the child is mapped using table per class

From: NHibernate J. <nh...@gm...> - 2009-05-17 21:40:00

    [ http://nhjira.koah.net/browse/NH-1642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17959#action_17959 ] 

Tuna Toksoz commented on NH-1642:
---------------------------------

Made it sub-task of NH-1747 as I believe they are basically the same issue.

> one-to-many collection doesn't work if the child is mapped using table per class
> --------------------------------------------------------------------------------
>
>                 Key: NH-1642
>                 URL: http://nhjira.koah.net/browse/NH-1642
>             Project:  NHibernate
>          Issue Type: Sub-task
>          Components: Core
>    Affects Versions:  2.0.1.GA
>            Reporter: Kiran Gawde
>            Priority: Major
>         Attachments: KGTest.rar
>
>
> In the attached example, I have parent object TrafficRuleSet. It contains list of TrafficRule. TrafficRule has a backpointer to TrafficRuleSet. Also, TrafficRule is subclassed from AbstractRule. These are represented with three different tables.
> Now, when you try to retrieve the TrafficRuleSet and associated TrafficRules, it generates following query:
> select * from Traffic_RuleSet where gr.ruleset_id = '3'
> select * from Generic_Rule gr inner join Traffic_Rule tr on gr.rule_id = tr.rule_id where gr.ruleset_id = '3'
> (Note: Above sqls are simplied for clarity.)
> The second sql above is wrong. It should have been:
> select * from Generic_Rule gr inner join Traffic_Rule tr on gr.rule_id = tr.rule_id where tr.ruleset_id = '3'

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://nhjira.koah.net/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

[nhibernate-issues] [JIRA] Commented: (NH-1642) one-to-many collection doesn't work if the child is mapped using table per class

From: NHibernate J. <nh...@gm...> - 2009-06-06 23:43:16

    [ http://nhjira.koah.net/browse/NH-1642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18131#action_18131 ] 

Fabio Maulo commented on NH-1642:
---------------------------------

@Tuna or @Kiran
Can you extract a test case without all others stuff (as DAOs, NHibernateHelper etc.) following the link above ?
Thanks.

> one-to-many collection doesn't work if the child is mapped using table per class
> --------------------------------------------------------------------------------
>
>                 Key: NH-1642
>                 URL: http://nhjira.koah.net/browse/NH-1642
>             Project:  NHibernate
>          Issue Type: Sub-task
>          Components: Core
>    Affects Versions:  2.0.1.GA
>            Reporter: Kiran Gawde
>            Priority: Major
>         Attachments: KGTest.rar
>
>
> In the attached example, I have parent object TrafficRuleSet. It contains list of TrafficRule. TrafficRule has a backpointer to TrafficRuleSet. Also, TrafficRule is subclassed from AbstractRule. These are represented with three different tables.
> Now, when you try to retrieve the TrafficRuleSet and associated TrafficRules, it generates following query:
> select * from Traffic_RuleSet where gr.ruleset_id = '3'
> select * from Generic_Rule gr inner join Traffic_Rule tr on gr.rule_id = tr.rule_id where gr.ruleset_id = '3'
> (Note: Above sqls are simplied for clarity.)
> The second sql above is wrong. It should have been:
> select * from Generic_Rule gr inner join Traffic_Rule tr on gr.rule_id = tr.rule_id where tr.ruleset_id = '3'

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://nhjira.koah.net/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

[nhibernate-issues] [NHJIRA] Resolved: (NH-1642) one-to-many collection doesn't work if the child is mapped using table per class

From: Fabio M. (JIRA) <nh...@gm...> - 2011-04-23 20:38:29

     [ http://216.121.112.228/browse/NH-1642?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fabio Maulo resolved NH-1642.
-----------------------------

       Resolution: Fixed
    Fix Version/s: 3.2.0Alpha3

Fixed fixing NH-1747

> one-to-many collection doesn't work if the child is mapped using table per class
> --------------------------------------------------------------------------------
>
>                 Key: NH-1642
>                 URL: http://216.121.112.228/browse/NH-1642
>             Project:  NHibernate
>          Issue Type: Sub-task
>          Components: Core
>    Affects Versions:  2.0.1.GA
>            Reporter: Kiran Gawde
>            Priority: Major
>             Fix For: 3.2.0Alpha3
>
>         Attachments: KGTest.rar
>
>
> In the attached example, I have parent object TrafficRuleSet. It contains list of TrafficRule. TrafficRule has a backpointer to TrafficRuleSet. Also, TrafficRule is subclassed from AbstractRule. These are represented with three different tables.
> Now, when you try to retrieve the TrafficRuleSet and associated TrafficRules, it generates following query:
> select * from Traffic_RuleSet where gr.ruleset_id = '3'
> select * from Generic_Rule gr inner join Traffic_Rule tr on gr.rule_id = tr.rule_id where gr.ruleset_id = '3'
> (Note: Above sqls are simplied for clarity.)
> The second sql above is wrong. It should have been:
> select * from Generic_Rule gr inner join Traffic_Rule tr on gr.rule_id = tr.rule_id where tr.ruleset_id = '3'

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira