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

[nhibernate-bot]

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)

• nhcontrib-hg_1657.patch.zip
• nhcontrib-hg_1658.patch.zip

---

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)

• NHibernate.JetDriver_51.patch.zip
• NHibernate.JetDriver_52.patch.zip

---

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

Use the original SQL string as cache key

• NHibernate.JetDriver_46.patch.zip