Skip to content

Undefined join type failure with cross joins and Informix #3294

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.

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

Closed
robsosno opened this issue Apr 26, 2023 · 4 comments
Closed

Undefined join type failure with cross joins and Informix #3294

robsosno opened this issue Apr 26, 2023 · 4 comments

Comments

@robsosno
Copy link

After simplification I have following LINQ query:

        var q = from c in Orm.DB.Cards
                from s in Orm.DB.Services
                where c.Id == 1 && s.RowSerno == c.Id
                select s;

Entities Cards and Services are unrelated, i.e. there is no Many-to-one or bag on either side. s.Rowserno is not a primary key of Services entity neither is part of it. c.Id is primary key.
Previously it worked without problems. After upgrade I have "undefined join type" error.
Stack trace attached:
err1.txt

What does it mean "upgrade":
Previously I had .NET Core 3.1, NHibernate 5.2.5.0, database Informix, driver IBM.Data.DB2.Core 3.1.0.500
Now I have .NET 6.0, NH 5.4.1.0, same database, driver Net.IBM.Data.Db2 6.0.0.300

Similar problem is with JoinEntityAlias. I'll create separate issue as I'm not sure if this is the same problem or not.

@bahusoid
Copy link
Member

What dialect is used? Try with InformixDialect1000

@robsosno
Copy link
Author

Good point, I haven't noticed that I have NHibernate.Dialect.InformixDialect . Of course it should be InformixDialect1000.
Tomorrow I'll check this. Thanks!

@robsosno
Copy link
Author

After changing dialect everything works as expected. It was just copied from older code and I forgot about this.
I know that original dialect implemented Informix-specific join syntax because ANSI joins were not supported (very long time ago). Possible that some changes broke that code.
I think that the issue can be closed. It is quite possible that very few people need fix in old dialect if any at all.

@bahusoid
Copy link
Member

Fixed by #3313

@fredericDelaporte fredericDelaporte changed the title undefined join type AssertionFailure Undefined join type failure with cross joins and Informix Jun 11, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants