You can specify the Settings.parseUnknownFunctions flag to tell jOOQ's parser to ignore unknown scalar functions
On Mon, Mar 18, 2024 at 2:07 PM deepankar gupta < deepankargupta1...@gmail.com> wrote: > Hi Lukas, > > Does jooq parser support other than user-defined table valued functions > like functions which has return type as text or boolean? > > Regards > Deepankar Gupta > > On Monday, March 18, 2024 at 6:31:23 PM UTC+5:30 lukas...@gmail.com wrote: > >> Hi Deepankar, >> >> Thank you for your message. Our parser doesn't support user-defined table >> valued functions yet, see: >> https://github.com/jOOQ/jOOQ/issues/16200 >> >> But you can implement your own ParseListener to intercept the parsing of >> Table expression and implement your own behaviour easily: >> >> https://www.jooq.org/doc/latest/manual/sql-building/sql-parser/sql-parser-listener/ >> >> I hope this helps, >> Lukas >> >> On Mon, Mar 18, 2024 at 1:53 PM deepankar gupta <deepankar...@gmail.com> >> wrote: >> >>> Hi Lukas, >>> >>> We have a custom sql having table valued function in it which we are >>> trying to parse in jooq using parseSelect ` >>> context.parser().parseSelect(customViewSQL);`. >>> >>> When we have custom sql like this: >>> *SELECT * FROM Table_valued_function ('Al%');* >>> Error: It is not able recognize Table valued function >>> >>> When we have custom sql like this >>> *SELECT Table_valued_function ('Al%');* It is working fine but not in >>> desired format. We are expecting it in table and it is coming as tuple. >>> >>> >>> Regards >>> Deepankar Gupta >>> >>> -- >>> 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 jooq-user+...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/jooq-user/38608a57-757d-4882-ac85-eae8edf82bcdn%40googlegroups.com >>> <https://groups.google.com/d/msgid/jooq-user/38608a57-757d-4882-ac85-eae8edf82bcdn%40googlegroups.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 jooq-user+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/7b9f6ebc-2efc-4b8f-9acc-f5b6b426e116n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/7b9f6ebc-2efc-4b8f-9acc-f5b6b426e116n%40googlegroups.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 jooq-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO7%3DF%3DR%2BkwYceBALg4a8BLqvj%2B-ftnLh2i77WBv0igbV8w%40mail.gmail.com.
