Hi Walid, That's surprising, there isn't a direct link between interpreting (DDL) and parsing. Can you show some example code that helps reproduce what you're seeing? Perhaps there's a more complex interaction in your setup that can't be easily derived from your description.
Thanks, Lukas On Thu, Apr 1, 2021 at 3:11 PM Walid CHAIB <[email protected]> wrote: > When I don't specify the interpreter dialect Joqq doesn't parse the oracle > function like nvl and decode ... > > Le jeu. 1 avr. 2021 à 13:27, Lukas Eder <[email protected]> a écrit : > >> Hi Walid, >> >> You can safely ignore the interpreter dialect. It has nothing to do with >> your current work. You only need to work with the parse dialect. But that >> is only used to resolve ambiguous syntax (e.g. select a = b in PostgreSQL >> vs SQL Server). >> >> Now, let's rewind and look at what you're actually trying to do? >> >> Cheers, >> Lukas >> >> On Thu, Apr 1, 2021 at 1:46 PM Walid CHAIB <[email protected]> >> wrote: >> >>> Hi Lukas, >>> >>> Is there a parameter I have to set it, so I can parse cast functions ( >>> to_char(),to_number() ...) to cast( x as varchar ) , cast (x as int) >>> because when specifying >>> .withInterpreterDialect(SQLDialect.POSTGRES_12), jooq doesn't parse it, and >>> when i didn't specify the dialect interpreter i get problems with parsing >>> other functions like decode ? >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "jOOQ User Group" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/jooq-user/CAOP4XxiF9P6aaD%2Bb6pwO8mPsUe_GpCxuytzs6b1Y5UFnHefFBw%40mail.gmail.com >>> <https://groups.google.com/d/msgid/jooq-user/CAOP4XxiF9P6aaD%2Bb6pwO8mPsUe_GpCxuytzs6b1Y5UFnHefFBw%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "jOOQ User Group" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/jooq-user/CAB4ELO7%3DLVVA_ByhWW3oqMfF07GjUd156GcAfjmMUZYtsYVqow%40mail.gmail.com >> <https://groups.google.com/d/msgid/jooq-user/CAB4ELO7%3DLVVA_ByhWW3oqMfF07GjUd156GcAfjmMUZYtsYVqow%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/CAOP4Xxhr1aUvCbA6ewyfTYKSrd3rcMfJpHD56EcgJXdLY4qJmg%40mail.gmail.com > <https://groups.google.com/d/msgid/jooq-user/CAOP4Xxhr1aUvCbA6ewyfTYKSrd3rcMfJpHD56EcgJXdLY4qJmg%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO4G%3Dt4L3YJ%2BoS%3DLUSEiWTrr7fzgOG6VgnERQM7LQ6TfDQ%40mail.gmail.com.
