Jinq icon indicating copy to clipboard operation
Jinq copied to clipboard

Published 20 hours ago • verified publisher icon my2iu

EXISTS

Open my2iu opened this issue 7 years ago • 4 comments

Add a way to generate EXISTS queries because it's faster for some databases.

my2iu avatar Apr 18 '17 01:04 my2iu

Hello. Is there any plan about this feature?

lvv83 avatar Aug 14 '22 08:08 lvv83

I didn’t have any particular plans for it, but if you need the feature, then I can try to take a look later this month.

my2iu avatar Aug 14 '22 14:08 my2iu

I would appreciate for this. Thank you!

lvv83 avatar Aug 14 '22 14:08 lvv83

Just a reference note about EXISTS queries in JPQL so it's easy to find later:

https://jakarta.ee/specifications/persistence/3.0/jakarta-persistence-spec-3.0.html#exists-expressions

my2iu avatar Aug 15 '22 21:08 my2iu

I've added an .exists() method to streams that will be translated into EXISTS subqueries. I've built new Maven versions with support for this, but I still need to work on documentation fixups and updating the website.

my2iu avatar Aug 27 '22 04:08 my2iu

Documentation has now been updated, so support for exists() should now be complete.

my2iu avatar Aug 30 '22 00:08 my2iu