[orientdb] Re: simple query ist mysterious

2016-09-19 Thread Oleksandr Gubchenko 
I've done some tests and you are right, with you db there is some strange 
behaviour.
But this query seems to work fine:

select * from option where 30 = strike


or:
select * from contract where 30 = strike






Hope it helps.


Il giorno lunedì 19 settembre 2016 10:35:39 UTC+2, hartmut bischoff ha 
scritto:
>
> Thanks for checking.
>
> still mysterious.
>
> I attatched my test-database.
> can you do a test with it, too?
>
>
>
> On Monday, September 19, 2016 at 9:44:30 AM UTC+2, Oleksandr Gubchenko 
> wrote:
>>
>> I've also tried it on 2.2.7 with option being sub-class of contract.
>>
>>
>> 
>> All works properly.
>>
>>
>>
>> Il giorno lunedì 19 settembre 2016 09:36:02 UTC+2, Oleksandr Gubchenko ha 
>> scritto:
>>>
>>> On 2.2.10 I get this:
>>>
>>>
>>> 
>>>
>>>
>>> Your contract class is a superclass of option?
>>>
>>> Il giorno lunedì 19 settembre 2016 09:26:30 UTC+2, hartmut bischoff ha 
>>> scritto:

 I'm using 2.2.7


 




 On Monday, September 19, 2016 at 8:42:38 AM UTC+2, Oleksandr Gubchenko 
 wrote:
>
> I've tried it on the latest 2.2.10 and both studio and rest (using 
> postman) give me the right result:
>
> {"result":[{"@type":"d","@rid":"#21:0","@version":1,"@class":
> "contract","strike":30,"@fieldTypes":"strike=c"}]}
>
>
>>>

-- 

--- 
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 orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[orientdb] Re: simple query ist mysterious

2016-09-19 Thread Oleksandr Gubchenko 
I've also tried it on 2.2.7 with option being sub-class of contract.
All works properly.

Il giorno lunedì 19 settembre 2016 09:36:02 UTC+2, Oleksandr Gubchenko ha 
scritto:
>
> On 2.2.10 I get this:
>
>
> 
>
>
> Your contract class is a superclass of option?
>
> Il giorno lunedì 19 settembre 2016 09:26:30 UTC+2, hartmut bischoff ha 
> scritto:
>>
>> I'm using 2.2.7
>>
>>
>> 
>>
>>
>>
>>
>> On Monday, September 19, 2016 at 8:42:38 AM UTC+2, Oleksandr Gubchenko 
>> wrote:
>>>
>>> I've tried it on the latest 2.2.10 and both studio and rest (using 
>>> postman) give me the right result:
>>>
>>> {"result":[{"@type":"d","@rid":"#21:0","@version":1,"@class":"contract",
>>> "strike":30,"@fieldTypes":"strike=c"}]}
>>>
>>>
>

-- 

--- 
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 orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[orientdb] Re: simple query ist mysterious

2016-09-19 Thread Oleksandr Gubchenko 
On 2.2.10 I get this:




Your option class is a superclass of contract?

Il giorno lunedì 19 settembre 2016 09:26:30 UTC+2, hartmut bischoff ha 
scritto:
>
> I'm using 2.2.7
>
>
> 
>
>
>
>
> On Monday, September 19, 2016 at 8:42:38 AM UTC+2, Oleksandr Gubchenko 
> wrote:
>>
>> I've tried it on the latest 2.2.10 and both studio and rest (using 
>> postman) give me the right result:
>>
>> {"result":[{"@type":"d","@rid":"#21:0","@version":1,"@class":"contract",
>> "strike":30,"@fieldTypes":"strike=c"}]}
>>
>>


-- 

--- 
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 orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[orientdb] Re: simple query ist mysterious

2016-09-19 Thread hartmut bischoff 
I'm using 2.2.7






On Monday, September 19, 2016 at 8:42:38 AM UTC+2, Oleksandr Gubchenko 
wrote:
>
> I've tried it on the latest 2.2.10 and both studio and rest (using 
> postman) give me the right result:
>
> {"result":[{"@type":"d","@rid":"#21:0","@version":1,"@class":"contract",
> "strike":30,"@fieldTypes":"strike=c"}]}
>
>
>>>

-- 

--- 
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 orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[orientdb] Re: simple query ist mysterious

2016-09-19 Thread Oleksandr Gubchenko 
I've tried it on the latest 2.2.10 and both studio and rest (using postman) 
give me the right result:

{"result":[{"@type":"d","@rid":"#21:0","@version":1,"@class":"contract",
"strike":30,"@fieldTypes":"strike=c"}]}

Alex.

Il giorno lunedì 19 settembre 2016 08:35:01 UTC+2, Oleksandr Gubchenko ha 
scritto:
>
> Hi,
>
> which version are you using?
>
> Il giorno lunedì 19 settembre 2016 08:20:41 UTC+2, hartmut bischoff ha 
> scritto:
>>
>> Hi,
>>
>> I was very surprised, that a simple query " select from something where a 
>> = b " could be a subject.
>>
>> but
>> 2.3.1 :001 > DB.execute{ "select from contract where strike = 30" }
>>  => [] 
>> 2.3.1 :002 > DB.execute{ "select from contract where strike between 30 
>> and 30" }
>>  => [#"d", 
>> "class"=>"option", "version"=>1, "fieldTypes"=>"expiry=t,strike=c", 
>> "cluster"=>25, "record"=>25},  @attributes={ (...) "strike"=>30.0, (...) ] 
>> 2.3.1 :003 > 
>>
>>  
>> (rest-api)
>>
>> A verification in studio was successful. 
>>
>> The property "strike" is defined as decimal. 
>>
>> Why is the simple "where strike =  30" or "where strike = 30.0" returning 
>> an empty result,
>> whereas "where strike between 30 and 30" returns the correct record?
>>
>>
>>
>> hartmut
>>
>>
>>
>>
>>
>>
>>

-- 

--- 
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 orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[orientdb] Re: simple query ist mysterious

2016-09-19 Thread Oleksandr Gubchenko 
Hi,

which version are you using?

Il giorno lunedì 19 settembre 2016 08:20:41 UTC+2, hartmut bischoff ha 
scritto:
>
> Hi,
>
> I was very surprised, that a simple query " select from something where a 
> = b " could be a subject.
>
> but
> 2.3.1 :001 > DB.execute{ "select from contract where strike = 30" }
>  => [] 
> 2.3.1 :002 > DB.execute{ "select from contract where strike between 30 and 
> 30" }
>  => [#"d", 
> "class"=>"option", "version"=>1, "fieldTypes"=>"expiry=t,strike=c", 
> "cluster"=>25, "record"=>25},  @attributes={ (...) "strike"=>30.0, (...) ] 
> 2.3.1 :003 > 
>
>  
> (rest-api)
>
> A verification in studio was successful. 
>
> The property "strike" is defined as decimal. 
>
> Why is the simple "where strike =  30" or "where strike = 30.0" returning 
> an empty result,
> whereas "where strike between 30 and 30" returns the correct record?
>
>
>
> hartmut
>
>
>
>
>
>
>

-- 

--- 
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 orient-database+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.