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

NHCD-44 - JetDriver: Replace CASE expressions with something that's understandable by Access #10

Open

nhibernate-bot opened this issue May 19, 2017 · 0 comments

nhibernate-bot commented May 19, 2017

Mark Junker created issue - 21/Oct/11 12:25 AM

The first patch simplifies the SQL transformation function.

The second patch has the following effect:
Change all (case when ... then ... else ... end) expressions into something like:
IIf(IsNull(Switch(when_1, then_1, ... when_n, then_n)), else, Switch(when_1, then_1, ... when_n, then_n))
or (when no "else" part exists):
Switch(when_1, then_1, ... when_n, then_n)

Mark Junker added a comment - 24/Oct/11 9:07 PM

This patch moves the CASE conversion to the top of the function. It also renames the function to something more suitable.

nhcontrib-hg_1659.patch.zip

Mark Junker added a comment - 25/Oct/11 10:31 PM

Fixes problems with the created Switch statements (multiple and duplicate WHEN parts)

Mark Junker added a comment - 25/Oct/11 10:34 PM

Use the original SQL string as cache key

NHibernate.JetDriver_46.patch.zip

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment