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.