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 <https://lh3.googleusercontent.com/-jYULXDC2WJ0/V9-oyszlSMI/AAAAAAAAAFc/D8o94otBnbI6ayhZ5cDObSVbflMn_PKCACLcB/s1600/code3.jpg> 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. >> >> >> <https://lh3.googleusercontent.com/-xy-QJL0_MKY/V9-YUB8KsNI/AAAAAAAAAE0/lkqfcI60aOIZ5ccDnl9MvcncWBENPtH4ACLcB/s1600/Immagine.png> >> 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: >>> >>> >>> <https://lh3.googleusercontent.com/-W39YcQO9WbU/V9-VQKpPBnI/AAAAAAAAAEo/_6LW-iicC-Amt1Ds7luo3uTM0iQeyW3UACLcB/s1600/code2.jpg> >>> >>> >>> 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 >>>> >>>> >>>> <https://lh3.googleusercontent.com/-0o2KfD6oAro/V9-TDDNcPBI/AAAAAAAAK44/7FzDgCuAGxkX8sNOBZrxPmiwCxkUiRhaQCLcB/s1600/strike.png> >>>> >>>> >>>> >>>> >>>> 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
