• Home
• io.snappydata
• gemfire-junit
• 1.5.3
• source code
• unitTests.txt

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.gemstone.gemfire.cache.query.facets.lang.unitTests.txt Maven / Gradle / Ivy

"#select distinct * from /Employees where testMethod(null, 'hello') > 100000",
"#select distinct * from /Employees where not (select distinct * from collect).isEmpty",
"42 or true",
"#select distinct * from /Employees where element(select distinct * from /Employees e where e.empId = 1).name = 'A'",
"select distinct * from /Employees where address = null",
"select distinct * from /Employees where fieldAddress = null",
"select distinct * from /Employees where address() = null",
"select distinct * from /Employees-- this is a comment",
"select distinct * from /Employees where f = 0.9F",
"select distinct * from /Employees where f <= 0.9F;",
"select distinct * from /Employees where 0.9F >= f;",
"select distinct * from /Employees where d = 0.1;",
"select distinct * from /Employees where 1 > d; ",
"select distinct * from /Employees where false",
"select distinct * from /Employees where true",
"select distinct * from /Employees where name = 'Bob'",
"select distinct * from /Employees where salary < 10000 and name = 'Bob'",
"#select distinct * from /Employees where emps.salary <= 100000",
"#select distinct * from /Employees WHERE salary < 100000 AND emps.name = 'Bob'",
"select distinct * from /Employees where 100000 < salary OR name = 'Bob'",
"select distinct * from /Employees where f = 0.9F or name = 'Bob'",
"select distinct * from /Employees where salary > 100000 and name = 'Bob'",
"select distinct * from /Employees where not(salary > 100000 and name = 'Bob')",
"select distinct * from /Employees where salary <= 100000",
"select distinct * from /Employees where 100000 > salary",
"select distinct * from /Employees where salary >= 100000",
"select distinct * from /Employees where salary = 100000",
"select distinct * from /Employees where salary <> 100000",
"select distinct * from /Employees where not (salary > 100000)",
"select distinct * from /Employees /* this is a comment */ where not (salary > 100000)",
"(select distinct * from /Employees where hireDate.getTime > 5.0e18).iterator",
"select distinct * from /Employees where hireDate.getTime > 5.0e18",
"select distinct * from /Employees where hireDate > hireDate.getClass.newInstance",
"select distinct * from /Employees where name = 'A'.concat('dam')",
"select distinct * from /Employees where name = 'Ada'.concat('m');",
"select distinct * from /Employees where name.startsWith('Bo')",
"select distinct * from /Employees emps where emps.testMethod(5,'x') > 100000",
"select distinct * from /Employees where testMethod(5,'x') > 100000",
"select distinct * from /Employees where testMethod(99999999999L, 'y') > 100000",
"select distinct * from /Employees where testMethod(1.0F, 'z') > 100000;",
"#select distinct * from /Employees where testMethod(-1.0e10F, 'z') > 100000",
"select distinct * from /Employees where testMethod(1.0e-67, 'a') > 100000",
"select distinct * from /Employees where testMethod(0, 'b') > 100000",
"select distinct * from /Employees where testMethod(DATE '2000-01-07', 'c') > 100000",
"select distinct * from /Employees where testMethod(date '1999-12-31', 'd') > 100000",
"select distinct * from /Employees where testMethod(TIME '12:00:0', 'e') > 100000",
"select distinct * from /Employees where testMethod(TIMEstAmp '2000-01-07 12:00:0.5', 'e') > 100000",
"select distinct * from /Employees where testMethod(TIMESTAMP '1776-07-04 16:22:32.101010101', 'e') > 100000",
"select distinct * from /Employees where testMethod(TIMESTAMP '1776-07-04 16:22:32.101910101', 'e') > 100000",
"select distinct * from /Employees where NOT name.startsWith('Bo')",
"select distinct * from /Employees where name='Bob'",
"select distinct * from /Employees where address = undefined",
"select distinct * from /Employees where address = null",
"select distinct * from /Employees where address.postalCode = '97006'",
"select distinct * from /Employees where salary > $1",
"select distinct * from $2 where salary > $1",
"select distinct * from /Employees where name.charAt(0) = char 'B'",
"select distinct * from /Employees where name.charAt(0) = char 'R'",
"select distinct * from /Employees where is_undefined(address.postalCode)",
"select distinct * from /Employees where is_defined(address.postalCode)",
"select distinct * from /Employees where address <> null",
"select distinct * from /Employees where address() <> null",
"select distinct * from /Employees where address = null;",
"select distinct * from /Employees where address.street = null",
"select distinct * from /Employees where address.city() = 'Beaverton'"