Issue with `Pageable` queries

[j-nc]

As described at https://stackoverflow.com/questions/78949941, it's not possible to use Pageable queries in @Repository methods because the standard query translation is wrong for Vertica specifically. It would be nice if you could provide an implementation that works for all (or at least relatively common) cases. The answer to the linked question provides a simple workaround for LIMIT and OFFSET commands, but this needs to be more thoroughly tested, and I'm not sure about the rest.

[manju-priya-ar]

@ajay-abrol2 , @bilalahmed-3, @oualib , @sitingren , @vertica-cla : This issue is observed when using the latest vertica dialect jar with hibernate 6.x. Please look into this issue.

[bilalahmed-3]

Hello, Currently am working in a different project,Request @ajay ***@***.***> to take it further. Thanks, Bilal Ahmed

…

________________________________ From: armanjupriya-er ***@***.***> Sent: 16 October 2024 20:31 To: vertica/hibernate-verticadialect ***@***.***> Cc: Bilal.a ***@***.***>; Mention ***@***.***> Subject: Re: [vertica/hibernate-verticadialect] Issue with `Pageable` queries (Issue #3) @ajay-abrol2<https://github.com/ajay-abrol2> , @bilalahmed-3<https://github.com/bilalahmed-3>, @oualib<https://github.com/oualib> , @sitingren<https://github.com/sitingren> , @vertica-cla<https://github.com/vertica-cla> : This issue is observed when using the latest vertica dialect jar with hibernate 6.x. Please look into this issue. — Reply to this email directly, view it on GitHub<#3 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BGD2NOOB2IRXR2G74KJSH4DZ3Z5V5AVCNFSM6AAAAABNW3MDB2VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIMJXGA4DSNZRHE>. You are receiving this because you were mentioned.Message ID: ***@***.***> Disclaimer: The information transmitted is intended only for recipient(s) to whom it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and then delete it. Disclaimer: The information transmitted is intended only for recipient(s) to whom it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you have received this in error, please contact the sender and then delete it.

[ajay-abrol2]

Hello,

I will work on this issue and will update repository accordingly.

Thanks & Regards,
Ajay Abrol

[manju-priya-ar]

Hello,

I will work on this issue and will update repository accordingly.

Thanks & Regards, Ajay Abrol

Thanks @ajay-abrol2