SQL Support for IN predicate

2018-11-14 Thread Ramin Farajollah (BLOOMBERG/ 731 LEX)
Hi, *Is "IN" predicate supported? *If so, can we use a "?" to be replaced and how? Example. I'd like to construct something like this for an integer property: "id IN (1, 6, 12)" Thanks Ramin

Cache Structure

2018-11-13 Thread Ramin Farajollah (BLOOMBERG/ 731 LEX)
Hi, Please help me structure the cache to store instances of a type, say T. I'd like to cache the objects in two different ways: 1. By a unique key (k1), where the value is a single instance 2. By a non-unique key (k2), where the value is a list of instances Please comment on my approach: -