Hey Riccardo, thanks for your response,
well now I know know why you always get an result. You always use "*OR*" to
combine the results. For sure that works great and gives back results.
But what I need is that I want to get all IDs where the symbols are both ('
*B62D*' AND '*B60*') matching that ID. So instead take *AND*, I think *DISTINCT
*and *OR *is not the way to get it to work here.
And yes *REGEX *might not use the index. But first of all I need it
running. After that I can looks for improvements =)
I also tried this here
SELECT $a.id LET $a = ( SELECT id FROM Application WHERE symbol
CONTAINSTEXT 'B62D' ), $b = ( SELECT id FROM Application WHERE symbol
CONTAINSTEXT 'B60' ) WHERE $a=$b
but this is returning 301 entries. I think it just return "B62D" somehow.
Am Donnerstag, 21. August 2014 08:32:58 UTC+2 schrieb Riccardo Tasso:
>
> Ok, I think there's something wrong with the regular expression syntax.
>
> I've tried the following query:
> SELECT DISTINCT(pid) FROM App WHERE symbol MATCHES '(^B\\d.*)' OR symbol
> MATCHES '^..5.*'
> Which gives me the expected results:
> 2
> 3
>
> In fact I can't understand why you have the [[:<:]] in your pattern,
> since you don't have any symbol starting with those characters, maybe you
> forgoto a star (*) operator? Please remember that the Orient REGEX syntax
> is the one defined for Java (
> http://docs.oracle.com/javase/7/docs/api/java/util/regex/Pattern.html)
> which may be different from MySql one.
>
> Note that, as far as I know, REGEX operations doesn't benefit form
> indices, hence if this is your only query I would suggest to remove them.
>
> Cheers,
> Riccardo
>
>
> 2014-08-20 16:53 GMT+02:00 'Curtis Mosters' via OrientDB <
> [email protected] <javascript:>>:
>
>> Sure id should be unique, so it's just not a good name for it. You are
>> right.
>>
>> But testing your query give me also am* empty result* =(
>>
>> FYI:
>>
>> - symbol is FULLTEXT_HASH_INDEX
>> - id is NOTUNIQUE_HASH_INDEX
>>
>> Does that matter?
>>
>> Because of the Indexes, please let's
>>
>> SELECT appln_id FROM Application WHERE ipc_class_symbol CONTAINSTEXT
>> 'B62D' AND ipc_class_symbol CONTAINSTEXT 'B60'
>>
>> Runs much faster.
>>
>> --
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "OrientDB" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
