Java tutorial
/* * Licensed to the Apache Software Foundation (ASF) under one or more contributor license * agreements. See the NOTICE file distributed with this work for additional information regarding * copyright ownership. The ASF licenses this file to You under the Apache License, Version 2.0 (the * "License"); you may not use this file except in compliance with the License. You may obtain a * copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software distributed under the License * is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express * or implied. See the License for the specific language governing permissions and limitations under * the License. */ package org.apache.geode.cache.query; import static org.apache.geode.distributed.ConfigurationProperties.MCAST_PORT; import org.apache.commons.io.FileUtils; import org.apache.geode.LogWriter; import org.apache.geode.cache.AttributesFactory; import org.apache.geode.cache.Cache; import org.apache.geode.cache.CacheException; import org.apache.geode.cache.CacheFactory; import org.apache.geode.cache.ExpirationAttributes; import org.apache.geode.cache.PartitionAttributesFactory; import org.apache.geode.cache.Region; import org.apache.geode.cache.RegionAttributes; import org.apache.geode.cache.RegionFactory; import org.apache.geode.cache.RegionShortcut; import org.apache.geode.cache30.CacheSerializableRunnable; import org.apache.geode.test.dunit.SerializableRunnable; import org.apache.geode.test.dunit.VM; import java.io.File; import java.io.IOException; import java.io.Serializable; import java.util.HashMap; import java.util.Map; import java.util.Properties; /** * Utility class for testing supported queries */ public class QueryTestUtils implements Serializable { private static Cache cache; public HashMap<String, String> queries; public HashMap<String, String> bindQueries; private static QueryTestUtils instance = new QueryTestUtils(); public static QueryTestUtils getInstance() { return instance; } public QueryTestUtils() { queries = new HashMap<String, String>(); bindQueries = new HashMap<String, String>(); initializeQueryMap(); initializeBindQueryMap(); } public void initializeBindQueryMap() { // BIND QUERIES bindQueries.put("1", "$1 AND $2"); bindQueries.put("2", "$1 IN $2"); bindQueries.put("3", "$1 IN $3"); bindQueries.put("4", "$1 IN SET(1, 'a', $2, $3, $4, $5)"); bindQueries.put("5", "$1 OR $2"); bindQueries.put("6", "$1[$2]"); bindQueries.put("7", "$1[0][0]"); bindQueries.put("8", "$3 IN $2"); bindQueries.put("9", "(SELECT DISTINCT * FROM /root/exampleRegion WHERE ID < $1).size"); bindQueries.put("10", "/exampleRegion.containsValue($1)"); bindQueries.put("11", "IMPORT org.apache.geode.cache.\"query\".data.Student;IMPORT org.apache.geode.cache.\"query\".data.Student$Subject;Select distinct * from $1 as it1 , it1.subjects type Student$Subject where subject='Hindi'"); bindQueries.put("12", "IMPORT org.apache.geode.cache.\"query\".data.Student;IMPORT org.apache.geode.cache.\"query\".data.Student$Subject;Select distinct * from $1 as it1 , it1.subjects x type Student$Subject where x.subject='Hindi'"); bindQueries.put("13", "IMPORT org.apache.geode.cache.\"query\".data.Student;IMPORT org.apache.geode.cache.\"query\".data.Student$Subject;Select distinct * from $1 as it1 , (list<Student$Subject>) it1.subjects where subject='Hindi'"); bindQueries.put("14", "IMPORT org.apache.geode.cache.\"query\".data.Student;IMPORT org.apache.geode.cache.\"query\".data.Student$Teacher;Select distinct * from $1 as it1 , it1.teachers type Student$Teacher where teacher='Y'"); bindQueries.put("15", "IMPORT org.apache.geode.cache.\"query\".data.Student;IMPORT org.apache.geode.cache.\"query\".data.Student$Teacher;Select distinct * from $1 as it1 , it1.teachers x type Student$Teacher where x.teacher='Y'"); bindQueries.put("16", "IMPORT org.apache.geode.cache.\"query\".data.Student;IMPORT org.apache.geode.cache.\"query\".data.Student$Teacher;Select distinct * from $1 as it1 , (list<Student$Teacher>) it1.teachers where teacher='Y'"); bindQueries.put("17", "IS_DEFINED($1)"); bindQueries.put("18", "IS_UNDEFINED($1)"); bindQueries.put("19", "NOT $1"); bindQueries.put("20", "NOT $2"); bindQueries.put("21", "NOT $3"); bindQueries.put("22", "NOT $4"); bindQueries.put("23", "SELECT distinct ID, description, createTime FROM /exampleRegion1 pf1 where pf1.ID != $1 limit 10"); bindQueries.put("24", "SELECT distinct ID, description, createTime FROM /exampleRegion1 pf1 where pf1.ID != $1 order by ID"); bindQueries.put("25", "SELECT * FROM /exampleRegion pf WHERE pf = $1"); bindQueries.put("26", "SELECT * FROM /exampleRegion pf WHERE pf > $1"); bindQueries.put("27", "SELECT * FROM /exampleRegion.keys k WHERE k.ID = $1"); bindQueries.put("28", "SELECT * FROM /exampleRegion.keys key WHERE key.ID > $1"); bindQueries.put("29", "SELECT * FROM /exampleRegion.values pf WHERE pf < $1"); bindQueries.put("30", "SELECT * FROM /root/exampleRegion WHERE ID < $1 and Ticker = $2"); bindQueries.put("31", "SELECT * FROM /root/exampleRegion WHERE ID = $1 and Ticker = $2"); bindQueries.put("32", "SELECT DISTINCT * FROM $1 z where z.status = 'active'"); bindQueries.put("33", "SELECT DISTINCT * FROM /exampleRegion WHERE ID < $1 ORDER BY $2"); bindQueries.put("34", "SELECT DISTINCT * FROM /exampleRegion where ID = $1"); bindQueries.put("35", "SELECT DISTINCT * FROM /exampleRegion where status = $1"); bindQueries.put("36", "SELECT DISTINCT * FROM /exampleRegion where status.equals($1)"); bindQueries.put("37", "SELECT DISTINCT * FROM /root/exampleRegion WHERE ID < $1 ORDER BY $2"); bindQueries.put("38", "SELECT DISTINCT * FROM /root/exampleRegion WHERE ID < $1 ORDER BY ID"); bindQueries.put("39", "SELECT DISTINCT booleanValue from $1 TYPE boolean"); bindQueries.put("40", "SELECT DISTINCT booleanValue from (set<boolean>) $1"); bindQueries.put("41", "SELECT DISTINCT byteValue from $1 TYPE byte"); bindQueries.put("42", "SELECT DISTINCT byteValue from (set<byte>) $1"); bindQueries.put("43", "SELECT DISTINCT charValue from $1 TYPE char"); bindQueries.put("44", "SELECT DISTINCT charValue from (set<char>) $1"); bindQueries.put("45", "SELECT DISTINCT doubleValue from $1 TYPE double"); bindQueries.put("46", "SELECT DISTINCT doubleValue from (set<double>) $1"); bindQueries.put("47", "SELECT DISTINCT floatValue from $1 TYPE float"); bindQueries.put("48", "SELECT DISTINCT floatValue from (set<float>) $1"); bindQueries.put("49", "SELECT DISTINCT intern from $1 TYPE string"); bindQueries.put("50", "SELECT DISTINCT intern from (set<string>) $1"); bindQueries.put("51", "SELECT DISTINCT longValue from $1 TYPE long"); bindQueries.put("52", "SELECT DISTINCT longValue from (set<long>) $1"); bindQueries.put("53", "SELECT DISTINCT shortValue from $1 TYPE short"); bindQueries.put("54", "SELECT DISTINCT shortValue from (set<short>) $1"); bindQueries.put("55", "SELECT ID, status FROM /exampleRegion.keys WHERE ID = $1"); bindQueries.put("56", "SELECT distinct * FROM /exampleRegion ps WHERE ps.status like $1 AND ps.ID > 2 AND ps.ID < 150"); bindQueries.put("57", "SELECT distinct * FROM /exampleRegion ps WHERE ps.status like $1"); bindQueries.put("58", "SELECT e.key, e.value FROM /exampleRegion.entrySet e WHERE e.key IN $1"); bindQueries.put("59", "SELECT e.value FROM /exampleRegion.entrySet e WHERE e.key IN $1"); bindQueries.put("60", "SELECT itr.value FROM /root/exampleRegion.entries itr where itr.key = $1"); bindQueries.put("61", "SELECT k.ID, k.status FROM /exampleRegion.keys k WHERE k.ID = $1 and k.status = $2"); bindQueries.put("62", "SELECT key.ID FROM /exampleRegion.keys key WHERE key.ID = $1"); bindQueries.put("63", "Select distinct * from /exampleRegion.keys keys where keys.hashCode >= $1"); bindQueries.put("64", "Select distinct intValue from $1 TYPE int"); bindQueries.put("65", "Select distinct intValue from (array<int>) $1"); bindQueries.put("66", "Select distinct intValue from (list<int>) $1"); bindQueries.put("67", "Select distinct keys.hashCode from /exampleRegion.keys() keys where keys.hashCode >= $1"); bindQueries.put("68", "Select distinct value.secId from /exampleRegion , getPositions($1)"); bindQueries.put("69", "import org.apache.geode.cache.\"query\".data.Position;select distinct * from $1 r, r.positions.values pVal TYPE Position where r.status = 'active' AND pVal.mktValue >= 25.00"); bindQueries.put("70", "import org.apache.geode.cache.\"query\".data.Position;select distinct r from $1 r, r.positions.values pVal TYPE Position where pVal.mktValue < $2"); bindQueries.put("71", "import org.apache.geode.cache.\"query\".data.Position;select distinct r.ID, status, mktValue from $1 r, r.positions.values pVal TYPE Position where r.status = 'active' AND pVal.mktValue >= 25.00"); bindQueries.put("72", "import java.util.Map$Entry as Entry;select distinct value.secId from /exampleRegion, getPositions(23) type Entry"); bindQueries.put("73", "select * from $1"); bindQueries.put("74", "select ALL * from $1"); bindQueries.put("75", "select distinct * from $1 where status = 'active'"); bindQueries.put("76", "select distinct * from $1"); bindQueries.put("77", "select distinct * from /exampleRegion pf where pf.getCW(pf.ID) != $1"); bindQueries.put("78", "select distinct * from /exampleRegion pf where pf.getCW(pf.ID) < $1"); bindQueries.put("79", "select distinct * from /exampleRegion pf where pf.getCW(pf.ID) > $1"); bindQueries.put("80", "select distinct * from /root/exampleRegion where ticker = $1"); bindQueries.put("81", "select p from /exampleRegion.values p where p like $1"); bindQueries.put("82", "select p.positions.get('acc') from $1 p"); } public void initializeQueryMap() { queries.put("1", "SELECT DISTINCT * FROM /exampleRegion WHERE status = 'active'"); queries.put("2", "SELECT * FROM /exampleRegion WHERE \"type\" = 'type1' and status = 'active'"); queries.put("3", "SELECT key, positions FROM /exampleRegion.entrySet, value.positions.values positions WHERE positions.mktValue >= 25.00"); queries.put("4", "SELECT DISTINCT entry.value FROM /exampleRegion.entries entry WHERE entry.key = '1'"); queries.put("5", "SELECT * FROM /exampleRegion.entries entry WHERE entry.value.ID > 1"); queries.put("6", "SELECT entry.value FROM /exampleRegion.entries entry WHERE entry.key = '1'"); queries.put("7", "SELECT * FROM /exampleRegion.keySet key WHERE key = '1'"); queries.put("8", "SELECT * FROM /exampleRegion.values portfolio WHERE portfolio.status = 'active'"); queries.put("9", "SELECT entry.key, entry.value FROM /exampleRegion.entries entry WHERE entry.value['version'] = '100'"); queries.put("10", "SELECT DISTINCT * FROM /exampleRegion WHERE ID < 101 ORDER BY ID"); queries.put("11", "SELECT DISTINCT * FROM /exampleRegion WHERE ID < 101 ORDER BY ID asc"); queries.put("12", "SELECT DISTINCT * FROM /exampleRegion WHERE ID < 101 ORDER BY ID desc"); queries.put("13", "SELECT * FROM /exampleRegion p WHERE p.status LIKE 'active'"); queries.put("14", "SELECT * FROM /exampleRegion p WHERE p.status LIKE 'activ%'"); queries.put("15", "SELECT * FROM /exampleRegion p, p.positions.values AS pos WHERE pos.secId != '1'"); queries.put("16", "SELECT DISTINCT * FROM /exampleRegion WHERE TRUE"); queries.put("17", "SELECT * FROM /exampleRegion portfolio WHERE portfolio.ID IN SET(1, 2)"); queries.put("18", "SELECT * FROM /exampleRegion portfolio, portfolio.positions.values positions WHERE portfolio.Pk IN SET ('1', '2') AND positions.secId = '1'"); queries.put("19", "SELECT * FROM /exampleRegion portfolio, portfolio.positions.values positions WHERE portfolio.Pk IN SET ('1', '2') OR positions.secId IN SET ('1', '2', '3')"); queries.put("20", "SELECT * FROM /exampleRegion portfolio, portfolio.positions.values positions WHERE portfolio.Pk IN SET ('1', '2') OR positions.secId IN SET ('1', '2', '3') and portfolio.status = 'active'"); queries.put("21", "SELECT * FROM /exampleRegion portfolio WHERE portfolio.ID <> 2"); queries.put("22", "SELECT * FROM /exampleRegion portfolio WHERE portfolio.ID != 2"); queries.put("23", "(SELECT * FROM /exampleRegion).size"); queries.put("24", "(SELECT * FROM /exampleRegion p WHERE p.ID = 1).size"); queries.put("25", "SELECT * FROM /exampleRegion p WHERE p.status.length > 1"); queries.put("26", "select * from /exampleRegion sp where sp = set ('20', '21', '22')"); queries.put("27", "select * from /exampleRegion sp where sp.containsAll(set('20', '21', '22'))"); queries.put("28", "select * from /exampleRegion sp where sp IN SET (set('20', '21', '22'), set('10', '11', '12'))"); queries.put("29", "select distinct r.name, pVal, r.\"type\" from /exampleRegion r , r.positions.values pVal where ( r.name IN Set('name_11' , 'name_12') OR false ) AND pVal.mktValue = 1.00"); queries.put("30", "select distinct r.name, pVal, r.\"type\" from /exampleRegion r , r.positions.values pVal where ( r.undefinedTestField.toString = UNDEFINED AND true ) AND pVal.mktValue = 1.00"); queries.put("31", "select distinct r.name, pVal, r.\"type\" from /exampleRegion r , r.positions.values pVal where ( r.undefinedTestField.toString = UNDEFINED OR false )"); queries.put("32", "select distinct r.name, pVal, r.\"type\" from /exampleRegion r , r.positions.values pVal where (r.name='name_11' OR r.name='name_12') AND pVal.mktValue >=1.00"); queries.put("33", "(select distinct * from /exampleRegion).size"); queries.put("34", "/exampleRegion.fullPath"); queries.put("35", "/exampleRegion.size > 0"); queries.put("36", "/exampleRegion.size"); queries.put("37", "2 IN SET(1,2,3)"); queries.put("38", "IMPORT org.apache.geode.cache.\"query\".data.Manager;SELECT DISTINCT manager_id FROM (set<Manager>)/exampleRegion where empId > 0"); queries.put("39", "IMPORT org.apache.geode.cache.\"query\".data.Portfolio; SELECT DISTINCT * FROM (set<Portfolio>)/exampleRegion where iD > 0"); queries.put("40", "IMPORT org.apache.geode.cache.\"query\".data.Position;IMPORT org.apache.geode.cache.\"query\".data.Portfolio;SELECT DISTINCT secId FROM (set<Portfolio>)/exampleRegion, (set<Position>)positions.values WHERE iD > 0"); queries.put("41", "IMPORT org.apache.geode.cache.\"query\".data.Position;SELECT DISTINCT pos.secId FROM /exampleRegion, pos IN positions.values TYPE Position WHERE iD > 0"); queries.put("42", "IMPORT org.apache.geode.cache.\"query\".data.Position;SELECT DISTINCT secId FROM /exampleRegion, positions.values pos TYPE Position WHERE iD > 0"); queries.put("43", "IMPORT org.apache.geode.cache.\"query\".data.Position;SELECT DISTINCT secId FROM /exampleRegion, (set<Position>)positions.values WHERE iD > 0"); queries.put("44", "IMPORT org.apache.geode.cache.\"query\".data.Position;SELECT DISTINCT secId FROM /exampleRegion, positions.values AS pos TYPE Position WHERE iD > 0"); queries.put("45", "SELECT DISTINCT iD as portfolio_id, pos.secId as sec_id from /exampleRegion p , p.positions.values pos where p.status= 'active'"); queries.put("46", "SELECT distinct * FROM /exampleRegion order by pkid desc"); queries.put("47", "SELECT distinct * FROM /exampleRegion pf1 order by pkid asc"); queries.put("48", "SELECT distinct * FROM /exampleRegion pf1 order by pkid"); queries.put("49", "SELECT distinct * FROM /exampleRegion pf1 where ID != 10 order by ID asc, pkid asc limit 10"); queries.put("50", "SELECT distinct * FROM /exampleRegion pf1 where ID != 10 order by ID desc"); queries.put("51", "SELECT distinct * FROM /exampleRegion pf1 where ID != 10 order by ID desc, pkid desc limit 10"); queries.put("52", "SELECT distinct * FROM /exampleRegion pf1 where ID > 0 order by pkid asc"); queries.put("53", "SELECT distinct * FROM /exampleRegion pf1 where ID > 0 order by pkid"); queries.put("54", "SELECT distinct * FROM /exampleRegion pf1 where ID > 10 and ID < 20 order by ID asc, pkid asc limit 5"); queries.put("55", "SELECT distinct * FROM /exampleRegion pf1 where ID > 10 and ID < 20 order by ID desc"); queries.put("56", "SELECT distinct * FROM /exampleRegion pf1 where pkid < '7' and ID > 10 and ID < 20 order by ID asc, pkid asc limit 5"); queries.put("57", "SELECT distinct * FROM /exampleRegion pf1 where pkid > '1' and pkid <='9' and ID >= 10 and ID <= 20 order by ID asc, pkid asc"); queries.put("58", "SELECT distinct * FROM /exampleRegion pf1 where pkid > '17' and ID > 10 order by ID asc, pkid desc limit 5"); queries.put("59", "SELECT distinct ID, description, createTime FROM /exampleRegion pf1 where ID > 10 and ID < 20 order by ID desc, pkid asc limit 5"); queries.put("60", "SELECT distinct ID, description, createTime FROM /exampleRegion pf1 where ID > 10 order by ID desc limit 5"); queries.put("61", "SELECT distinct ID, description, createTime FROM /exampleRegion pf1 where ID > 10 order by ID desc, pkid desc limit 5"); queries.put("62", "SELECT distinct ID, description, createTime FROM /exampleRegion pf1 where ID > 10 order by ID desc, pkid desc"); queries.put("63", "SELECT distinct ID, description, createTime FROM /exampleRegion pf1 where ID >= 10 and ID <= 20 order by ID asc, pkid desc"); queries.put("64", "SELECT distinct ID, description, createTime FROM /exampleRegion pf1 where ID >= 10 and ID <= 20 order by ID desc limit 5"); queries.put("65", "SELECT distinct ID, description, createTime FROM /exampleRegion pf1 where ID >= 10 and ID <= 20 order by ID desc"); queries.put("66", "SELECT distinct ID, description, createTime FROM /exampleRegion pf1 where ID >= 10 and ID <= 20 order by ID desc, pkid desc limit 5"); queries.put("67", "SELECT distinct ID, description, createTime FROM /exampleRegion pf1 where pf1.ID != '10' order by ID desc limit 5"); queries.put("68", "SELECT distinct ID, description, createTime FROM /exampleRegion pf1 where pkid > 'a' and ID >= 10 and ID <= 20 order by ID desc, pkid asc limit 5"); queries.put("69", "SELECT distinct ID, pkid FROM /exampleRegion pf1 where ID < 1000 order by pkid"); queries.put("70", "SELECT distinct ID, pkid FROM /exampleRegion pf1 where ID > 0 order by pkid"); queries.put("71", "SELECT distinct ID, pkid FROM /exampleRegion pf1 where ID > 0 order by pkid, ID asc"); queries.put("72", "SELECT distinct ID, pkid FROM /exampleRegion pf1 where ID > 0 order by pkid, ID desc"); queries.put("73", "SELECT distinct pkid FROM /exampleRegion pf1 order by pkid"); queries.put("74", "SELECT distinct pkid FROM /exampleRegion pf1 where ID > 0 order by pkid asc"); queries.put("75", "SELECT distinct pkid FROM /exampleRegion pf1 where ID > 0 order by pkid desc"); queries.put("76", "SELECT distinct pkid FROM /exampleRegion pf1 where ID > 0 order by pkid"); queries.put("77", "SELECT distinct pkid FROM /exampleRegion pf1 where pkid != 'XXXX' order by pkid asc"); queries.put("78", "SELECT distinct pkid FROM /exampleRegion pf1 where pkid != 'XXXX' order by pkid desc"); queries.put("79", "SELECT * FROM /exampleRegion p where p.intVar < 9"); queries.put("80", "SELECT * FROM /exampleRegion pf WHERE pf = 'XX1'"); queries.put("81", "SELECT * FROM /exampleRegion pf WHERE pf IN SET( 'XX5', 'XX6', 'XX7')"); queries.put("82", "SELECT * FROM /exampleRegion"); queries.put("83", "SELECT * FROM /exampleRegion.keys k WHERE k.ID = 1"); queries.put("84", "SELECT * FROM /exampleRegion.keys key WHERE key.ID = 1"); queries.put("85", "SELECT * FROM /exampleRegion.keys key WHERE key.ID > 5"); queries.put("86", "SELECT * FROM /exampleRegion.values pf WHERE pf IN SET( 'XX5', 'XX6', 'XX7')"); queries.put("87", "SELECT * from /exampleRegion"); queries.put("88", "SELECT ALL * FROM /exampleRegion"); queries.put("89", "SELECT DISTINCT q.cusip, q.quoteType, q.dealerPortfolio, q.channelName, q.dealerCode, q.priceType, q.price, q.lowerQty, q.upperQty, q.ytm, r.minQty, r.maxQty, r.incQty FROM /exampleRegion q, /exampleRegion r WHERE q.cusip = r.cusip AND q.quoteType = r.quoteType"); queries.put("90", "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM /exampleRegion AS ptf, positions AS pos) WHERE pos.value.secId = 'IBM'"); queries.put("91", "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM /exampleRegion ptf, positions pos) WHERE pos.value.secId = 'IBM'"); queries.put("92", "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM /exampleRegion ptf, positions pos) p WHERE p.get('pos').value.secId = 'IBM'"); queries.put("93", "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM /exampleRegion ptf, positions pos) p WHERE p.pos.value.secId = 'IBM'"); queries.put("94", "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM /exampleRegion ptf, positions pos) p WHERE pos.value.secId = 'IBM'"); queries.put("95", "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM /exampleRegion, positions) WHERE positions.value.secId = 'IBM'"); queries.put("96", "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM /exampleRegion, positions) p WHERE p.positions.value.secId = 'IBM'"); queries.put("97", "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM ptf IN /exampleRegion, pos IN positions) WHERE pos.value.secId = 'IBM'"); queries.put("98", "SELECT DISTINCT * FROM (SELECT DISTINCT pos AS myPos FROM /exampleRegion ptf, positions pos) WHERE myPos.value.secId = 'IBM'"); queries.put("99", "SELECT DISTINCT * FROM /exampleRegion pf WHERE pf.ID > 10 limit 5"); queries.put("100", "SELECT DISTINCT * FROM /exampleRegion pf, pf.collectionHolderMap.keySet WHERE pf.ID > 10 limit 20"); queries.put("101", "SELECT DISTINCT * FROM /exampleRegion WHERE NOT(SELECT DISTINCT * FROM positions.values p WHERE p.secId = 'IBM').isEmpty"); queries.put("102", "SELECT DISTINCT * FROM /exampleRegion as a, a.collectionHolderMap['0'].arr as b where a.status = 'active' and a.ID = 0"); queries.put("103", "SELECT DISTINCT * FROM /exampleRegion c WHERE c.name = 'INDIA'"); queries.put("104", "SELECT DISTINCT * FROM /exampleRegion c, c.states s, s.districts d WHERE d.name = 'PUNEDIST' AND s.name = 'GUJARAT'"); queries.put("105", "SELECT DISTINCT * FROM /exampleRegion c, c.states s, s.districts d, d.cities ct WHERE ct.name = 'MUMBAI'"); queries.put("106", "SELECT DISTINCT * FROM /exampleRegion c, c.states s, s.districts d, d.cities ct, d.villages v WHERE c.name = 'INDIA'"); queries.put("107", "SELECT DISTINCT * FROM /exampleRegion c, c.states s, s.districts d, d.villages v, d.cities ct WHERE ct.name = 'PUNE' AND s.name = 'MAHARASHTRA'"); queries.put("108", "SELECT DISTINCT * FROM /exampleRegion c, c.states s, s.districts d, d.villages v, d.cities ct WHERE v.name = 'MAHARASHTRA_VILLAGE1'"); queries.put("109", "SELECT DISTINCT * FROM /exampleRegion c, c.states s, s.districts d, d.villages v, d.cities ct WHERE v.name='MAHARASHTRA_VILLAGE1' AND ct.name = 'PUNE'"); queries.put("110", "SELECT DISTINCT * FROM /exampleRegion itr1 WHERE itr1.liist[0] >= 2"); queries.put("111", "SELECT DISTINCT * FROM /exampleRegion itr1 WHERE itr1.maap.get('key2') >= 16"); queries.put("112", "SELECT DISTINCT * FROM /exampleRegion itr1 WHERE itr1.maap.get('key2') >= 3"); queries.put("113", "SELECT DISTINCT * FROM /exampleRegion itr1 WHERE itr1.maap['key2'] >= 16"); queries.put("114", "SELECT DISTINCT * FROM /exampleRegion itr1 WHERE itr1.maap['key2'] >= 3 and itr1.maap['key3'] < 18"); queries.put("115", "SELECT DISTINCT * FROM /exampleRegion itr1 WHERE itr1.maap['key2'] >= 3 and itr1.maap['key2'] <=18"); queries.put("116", "SELECT DISTINCT * FROM /exampleRegion itr1 WHERE itr1.maap['key2'] >= 3"); queries.put("117", "SELECT DISTINCT * FROM /exampleRegion itr1 WHERE itr1.maap['key3'] >= 3 and itr1.maap['key3'] >= 13"); queries.put("118", "SELECT DISTINCT * FROM /exampleRegion itr1 WHERE itr1.maap['key3'] >= 3"); queries.put("119", "SELECT DISTINCT * FROM /exampleRegion itr1 WHERE itr1.maap['key4'] >= 16"); queries.put("120", "SELECT DISTINCT * FROM /exampleRegion num WHERE num.id1 >= -200"); queries.put("121", "SELECT DISTINCT * FROM /exampleRegion p WHERE p.ID <= 10 order by p.ID asc limit 1"); queries.put("122", "SELECT DISTINCT * FROM /exampleRegion p WHERE p.ID <= 10 order by p.ID desc limit 1"); queries.put("123", "SELECT DISTINCT * FROM /exampleRegion p WHERE p.ID <= 10 order by p.pkid desc limit 1"); queries.put("124", "SELECT DISTINCT * FROM /exampleRegion pf WHERE pf.ID > 0 limit 5"); queries.put("125", "SELECT DISTINCT * FROM /exampleRegion pf where pf.description = 'XXXX' and pf.status='active' and pf.createTime = 5"); queries.put("126", "SELECT DISTINCT * FROM /exampleRegion pf where pf.description = 'XXXX' and pf.status='active'"); queries.put("127", "SELECT DISTINCT * FROM /exampleRegion pf, positions.values pos where pf.ID > 0 and pf.ID < 250 and pf.status='active' and pos.secId != null"); queries.put("128", "SELECT DISTINCT * FROM /exampleRegion pf, positions.values pos where pf.status='active' and pos.secId= 'IBM' and pf.ID = 0"); queries.put("129", "SELECT DISTINCT * FROM /exampleRegion pf, /exampleRegion emp WHERE pf.ID = emp.empId"); queries.put("130", "SELECT DISTINCT * FROM /exampleRegion pf, pf.positions pos, /exampleRegion emp WHERE pf.iD = emp.empId and pf.status='active' and emp.age > 900"); queries.put("131", "SELECT DISTINCT * FROM /exampleRegion pf, pf.positions pos, /exampleRegion emp WHERE pf.iD = emp.empId"); queries.put("132", "SELECT DISTINCT * FROM /exampleRegion pf, pf.positions.values WHERE pf.ID > 0 limit 5"); queries.put("133", "SELECT DISTINCT * FROM /exampleRegion pf, pf.positions.values position WHERE (pf.ID > 0 OR position.secId = 'SUN') OR false"); queries.put("134", "SELECT DISTINCT * FROM /exampleRegion pf, pf.positions.values position WHERE (true = null OR position.secId = 'SUN') AND true"); queries.put("135", "SELECT DISTINCT * FROM /exampleRegion pf, pf.positions.values position WHERE (true = null OR position.secId = 'SUN') OR true"); queries.put("136", "SELECT DISTINCT * FROM /exampleRegion pf, pf.positions.values position WHERE true = null OR position.secId = 'SUN'"); queries.put("137", "SELECT DISTINCT * FROM /exampleRegion value where value.length > 6"); queries.put("138", "SELECT DISTINCT * FROM /exampleRegion value"); queries.put("139", "SELECT DISTINCT * FROM /exampleRegion where (status = 'active' OR ID = 2) AND P1.secId = 'IBM'"); queries.put("140", "SELECT DISTINCT * FROM /exampleRegion where FALSE"); queries.put("141", "SELECT DISTINCT * FROM /exampleRegion where NOT (status = 'active') AND ID = 2"); queries.put("142", "SELECT DISTINCT * FROM /exampleRegion where NOT (status = 'active') OR ID = 2"); queries.put("143", "SELECT DISTINCT * FROM /exampleRegion where NULL"); queries.put("144", "SELECT DISTINCT * FROM /exampleRegion where P1.secId != 'IBM'"); queries.put("145", "SELECT DISTINCT * FROM /exampleRegion where P1.secId > 'IBM'"); queries.put("146", "SELECT DISTINCT * FROM /exampleRegion where P1.secId >= 'IBM'"); queries.put("147", "SELECT DISTINCT * FROM /exampleRegion where P1.secId!='DELL'"); queries.put("148", "SELECT DISTINCT * FROM /exampleRegion where P1.secId<'DELL'"); queries.put("149", "SELECT DISTINCT * FROM /exampleRegion where P1.secId<='DELL'"); queries.put("150", "SELECT DISTINCT * FROM /exampleRegion where P1.secId<>'DELL'"); queries.put("151", "SELECT DISTINCT * FROM /exampleRegion where P1.secId='DELL'"); queries.put("152", "SELECT DISTINCT * FROM /exampleRegion where P1.secId>'DELL'"); queries.put("153", "SELECT DISTINCT * FROM /exampleRegion where P1.secId>='DELL'"); queries.put("154", "SELECT DISTINCT * FROM /exampleRegion where P1.secType = 'a'"); queries.put("155", "SELECT DISTINCT * FROM /exampleRegion where P2!=null"); queries.put("156", "SELECT DISTINCT * FROM /exampleRegion where P2.secId = UNDEFINED"); queries.put("157", "SELECT DISTINCT * FROM /exampleRegion where P2.secId = null"); queries.put("158", "SELECT DISTINCT * FROM /exampleRegion where P2.secId!= UNDEFINED"); queries.put("159", "SELECT DISTINCT * FROM /exampleRegion where P2.secId< UNDEFINED"); queries.put("160", "SELECT DISTINCT * FROM /exampleRegion where P2.secId<= UNDEFINED"); queries.put("161", "SELECT DISTINCT * FROM /exampleRegion where P2.secId<> UNDEFINED"); queries.put("162", "SELECT DISTINCT * FROM /exampleRegion where P2.secId= UNDEFINED"); queries.put("163", "SELECT DISTINCT * FROM /exampleRegion where P2.secId> UNDEFINED"); queries.put("164", "SELECT DISTINCT * FROM /exampleRegion where P2.secId>= UNDEFINED"); queries.put("165", "SELECT DISTINCT * FROM /exampleRegion where P2<=null"); queries.put("166", "SELECT DISTINCT * FROM /exampleRegion where P2<>null"); queries.put("167", "SELECT DISTINCT * FROM /exampleRegion where P2<null"); queries.put("168", "SELECT DISTINCT * FROM /exampleRegion where P2=null"); queries.put("169", "SELECT DISTINCT * FROM /exampleRegion where P2>=null"); queries.put("170", "SELECT DISTINCT * FROM /exampleRegion where P2>null"); queries.put("171", "SELECT DISTINCT * FROM /exampleRegion where TRUE"); queries.put("172", "SELECT DISTINCT * FROM /exampleRegion where UNDEFINED"); queries.put("173", "SELECT DISTINCT * FROM /exampleRegion where ID != 2"); queries.put("174", "SELECT DISTINCT * FROM /exampleRegion where ID <> 2"); queries.put("175", "SELECT DISTINCT * FROM /exampleRegion where ID >= 2"); queries.put("176", "SELECT DISTINCT * FROM /exampleRegion where ID!=2"); queries.put("177", "SELECT DISTINCT * FROM /exampleRegion where ID<2"); queries.put("178", "SELECT DISTINCT * FROM /exampleRegion where ID<=2"); queries.put("179", "SELECT DISTINCT * FROM /exampleRegion where ID<>2"); queries.put("180", "SELECT DISTINCT * FROM /exampleRegion where ID=2"); queries.put("181", "SELECT DISTINCT * FROM /exampleRegion where ID>2"); queries.put("182", "SELECT DISTINCT * FROM /exampleRegion where ID>=2"); queries.put("183", "SELECT DISTINCT * FROM /exampleRegion where status != 'active'"); queries.put("184", "SELECT DISTINCT * FROM /exampleRegion where status < 'active'"); queries.put("185", "SELECT DISTINCT * FROM /exampleRegion where status <= 'active'"); queries.put("186", "SELECT DISTINCT * FROM /exampleRegion where status <> 'active'"); queries.put("187", "SELECT DISTINCT * FROM /exampleRegion where status = 'active' AND ( ID = 2 OR P1.secId = 'IBM')"); queries.put("188", "SELECT DISTINCT * FROM /exampleRegion where status = 'active' AND NOT( ID = 2 )"); queries.put("189", "SELECT DISTINCT * FROM /exampleRegion where status = 'active' AND P1.secType = 'a'"); queries.put("190", "SELECT DISTINCT * FROM /exampleRegion where status = 'active' AND ID = 1 OR P1.secType = 'a'"); queries.put("191", "SELECT DISTINCT * FROM /exampleRegion where status = 'active' AND ID = 2 AND P1.secId = 'IBM'"); queries.put("192", "SELECT DISTINCT * FROM /exampleRegion where status = 'active' AND ID = 2 OR P1.secId = 'IBM'"); queries.put("193", "SELECT DISTINCT * FROM /exampleRegion where status = 'active' AND ID = 2"); queries.put("194", "SELECT DISTINCT * FROM /exampleRegion where status = 'active' AND ID =1 AND P1.secType = 'a'"); queries.put("195", "SELECT DISTINCT * FROM /exampleRegion where status = 'active' OR NOT( ID = 2 )"); queries.put("196", "SELECT DISTINCT * FROM /exampleRegion where status = 'active' OR P1.secType = 'a'"); queries.put("197", "SELECT DISTINCT * FROM /exampleRegion where status = 'active' OR ID = 1 AND P1.secType = 'a'"); queries.put("198", "SELECT DISTINCT * FROM /exampleRegion where status = 'active' OR ID = 2 AND P1.secId = 'IBM'"); queries.put("199", "SELECT DISTINCT * FROM /exampleRegion where status = 'active' OR ID = 2 OR P1.secId = 'IBM'"); queries.put("200", "SELECT DISTINCT * FROM /exampleRegion where status = 'active' OR ID = 2"); queries.put("201", "SELECT DISTINCT * FROM /exampleRegion where status = 'active'"); queries.put("202", "SELECT DISTINCT * FROM /exampleRegion where status = 'inactive'"); queries.put("203", "SELECT DISTINCT * FROM /exampleRegion where status > 'active'"); queries.put("204", "SELECT DISTINCT * FROM /exampleRegion where status >= 'active'"); queries.put("205", "SELECT DISTINCT * FROM /exampleRegion where status='active'"); queries.put("206", "SELECT DISTINCT * FROM /exampleRegion where\"AND\"()"); queries.put("207", "SELECT DISTINCT * FROM /exampleRegion where\"DISTINCT\"()"); queries.put("208", "SELECT DISTINCT * FROM /exampleRegion where\"ELEMENT\"()"); queries.put("209", "SELECT DISTINCT * FROM /exampleRegion where\"FALSE\""); queries.put("210", "SELECT DISTINCT * FROM /exampleRegion where\"FALSE\"()"); queries.put("211", "SELECT DISTINCT * FROM /exampleRegion where\"FROM\"()"); queries.put("212", "SELECT DISTINCT * FROM /exampleRegion where\"NOT\"()"); queries.put("213", "SELECT DISTINCT * FROM /exampleRegion where\"OR\"()"); queries.put("214", "SELECT DISTINCT * FROM /exampleRegion where\"SELECT\"()"); queries.put("215", "SELECT DISTINCT * FROM /exampleRegion where\"TRUE\""); queries.put("216", "SELECT DISTINCT * FROM /exampleRegion where\"TRUE\"()"); queries.put("217", "SELECT DISTINCT * FROM /exampleRegion where\"TYPE\"()"); queries.put("218", "SELECT DISTINCT * FROM /exampleRegion where\"UNDEFINED\"()"); queries.put("219", "SELECT DISTINCT * FROM /exampleRegion where\"WHERE\"()"); queries.put("220", "SELECT DISTINCT * FROM /exampleRegion where\"and\""); queries.put("221", "SELECT DISTINCT * FROM /exampleRegion where\"distinct\""); queries.put("222", "SELECT DISTINCT * FROM /exampleRegion where\"element\""); queries.put("223", "SELECT DISTINCT * FROM /exampleRegion where\"from\""); queries.put("224", "SELECT DISTINCT * FROM /exampleRegion where\"not\""); queries.put("225", "SELECT DISTINCT * FROM /exampleRegion where\"or\""); queries.put("226", "SELECT DISTINCT * FROM /exampleRegion where\"select\""); queries.put("227", "SELECT DISTINCT * FROM /exampleRegion where\"undefined\""); queries.put("228", "SELECT DISTINCT * FROM /exampleRegion where\"where\""); queries.put("229", "SELECT DISTINCT * FROM /exampleRegion x where status = ELEMENT(SELECT DISTINCT * FROM /exampleRegion p where p.ID = 1).status"); queries.put("230", "SELECT DISTINCT * FROM /exampleRegion x where status = ELEMENT(SELECT DISTINCT * FROM /exampleRegion p where p.ID = x.ID).status"); queries.put("231", "SELECT DISTINCT * FROM /exampleRegion x where status = ELEMENT(SELECT DISTINCT * FROM /exampleRegion p where x.ID = p.ID).status"); queries.put("232", "SELECT DISTINCT * FROM /exampleRegion"); queries.put("233", "SELECT DISTINCT * FROM /exampleRegion er, positions.values where er.status='active'"); queries.put("234", "SELECT DISTINCT * FROM /exampleRegion er, positions WHERE er.ID = 3"); queries.put("235", "SELECT DISTINCT * FROM NULL"); queries.put("236", "SELECT DISTINCT * FROM UNDEFINED"); queries.put("237", "SELECT DISTINCT * from /exampleRegion order by status, ID desc"); queries.put("238", "SELECT DISTINCT * from /exampleRegion p order by p.getID()"); queries.put("239", "SELECT DISTINCT * from /exampleRegion p order by p.getP1().getSecId()"); queries.put("240", "SELECT DISTINCT * from /exampleRegion p order by p.getP1().secId"); queries.put("241", "SELECT DISTINCT * from /exampleRegion p order by p.getP1().secId, p.ID desc, p.ID LIMIT 9"); queries.put("242", "SELECT DISTINCT * from /exampleRegion p order by p.ID"); queries.put("243", "SELECT DISTINCT * from /exampleRegion p order by p.names[1]"); queries.put("244", "SELECT DISTINCT * from /exampleRegion p order by p.position1.secId"); queries.put("245", "SELECT DISTINCT * from /exampleRegion p order by p.status, p.ID"); queries.put("246", "SELECT DISTINCT * from /exampleRegion p, p.positions.values order by p.ID"); queries.put("247", "SELECT DISTINCT * from /exampleRegion pf , pf.positions.values pos where pos.getSecId = 'IBM' and pf.status = 'inactive'"); queries.put("248", "SELECT DISTINCT * from /exampleRegion pf, pf.positions.values pos where pos.secId = 'IBM'"); queries.put("249", "SELECT DISTINCT c.name, s.name FROM /exampleRegion c, c.states s, s.districts d, d.cities ct WHERE ct.name = 'MUMBAI' AND s.name = 'GUJARAT'"); queries.put("250", "SELECT DISTINCT c.name, s.name FROM /exampleRegion c, c.states s, s.districts d, d.cities ct WHERE ct.name = 'MUMBAI' OR s.name = 'GUJARAT'"); queries.put("251", "SELECT DISTINCT c.name, s.name, ct.name FROM /exampleRegion c, c.states s, s.districts d, d.cities ct, d.getVillages() v WHERE v.getName() = 'PUNJAB_VILLAGE1'"); queries.put("252", "SELECT DISTINCT c.name, s.name, d.name, ct.name FROM /exampleRegion c, c.states s, s.districts d, d.cities ct WHERE ct.name = 'MUMBAI' OR ct.name = 'CHENNAI'"); queries.put("253", "SELECT DISTINCT c1.name, s1.name, ct1.name FROM /exampleRegion c1, c1.states s1, s1.districts d1, d1.cities ct1, d1.getVillages() v1 WHERE v1.getName() = 'PUNJAB_VILLAGE1'"); queries.put("254", "SELECT DISTINCT d.getName(), d.getCities(), d.getVillages() FROM /exampleRegion c, c.states s, s.districts d WHERE d.name = 'MUMBAIDIST'"); queries.put("255", "SELECT DISTINCT e.key from /exampleRegion.entrySet e order by e.key.ID desc, e.key.pkid desc"); queries.put("256", "SELECT DISTINCT e.key from /exampleRegion.entrySet e order by e.key.ID, e.key.pkid desc"); queries.put("257", "SELECT DISTINCT e.key, e.value from /exampleRegion.entrySet e order by e.key.ID, e.value.status desc"); queries.put("258", "SELECT DISTINCT e.key.ID from /exampleRegion.entries e order by e.key.ID"); queries.put("259", "SELECT DISTINCT e.key.ID, e.value.status from /exampleRegion.entries e order by e.key.ID"); queries.put("260", "SELECT DISTINCT e.key.ID, e.value.status from /exampleRegion.entrySet e order by e.key.ID desc , e.value.status desc"); queries.put("261", "SELECT DISTINCT e.key.ID, e.value.status from /exampleRegion.entrySet e order by e.key.ID, e.value.status desc"); queries.put("262", "SELECT DISTINCT r.iD, p.value.secId FROM /exampleRegion r, getPositions('true') p where r.status = 'active' and r.iD = 0"); queries.put("263", "SELECT DISTINCT er.ID, value.secId FROM /exampleRegion er, getPositions value where er.status = 'active' and er.ID = 0"); queries.put("264", "SELECT DISTINCT key from /exampleRegion.keys key order by key.status"); queries.put("265", "SELECT DISTINCT key.ID from /exampleRegion.keys key order by key.ID"); queries.put("266", "SELECT DISTINCT key.ID, key.status from /exampleRegion.keys key order by key.status desc, key.ID"); queries.put("267", "SELECT DISTINCT key.ID, key.status from /exampleRegion.keys key order by key.status"); queries.put("268", "SELECT DISTINCT key.ID, key.status from /exampleRegion.keys key order by key.status, key.ID desc"); queries.put("269", "SELECT DISTINCT key.ID, key.status from /exampleRegion.keys key order by key.status, key.ID"); queries.put("270", "SELECT DISTINCT name FROM /exampleRegion , secIds name where length > 0"); queries.put("271", "SELECT DISTINCT p, pos from /exampleRegion p, p.positions.values pos order by p.ID"); queries.put("272", "SELECT DISTINCT p, pos from /exampleRegion p, p.positions.values pos order by p.ID, pos.secId"); queries.put("273", "SELECT DISTINCT p, pos from /exampleRegion p, p.positions.values pos order by pos.secId"); queries.put("274", "SELECT DISTINCT p.getID() from /exampleRegion p order by p.getID()"); queries.put("275", "SELECT DISTINCT p.ID from /exampleRegion p order by p.ID"); queries.put("276", "SELECT DISTINCT p.ID, p.status from /exampleRegion p order by p.ID"); queries.put("277", "SELECT DISTINCT p.ID from /exampleRegion p, p.positions.values order by p.ID"); queries.put("278", "SELECT DISTINCT p.ID, p.position1.secId from /exampleRegion p order by p.position1.secId"); queries.put("279", "SELECT DISTINCT p.ID, p.position1.secId from /exampleRegion p order by p.position1.secId, p.ID"); queries.put("280", "SELECT DISTINCT p.ID, p.status from /exampleRegion p order by p.ID desc, p.status asc"); queries.put("281", "SELECT DISTINCT p.ID, p.status from /exampleRegion p, p.positions.values order by p.status"); queries.put("282", "SELECT DISTINCT p.ID, p.status from /exampleRegion p, p.positions.values order by p.status, p.ID"); queries.put("283", "SELECT DISTINCT p.ID, pos.secId from /exampleRegion p, p.positions.values pos order by p.ID desc, pos.secId desc"); queries.put("284", "SELECT DISTINCT p.ID, pos.secId from /exampleRegion p, p.positions.values pos order by p.ID desc, pos.secId"); queries.put("285", "SELECT DISTINCT p.ID, pos.secId from /exampleRegion p, p.positions.values pos order by p.ID, pos.secId"); queries.put("286", "SELECT DISTINCT p.ID, pos.secId from /exampleRegion p, p.positions.values pos order by pos.secId"); queries.put("287", "SELECT DISTINCT p.ID, pos.secId from /exampleRegion p, p.positions.values pos order by pos.secId, p.ID"); queries.put("288", "SELECT DISTINCT p.key, p.value FROM /exampleRegion.entrySet p WHERE p.value.ID <= 10 order by p.value.createTime asc limit 1"); queries.put("289", "SELECT DISTINCT p.key, p.value FROM /exampleRegion.entrySet p WHERE p.value.ID <= 10 order by p.value.createTime desc limit 1"); queries.put("290", "SELECT DISTINCT p.names[1] from /exampleRegion p order by p.names[1]"); queries.put("291", "SELECT DISTINCT p.position1.secId, p.ID from /exampleRegion p order by p.position1.secId desc, p.ID"); queries.put("292", "SELECT DISTINCT p.position1.secId, p.ID from /exampleRegion p order by p.position1.secId"); queries.put("293", "SELECT DISTINCT p.status, p.ID from /exampleRegion p order by p.status asc, p.ID"); queries.put("294", "SELECT DISTINCT p.status, p.ID from /exampleRegion p order by p.status"); queries.put("295", "SELECT DISTINCT p.status, p.ID from /exampleRegion p order by p.status, p.ID"); queries.put("296", "SELECT DISTINCT pf FROM /exampleRegion pf, positions.values pos where pf.description = 'XXXX' and pos.secId= 'IBM'"); queries.put("297", "SELECT DISTINCT pos.secId FROM /exampleRegion er, positions.values AS pos WHERE er.ID > 0"); queries.put("298", "SELECT DISTINCT pos.secId FROM /exampleRegion, pos IN positions.values WHERE pos.ID > 0"); queries.put("299", "SELECT DISTINCT pos.secId from /exampleRegion p, p.positions.values pos order by pos.secId"); queries.put("300", "SELECT DISTINCT s.name, s.getDistricts(), ct.getName() FROM /exampleRegion c, c.getStates() s, s.getDistricts() d, d.getCities() ct WHERE ct.getName() = 'PUNE' OR ct.name = 'CHANDIGARH' OR s.getName() = 'GUJARAT'"); queries.put("301", "SELECT DISTINCT status, ID from /exampleRegion order by status"); queries.put("302", "SELECT DISTINCT status, ID from /exampleRegion order by status, ID"); queries.put("303", "SELECT ID FROM /exampleRegion pf WHERE pf.ID = 1"); queries.put("304", "SELECT ID FROM /exampleRegion pf WHERE pf.ID > 10"); queries.put("305", "SELECT ID FROM /exampleRegion pf WHERE pf.ID > 5"); queries.put("306", "SELECT ID FROM /exampleRegion.keys key WHERE key.ID = 1"); queries.put("307", "SELECT ID FROM /exampleRegion.keys key WHERE key.ID > 5"); queries.put("308", "SELECT k.ID, k.status FROM /exampleRegion.keys k WHERE k.ID = 1 and k.status = 'active'"); queries.put("309", "SELECT key.ID FROM /exampleRegion.keys key WHERE key.ID > 5 and key.status = 'active'"); queries.put("310", "SELECT pkid FROM /exampleRegion ps WHERE ps.pkid = 'abc'"); queries.put("311", "Select * from /exampleRegion pf where pf.ID < 2"); queries.put("312", "Select * from /exampleRegion pf where pf.ID = 2"); queries.put("313", "Select * from /exampleRegion pf where pf.ID > 1"); queries.put("314", "Select * from /exampleRegion pf where pf.position1.secId > '2'"); queries.put("315", "Select * from /exampleRegion.keys key where key.ID = 2"); queries.put("316", "Select distinct * from /exampleRegion.keySet keys where keys = '4'"); queries.put("317", "Select distinct security from /exampleRegion pos , secIds security where length > 2 and pos.ID > 0"); queries.put("318", "Select distinct * from /exampleRegion e, /exampleRegion a, e.getPhoneNo(a.zipCode) ea where e.name ='empName'"); queries.put("319", "Select distinct * from /exampleRegion pf where pf.getID() = -1"); queries.put("320", "Select distinct * from /exampleRegion pf where pf.getID() = -2147483648"); queries.put("321", "Select distinct * from /exampleRegion pf where pf.getID() = 3 and pf.getDoubleMinValue() = 4.9E-324"); queries.put("322", "Select distinct * from /exampleRegion pf where pf.getID() = 3 and pf.getFloatMinValue() = 1.4E-45f"); queries.put("323", "Select distinct * from /exampleRegion pf where pf.getID() = 3 and pf.getLongMinValue() = -9223372036854775808l"); queries.put("324", "Select distinct * from /exampleRegion pf, /exampleRegion e where e.name ='empName' and pf.status='active'"); queries.put("325", "Select distinct * from /exampleRegion pf, /exampleRegion e where e.name ='empName'"); queries.put("326", "Select distinct * from /exampleRegion pf, pf.positions.values pos where pf.status = 'active' and pos.secId = 'IBM'"); queries.put("327", "Select distinct * from /exampleRegion pf,/exampleRegion e where pf.status='active'"); queries.put("328", "Select distinct * from /exampleRegion pf1 where pf1.getID() > 3"); queries.put("329", "Select distinct * from /exampleRegion pf1 where pf1.pkid > '3'"); queries.put("330", "Select distinct * from /exampleRegion, /exampleRegion"); queries.put("331", "Select distinct * from /exampleRegion.entrySet pf where pf.value.getID() = 4"); queries.put("332", "Select distinct e.value.secId from /exampleRegion, getPositions(23) e"); queries.put("333", "Select distinct ID from /exampleRegion"); queries.put("334", "Select distinct p from /exampleRegion p order by p"); queries.put("335", "Select distinct pf from /exampleRegion pf , pf.positions.values ps where ps.secId='SUN'"); queries.put("336", "Select distinct security from /exampleRegion , secIds security where security.length > 2 AND (security.intern <> 'SUN' AND security.intern <> 'DELL' )"); queries.put("337", "Select distinct security from /exampleRegion, secIds security where security.length > 1"); queries.put("338", "Select distinct pos.secId from /exampleRegion , getPositions(23) pos"); queries.put("339", "Select distinct pos.secId from /exampleRegion, positions pos"); queries.put("340", "Select p.get('acc') from /exampleRegion p"); queries.put("341", "Select p.get('account') from /exampleRegion p"); queries.put("342", "Select p.shortID from /exampleRegion p where p.shortID < 5"); queries.put("343", "Select pf.ID from /exampleRegion pf where pf.ID > 2 and pf.ID < 100"); queries.put("344", "Select status from /exampleRegion pf where status='active'"); queries.put("345", "'a' IN SET('x','y','z')"); queries.put("346", "import org.apache.geode.cache.\"query\".data.Portfolio; select distinct * from /exampleRegion, (select distinct * from /exampleRegion p TYPE Portfolio, p.positions where value!=null)"); queries.put("347", "import org.apache.geode.cache.\"query\".data.Position;select distinct value.secId from /exampleRegion, (map<string, Position>)getPositions(23)"); queries.put("348", "select * from /exampleRegion pf where pf.getID > 1 and pf.getID < 12000"); queries.put("349", "select * from /exampleRegion pf where pf.status != 'active' and pf.status != null"); queries.put("350", "select distinct p.status from /exampleRegion p where p.ID IN SET( 0) AND p.createTime IN SET( 4l ) AND p.\"type\" IN SET( 'type0') AND p.status IN SET( 'active')"); queries.put("351", "select distinct p.status from /exampleRegion p where (p.createTime IN SET( 10l ) OR p.status IN SET( 'active') )AND p.ID > 0 AND p.createTime = 10l"); queries.put("352", "select distinct p.status from /exampleRegion p where (p.createTime IN SET( 10l ) OR p.status IN SET( 'active') )AND p.ID > 0"); queries.put("353", "select distinct p.status from /exampleRegion p where p.createTime = 10l AND p.status IN SET( 'active') AND true"); queries.put("354", "select distinct p.status from /exampleRegion p where p.createTime > 0 AND p.createTime <11 AND p.ID IN SET( 0)"); queries.put("355", "select distinct p.status from /exampleRegion p where p.ID = 11 AND p.createTime IN SET( 10L)"); queries.put("356", "select distinct p.status from /exampleRegion p where p.ID > 11 AND p.ID < 19 and p.createTime IN SET( 10L)"); queries.put("357", "select distinct p.status from /exampleRegion p where p.ID > 11 AND p.ID < 20 AND p.createTime <>9L"); queries.put("358", "select distinct p.status from /exampleRegion p where true"); queries.put("359", "select p.status as sts, p as pos from /exampleRegion p where p.ID IN ( Select x.ID from /exampleRegion x where x.ID > 10)"); queries.put("360", "select p.status as sts, p as pos from /exampleRegion p where p.ID IN SET( 0,1,2,3,4,5)"); queries.put("361", "select p.status as sts, p as pos from /exampleRegion p where p.ID IN SET( 0,1,2,3,4,5,101,102,103,104,105) AND p.createTime > 9l"); queries.put("362", "select p.status as sts, p as pos from /exampleRegion p where ( p.ID IN SET( 0,1,2,3) and p.createTime > 0L) OR (p.ID IN SET( 2,3) and p.createTime > 5L)"); queries.put("363", "select p.status as sts, p as pos from /exampleRegion p where p.ID > 0 and p.createTime > 0"); queries.put("364", "select p.status as sts, p as pos from /exampleRegion p where p.ID IN SET( 0,1,2,3) and p.createTime > 0"); queries.put("365", "select p.status from /exampleRegion p where p.ID > 0 and p.createTime > 0"); queries.put("366", "select p.status from /exampleRegion p where p.ID > 0"); queries.put("367", "select p.status from /exampleRegion p, p.positions pos where p.ID > 0"); queries.put("368", "select * from /exampleRegion p where NOT (p.ID IN SET(1, 2))"); queries.put("369", "select * from /exampleRegion sf where sf.shortField < 10"); queries.put("370", "select * from /exampleRegion this where FALSE"); queries.put("371", "select * from /exampleRegion this where NOT isActive"); queries.put("372", "select * from /exampleRegion this where NULL"); queries.put("373", "select * from /exampleRegion this where P1.secId = 'SUN'"); queries.put("374", "select * from /exampleRegion this where TRUE"); queries.put("375", "select * from /exampleRegion this where UNDEFINED"); queries.put("376", "select * from /exampleRegion this where ID < 1"); queries.put("377", "select * from /exampleRegion this where ID < 5"); queries.put("378", "select * from /exampleRegion this where ID <= 1"); queries.put("379", "select * from /exampleRegion this where ID <= 5"); queries.put("380", "select * from /exampleRegion this where ID = 0 OR ID = 1"); queries.put("381", "select * from /exampleRegion this where ID = 5"); queries.put("382", "select * from /exampleRegion this where ID > 2"); queries.put("383", "select * from /exampleRegion this where ID > 4 AND ID < 9"); queries.put("384", "select * from /exampleRegion this where ID > 5 and ID <=15"); queries.put("385", "select * from /exampleRegion this where ID >= 2"); queries.put("386", "select * from /exampleRegion this where isActive"); queries.put("387", "select * from /exampleRegion this where isActive()"); queries.put("388", "select * from /exampleRegion this where pk = '2'"); queries.put("389", "select * from /exampleRegion this where pk = '7'"); queries.put("390", "select * from /exampleRegion this where status <> 'active'"); queries.put("391", "select * from /exampleRegion this where status = 'active' AND ( ID = 1 OR P1.secId = 'SUN')"); queries.put("392", "select * from /exampleRegion this where status = 'active' AND ID = 0"); queries.put("393", "select * from /exampleRegion this where status = 'active' AND ID = 1"); queries.put("394", "select * from /exampleRegion this where status = 'active' OR ID = 1"); queries.put("395", "select * from /exampleRegion this where status = 'active'"); queries.put("396", "select * from /exampleRegion this where testMethod(true)"); queries.put("397", "select * from /exampleRegion this where this = 'value'"); queries.put("398", "select * from /exampleRegion this where toString()='doOpDuringBucketRemove.VALUE'"); queries.put("399", "select * from /exampleRegion where 3 >= length"); queries.put("400", "select * from /exampleRegion where age < 50"); queries.put("401", "select * from /exampleRegion where intVar = 0"); queries.put("402", "select * from /exampleRegion.entries sf where sf.value.shortField < 10"); queries.put("403", "select ALL * from /exampleRegion where 3 >= length"); queries.put("404", "select distinct key.status as st from /exampleRegion key where key.ID > 5 order by key.status"); queries.put("405", "select distinct p.position1.secId as st from /exampleRegion p order by p.position1.secId"); queries.put("406", "select distinct p.status, p.ID from /exampleRegion p order by p.status"); queries.put("407", "select distinct status, ID from /exampleRegion order by status"); queries.put("408", "select distinct 'a' from /exampleRegion p"); queries.put("409", "select distinct 'a',1, p from /exampleRegion p"); queries.put("410", "select distinct 'a',1, p from UNDEFINED"); queries.put("411", "select distinct 'a',1, p from null"); queries.put("412", "select distinct * from /exampleRegion a, /exampleRegion p, /exampleRegion e, a.street s where s.street ='DPStreet1'"); queries.put("413", "select distinct * from /exampleRegion a, /exampleRegion p, /exampleRegion e, a.street s where p.status='active' and s.street ='DPStreet1'"); queries.put("414", "select distinct * from /exampleRegion itr1,itr1.phoneNo itr2,itr1.street itr3 where itr2.mobile>333"); queries.put("415", "select distinct * from /exampleRegion itr1,itr1.street itr2,itr1.phoneNo itr3 where itr3.mobile>333"); queries.put("416", "select distinct * from /exampleRegion p order by p.getID()"); queries.put("417", "select distinct * from /exampleRegion p order by p.getP1().secId"); queries.put("418", "select distinct * from /exampleRegion p order by status, ID desc"); queries.put("419", "select distinct * from /exampleRegion p where p.ID > 1 and p.ID < 3"); queries.put("420", "select distinct * from /exampleRegion p"); queries.put("421", "select distinct * from /exampleRegion p, /exampleRegion e where p.pkid = '1'"); queries.put("422", "select distinct * from /exampleRegion p, /exampleRegion e"); queries.put("423", "select distinct * from /exampleRegion p, /exampleRegion e, /exampleRegion a, a.street s where s.street ='DPStreet1'"); queries.put("424", "select distinct * from /exampleRegion p, /exampleRegion p1 where p.position1.Id = p1.position1.Id and p1.position1.secId in set('MSFT')"); queries.put("425", "select distinct * from /exampleRegion p, p.positions where p.ID = 1"); queries.put("426", "select distinct * from /exampleRegion p, p.positions,/exampleRegion e where p.ID = e.empId"); queries.put("427", "select distinct * from /exampleRegion p, p.positions,/exampleRegion e, /exampleRegion p1 where p.ID = 1 and p1.ID = 2 and e.empId = 1"); queries.put("428", "select distinct * from /exampleRegion p, p.positions,/exampleRegion e, /exampleRegion p1 where p.ID =p1.ID and e.empId = 1 and p1.status = 'active' and p.status='active'"); queries.put("429", "select distinct * from /exampleRegion p, p.positions,/exampleRegion e, /exampleRegion p1 where p.ID =p1.ID and e.empId = p1.ID"); queries.put("430", "select distinct * from /exampleRegion p, p.positions.values order by p.ID"); queries.put("431", "select distinct * from /exampleRegion p, p.positions.values val order by p.ID, val.secId desc"); queries.put("432", "select distinct * from /exampleRegion p, p.positions.values where p.ID < 3"); queries.put("433", "select distinct * from /exampleRegion p, p.positions.values where p.pkid != '53'"); queries.put("434", "select distinct * from /exampleRegion pf where false and ID = 0"); queries.put("435", "select distinct * from /exampleRegion pf where ID = 0 or false"); queries.put("436", "select distinct * from /exampleRegion pf where nvl(pf.position2, pf.position1).secId = 'SUN'"); queries.put("437", "select distinct * from /exampleRegion pf where nvl(pf.position2,'foundNull') = 'foundNull'"); queries.put("438", "select distinct * from /exampleRegion pf where true and ID = 0"); queries.put("439", "select distinct * from /exampleRegion pf where true or ID = 0"); queries.put("440", "select distinct * from /exampleRegion pf, positions.values pos where (pf.ID > 1 or pf.status = 'active') or (false AND pos.secId ='IBM')"); queries.put("441", "select distinct * from /exampleRegion pf, positions.values pos where true = true and pf.ID > 1 and pos.secId ='IBM'"); queries.put("442", "select distinct * from /exampleRegion pf, positions.values pos where (pf.ID > 1 or pf.status = 'active') or (true AND pos.secId ='IBM')"); queries.put("443", "select distinct * from /exampleRegion pf, positions.values pos where (true AND pos.secId ='SUN') or (pf.ID > 1 and pf.status != 'active')"); queries.put("444", "select distinct * from /exampleRegion pf, positions.values pos where (ID = 2 or false) or (pf.status = 'active' and (pos.secId != 'IBM' or true))"); queries.put("445", "select distinct * from /exampleRegion pf, positions.values pos where (pf.ID < 1 and pf.status = 'active') and (false or pos.secId = 'IBM')"); queries.put("446", "select distinct * from /exampleRegion pf, positions.values pos where false and pos.secId ='IBM'"); queries.put("447", "select distinct * from /exampleRegion pf, positions.values pos where true = false and pf.ID > 1 and pos.secId ='IBM'"); queries.put("448", "select distinct * from /exampleRegion pf, positions.values pos where true = true and pf.ID > 1 or pos.secId ='IBM'"); queries.put("449", "select distinct * from /exampleRegion pf, positions.values pos where true = true and pos.secId ='IBM'"); queries.put("450", "select distinct * from /exampleRegion s where 3 >= s.length"); queries.put("451", "select distinct * from /exampleRegion where 3 >= length"); queries.put("452", "select distinct * from /exampleRegion where NOT isActive"); queries.put("453", "select distinct * from /exampleRegion where ID != 53"); queries.put("454", "select distinct * from /exampleRegion where ID < 1"); queries.put("455", "select distinct * from /exampleRegion where ID >= 2"); queries.put("456", "select distinct * from /exampleRegion where isActive"); queries.put("457", "select distinct * from /exampleRegion where isActive()"); queries.put("458", "select distinct * from /exampleRegion where status <> 'active'"); queries.put("459", "select distinct * from /exampleRegion where status = 'active' AND ( ID = 1 OR P1.secId = 'SUN')"); queries.put("460", "select distinct * from /exampleRegion where status = 'active' AND ID = 0"); queries.put("461", "select distinct * from /exampleRegion where status = 'active' AND ID = 1"); queries.put("462", "select distinct * from /exampleRegion where status = 'active' OR ID = 1"); queries.put("463", "select distinct * from /exampleRegion where status = 'active'"); queries.put("464", "select distinct * from /exampleRegion where testMethod(true)"); queries.put("465", "select distinct * from /exampleRegion x, x.positions.values where x.pk = '1'"); queries.put("466", "select distinct * from /exampleRegion x, x.positions.values where x.pkid = '1'"); queries.put("467", "select distinct * from /exampleRegion"); queries.put("468", "select distinct * from /exampleRegion.entries where key = '1'"); queries.put("469", "select distinct * from /exampleRegion.entries where value.ID = 1 and key = '1'"); queries.put("470", "select distinct * from /exampleRegion.entries where value.status = 'active'"); queries.put("471", "select distinct * from /exampleRegion.entries x, x.value.positions.values where x.key = '1'"); queries.put("472", "select distinct * from /exampleRegion.entries x, x.value.positions.values where x.value.pkid = '1'"); queries.put("473", "select distinct * from /exampleRegion.keySet where toString = '1'"); queries.put("474", "select distinct * from /exampleRegion.keys where toString = '1'"); queries.put("475", "select distinct * from /exampleRegion.values where ID = 1"); queries.put("476", "select distinct * from /exampleRegion.values where status = 'active'"); queries.put("477", "select distinct * from null"); queries.put("478", "select distinct 1 from /exampleRegion p"); queries.put("479", "select distinct 1 from UNDEFINED"); queries.put("480", "select distinct 1 from null"); queries.put("481", "select distinct e.key from /exampleRegion.entrySet e order by e.key.ID desc, e.key.pkid desc"); queries.put("482", "select distinct e.key, e.value from /exampleRegion.entrySet e order by e.key.ID, e.value.status desc"); queries.put("483", "select distinct e.key.ID from /exampleRegion.entries e order by e.key.ID"); queries.put("484", "select distinct e.key.ID, e.value.status from /exampleRegion.entries e order by e.key.ID"); queries.put("485", "select distinct e.key.ID, e.value.status from /exampleRegion.entrySet e order by e.key.ID desc , e.value.status desc"); queries.put("486", "select distinct getID, status from /exampleRegion pf where getID < 10 order by getID asc"); queries.put("487", "select distinct getID, status from /exampleRegion pf where getID < 10 order by getID desc"); queries.put("488", "select distinct iD, status from /exampleRegion order by iD"); queries.put("489", "select distinct key from /exampleRegion.entrySet , value.positions.values where value.ID = 1 and key = '1'"); queries.put("490", "select distinct key.ID from /exampleRegion.keys key order by key.ID"); queries.put("491", "select distinct key.ID, key.status from /exampleRegion.keys key order by key.status desc, key.ID"); queries.put("492", "select distinct key.ID, key.status from /exampleRegion.keys key order by key.status, key.ID desc"); queries.put("493", "select distinct key.ID, key.status from /exampleRegion.keys key order by key.status, key.ID"); queries.put("494", "select distinct key.ID,key.status as st from /exampleRegion key where key.status = 'inactive' order by key.status desc, key.ID"); queries.put("495", "select distinct nm from /exampleRegion prt,names nm where prt.ID>0"); queries.put("496", "select distinct nvl(pf.position2, 'inProjection') from /exampleRegion pf where nvl(pf.position2, pf.position1).secId = 'SUN'"); queries.put("497", "select distinct nvl(pf.position2, 'inProjection') from /exampleRegion pf where nvl(pf.position2,'foundNull') = 'foundNull'"); queries.put("498", "select distinct p from /exampleRegion p where p.ID > 0"); queries.put("499", "select distinct p, pos from /exampleRegion p, p.positions.values pos order by p.ID"); queries.put("500", "select distinct p.ID, pos.secId from /exampleRegion p, p.positions.values pos order by pos.secId, p.ID"); queries.put("501", "select distinct p.names[1] from /exampleRegion p order by p.names[1]"); queries.put("502", "select distinct p.position1.secId as st from /exampleRegion p where p.ID > 0 and p.position1.secId != 'IBM' order by p.position1.secId"); queries.put("503", "select distinct p.position1.secId, p.ID from /exampleRegion p order by p.position1.secId"); queries.put("504", "select distinct p.status as STATUS, SECID: p.P1.SecId, ID from /exampleRegion p "); queries.put("505", "select distinct p.status as st from /exampleRegion p where ID > 0 and status = 'inactive' order by p.status"); queries.put("506", "select distinct p.status from /exampleRegion p order by p.status"); queries.put("507", "select distinct p.status from /exampleRegion p where p.ID > 0"); queries.put("508", "select distinct p.status, p.ID from /exampleRegion p order by p.status asc, p.ID"); queries.put("509", "select distinct p.status, p.ID from /exampleRegion p order by p.status, p.ID"); queries.put("510", "select distinct p.status,p.ID from /exampleRegion p where p.ID > 0"); queries.put("511", "select distinct portfolio: p ,p.P1.SecId from /exampleRegion p where p.ID > 0 "); queries.put("512", "select distinct pos.secId from /exampleRegion p, p.positions.values pos order by pos.secId"); queries.put("513", "select distinct positions.values.toArray[0], positions.values.toArray[0],status from /exampleRegion"); queries.put("514", "select distinct prt from /exampleRegion prt, names where prt.names[3]='ddd'"); queries.put("515", "select distinct status as st from /exampleRegion where ID > 0 order by status"); queries.put("516", "select distinct status from /exampleRegion where ID > 0 order by status"); queries.put("517", "select distinct status, getID from /exampleRegion pf where getID < 10 order by status asc, getID desc"); queries.put("518", "select distinct status, ID from /exampleRegion order by status, ID"); queries.put("519", "SELECT * FROM /exampleRegion WHERE \"type\" = 'type1'"); queries.put("520", "select count(*) from /exampleRegion"); queries.put("521", "SELECT * from /exampleRegion P1, P1.positions.values WHERE P1.ID = 5"); queries.put("522", "SELECT * from /exampleRegion P1, /exampleRegion2 P2 WHERE P1.ID = 5"); queries.put("523", "SELECT * from /numericRegion n WHERE n.max1 = 50"); queries.put("524", "SELECT * from /numericRegion n WHERE n.max1 = 50.0"); queries.put("525", "SELECT * from /numericRegion n WHERE n.max1 = 50.0f"); queries.put("526", "SELECT * from /numericRegion n WHERE n.max1 = 50.0d"); queries.put("527", "SELECT * from /numericRegion n WHERE n.max1 > 50"); queries.put("528", "SELECT * from /numericRegion n WHERE n.max1 > 50.0"); queries.put("529", "SELECT * from /numericRegion n WHERE n.max1 > 50.0f"); queries.put("530", "SELECT * from /numericRegion n WHERE n.max1 > 50.0d"); queries.put("531", "SELECT * from /numericRegion n WHERE n.max1 < 50"); queries.put("532", "SELECT * from /numericRegion n WHERE n.max1 < 50.0"); queries.put("533", "SELECT * from /numericRegion n WHERE n.max1 < 50.0f"); queries.put("534", "SELECT * from /numericRegion n WHERE n.max1 < 50.0d"); queries.put("535", "SELECT * from /numericRegion n WHERE n.max1 <= 50"); queries.put("536", "SELECT * from /numericRegion n WHERE n.max1 <= 50.0"); queries.put("537", "SELECT * from /numericRegion n WHERE n.max1 <= 50.0f"); queries.put("538", "SELECT * from /numericRegion n WHERE n.max1 <= 50.0d"); queries.put("539", "SELECT * from /numericRegion n WHERE n.max1 >= 50"); queries.put("540", "SELECT * from /numericRegion n WHERE n.max1 >= 50.0"); queries.put("541", "SELECT * from /numericRegion n WHERE n.max1 >= 50.0f"); queries.put("542", "SELECT * from /numericRegion n WHERE n.max1 >= 50.0d"); queries.put("543", "select distinct * from /portfolios p where p.ID > -1 order by p.ID"); queries.put("544", "select distinct * from /portfolios p where p.ID > -1 order by p.ID limit 100"); queries.put("545", "select distinct * from /portfolios p where p.ID > -1"); queries.put("546", "select distinct * from /portfolios p where p.ID > -1 limit 100"); // NESTED QUERIES queries.put("701", "SELECT ID, status FROM /exampleRegion portfolio WHERE NOT (SELECT DISTINCT * FROM portfolio.positions.values positions WHERE positions.secId='AOL' OR positions.secId='SAP').isEmpty"); queries.put("702", "SELECT * FROM /exampleRegion p where p.status = ELEMENT(SELECT DISTINCT * FROM /exampleRegion p2 WHERE p2.ID = 0).status"); queries.put("703", "IMPORT org.apache.geode.cache.\"query\".data.Portfolio; SELECT * FROM /exampleRegion, (SELECT DISTINCT * from /exampleRegion p TYPE Portfolio, p.positions WHERE value!=null)"); queries.put("704", "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM /exampleRegion portfolios, positions pos) WHERE pos.value.secId = 'IBM'"); queries.put("705", "SELECT * FROM /exampleRegion portfolio WHERE portfolio.ID IN (SELECT p2.ID FROM /exampleRegion2 p2 where p2.ID > 1)"); queries.put("706", "SELECT * FROM /root/exampleRegion p where NOT(SELECT DISTINCT * FROM positions.values pos WHERE pos.secId in SET('YHOO', 'SUN', 'IBM', 'YHOO', 'GOOG', 'MSFT', 'AOL', 'APPL', 'ORCL', 'SAP', 'DELL', 'RHAT', 'NOVL', 'HP')).isEmpty"); queries.put("707", "SELECT DISTINCT * FROM /exampleRegion pf, (SELECT DISTINCT * FROM /exampleRegion ptf, ptf.positions pos where pf.ID != 1 and pos.value.sharesOutstanding > 2000) as x WHERE x.secId = 'IBM'"); queries.put("708", "SELECT DISTINCT * FROM /exampleRegion pf, (SELECT DISTINCT * FROM /exampleRegion ptf, ptf.positions pos where pf.ID != 1 and pos.value.sharesOutstanding > 2000)as y WHERE y.value.secId = 'HP'"); queries.put("709", "SELECT DISTINCT * FROM /exampleRegion where NOT(SELECT DISTINCT * FROM /exampleRegion p where p.ID = 0).isEmpty"); queries.put("710", "SELECT DISTINCT * FROM /root/exampleRegion p, (SELECT DISTINCT pos FROM /root/exampleRegion x, x.positions.values pos WHERE x.ID = p.ID) as itrX"); queries.put("711", "SELECT DISTINCT * FROM /root/exampleRegion p, p.positions.values outerPos, (SELECT DISTINCT key from /exampleRegion.keys key)"); queries.put("712", "SELECT DISTINCT c.name, s.name, ct.name FROM /exampleRegion c, c.states s, (SELECT DISTINCT * FROM /exampleRegion c, c.states s, s.districts d, d.cities ct WHERE s.name = 'PUNJAB') itr1, s.districts d, d.cities ct WHERE ct.name = 'CHANDIGARH'"); queries.put("713", "SELECT DISTINCT c.name, s.name, ct.name FROM /exampleRegion c, c.states s, s.districts d, d.cities ct WHERE ct.name = element (SELECT DISTINCT ct.name FROM /exampleRegion c, c.states s, s.districts d, d.cities ct WHERE s.name = 'MAHARASHTRA' AND ct.name = 'PUNE')"); queries.put("714", "SELECT DISTINCT c1.name, s1.name, ct1.name FROM /exampleRegion c1, c1.states s1, (SELECT DISTINCT * FROM /exampleRegion2 c2, c2.states s2, s2.districts d2, d2.cities ct2 WHERE s2.name = 'PUNJAB') itr1, s1.districts d1, d1.cities ct1 WHERE ct1.name = 'CHANDIGARH'"); queries.put("715", "SELECT DISTINCT c1.name, s1.name, ct1.name FROM /exampleRegion c1, c1.states s1, s1.districts d1, d1.cities ct1 WHERE ct1.name = element (SELECT DISTINCT ct3.name FROM /exampleRegion3 c3, c3.states s3, s3.districts d3, d3.cities ct3 WHERE s3.name = 'MAHARASHTRA' AND ct3.name = 'PUNE')"); queries.put("716", "Select distinct * from /exampleRegion pfos, pfos.positions.values outerPos, (SELECT DISTINCT key"); queries.put("717", "Select distinct structset.sos, structset.key from /exampleRegion pfos, pfos.positions.values outerPos, " + "(SELECT DISTINCT key: key, sos: pos.sharesOutstanding from /exampleRegion.entries pf, pf.value.positions.values pos " + "where outerPos.secId != 'IBM' AND pf.key IN (select distinct * from pf.value.collectionHolderMap['0'].arr)) structset " + "where structset.sos > 2000"); queries.put("718", "select DISTINCT * from ( SELECT DISTINCT p.ID as portfolio_id, pos.secId as sec_id from /exampleRegion p , p.positions.values pos where p.status= 'active')"); queries.put("719", "select distinct * from /exampleRegion p, (select distinct pos as poos from /exampleRegion x, x.positions.values pos where pos.secId = 'YHOO') as k"); queries.put("720", "select distinct * from /exampleRegion p, (select distinct pos as poos from /exampleRegion x, p.positions.values pos where x.ID = p.ID) as k"); queries.put("721", "select distinct * from /exampleRegion p, (select distinct val from positions.values as val where val.secId = 'YHOO') as k"); queries.put("722", "select distinct * from /exampleRegion p, (select distinct x as pf , myPos as poos from /exampleRegion x, x.positions.values as myPos) as k where k.poos.secId = 'YHOO'"); queries.put("723", "select distinct * from /exampleRegion p, (select distinct x.ID as ID from /exampleRegion x where x.ID = p.ID) as k"); // STRING OPERATIONS queries.put("800", "SELECT distinct * FROM /exampleRegion ps WHERE ps.status like '%'"); queries.put("801", "SELECT distinct * FROM /exampleRegion ps WHERE ps.status like 'a%bc%'"); queries.put("802", "SELECT distinct * FROM /exampleRegion ps WHERE ps.status like 'abc%' AND ps.ID > 2 AND ps.ID < 150"); queries.put("803", "SELECT distinct * FROM /exampleRegion ps WHERE ps.status like 'abc%' OR ps.ID > 6"); queries.put("804", "SELECT distinct * FROM /exampleRegion ps WHERE ps.status like 'abc%'"); queries.put("805", "SELECT distinct * FROM /exampleRegion ps WHERE ps.status like 'abcd'"); queries.put("806", "SELECT distinct * FROM /exampleRegion ps WHERE ps.status like 'abcd\\%'"); queries.put("807", "SELECT distinct * FROM /exampleRegion ps WHERE ps.status like 'abcd\\_'"); queries.put("808", "SELECT distinct * FROM /exampleRegion ps WHERE ps.status like 'a_bc'"); queries.put("809", "SELECT distinct * FROM /exampleRegion ps WHERE ps.status like 'abc_'"); queries.put("810", "SELECT pkid FROM /exampleRegion ps WHERE ps.pkid like '%b%' and ps.pkid like '_bc'"); queries.put("811", "SELECT pkid FROM /exampleRegion ps WHERE ps.pkid like '%b%' and ps.status = 'like'"); queries.put("812", "SELECT pkid FROM /exampleRegion ps WHERE ps.pkid like '%b%' and ps.status like '%ike'"); queries.put("813", "SELECT pkid FROM /exampleRegion ps WHERE ps.pkid like 'abc%'"); queries.put("814", "SELECT pkid FROM /exampleRegion ps WHERE ps.pkid like 'ml%' or ps.status = 'like'"); queries.put("815", "select p from /exampleRegion.values p where p like '%%ti%'"); queries.put("816", "select p from /exampleRegion.values p where p like '%'"); queries.put("817", "select p from /exampleRegion.values p where p like '%c%iv%'"); queries.put("818", "select p from /exampleRegion.values p where p like '%ctiv%'"); queries.put("819", "select p from /exampleRegion.values p where p like '%ctive'"); queries.put("820", "select p from /exampleRegion.values p where p like '1inact\\_+ive'"); queries.put("821", "select p from /exampleRegion.values p where p like '?act?ve'"); queries.put("822", "select p from /exampleRegion.values p where p like 'X%X'"); queries.put("823", "select p from /exampleRegion.values p where p like 'X__X'"); queries.put("824", "select p from /exampleRegion.values p where p like 'Y\\%Y'"); queries.put("825", "select p from /exampleRegion.values p where p like 'Z\\\\%Z'"); queries.put("826", "select p from /exampleRegion.values p where p like '^+act.ve+^'"); queries.put("827", "select p from /exampleRegion.values p where p like '__tive'"); queries.put("828", "select p from /exampleRegion.values p where p like '_c_iv_'"); queries.put("829", "select p from /exampleRegion.values p where p like '_ctiv%'"); queries.put("830", "select p from /exampleRegion.values p where p like '_ctive'"); queries.put("831", "select p from /exampleRegion.values p where p like 'a%e'"); queries.put("832", "select p from /exampleRegion.values p where p like 'a%iv_'"); queries.put("833", "select p from /exampleRegion.values p where p like 'a_tiv%'"); queries.put("834", "select p from /exampleRegion.values p where p like 'ac%'"); queries.put("835", "select p from /exampleRegion.values p where p like 'ac(tiv)e'"); queries.put("836", "select p from /exampleRegion.values p where p like 'ac+t+ve'"); queries.put("837", "select p from /exampleRegion.values p where p like 'ac\\%'"); queries.put("838", "select p from /exampleRegion.values p where p like 'ac\\tive'"); queries.put("839", "select p from /exampleRegion.values p where p like 'ac_ive'"); queries.put("840", "select p from /exampleRegion.values p where p like 'ac_tive'"); queries.put("841", "select p from /exampleRegion.values p where p like 'act%%ve'"); queries.put("842", "select p from /exampleRegion.values p where p like 'act()ive'"); queries.put("843", "select p from /exampleRegion.values p where p like 'act)ve^'"); queries.put("844", "select p from /exampleRegion.values p where p like 'act**ve'"); queries.put("845", "select p from /exampleRegion.values p where p like 'act*+|ve'"); queries.put("846", "select p from /exampleRegion.values p where p like 'act/exampleRegion'"); queries.put("847", "select p from /exampleRegion.values p where p like 'act[]ve'"); queries.put("848", "select p from /exampleRegion.values p where p like 'act][ve'"); queries.put("849", "select p from /exampleRegion.values p where p like 'act^[a-z]ve'"); queries.put("850", "select p from /exampleRegion.values p where p like 'act__e'"); queries.put("851", "select p from /exampleRegion.values p where p like 'activ_'"); queries.put("852", "select p from /exampleRegion.values p where p like 'active'"); queries.put("853", "select p from /exampleRegion.values p where p like 'acxtxve'"); queries.put("854", "select p from /exampleRegion.values p where p like 'inact\\%+ive'"); queries.put("855", "select p from /exampleRegion.values p where p like 'inactive'"); queries.put("856", "select p from /exampleRegion.values p where p like '|+act(ve'"); queries.put("857", "SELECT * FROM /exampleRegion ps WHERE ps.status like '%b%' and ps.pkid = '1'"); queries.put("858", "SELECT * FROM /exampleRegion ps WHERE ps.status like '%b%' or ps.ID > 0"); queries.put("859", "SELECT * FROM /exampleRegion ps WHERE ps.status like '%b%' or ps.pkid = '2'"); queries.put("860", "SELECT * FROM /exampleRegion ps WHERE ps.status like '%b%'"); queries.put("861", "SELECT * FROM /exampleRegion ps WHERE ps.status like '_b_' or ps.pkid = '2'"); queries.put("862", "SELECT * FROM /exampleRegion ps WHERE ps.pkid like '%b%' and ps.status like '%ctiv%'"); queries.put("863", "SELECT * FROM /exampleRegion ps WHERE ps.pkid like '_bc'"); queries.put("864", "SELECT distinct * FROM /exampleRegion ps WHERE ps.pkid like '%b%'"); // LIMIT queries.put("900", "SELECT DISTINCT key.ID, key.status as st from /exampleRegion.keys key where key.status = 'inactive' order by key.status desc, key.ID LIMIT 1"); queries.put("901", "SELECT DISTINCT key.ID, key.status as st from /exampleRegion.keys key where key.status = 'inactive' order by key.status desc, key.ID LIMIT 9"); queries.put("902", "SELECT DISTINCT key.status as st, key.ID from /exampleRegion.keys key where key.ID > 5 order by key.status, key.ID desc LIMIT 1"); queries.put("903", "SELECT DISTINCT key.status as st, key.ID from /exampleRegion.keys key where key.ID > 5 order by key.status, key.ID desc LIMIT 4"); queries.put("904", "SELECT DISTINCT key.status as st, key.ID from /exampleRegion.keys key where key.ID > 5 order by key.status, key.ID desc LIMIT 9"); queries.put("905", "SELECT DISTINCT p.position1.secId , p.ID as st from /exampleRegion p order by p.position1.secId, p.ID LIMIT 1"); queries.put("906", "SELECT DISTINCT p.position1.secId , p.ID as st from /exampleRegion p order by p.position1.secId, p.ID LIMIT 9"); queries.put("907", "SELECT DISTINCT * from /exampleRegion p order by p.getID() LIMIT 9"); queries.put("908", "SELECT DISTINCT * from /exampleRegion p, p.positions.values val order by p.ID, val.secId LIMIT 1"); queries.put("909", "SELECT DISTINCT * from /exampleRegion p, p.positions.values val order by p.ID, val.secId LIMIT 9"); queries.put("910", "SELECT DISTINCT e.key from /exampleRegion.entrySet e order by e.key.ID, e.key.pkid desc LIMIT 1"); queries.put("911", "SELECT DISTINCT e.key from /exampleRegion.entrySet e order by e.key.ID, e.key.pkid desc LIMIT 4"); queries.put("912", "SELECT DISTINCT e.key from /exampleRegion.entrySet e order by e.key.ID, e.key.pkid desc LIMIT 9"); queries.put("913", "SELECT DISTINCT e.key.ID, e.value.status from /exampleRegion.entrySet e order by e.key.ID, e.value.status desc LIMIT 1"); queries.put("914", "SELECT DISTINCT e.key.ID, e.value.status from /exampleRegion.entrySet e order by e.key.ID, e.value.status desc LIMIT 4"); queries.put("915", "SELECT DISTINCT e.key.ID, e.value.status from /exampleRegion.entrySet e order by e.key.ID, e.value.status desc LIMIT 9"); queries.put("916", "SELECT DISTINCT iD, status from /exampleRegion order by iD LIMIT 1"); queries.put("917", "SELECT DISTINCT iD, status from /exampleRegion order by iD LIMIT 4"); queries.put("918", "SELECT DISTINCT iD, status from /exampleRegion order by iD LIMIT 9"); queries.put("919", "SELECT DISTINCT iD, status from /exampleRegion order by iD"); queries.put("920", "SELECT DISTINCT key from /exampleRegion.keys key order by key.status, key.ID LIMIT 1"); queries.put("921", "SELECT DISTINCT key from /exampleRegion.keys key order by key.status, key.ID LIMIT 4"); queries.put("922", "SELECT DISTINCT key from /exampleRegion.keys key order by key.status, key.ID LIMIT 9"); queries.put("923", "SELECT DISTINCT key.ID from /exampleRegion.keys key order by key.ID LIMIT 1"); queries.put("924", "SELECT DISTINCT key.ID from /exampleRegion.keys key order by key.ID LIMIT 4"); queries.put("925", "SELECT DISTINCT key.ID from /exampleRegion.keys key order by key.ID LIMIT 9"); queries.put("926", "SELECT DISTINCT key.ID, key.status from /exampleRegion.keys key order by key.status desc, key.ID LIMIT 9"); queries.put("927", "SELECT DISTINCT key.ID, key.status from /exampleRegion.keys key order by key.status, key.ID asc LIMIT 1"); queries.put("928", "SELECT DISTINCT key.ID, key.status from /exampleRegion.keys key order by key.status, key.ID asc LIMIT 4"); queries.put("929", "SELECT DISTINCT key.ID, key.status from /exampleRegion.keys key order by key.status, key.ID asc LIMIT 9"); queries.put("930", "SELECT DISTINCT p, pos from /exampleRegion p, p.positions.values pos order by p.ID, pos.secId desc LIMIT 1"); queries.put("931", "SELECT DISTINCT p, pos from /exampleRegion p, p.positions.values pos order by p.ID, pos.secId desc LIMIT 4"); queries.put("932", "SELECT DISTINCT p, pos from /exampleRegion p, p.positions.values pos order by p.ID, pos.secId desc LIMIT 9"); queries.put("933", "SELECT DISTINCT p, pos from /exampleRegion p, p.positions.values pos order by pos.secId, p.ID LIMIT 1"); queries.put("934", "SELECT DISTINCT p, pos from /exampleRegion p, p.positions.values pos order by pos.secId, p.ID LIMIT 4"); queries.put("935", "SELECT DISTINCT p, pos from /exampleRegion p, p.positions.values pos order by pos.secId, p.ID LIMIT 9"); queries.put("936", "SELECT DISTINCT p.ID, p.status from /exampleRegion p order by p.ID LIMIT 9"); queries.put("937", "SELECT DISTINCT p.position1.secId as st, p.ID as ied from /exampleRegion p where p.ID > 0 and p.position1.secId != 'IBM' order by p.position1.secId, p.ID LIMIT 1"); queries.put("938", "SELECT DISTINCT p.position1.secId as st, p.ID as ied from /exampleRegion p where p.ID > 0 and p.position1.secId != 'IBM' order by p.position1.secId, p.ID LIMIT 4"); queries.put("939", "SELECT DISTINCT p.position1.secId as st, p.ID as ied from /exampleRegion p where p.ID > 0 and p.position1.secId != 'IBM' order by p.position1.secId, p.ID LIMIT 9"); queries.put("940", "SELECT DISTINCT p.position1.secId, p.ID from /exampleRegion p order by p.position1.secId, p.ID desc LIMIT 1"); queries.put("941", "SELECT DISTINCT p.position1.secId, p.ID from /exampleRegion p order by p.position1.secId, p.ID desc LIMIT 4"); queries.put("942", "SELECT DISTINCT p.position1.secId, p.ID from /exampleRegion p order by p.position1.secId, p.ID desc LIMIT 9"); queries.put("943", "SELECT DISTINCT p.status as st, p.ID as ID from /exampleRegion p where ID > 0 and status = 'inactive' order by p.status, p.ID desc LIMIT 1"); queries.put("944", "SELECT DISTINCT p.status as st, p.ID as ID from /exampleRegion p where ID > 0 and status = 'inactive' order by p.status, p.ID desc LIMIT 4"); queries.put("945", "SELECT DISTINCT p.status as st, p.ID as ID from /exampleRegion p where ID > 0 and status = 'inactive' order by p.status, p.ID desc LIMIT 9"); queries.put("946", "SELECT DISTINCT p.status from /exampleRegion p order by p.status LIMIT 9"); queries.put("947", "SELECT DISTINCT p.status, p.ID from /exampleRegion p order by p.status asc, p.ID LIMIT 1"); queries.put("948", "SELECT DISTINCT p.status, p.ID from /exampleRegion p order by p.status asc, p.ID LIMIT 4"); queries.put("949", "SELECT DISTINCT p.status, p.ID from /exampleRegion p order by p.status asc, p.ID LIMIT 9"); queries.put("950", "SELECT DISTINCT pf.ID , pf.createTime FROM /exampleRegion pf WHERE pf.ID > 10 limit 5"); queries.put("951", "SELECT DISTINCT pf.ID FROM /exampleRegion pf WHERE pf.ID > 10 limit 5"); queries.put("952", "SELECT DISTINCT pf.ID FROM /exampleRegion pf WHERE pf.ID > 0 limit 5"); queries.put("953", "SELECT DISTINCT pf.ID, pf.createTime FROM /exampleRegion pf WHERE pf.ID > 0 limit 5"); queries.put("954", "SELECT DISTINCT status , ID as ied from /exampleRegion where ID > 0 order by status, ID desc LIMIT 1"); queries.put("955", "SELECT DISTINCT status , ID as ied from /exampleRegion where ID > 0 order by status, ID desc LIMIT 4"); queries.put("956", "SELECT DISTINCT status , ID as ied from /exampleRegion where ID > 0 order by status, ID desc LIMIT 9"); queries.put("957", "SELECT DISTINCT status as st from /exampleRegion order by status LIMIT 1"); queries.put("958", "SELECT DISTINCT status as st from /exampleRegion order by status LIMIT 4"); queries.put("959", "SELECT DISTINCT status as st from /exampleRegion order by status LIMIT 9"); queries.put("960", "SELECT * FROM /exampleRegion p WHERE p.ID > 0 LIMIT 2"); queries.put("961", "select * from /exampleRegion this where ID > 2 limit 100"); // FUNCTIONS queries.put("1000", "SELECT DISTINCT * FROM /exampleRegion where IS_DEFINED(P2.secId)"); queries.put("1001", "SELECT DISTINCT * FROM /exampleRegion where IS_UNDEFINED(P2.secId)"); queries.put("1002", "null IN SET('x','y','z')"); queries.put("1003", "null IN SET(null)"); queries.put("1004", "nvl('notNull', 'foundNull')"); queries.put("1005", "nvl(NULL, 'foundNull')"); queries.put("1006", "select distinct * from UNDEFINED"); queries.put("1007", "to_date('05/09/10', 'yy/dd/yy')"); queries.put("1008", "to_date('05/10/09', 'yy/dd/MM')"); queries.put("1009", "to_date('050910', 'yyddMM')"); queries.put("1010", "to_date('051009', 'yyMMdd')"); queries.put("1011", "to_date('09/05/10', 'dd/MM/yy')"); queries.put("1012", "to_date('09/10/05', 'MM/dd/yy')"); queries.put("1013", "to_date('09/10/2005', 'dd/MM/yyyy')"); queries.put("1014", "to_date('09/2005/10', 'dd/yyyy/MM')"); queries.put("1015", "to_date('090510', 'ddyyMM')"); queries.put("1016", "to_date('091005', 'ddMMyy')"); queries.put("1017", "to_date('09102005', 'ddMMyy')"); queries.put("1018", "to_date('09102005', 'ddMMyyyy')"); queries.put("1019", "to_date('09200510', 'ddyyyyMM')"); queries.put("1020", "to_date('10/05/09', 'MM/dd/yy')"); queries.put("1021", "to_date('10/09/05', 'MM/dd/yy')"); queries.put("1022", "to_date('10/09/2005', 'MM/dd/yyyy')"); queries.put("1023", "to_date('10/2005/09', 'MM/yyyy/dd')"); queries.put("1024", "to_date('100509', 'MMyydd')"); queries.put("1025", "to_date('100905', 'MMddyy')"); queries.put("1026", "to_date('10092005', 'MMddyy')"); queries.put("1027", "to_date('10092005', 'MMddyyyy')"); queries.put("1028", "to_date('10092005121314', 'MMddyyyyHHmmss')"); queries.put("1029", "to_date('10092005121314567', 'MMddyyyyHHmmssSSS')"); queries.put("1030", "to_date('10200509', 'MMyyyydd')"); queries.put("1031", "to_date('2005/09/10', 'yyyy/dd/MM')"); queries.put("1032", "to_date('2005/09/10', 'yyyy/MM/dd')"); queries.put("1033", "to_date('20050910', 'yyyyddMM')"); queries.put("1034", "to_date('20051009', 'yyyyMMdd')"); queries.put("1035", "ELEMENT(SELECT DISTINCT * FROM /exampleRegion value where value.length > 6)"); queries.put("1036", "ELEMENT(SELECT DISTINCT * FROM /exampleRegion where ID <= 1).status"); queries.put("1037", "ELEMENT(SELECT DISTINCT * FROM /exampleRegion where ID =1).status"); queries.put("1038", "SELECT DISTINCT * FROM /exampleRegion where status = ELEMENT(SELECT DISTINCT * FROM /exampleRegion p where ID = 0).status"); queries.put("1039", "SELECT DISTINCT * FROM /exampleRegion where status = ELEMENT(SELECT DISTINCT * FROM /exampleRegion p where p.ID = 0).status"); queries.put("1040", "UNDEFINED IN SET(1,2,3)"); queries.put("1041", "UNDEFINED IN SET(UNDEFINED)"); queries.put("1042", "UNDEFINED IN SET(UNDEFINED,UNDEFINED)"); // MULTIPLE REGIONS queries.put("1100", "SELECT * FROM /exampleRegion portfolio1, /exampleRegion2 portfolio2 WHERE portfolio1.status = portfolio2.status"); queries.put("1101", "SELECT portfolio1.ID, portfolio2.status FROM /exampleRegion portfolio1, /exampleRegion2 portfolio2"); queries.put("1102", "SELECT * FROM /exampleRegion portfolio1, portfolio1.positions.values positions1, /exampleRegion2 portfolio2,"); queries.put("1103", "SELECT * FROM /exampleRegion portfolio1, portfolio1.positions.values positions1, /exampleRegion2 portfolio2,"); queries.put("1104", "SELECT * FROM (SELECT * FROM /exampleRegion2 m) r2, (SELECT * FROM /exampleRegion e WHERE e.pkid IN r2.sp) p"); queries.put("1105", "SELECT * FROM (SELECT * FROM /exampleRegion2 m WHERE m.ID IN SET (1, 5, 10)) r2, (SELECT * FROM /exampleRegion e WHERE e.pkid IN r2.sp) p"); queries.put("1106", "SELECT DISTINCT * FROM /exampleRegion c1, /exampleRegion2 c2 WHERE c1.name = 'INDIA' AND c2.name = 'ISRAEL'"); queries.put("1107", "SELECT DISTINCT * FROM /exampleRegion c1, /exampleRegion2 c3, c1.states s1, c3.states s3, s1.districts d1, s3.getDistrictsWithSameName(d1) d3 WHERE c1.name = 'INDIA' OR c3.name = 'ISRAEL' OR d3.name = 'MUMBAIDIST' OR d3.name = 'PUNEDIST'"); queries.put("1108", "SELECT DISTINCT * FROM /exampleRegion c1, c1.states s1, s1.districts d1, /exampleRegion2 c2, c2.states s2, s2.districts d2, /exampleRegion2 c3, c3.states s3, s3.districts d3 WHERE d3.name = 'PUNEDIST' AND s2.name = 'GUJARAT'"); queries.put("1109", "SELECT DISTINCT * FROM /exampleRegion c1, c1.states s1, s1.districts d1, d1.cities ct1, d1.villages v1, /exampleRegion2 c2, c2.states s2, s2.districts d2, d2.cities ct2, d2.villages v2 WHERE c1.name = 'INDIA' AND c2.name = 'ISRAEL'"); queries.put("1110", "SELECT DISTINCT * FROM /exampleRegion c1, c1.states s1, s1.districts d1, d1.villages v1, d1.cities ct1, /exampleRegion2 c2, c2.states s2, s2.districts d2, d2.villages v2, d2.cities ct2 WHERE v1.name = 'MAHARASHTRA_VILLAGE1' AND ct2.name = 'MUMBAI'"); queries.put("1111", "SELECT DISTINCT * FROM /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion e WHERE pf1.status = 'active'"); queries.put("1112", "SELECT DISTINCT * FROM /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion e1 WHERE pf1.status = 'active' AND e1.empId < 10"); queries.put("1113", "SELECT DISTINCT * FROM /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion e1 WHERE pf1.status = 'active' AND pf2.status = 'active' AND e1.empId < 10"); queries.put("1114", "SELECT DISTINCT * FROM /exampleRegion pf1, /exampleRegion2 pf2, pf1.positions.values posit1, pf2.positions.values posit2 WHERE posit1.secId='IBM' AND posit2.secId='IBM'"); queries.put("1115", "SELECT DISTINCT * FROM /exampleRegion pf1, pf1.collectionHolderMap.values coll1, pf1.positions.values posit1, /exampleRegion2 pf2, pf2.collectionHolderMap.values coll2, pf2.positions.values posit2 WHERE posit1.secId='IBM' AND posit2.secId='IBM'"); queries.put("1116", "SELECT DISTINCT * FROM /exampleRegion pf1, pf1.positions.values posit1, /exampleRegion2 pf2, /exampleRegion e WHERE posit1.secId='IBM'"); queries.put("1117", "SELECT DISTINCT * FROM /exampleRegion pf1, pf1.positions.values posit1, /exampleRegion2 pf2, pf2.positions.values posit2 WHERE pf2.status='active' AND posit1.secId='IBM'"); queries.put("1118", "SELECT DISTINCT * FROM /exampleRegion pf1,/exampleRegion2 pf2, pf1.positions.values posit1, pf2.positions.values posit2 WHERE posit1.secId='IBM' OR posit2.secId='IBM'"); queries.put("1119", "SELECT DISTINCT * FROM /exampleRegion pf1,/exampleRegion2 pf2, pf1.positions.values posit1, pf2.positions.values posit2, pf1.collectionHolderMap.values coll1,pf2.collectionHolderMap.values coll2 WHERE posit1.secId='IBM' OR posit2.secId='IBM'"); queries.put("1120", "SELECT DISTINCT * FROM /exampleRegion2, positions.values where status='active'"); queries.put("1121", "SELECT DISTINCT * FROM /root/exampleRegion p, /root/exampleRegion2 p2 WHERE p.status = 'active'"); queries.put("1122", "SELECT DISTINCT c1.name, s1.name, d2.name, ct2.name FROM /exampleRegion c1, c1.states s1, s1.districts d1, d1.cities ct1, /exampleRegion2 c2, c2.states s2, s2.districts d2, d2.cities ct2 WHERE ct1.name = 'MUMBAI' OR ct2.name = 'CHENNAI'"); queries.put("1123", "SELECT DISTINCT c1.name, s1.name, d2.name, ct2.name FROM /exampleRegion c1, c1.states s1, s1.districts d1, d1.cities ct1,/exampleRegion2 c2, c2.states s2, s2.districts d2, d2.cities ct2 WHERE ct1.name = 'MUMBAI' OR ct2.name = 'CHENNAI'"); queries.put("1124", "SELECT DISTINCT coll1 as collHldrMap1 , coll2 as CollHldrMap2 FROM /exampleRegion pf1, /exampleRegion2 pf2, pf1.positions.values posit1, pf2.positions.values posit2, pf1.collectionHolderMap.values coll1,pf2.collectionHolderMap.values coll2 WHERE posit1.secId='IBM' OR posit2.secId='IBM'"); queries.put("1125", "SELECT DISTINCT coll1 as collHldrMap1 , coll2 as CollHldrMap2 FROM /exampleRegion pf1, /exampleRegion2 pf2, pf1.positions.values posit1,pf2.positions.values posit2,pf1.collectionHolderMap.values coll1, pf2.collectionHolderMap.values coll2 WHERE posit1.secId='IBM' OR posit2.secId='IBM'"); queries.put("1126", "SELECT DISTINCT p.ID FROM /root/exampleRegion p, /root/exampleRegion2 p2 WHERE p.ID = p2.ID and p.ID > 100 and p2.ID < 1"); queries.put("1127", "SELECT p.ID FROM /root/exampleRegion p, /root/exampleRegion2 p2 WHERE p.ID = p2.ID and p.status = 'active' and p2.status = 'active'"); queries.put("1128", "Select distinct * from /exampleRegion c1, c1.states sts1, sts1.districts dists, dists.cities ct1, dists.villages villgs1, /exampleRegion2 c2, /exampleRegion3 c3 where c1.name = c2.name and ct1.name != 'PUNE' and villgs1.name = 'MAHARASHTRA_VILLAGE1'"); queries.put("1129", "Select distinct * from /exampleRegion c1, c1.states sts1, sts1.districts dists, dists.cities ct1, dists.villages villgs1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where c1.name = c2.name or ct1.name != 'PUNE' or villgs1.name = 'MAHARASHTRA_VILLAGE1'"); queries.put("1130", "Select distinct * from /exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, /exampleRegion2 c2, c2.states s2, /exampleRegion3 c3, c3.states sts3, sts3.districts dists3, dists3.cities ct3, dists3.villages villgs3 where c1.name = c2.name and ct1.name != 'PUNE' and villgs1.name = 'MAHARASHTRA_VILLAGE1' and villgs1.name = villgs3.name and s2.name = 'PUNJAB' and ct1.name = ct3.name and dists3.name = 'MUMBAIDIST'"); queries.put("1131", "Select distinct * from /exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, /exampleRegion2 c2, c2.states s2, /exampleRegion3 c3, c3.states sts3, sts3.districts dists3, dists3.cities ct3, dists3.villages villgs3 where c1.name = c2.name and ct1.name != 'PUNE' or villgs1.name = 'MAHARASHTRA_VILLAGE1' or villgs1.name = villgs3.name or s2.name = 'PUNJAB' or ct1.name = ct3.name and dists3.name = 'MUMBAIDIST'"); queries.put("1132", "Select distinct * from /exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, /exampleRegion2 c2, c2.states s2, /exampleRegion3 c3, c3.states sts3, sts3.districts dists3, dists3.cities ct3, dists3.villages villgs3 where c1.name = c2.name and sts1.name != 'PUNJAB' and ct1.name != 'PUNE' and villgs1.name = 'MAHARASHTRA_VILLAGE1' and villgs1.name = villgs3.name and sts3.name != sts1.name and s2.name = 'PUNJAB' and ct1.name = ct3.name and dists3.name = 'MUMBAIDIST' and dists3.name != s2.name"); queries.put("1133", "Select distinct * from /exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, /exampleRegion2 c2, c2.states s2, /exampleRegion3 c3, c3.states sts3, sts3.districts dists3, dists3.cities ct3, dists3.villages villgs3 where c1.name = c2.name or ct1.name != 'PUNE' and villgs1.name = 'MAHARASHTRA_VILLAGE1' or villgs1.name = villgs3.name or s2.name = 'PUNJAB' or ct1.name = ct3.name and dists3.name = 'MUMBAIDIST'"); queries.put("1134", "Select distinct * from /exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, /exampleRegion2 c2, c2.states s2, /exampleRegion3 c3, c3.states sts3, sts3.districts dists3, dists3.cities ct3, dists3.villages villgs3 where c1.name = c2.name or ct1.name != 'PUNE' or villgs1.name = 'MAHARASHTRA_VILLAGE1' or villgs1.name = villgs3.name or s2.name = 'PUNJAB' or ct1.name = ct3.name or dists3.name = 'MUMBAIDIST'"); queries.put("1135", "Select distinct * from /exampleRegion pf, /exampleRegion2, /exampleRegion3, /exampleRegion where pf.status='active'"); queries.put("1136", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where Pos1.secId = 'YHOO' and (c1.name = c2.name or pfo3.status != 'inactive') and pfo3.status = pfos.status"); queries.put("1137", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where Pos1.secId = 'YHOO' and c1.name = c2.name or c3.name = 'INDIA' and pfo3.status != 'inactive' or pfo3.\"type\" = 'type1' and pfo3.status = pfos.status"); queries.put("1138", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where Pos1.secId = 'YHOO' and c1.name = c2.name or pfo3.status != 'inactive' and pfo3.status = pfos.status"); queries.put("1139", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where Pos1.secId = 'YHOO' or c1.name = c2.name or c3.name = 'INDIA' and pfo3.status != 'inactive' or pfo3.\"type\" = 'type1' and pfo3.status = pfos.status"); queries.put("1140", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where Pos1.secId = 'YHOO' or c1.name = c2.name or pfo3.status != 'inactive' or pfo3.status = pfos.status"); queries.put("1141", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, c1.states s1, /exampleRegion2 c2, c2.states s2, /exampleRegion3 c3, /exampleRegion3 pfo3 where Pos1.secId = 'YHOO' and ((c1.name = c2.name or pfo3.status != 'inactive') and pfo3.status = pfos.status) or s1.name = 'MAHARASHTRA' and s2.name != 'MAHARASHTRA'"); queries.put("1142", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where (Pos1.secId = 'YHOO' and c1.name = c2.name or pfo3.status != 'inactive') and pfo3.status = pfos.status and villgs1.name = 'MAHARASHTRA_VILLAGE1'"); queries.put("1143", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where Pos1.secId = 'YHOO' and c1.name = c2.name or pfo3.status != 'inactive' and pfo3.status = pfos.status and villgs1.name = 'MAHARASHTRA_VILLAGE1' or pfos.ID != 0"); queries.put("1144", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where Pos1.secId = 'YHOO' and c1.name = c2.name or pfo3.status != 'inactive' and pfo3.status = pfos.status and villgs1.name = 'MAHARASHTRA_VILLAGE1'"); queries.put("1145", "Select distinct * from /exampleRegion, /exampleRegion2"); queries.put("1146", "Select distinct * from /exampleRegion, /exampleRegion2, /exampleRegion3, /exampleRegion"); queries.put("1147", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and false and c1.name = 'INDIA' and pf2.ID = 2"); queries.put("1148", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and false and pf1.ID = pf2.ID and c1.name = 'INDIA' and pf2.ID = 2"); queries.put("1149", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and false and pf1.ID = pf2.ID or c1.name = 'INDIA' or pf2.ID = 2"); queries.put("1150", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and false and pf1.ID = pf2.ID"); queries.put("1151", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and false or c1.name = 'INDIA' or pf2.ID = 2"); queries.put("1152", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and false"); queries.put("1153", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and true and c1.name = 'INDIA' and pf2.ID = 2"); queries.put("1154", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and true or c1.name = 'INDIA' or pf1.ID = 2"); queries.put("1155", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and true or pf1.ID = pf2.ID and c1.name = 'INDIA' and pf2.ID = 2"); queries.put("1156", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and true or pf1.ID = pf2.ID or c1.name = 'INDIA' or pf2.ID = 2"); queries.put("1157", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and true or pf1.ID = pf2.ID"); queries.put("1158", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and true"); queries.put("1159", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name"); queries.put("1160", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or false or c1.name = c2.name and c1.name = 'INDIA' and pf1.ID = 2"); queries.put("1161", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or false or c1.name = c2.name or c1.name = 'INDIA' or pf1.ID = 2"); queries.put("1162", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or false or c1.name = c2.name or pf2.ID = 1 or c1.name = 'INDIA' and c1.name = 'INDIA' and pf2.ID = 2"); queries.put("1163", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or false or c1.name = c2.name or pf2.ID = 1 or c1.name = 'INDIA'"); queries.put("1164", "select distinct * from /exampleRegion pf1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or false or c1.name = c2.name"); queries.put("1165", "select distinct * from /exampleRegion pf1, pf1.positions.values pos1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status and c1.name = c2.name or pos1.secId = 'IBM' and c1.name = 'INDIA' and pf2.ID = 2"); queries.put("1166", "select distinct * from /exampleRegion pf1, pf1.positions.values pos1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status and c1.name = c2.name or pos1.secId = 'IBM' or c1.name = 'INDIA' or pf2.ID = 2"); queries.put("1167", "select distinct * from /exampleRegion pf1, pf1.positions.values pos1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status and c1.name = c2.name or pos1.secId = 'IBM' or false and pf1.ID = pf2.ID and c1.name = 'INDIA' and pf2.ID = 2"); queries.put("1168", "select distinct * from /exampleRegion pf1, pf1.positions.values pos1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status and c1.name = c2.name or pos1.secId = 'IBM' or false and pf1.ID = pf2.ID or c1.name = 'INDIA' or pf1.ID = 2"); queries.put("1169", "select distinct * from /exampleRegion pf1, pf1.positions.values pos1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status and c1.name = c2.name or pos1.secId = 'IBM' or false and pf1.ID = pf2.ID"); queries.put("1170", "select distinct * from /exampleRegion pf1, pf1.positions.values pos1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status and c1.name = c2.name or pos1.secId = 'IBM'"); queries.put("1171", "select distinct * from /exampleRegion pf1, pf1.positions.values pos1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and pos1.secId = 'IBM' and true and c1.name = 'INDIA' and pf2.ID = 2"); queries.put("1172", "select distinct * from /exampleRegion pf1, pf1.positions.values pos1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and pos1.secId = 'IBM' and true or pf1.ID != 3"); queries.put("1173", "select distinct * from /exampleRegion pf1, pf1.positions.values pos1, /exampleRegion2 pf2, /exampleRegion c1, /exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and pos1.secId = 'IBM' and true"); queries.put("1174", "select distinct * from /root/exampleRegion, /root/exampleRegion2"); queries.put("1175", "select distinct a, b.price from /root/exampleRegion a, /root/exampleRegion2 b where a.price = b.price and a.price = 50"); queries.put("1176", "select distinct a, b.price from /root/exampleRegion a, /root/exampleRegion2 b where a.price = b.price"); queries.put("1177", "SELECT DISTINCT * FROM /exampleRegion pf, pf.positions pos, /exampleRegion3 pf3, /exampleRegion emp WHERE pf.iD = emp.empId and pf.status='active' and emp.age > 50 and pf3.status='active'"); queries.put("1178", "Select distinct * from /exampleRegion c1, c1.states sts1, sts1.districts dists, dists.cities ct1, dists.villages villgs1, /exampleRegion2 c2, /exampleRegion3 c3 where c1.name = c2.name and ct1.name != 'PUNE' and villgs1.name = 'MAHARASHTRA_VILLAGE1'"); queries.put("1179", "Select distinct * from /exampleRegion c1, c1.states sts1, sts1.districts dists, dists.cities ct1, dists.villages villgs1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where c1.name = c2.name or ct1.name != 'PUNE' or villgs1.name = 'MAHARASHTRA_VILLAGE1'"); queries.put("1180", "Select distinct * from /exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, /exampleRegion2 c2, c2.states s2, /exampleRegion3 c3, c3.states sts3, sts3.districts dists3, dists3.cities ct3, dists3.villages villgs3 where c1.name = c2.name and ct1.name != 'PUNE' and villgs1.name = 'MAHARASHTRA_VILLAGE1' and villgs1.name = villgs3.name and s2.name = 'PUNJAB' and ct1.name = ct3.name and dists3.name = 'MUMBAIDIST'"); queries.put("1181", "Select distinct * from /exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, /exampleRegion2 c2, c2.states s2, /exampleRegion3 c3, c3.states sts3, sts3.districts dists3, dists3.cities ct3, dists3.villages villgs3 where c1.name = c2.name and ct1.name != 'PUNE' or villgs1.name = 'MAHARASHTRA_VILLAGE1' or villgs1.name = villgs3.name or s2.name = 'PUNJAB' or ct1.name = ct3.name and dists3.name = 'MUMBAIDIST'"); queries.put("1182", "Select distinct * from /exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, /exampleRegion2 c2, c2.states s2, /exampleRegion3 c3, c3.states sts3, sts3.districts dists3, dists3.cities ct3, dists3.villages villgs3 where c1.name = c2.name and sts1.name != 'PUNJAB' and ct1.name != 'PUNE' and villgs1.name = 'MAHARASHTRA_VILLAGE1' and villgs1.name = villgs3.name and sts3.name != sts1.name and s2.name = 'PUNJAB' and ct1.name = ct3.name and dists3.name = 'MUMBAIDIST' and dists3.name != s2.name"); queries.put("1183", "Select distinct * from /exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, /exampleRegion2 c2, c2.states s2, /exampleRegion3 c3, c3.states sts3, sts3.districts dists3, dists3.cities ct3, dists3.villages villgs3 where c1.name = c2.name or ct1.name != 'PUNE' and villgs1.name = 'MAHARASHTRA_VILLAGE1' or villgs1.name = villgs3.name or s2.name = 'PUNJAB' or ct1.name = ct3.name and dists3.name = 'MUMBAIDIST'"); queries.put("1184", "Select distinct * from /exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, /exampleRegion2 c2, c2.states s2, /exampleRegion3 c3, c3.states sts3, sts3.districts dists3, dists3.cities ct3, dists3.villages villgs3 where c1.name = c2.name or ct1.name != 'PUNE' or villgs1.name = 'MAHARASHTRA_VILLAGE1' or villgs1.name = villgs3.name or s2.name = 'PUNJAB' or ct1.name = ct3.name or dists3.name = 'MUMBAIDIST'"); queries.put("1185", "Select distinct * from /exampleRegion pf, /exampleRegion2, /exampleRegion3, /exampleRegion where pf.status='active'"); queries.put("1186", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where Pos1.secId = 'YHOO' and (c1.name = c2.name or pfo3.status != 'inactive') and pfo3.status = pfos.status"); queries.put("1187", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where Pos1.secId = 'YHOO' and c1.name = c2.name or c3.name = 'INDIA' and pfo3.status != 'inactive' or pfo3.\"type\" = 'type1' and pfo3.status = pfos.status"); queries.put("1188", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where Pos1.secId = 'YHOO' and c1.name = c2.name or pfo3.status != 'inactive' and pfo3.status = pfos.status"); queries.put("1189", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where Pos1.secId = 'YHOO' or c1.name = c2.name or c3.name = 'INDIA' and pfo3.status != 'inactive' or pfo3.\"type\" = 'type1' and pfo3.status = pfos.status"); queries.put("1190", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where Pos1.secId = 'YHOO' or c1.name = c2.name or pfo3.status != 'inactive' or pfo3.status = pfos.status"); queries.put("1191", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, c1.states s1, /exampleRegion2 c2, c2.states s2, /exampleRegion3 c3, /exampleRegion3 pfo3 where Pos1.secId = 'YHOO' and ((c1.name = c2.name or pfo3.status != 'inactive') and pfo3.status = pfos.status) or s1.name = 'MAHARASHTRA' and s2.name != 'MAHARASHTRA'"); queries.put("1192", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where (Pos1.secId = 'YHOO' and c1.name = c2.name or pfo3.status != 'inactive') and pfo3.status = pfos.status and villgs1.name = 'MAHARASHTRA_VILLAGE1'"); queries.put("1193", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where Pos1.secId = 'YHOO' and c1.name = c2.name or pfo3.status != 'inactive' and pfo3.status = pfos.status and villgs1.name = 'MAHARASHTRA_VILLAGE1' or pfos.ID != 0"); queries.put("1194", "Select distinct * from /exampleRegion pfos, pfos.positions.values Pos1, /exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, /exampleRegion2 c2, /exampleRegion3 c3, /exampleRegion3 pfo3 where Pos1.secId = 'YHOO' and c1.name = c2.name or pfo3.status != 'inactive' and pfo3.status = pfos.status and villgs1.name = 'MAHARASHTRA_VILLAGE1'"); queries.put("1195", "Select distinct * from /exampleRegion, /exampleRegion2, /exampleRegion3, /exampleRegion"); queries.put("1196", "Select distinct * from /exampleRegion3 pf, pf.positions"); queries.put("1197", "Select distinct * from /exampleRegion3, /exampleRegion"); queries.put("1198", "select distinct * from /root/exampleRegion3"); // Queries used for Equi-join tests queries.put("1199", "select * from /region1 r1, /region2 r2 where" + "r1.ID = r2.id"); queries.put("1200", "select * from /region1 r1, /region2 r2 where" + "r1.ID = r2.id AND r1.ID > 5"); queries.put("1201", "select * from /region1 r1, /region2 r2 where" + "r1.ID = r2.id AND r1.status = 'active'"); queries.put("1202", "select distinct * from /region1 r1, /region2 r2 where" + "r1.ID = r2.id ORDER BY r1.ID"); queries.put("1203", "select distinct * from /region1 r1, /region2 r2 where" + "r1.ID = r2.id ORDER BY r2.id"); queries.put("1204", "select distinct * from /region1 r1, /region2 r2 where" + "r1.ID = r2.id ORDER BY r2.status"); queries.put("1205", "select * from /region1 r1, /region2 r2 where" + "r1.ID = r2.id AND r1.status != r2.status"); queries.put("1206", "select * from /region1 r1, /region2 r2 where" + "r1.ID = r2.id AND r1.status = r2.status"); queries.put("1207", "select * from /region1 r1, /region2 r2 where" + "r1.ID = r2.id AND r1.positions.size = r2.positions.size"); queries.put("1208", "select * from /region1 r1, /region2 r2 where" + "r1.ID = r2.id AND r1.positions.size > r2.positions.size"); queries.put("1209", "select * from /region1 r1, /region2 r2 where" + "r1.ID = r2.id AND r1.positions.size < r2.positions.size"); queries.put("1210", "select * from /region1 r1, /region2 r2 where" + "r1.ID = r2.id AND r1.positions.size = r2.positions.size AND r2.positions.size > 0"); queries.put("1211", "select * from /region1 r1, /region2 r2 where" + "r1.ID = r2.id AND (r1.positions.size > r2.positions.size OR r2.positions.size > 0)"); queries.put("1212", "select * from /region1 r1, /region2 r2 where" + "r1.ID = r2.id AND (r1.positions.size < r2.positions.size OR r1.positions.size > 0)"); queries.put("1199", "select * from /region1 r1, /region2 r2, r2.positions.values pos2 where" + "r1.ID = pos2.id"); queries.put("1200", "select * from /region1 r1, /region2 r2, r2.positions.values pos2 where" + "r1.ID = pos2.id AND r1.ID > 5"); queries.put("1201", "select * from /region1 r1, /region2 r2, r2.positions.values pos2 where" + "r1.ID = pos2.id AND r1.status = 'active'"); queries.put("1202", "select distinct * from /region1 r1, /region2 r2, r2.positions.values pos2 where" + "r1.ID = pos2.id ORDER BY r1.ID"); queries.put("1203", "select distinct * from /region1 r1, /region2 r2, r2.positions.values pos2 where" + "r1.ID = pos2.id ORDER BY pos2.id"); queries.put("1204", "select distinct * from /region1 r1, /region2 r2, r2.positions.values pos2 where" + "r1.ID = pos2.id ORDER BY r2.status"); queries.put("1205", "select * from /region1 r1, /region2 r2, r2.positions.values pos2 where" + "r1.ID = pos2.id AND r1.status != r2.status"); queries.put("1206", "select * from /region1 r1, /region2 r2, r2.positions.values pos2 where" + "r1.ID = pos2.id AND r1.status = r2.status"); queries.put("1207", "select * from /region1 r1, /region2 r2, r2.positions.values pos2 where" + "r1.ID = pos2.id AND r1.positions.size = r2.positions.size"); queries.put("1208", "select * from /region1 r1, /region2 r2, r2.positions.values pos2 where" + "r1.ID = pos2.id AND r1.positions.size > r2.positions.size"); queries.put("1209", "select * from /region1 r1, /region2 r2, r2.positions.values pos2 where" + "r1.ID = pos2.id AND r1.positions.size < r2.positions.size"); queries.put("1210", "select * from /region1 r1, /region2 r2, r2.positions.values pos2 where" + "r1.ID = pos2.id AND r1.positions.size = r2.positions.size AND r2.positions.size > 0"); queries.put("1211", "select * from /region1 r1, /region2 r2, r2.positions.values pos2 where" + "r1.ID = pos2.id AND (r1.positions.size > r2.positions.size OR r2.positions.size > 0)"); queries.put("1212", "select * from /region1 r1, /region2 r2, r2.positions.values pos2 where" + "r1.ID = pos2.id AND (r1.positions.size < r2.positions.size OR r1.positions.size > 0)"); } public static QueryService getQueryService() { return cache.getQueryService(); } public void createServer(VM server, final Properties prop) { SerializableRunnable createCacheServer = new CacheSerializableRunnable("Create Cache Server") { private static final long serialVersionUID = 1L; public void run2() throws CacheException { createCache(prop); } }; server.invoke(createCacheServer); } public void createCache(Properties prop) { if (null != prop && !prop.isEmpty()) { cache = new CacheFactory(prop).create(); } else { cache = new CacheFactory().set(MCAST_PORT, "0").create(); } } public static void setCache(Cache cache) { QueryTestUtils.cache = cache; } public void createPartitionRegion(final String name, final Class constraint, VM vm) { vm.invoke(new CacheSerializableRunnable("Create Partition region") { private static final long serialVersionUID = 1L; public void run2() throws CacheException { createPartitionRegion(name, constraint); } }); } public void createPartitionRegion(String name, Class constraint) { ExpirationAttributes expiration = ExpirationAttributes.DEFAULT; PartitionAttributesFactory paf = new PartitionAttributesFactory(); RegionFactory factory = cache.createRegionFactory(RegionShortcut.PARTITION) .setPartitionAttributes(paf.create()); if (constraint != null) { factory.setValueConstraint(constraint); } factory.create(name); } public void createReplicateRegion(final String name, VM vm) { vm.invoke(new CacheSerializableRunnable("Create Replicated region") { private static final long serialVersionUID = 1L; public void run2() throws CacheException { getLogger().fine("### Create replicated region. ###"); createReplicateRegion(name); } }); } public void createReplicateRegion(String name) { cache.createRegionFactory(RegionShortcut.REPLICATE).create(name); } public void createHashIndex(VM vm, final String name, final String field, final String region) { vm.invoke(new CacheSerializableRunnable("Create Replicated region") { public void run2() throws CacheException { createHashIndex(name, field, region); } }); } public Index createHashIndex(String name, String field, String region) { try { return cache.getQueryService().createHashIndex(name, field, region); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException("Index creation failed for index on region: " + region + "." + field, e); } } public void createIndex(VM vm, final String name, final String field, final String region) throws CacheException { vm.invoke(new CacheSerializableRunnable("Create Index") { public void run2() throws CacheException { createIndex(name, field, region); } }); } public Index createIndex(String name, String field, String region) throws CacheException { try { return cache.getQueryService().createIndex(name, field, region); } catch (Exception e) { throw new RuntimeException("Index creation failed for index on region: " + region + "." + field, e); } } public void removeIndex(String name, String region) { try { QueryService qs = getQueryService(); qs.removeIndex(qs.getIndex(cache.getRegion(region), name)); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException("Index removal failed for index: " + name + " on region: " + region, e); } } public void createLocalRegion(final String name, VM vm) { vm.invoke(new CacheSerializableRunnable("Create Local region") { private static final long serialVersionUID = 1L; public void run2() throws CacheException { getLogger().fine("### Create Local region. ###"); createLocalRegion(name); } }); } public void createLocalRegion(String name) { cache.createRegionFactory(RegionShortcut.LOCAL).create(name); } public void createSubRegion(final String rootName, final String name, final RegionAttributes regionAttributes, VM vm) { vm.invoke(new CacheSerializableRunnable("Creating subregion") { private static final long serialVersionUID = 1L; public void run2() throws CacheException { getLogger().fine("### Create subregion. ###"); Region root = cache.getRegion(rootName); if (root == null) { root = cache.createRegionFactory().create(rootName); } RegionAttributes ra = null; if (regionAttributes == null) { ra = new AttributesFactory().create(); } root.createSubregion(name, ra); } }); } public void closeServer(VM server) { server.invoke(new CacheSerializableRunnable("Closing Cache Server") { private static final long serialVersionUID = 1L; public void run2() throws CacheException { getLogger().fine("### Close Cache Server. ###"); closeCache(); } }); } public void closeCache() { if (!cache.isClosed()) { cache.close(); } } /** * Executes queries corresponding to the keys passed using array<br> * <P> * <code> * String[] arr = {"1", "2", "3"};<br> * new QueryTestUtils().executeQueries(arr); * </code> * </P> * * @param qarr Array of keys, queries in the values mapped are executed * @return Object array containing SelectResults */ public Object[] executeQueries(String qarr[]) throws Exception { QueryService qs = cache.getQueryService(); Object[] result = new Object[qarr.length]; String query = null; int j = 0; for (int i = 0; i < qarr.length; i++) { query = queries.get(qarr[i]); result[j++] = qs.newQuery(query).execute(); } return result; } /** * Execute queries by removing any DISTINCT clause if present * * @param vm * @param qarr */ public void executeQueriesWithoutDistinct(VM vm, final String qarr[]) { vm.invoke(new CacheSerializableRunnable("Executing query without distinct") { public void run2() { executeQueriesWithoutDistinct(qarr); } }); } /** * Execute queries by removing any DISTINCT clause if present * * @param qarr */ public Object[] executeQueriesWithoutDistinct(String qarr[]) { QueryService qs = cache.getQueryService(); Object[] result = new Object[qarr.length]; String query = null; int j = 0; for (int i = 0; i < qarr.length; i++) { query = queries.get(qarr[i]); if (query.indexOf("distinct") > -1) query = query.replace("distinct", ""); if (query.indexOf("DISTINCT") > -1) query = query.replace("DISTINCT", ""); // hydra.getLogWriter().info("\nExecuting query: " + query); try { result[j++] = qs.newQuery(query).execute(); } catch (Exception e) { throw new RuntimeException(e); } } return result; } /** * Execute queries by adding a DISTINCT clause if not present * * @param vm * @param qarr */ public void executeQueriesWithDistinct(VM vm, final String qarr[]) { vm.invoke(new CacheSerializableRunnable("Executing query with distinct") { public void run2() { executeQueriesWithDistinct(qarr); } }); } /** * Execute queries by adding a DISTINCT clause if not present * * @param qarr */ public Object[] executeQueriesWithDistinct(String qarr[]) { QueryService qs = cache.getQueryService(); Object[] result = new Object[qarr.length]; String query = null; int j = 0; for (final String aQarr : qarr) { query = queries.get(aQarr); if (!query.toLowerCase().contains("distinct")) { query = query.replaceFirst("select", "select distinct"); } // hydra.getLogWriter().info("\nExecuting query: " + query); try { result[j++] = qs.newQuery(query).execute(); } catch (Exception e) { throw new RuntimeException(e); } } return result; } private LogWriter getLogger() { if (cache == null) { return null; } return cache.getLogger(); } public Cache getCache() { return cache; } public static void createCacheInVM(VM vm, Properties props) { vm.invoke(() -> { getInstance().createCache(props); }); } public static void closeCacheInVM(VM vm) { vm.invoke(() -> { cache.close(); }); } public Region getRegion(String regionName) { return cache.getRegion(regionName); } public void populateRegion(String regionName, Map<?, ?> entries) { Region r = cache.getRegion("/" + regionName); entries.entrySet().forEach(e -> { r.put(e.getKey(), e.getValue()); }); } public static void populateRegion(VM vm, String regionName, Map<?, ?> entries) { vm.invoke(() -> { getInstance().populateRegion(regionName, entries); }); } public static File createTestRootDiskStore(String testName) throws IOException { File diskDir = new File(testName).getAbsoluteFile(); FileUtils.deleteDirectory(diskDir); diskDir.mkdir(); diskDir.deleteOnExit(); return diskDir; } public static File createRootDiskStoreInVM(VM vm, String rootDiskStoreName) { return vm.invoke(() -> { return createTestRootDiskStore(rootDiskStoreName); }); } }