JetBrains / Exposed

Kotlin SQL Framework
http://jetbrains.github.io/Exposed/
Apache License 2.0
8.05k stars 674 forks source link

fix: EXPOSED-353 dateLiteral does not work on OracleDB 12c or 19c #2057

Closed obabichevjb closed 2 months ago

obabichevjb commented 2 months ago

Here is the fix for usage date literals with Oracle DB. PR adds an explicit date format for date literals, because the default format is parametrized in DB, and can be different from the one we use.

obabichevjb commented 2 months ago

Added tests kotin-datetime. This MR should fix the initial problem with date literals, but looks like there are some other problems related to the time literals like the one EXPOSED-363 [Oracle] LocalTime and literal(LocalTime) are not the same. So I'd continue to fix it during fixing EXPOSED-363