Open boozerxxl opened 7 years ago
I looked at the sources. I suppose FinalizeJoins()
works incorrectly if there are nested SELECT FROM
in the query (as the formula does) because FinalizeJoins()
doesn't properly determine From-Where clauses indices in the sql string with IndexOfCaseInsensitive()
in this case.
A simple fix is to use LastIndexOfCaseInsensitive
in this case to skip the nested queries. It resolves my issue but I am not sure if it is correct in all possible cases.
Your issue wording is a mix of bug report and support request. Better write it only as a bug report, if you intend it to be a bug report. For support request, better go on nh user group or Stack Overflow.
Hello all,
I am using JetDriver 2.0.0.1001 for MsAccess on Net 4.5 and with NHibernate 3.3.3.4001 I need some help to clarify why the following SQL text is post-processed incorrectly by JetDriver's
ConnectionProvider.Driver.GenerateCommand()
. I think it is related to the formula property I have, without it all is ok.NHibernate generated SQL passed to
AbstractBatcher.Generate
method (correct)Jet Driver result after its
_factory.ConnectionProvider.Driver.GenerateCommand
Is it a known problem ? Could you please give me a hint about a possible workaround if any? Thanks a lot.