SQL EXISTS and exists-based JOIN

[annda...@gmail.com]

Hi, I saw an old post and example that demonstrate how the library supports exists-based JOIN using CQN syntax.  

When specifying the join via SQL WHERE EXISTS, I get the following error inside the SQLParser: 

Request was not successful: Failed to parse query at line 1:30: extraneous input 'EXISTS' expecting {'(', K_NOT, IDENTIFIER, STRING_LITERAL}

Does the SQLParser not support any join operation?

Thanks,

Ann

[Niall Gallagher]

Neither the CQN nor the SQL dialects support joins actually.

To do JOINs you will need to use the programmatic API because each IndexedCollection is not aware of other IndexedCollections, so the only way to combine them in a query is via the programmatic API.

You can find the grammars for the supported queries here:

https://github.com/npgall/cqengine/blob/master/code/src/main/antlr4/com/googlecode/cqengine/query/parser/cqn/grammar/CQNGrammar.g4

https://github.com/npgall/cqengine/blob/master/code/src/main/antlr4/com/googlecode/cqengine/query/parser/sql/grammar/SQLGrammar.g4

Sent from my Android

--
-- You received this message because you are subscribed to the "cqengine-discuss" group.
http://groups.google.com/group/cqengine-discuss
---
You received this message because you are subscribed to the Google Groups "cqengine-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cqengine-discu...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[annda...@gmail.com]

Thanks for confirming Niall!