Data Types
To be searchable using BigMemory SQL, the data type of an Attribute must be one of the following:

boolean

byte

char

float

short

long

int

double

date

sqldate

String
The value of an Attribute in the WHERE clause must follow these data type rules:

Except for integer and string types, an explicit cast must indicate the data type.

Values for string, boolean, date, and sqldate must be surrounded by single quotes.
Data Types Examples
select * from Person where age = 11 // age is of type int
select * from Person where name = 'Mary' // name is of type String
select * from Person where gender = (char)'M'
select * from Person where isMale = (bool)'true'
select * from Person where age = (byte)11
select * from Person where age = (short)11
select * from Person where age = (long)11
select * from Person where age = (double)11.1
select * from Person where birthDate = (date)'2003-01-10T14:25:22'
The data type name is case-sensitive. For example, use lowercase 'd' in (double) to indicate a primitive of type double.