/*
 * 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.cache.Region.SEPARATOR;
import static org.apache.geode.distributed.ConfigurationProperties.MCAST_PORT;

import java.io.File;
import java.io.IOException;
import java.io.Serializable;
import java.util.HashMap;
import java.util.Map;
import java.util.Properties;

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;

/**
 * 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 final QueryTestUtils instance = new QueryTestUtils();

  public static QueryTestUtils getInstance() {
    return instance;
  }

  public QueryTestUtils() {
    queries = new HashMap<>();
    bindQueries = new HashMap<>();
    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 " + SEPARATOR + "root" + SEPARATOR
        + "exampleRegion WHERE ID < $1).size");
    bindQueries.put("10", SEPARATOR + "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 " + SEPARATOR
            + "exampleRegion1 pf1 where pf1.ID != $1 limit 10");
    bindQueries.put("24",
        "SELECT  distinct ID, description, createTime FROM " + SEPARATOR
            + "exampleRegion1 pf1 where pf1.ID != $1 order by ID");
    bindQueries.put("25", "SELECT * FROM " + SEPARATOR + "exampleRegion pf WHERE pf = $1");
    bindQueries.put("26", "SELECT * FROM " + SEPARATOR + "exampleRegion pf WHERE pf > $1");
    bindQueries.put("27", "SELECT * FROM " + SEPARATOR + "exampleRegion.keys k WHERE k.ID = $1");
    bindQueries.put("28",
        "SELECT * FROM " + SEPARATOR + "exampleRegion.keys key WHERE key.ID > $1");
    bindQueries.put("29", "SELECT * FROM " + SEPARATOR + "exampleRegion.values pf WHERE pf < $1");
    bindQueries.put("30", "SELECT * FROM " + SEPARATOR + "root" + SEPARATOR
        + "exampleRegion WHERE ID < $1 and Ticker = $2");
    bindQueries.put("31", "SELECT * FROM " + SEPARATOR + "root" + SEPARATOR
        + "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 " + SEPARATOR + "exampleRegion WHERE ID < $1 ORDER BY $2");
    bindQueries.put("34", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where ID = $1");
    bindQueries.put("35",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where status = $1");
    bindQueries.put("36",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where status.equals($1)");
    bindQueries.put("37", "SELECT DISTINCT * FROM " + SEPARATOR + "root" + SEPARATOR
        + "exampleRegion WHERE ID < $1 ORDER BY $2");
    bindQueries.put("38", "SELECT DISTINCT * FROM " + SEPARATOR + "root" + SEPARATOR
        + "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 " + SEPARATOR + "exampleRegion.keys WHERE ID = $1");
    bindQueries.put("56",
        "SELECT distinct *  FROM " + SEPARATOR
            + "exampleRegion ps WHERE ps.status like $1 AND ps.ID > 2 AND ps.ID < 150");
    bindQueries.put("57",
        "SELECT distinct *  FROM " + SEPARATOR + "exampleRegion ps WHERE ps.status like $1");
    bindQueries.put("58",
        "SELECT e.key, e.value FROM " + SEPARATOR + "exampleRegion.entrySet e WHERE e.key IN $1");
    bindQueries.put("59",
        "SELECT e.value FROM " + SEPARATOR + "exampleRegion.entrySet e WHERE e.key IN $1");
    bindQueries.put("60",
        "SELECT itr.value FROM " + SEPARATOR + "root" + SEPARATOR
            + "exampleRegion.entries itr where itr.key = $1");
    bindQueries.put("61",
        "SELECT k.ID, k.status FROM " + SEPARATOR
            + "exampleRegion.keys k WHERE k.ID = $1 and k.status = $2");
    bindQueries.put("62",
        "SELECT key.ID FROM " + SEPARATOR + "exampleRegion.keys key WHERE key.ID = $1");
    bindQueries.put("63",
        "Select distinct * from " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion.keys() keys where keys.hashCode >= $1");
    bindQueries.put("68",
        "Select distinct value.secId from " + SEPARATOR + "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 " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf where pf.getCW(pf.ID) != $1");
    bindQueries.put("78",
        "select distinct * from " + SEPARATOR + "exampleRegion pf where pf.getCW(pf.ID) < $1");
    bindQueries.put("79",
        "select distinct * from " + SEPARATOR + "exampleRegion pf where pf.getCW(pf.ID) > $1");
    bindQueries.put("80", "select distinct * from " + SEPARATOR + "root" + SEPARATOR
        + "exampleRegion where ticker = $1");
    bindQueries.put("81", "select p from " + SEPARATOR + "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 " + SEPARATOR + "exampleRegion WHERE status = 'active'");
    queries.put("2", "SELECT * FROM " + SEPARATOR
        + "exampleRegion WHERE \"type\" = 'type1' and status = 'active'");
    queries.put("3",
        "SELECT key, positions FROM " + SEPARATOR
            + "exampleRegion.entrySet, value.positions.values positions WHERE positions.mktValue >= 25.00");
    queries.put("4",
        "SELECT DISTINCT entry.value FROM " + SEPARATOR
            + "exampleRegion.entries entry WHERE entry.key = '1'");
    queries.put("5",
        "SELECT * FROM " + SEPARATOR + "exampleRegion.entries entry WHERE entry.value.ID > 1");
    queries.put("6", "SELECT entry.value FROM " + SEPARATOR
        + "exampleRegion.entries entry WHERE entry.key = '1'");
    queries.put("7", "SELECT * FROM " + SEPARATOR + "exampleRegion.keySet key WHERE key = '1'");
    queries.put("8",
        "SELECT * FROM " + SEPARATOR
            + "exampleRegion.values portfolio WHERE portfolio.status = 'active'");
    queries.put("9",
        "SELECT entry.key, entry.value FROM " + SEPARATOR
            + "exampleRegion.entries entry WHERE entry.value['version'] = '100'");
    queries.put("10",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion WHERE ID < 101 ORDER BY ID");
    queries.put("11",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion WHERE ID < 101 ORDER BY ID asc");
    queries.put("12",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion WHERE ID < 101 ORDER BY ID desc");
    queries.put("13",
        "SELECT * FROM " + SEPARATOR + "exampleRegion p WHERE p.status LIKE 'active'");
    queries.put("14",
        "SELECT * FROM " + SEPARATOR + "exampleRegion p WHERE p.status LIKE 'activ%'");
    queries.put("15",
        "SELECT * FROM " + SEPARATOR
            + "exampleRegion p, p.positions.values AS pos WHERE pos.secId != '1'");
    queries.put("16", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion WHERE TRUE");
    queries.put("17",
        "SELECT * FROM " + SEPARATOR + "exampleRegion portfolio WHERE portfolio.ID IN SET(1, 2)");
    queries.put("18",
        "SELECT * FROM " + SEPARATOR
            + "exampleRegion portfolio, portfolio.positions.values positions WHERE portfolio.Pk IN SET ('1', '2') AND positions.secId = '1'");
    queries.put("19",
        "SELECT * FROM " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion portfolio WHERE portfolio.ID <> 2");
    queries.put("22",
        "SELECT * FROM " + SEPARATOR + "exampleRegion portfolio WHERE portfolio.ID != 2");
    queries.put("23", "(SELECT * FROM " + SEPARATOR + "exampleRegion).size");
    queries.put("24", "(SELECT * FROM " + SEPARATOR + "exampleRegion p WHERE p.ID = 1).size");
    queries.put("25", "SELECT * FROM " + SEPARATOR + "exampleRegion p WHERE p.status.length > 1");
    queries.put("26",
        "select * from " + SEPARATOR + "exampleRegion sp where sp = set ('20', '21', '22')");
    queries.put("27",
        "select * from " + SEPARATOR
            + "exampleRegion sp where sp.containsAll(set('20', '21', '22'))");
    queries.put("28",
        "select * from " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion r , r.positions.values pVal where  ( r.undefinedTestField.toString = UNDEFINED  OR false )");
    queries.put("32",
        "select distinct r.name, pVal, r.\"type\"   from " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion).size");
    queries.put("34", SEPARATOR + "exampleRegion.fullPath");
    queries.put("35", SEPARATOR + "exampleRegion.size > 0");
    queries.put("36", SEPARATOR + "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>)"
            + SEPARATOR + "exampleRegion where empId > 0");
    queries.put("39",
        "IMPORT org.apache.geode.cache.\"query\".data.Portfolio; SELECT DISTINCT * FROM (set<Portfolio>)"
            + SEPARATOR + "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>)"
            + SEPARATOR + "exampleRegion, (set<Position>)positions.values WHERE iD > 0");
    queries.put("41",
        "IMPORT org.apache.geode.cache.\"query\".data.Position;SELECT DISTINCT pos.secId FROM "
            + SEPARATOR + "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 "
            + SEPARATOR + "exampleRegion,  positions.values pos TYPE Position WHERE iD > 0");
    queries.put("43",
        "IMPORT org.apache.geode.cache.\"query\".data.Position;SELECT DISTINCT secId FROM "
            + SEPARATOR + "exampleRegion, (set<Position>)positions.values WHERE iD > 0");
    queries.put("44",
        "IMPORT org.apache.geode.cache.\"query\".data.Position;SELECT DISTINCT secId FROM "
            + SEPARATOR + "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 " + SEPARATOR
            + "exampleRegion p , p.positions.values pos  where p.status= 'active'");
    queries.put("46", "SELECT  distinct * FROM " + SEPARATOR + "exampleRegion order by pkid desc");
    queries.put("47",
        "SELECT  distinct * FROM " + SEPARATOR + "exampleRegion pf1  order by pkid asc");
    queries.put("48", "SELECT  distinct * FROM " + SEPARATOR + "exampleRegion pf1 order by pkid");
    queries.put("49",
        "SELECT  distinct * FROM " + SEPARATOR
            + "exampleRegion pf1 where ID != 10 order by ID asc, pkid asc limit 10");
    queries.put("50", "SELECT  distinct * FROM " + SEPARATOR
        + "exampleRegion pf1 where ID != 10 order by ID desc");
    queries.put("51",
        "SELECT  distinct * FROM " + SEPARATOR
            + "exampleRegion pf1 where ID != 10 order by ID desc, pkid desc limit 10");
    queries.put("52", "SELECT  distinct * FROM " + SEPARATOR
        + "exampleRegion pf1 where ID > 0 order by pkid asc");
    queries.put("53",
        "SELECT  distinct * FROM " + SEPARATOR + "exampleRegion pf1 where ID > 0 order by pkid");
    queries.put("54",
        "SELECT  distinct * FROM " + SEPARATOR
            + "exampleRegion pf1 where ID > 10 and ID < 20 order by ID asc, pkid asc limit 5");
    queries.put("55",
        "SELECT  distinct * FROM " + SEPARATOR
            + "exampleRegion pf1 where ID > 10 and ID < 20 order by ID desc");
    queries.put("56",
        "SELECT  distinct * FROM " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion pf1 where ID > 10 order by ID desc limit 5");
    queries.put("61",
        "SELECT  distinct ID, description, createTime FROM " + SEPARATOR
            + "exampleRegion pf1 where ID > 10 order by ID desc, pkid desc limit 5");
    queries.put("62",
        "SELECT  distinct ID, description, createTime FROM " + SEPARATOR
            + "exampleRegion pf1 where ID > 10 order by ID desc, pkid desc");
    queries.put("63",
        "SELECT  distinct ID, description, createTime FROM " + SEPARATOR
            + "exampleRegion pf1 where ID >= 10 and ID <= 20 order by ID asc, pkid desc");
    queries.put("64",
        "SELECT  distinct ID, description, createTime FROM " + SEPARATOR
            + "exampleRegion pf1 where ID >= 10 and ID <= 20 order by ID desc limit 5");
    queries.put("65",
        "SELECT  distinct ID, description, createTime FROM " + SEPARATOR
            + "exampleRegion pf1 where ID >= 10 and ID <= 20 order by ID desc");
    queries.put("66",
        "SELECT  distinct ID, description, createTime FROM " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion pf1 where pf1.ID != '10' order by ID desc limit 5");
    queries.put("68",
        "SELECT  distinct ID, description, createTime FROM " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion pf1 where ID < 1000 order by pkid");
    queries.put("70",
        "SELECT  distinct ID, pkid FROM " + SEPARATOR
            + "exampleRegion pf1 where ID > 0 order by pkid");
    queries.put("71",
        "SELECT  distinct ID, pkid FROM " + SEPARATOR
            + "exampleRegion pf1 where ID > 0 order by pkid, ID asc");
    queries.put("72",
        "SELECT  distinct ID, pkid FROM " + SEPARATOR
            + "exampleRegion pf1 where ID > 0 order by pkid, ID desc");
    queries.put("73",
        "SELECT  distinct pkid FROM " + SEPARATOR + "exampleRegion pf1 order by pkid");
    queries.put("74",
        "SELECT  distinct pkid FROM " + SEPARATOR
            + "exampleRegion pf1 where ID > 0 order by pkid asc");
    queries.put("75",
        "SELECT  distinct pkid FROM " + SEPARATOR
            + "exampleRegion pf1 where ID > 0 order by pkid desc");
    queries.put("76",
        "SELECT  distinct pkid FROM " + SEPARATOR + "exampleRegion pf1 where ID > 0 order by pkid");
    queries.put("77",
        "SELECT  distinct pkid FROM " + SEPARATOR
            + "exampleRegion pf1 where pkid != 'XXXX' order by pkid asc");
    queries.put("78",
        "SELECT  distinct pkid FROM " + SEPARATOR
            + "exampleRegion pf1 where pkid != 'XXXX' order by pkid desc");
    queries.put("79", "SELECT * FROM " + SEPARATOR + "exampleRegion p where p.intVar < 9");
    queries.put("80", "SELECT * FROM " + SEPARATOR + "exampleRegion pf WHERE pf = 'XX1'");
    queries.put("81",
        "SELECT * FROM " + SEPARATOR + "exampleRegion pf WHERE pf IN SET( 'XX5', 'XX6', 'XX7')");
    queries.put("82", "SELECT * FROM " + SEPARATOR + "exampleRegion");
    queries.put("83", "SELECT * FROM " + SEPARATOR + "exampleRegion.keys k WHERE k.ID = 1");
    queries.put("84", "SELECT * FROM " + SEPARATOR + "exampleRegion.keys key WHERE key.ID = 1");
    queries.put("85", "SELECT * FROM " + SEPARATOR + "exampleRegion.keys key WHERE key.ID > 5");
    queries.put("86",
        "SELECT * FROM " + SEPARATOR
            + "exampleRegion.values pf WHERE pf IN SET( 'XX5', 'XX6', 'XX7')");
    queries.put("87", "SELECT * from " + SEPARATOR + "exampleRegion");
    queries.put("88", "SELECT ALL * FROM " + SEPARATOR + "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 "
            + SEPARATOR + "exampleRegion q, " + SEPARATOR
            + "exampleRegion r WHERE q.cusip = r.cusip AND q.quoteType = r.quoteType");
    queries.put("90",
        "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion AS ptf, positions AS pos) WHERE pos.value.secId = 'IBM'");
    queries.put("91",
        "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion ptf, positions pos) WHERE pos.value.secId = 'IBM'");
    queries.put("92",
        "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion ptf, positions pos) p WHERE p.get('pos').value.secId = 'IBM'");
    queries.put("93",
        "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion ptf, positions pos) p WHERE p.pos.value.secId = 'IBM'");
    queries.put("94",
        "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion ptf, positions pos) p WHERE pos.value.secId = 'IBM'");
    queries.put("95",
        "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion, positions) WHERE positions.value.secId = 'IBM'");
    queries.put("96",
        "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion, positions) p WHERE p.positions.value.secId = 'IBM'");
    queries.put("97",
        "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM ptf IN " + SEPARATOR
            + "exampleRegion, pos IN positions) WHERE pos.value.secId = 'IBM'");
    queries.put("98",
        "SELECT DISTINCT * FROM (SELECT DISTINCT pos AS myPos FROM " + SEPARATOR
            + "exampleRegion ptf, positions pos) WHERE myPos.value.secId = 'IBM'");
    queries.put("99",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion  pf WHERE pf.ID > 10 limit 5");
    queries.put("100",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion  pf, pf.collectionHolderMap.keySet  WHERE pf.ID > 10 limit 20");
    queries.put("101",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion WHERE NOT(SELECT DISTINCT * FROM positions.values p WHERE p.secId = 'IBM').isEmpty");
    queries.put("102",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion as a, a.collectionHolderMap['0'].arr as b where a.status = 'active' and a.ID = 0");
    queries.put("103",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion c WHERE c.name = 'INDIA'");
    queries.put("104",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion c, c.states s, s.districts d WHERE d.name = 'PUNEDIST' AND s.name = 'GUJARAT'");
    queries.put("105",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion c, c.states s, s.districts d, d.cities ct WHERE ct.name = 'MUMBAI'");
    queries.put("106",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion c, c.states s, s.districts d, d.cities ct, d.villages v WHERE c.name = 'INDIA'");
    queries.put("107",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion itr1  WHERE itr1.liist[0] >= 2");
    queries.put("111",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion itr1  WHERE itr1.maap.get('key2') >= 16");
    queries.put("112",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion itr1  WHERE itr1.maap.get('key2') >= 3");
    queries.put("113", "SELECT DISTINCT * FROM " + SEPARATOR
        + "exampleRegion itr1  WHERE itr1.maap['key2'] >= 16");
    queries.put("114",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion itr1  WHERE itr1.maap['key2'] >= 3  and  itr1.maap['key3'] < 18");
    queries.put("115",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion itr1  WHERE itr1.maap['key2'] >= 3 and itr1.maap['key2'] <=18");
    queries.put("116",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion itr1  WHERE itr1.maap['key2'] >= 3");
    queries.put("117",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion itr1  WHERE itr1.maap['key3'] >= 3  and  itr1.maap['key3'] >= 13");
    queries.put("118",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion itr1  WHERE itr1.maap['key3'] >= 3");
    queries.put("119", "SELECT DISTINCT * FROM " + SEPARATOR
        + "exampleRegion itr1  WHERE itr1.maap['key4'] >= 16");
    queries.put("120",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion num WHERE num.id1 >= -200");
    queries.put("121",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion p  WHERE p.ID <= 10 order by p.ID asc limit 1");
    queries.put("122",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion p  WHERE p.ID <= 10 order by p.ID desc limit 1");
    queries.put("123",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion p  WHERE p.ID <= 10 order by p.pkid desc limit 1");
    queries.put("124",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion pf WHERE pf.ID > 0 limit 5");
    queries.put("125",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion pf where pf.description = 'XXXX'  and pf.status='active' and pf.createTime = 5");
    queries.put("126",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion pf where pf.description = 'XXXX'  and pf.status='active'");
    queries.put("127",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion pf,  positions.values pos where pf.status='active' and pos.secId= 'IBM' and pf.ID = 0");
    queries.put("129",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion pf, " + SEPARATOR
            + "exampleRegion emp WHERE pf.ID = emp.empId");
    queries.put("130",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion pf, pf.positions pos, " + SEPARATOR
            + "exampleRegion emp WHERE pf.iD = emp.empId and pf.status='active' and emp.age > 900");
    queries.put("131",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion pf, pf.positions pos, " + SEPARATOR
            + "exampleRegion emp WHERE pf.iD = emp.empId");
    queries.put("132",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion pf, pf.positions.values WHERE pf.ID > 0 limit 5");
    queries.put("133",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion pf, pf.positions.values position WHERE (pf.ID > 0 OR position.secId = 'SUN') OR false");
    queries.put("134",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion pf, pf.positions.values position WHERE (true = null OR position.secId = 'SUN') AND true");
    queries.put("135",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion pf, pf.positions.values position WHERE (true = null OR position.secId = 'SUN') OR true");
    queries.put("136",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion pf, pf.positions.values position WHERE true = null OR position.secId = 'SUN'");
    queries.put("137",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion value  where value.length > 6");
    queries.put("138", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion value");
    queries.put("139",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where (status = 'active' OR ID = 2) AND P1.secId  = 'IBM'");
    queries.put("140", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where FALSE");
    queries.put("141",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where NOT (status = 'active') AND ID = 2");
    queries.put("142",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where NOT (status = 'active') OR ID = 2");
    queries.put("143", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where NULL");
    queries.put("144",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P1.secId != 'IBM'");
    queries.put("145",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P1.secId > 'IBM'");
    queries.put("146",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P1.secId >= 'IBM'");
    queries.put("147",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P1.secId!='DELL'");
    queries.put("148",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P1.secId<'DELL'");
    queries.put("149",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P1.secId<='DELL'");
    queries.put("150",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P1.secId<>'DELL'");
    queries.put("151",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P1.secId='DELL'");
    queries.put("152",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P1.secId>'DELL'");
    queries.put("153",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P1.secId>='DELL'");
    queries.put("154",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P1.secType = 'a'");
    queries.put("155", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P2!=null");
    queries.put("156",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P2.secId = UNDEFINED");
    queries.put("157",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P2.secId = null");
    queries.put("158",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P2.secId!= UNDEFINED");
    queries.put("159",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P2.secId< UNDEFINED");
    queries.put("160",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P2.secId<= UNDEFINED");
    queries.put("161",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P2.secId<> UNDEFINED");
    queries.put("162",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P2.secId= UNDEFINED");
    queries.put("163",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P2.secId> UNDEFINED");
    queries.put("164",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P2.secId>= UNDEFINED");
    queries.put("165", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P2<=null");
    queries.put("166", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P2<>null");
    queries.put("167", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P2<null");
    queries.put("168", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P2=null");
    queries.put("169", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P2>=null");
    queries.put("170", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where P2>null");
    queries.put("171", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where TRUE");
    queries.put("172", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where UNDEFINED");
    queries.put("173", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where ID != 2");
    queries.put("174", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where ID <> 2");
    queries.put("175", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where ID >= 2");
    queries.put("176", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where ID!=2");
    queries.put("177", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where ID<2");
    queries.put("178", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where ID<=2");
    queries.put("179", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where ID<>2");
    queries.put("180", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where ID=2");
    queries.put("181", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where ID>2");
    queries.put("182", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where ID>=2");
    queries.put("183",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where status != 'active'");
    queries.put("184",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where status < 'active'");
    queries.put("185",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where status <= 'active'");
    queries.put("186",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where status <> 'active'");
    queries.put("187",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where status = 'active' AND ( ID = 2 OR P1.secId  = 'IBM')");
    queries.put("188",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where status = 'active' AND NOT( ID = 2 )");
    queries.put("189",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where status = 'active' AND P1.secType = 'a'");
    queries.put("190",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where status = 'active' AND ID = 1 OR P1.secType = 'a'");
    queries.put("191",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where status = 'active' AND ID = 2 AND P1.secId  = 'IBM'");
    queries.put("192",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where status = 'active' AND ID = 2 OR P1.secId  = 'IBM'");
    queries.put("193",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where status = 'active' AND ID = 2");
    queries.put("194",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where status = 'active' AND ID =1 AND P1.secType = 'a'");
    queries.put("195",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where status = 'active' OR NOT( ID = 2 )");
    queries.put("196",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where status = 'active' OR P1.secType = 'a'");
    queries.put("197",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where status = 'active' OR ID = 1 AND P1.secType = 'a'");
    queries.put("198",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where status = 'active' OR ID = 2 AND P1.secId  = 'IBM'");
    queries.put("199",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where status = 'active' OR ID = 2 OR P1.secId  = 'IBM'");
    queries.put("200",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where status = 'active' OR ID = 2");
    queries.put("201",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where status = 'active'");
    queries.put("202",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where status = 'inactive'");
    queries.put("203",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where status > 'active'");
    queries.put("204",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where status >= 'active'");
    queries.put("205",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where status='active'");
    queries.put("206", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"AND\"()");
    queries.put("207", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"DISTINCT\"()");
    queries.put("208", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"ELEMENT\"()");
    queries.put("209", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"FALSE\"");
    queries.put("210", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"FALSE\"()");
    queries.put("211", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"FROM\"()");
    queries.put("212", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"NOT\"()");
    queries.put("213", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"OR\"()");
    queries.put("214", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"SELECT\"()");
    queries.put("215", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"TRUE\"");
    queries.put("216", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"TRUE\"()");
    queries.put("217", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"TYPE\"()");
    queries.put("218",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"UNDEFINED\"()");
    queries.put("219", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"WHERE\"()");
    queries.put("220", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"and\"");
    queries.put("221", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"distinct\"");
    queries.put("222", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"element\"");
    queries.put("223", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"from\"");
    queries.put("224", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"not\"");
    queries.put("225", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"or\"");
    queries.put("226", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"select\"");
    queries.put("227", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"undefined\"");
    queries.put("228", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where\"where\"");
    queries.put("229",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion x where status = ELEMENT(SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion p where p.ID = 1).status");
    queries.put("230",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion x where status = ELEMENT(SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion p where p.ID = x.ID).status");
    queries.put("231",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion x where status = ELEMENT(SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion p where x.ID = p.ID).status");
    queries.put("232", "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion");
    queries.put("233",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion er,  positions.values where er.status='active'");
    queries.put("234",
        "SELECT DISTINCT * FROM " + SEPARATOR + "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 " + SEPARATOR + "exampleRegion order by status, ID desc");
    queries.put("238",
        "SELECT DISTINCT * from " + SEPARATOR + "exampleRegion p order by p.getID()");
    queries.put("239",
        "SELECT DISTINCT * from " + SEPARATOR + "exampleRegion p order by p.getP1().getSecId()");
    queries.put("240",
        "SELECT DISTINCT * from " + SEPARATOR + "exampleRegion p order by p.getP1().secId");
    queries.put("241",
        "SELECT DISTINCT * from " + SEPARATOR
            + "exampleRegion p order by p.getP1().secId, p.ID desc, p.ID LIMIT 9");
    queries.put("242", "SELECT DISTINCT * from " + SEPARATOR + "exampleRegion p order by p.ID");
    queries.put("243",
        "SELECT DISTINCT * from " + SEPARATOR + "exampleRegion p order by p.names[1]");
    queries.put("244",
        "SELECT DISTINCT * from " + SEPARATOR + "exampleRegion p order by p.position1.secId");
    queries.put("245",
        "SELECT DISTINCT * from " + SEPARATOR + "exampleRegion p order by p.status, p.ID");
    queries.put("246", "SELECT DISTINCT * from " + SEPARATOR
        + "exampleRegion p, p.positions.values order by p.ID");
    queries.put("247",
        "SELECT DISTINCT * from " + SEPARATOR
            + "exampleRegion pf , pf.positions.values pos where pos.getSecId = 'IBM' and pf.status = 'inactive'");
    queries.put("248",
        "SELECT DISTINCT * from " + SEPARATOR
            + "exampleRegion pf, pf.positions.values pos where pos.secId = 'IBM'");
    queries.put("249",
        "SELECT DISTINCT c.name, s.name FROM " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion c, c.states s, s.districts d WHERE d.name = 'MUMBAIDIST'");
    queries.put("255",
        "SELECT DISTINCT e.key from " + SEPARATOR
            + "exampleRegion.entrySet e order by e.key.ID desc, e.key.pkid desc");
    queries.put("256",
        "SELECT DISTINCT e.key from " + SEPARATOR
            + "exampleRegion.entrySet e order by e.key.ID, e.key.pkid desc");
    queries.put("257",
        "SELECT DISTINCT e.key, e.value from " + SEPARATOR
            + "exampleRegion.entrySet e order by e.key.ID, e.value.status desc");
    queries.put("258",
        "SELECT DISTINCT e.key.ID from " + SEPARATOR + "exampleRegion.entries e order by e.key.ID");
    queries.put("259",
        "SELECT DISTINCT e.key.ID, e.value.status from " + SEPARATOR
            + "exampleRegion.entries e order by e.key.ID");
    queries.put("260",
        "SELECT DISTINCT e.key.ID, e.value.status from " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion.entrySet e order by e.key.ID, e.value.status desc");
    queries.put("262",
        "SELECT DISTINCT r.iD, p.value.secId FROM " + SEPARATOR
            + "exampleRegion r, getPositions('true') p where r.status = 'active' and r.iD = 0");
    queries.put("263",
        "SELECT DISTINCT er.ID, value.secId FROM " + SEPARATOR
            + "exampleRegion er, getPositions value where er.status = 'active' and er.ID = 0");
    queries.put("264",
        "SELECT DISTINCT key from " + SEPARATOR + "exampleRegion.keys key order by key.status");
    queries.put("265",
        "SELECT DISTINCT key.ID from " + SEPARATOR + "exampleRegion.keys key order by key.ID");
    queries.put("266",
        "SELECT DISTINCT key.ID, key.status from " + SEPARATOR
            + "exampleRegion.keys key order by key.status desc, key.ID");
    queries.put("267",
        "SELECT DISTINCT key.ID, key.status from " + SEPARATOR
            + "exampleRegion.keys key order by key.status");
    queries.put("268",
        "SELECT DISTINCT key.ID, key.status from " + SEPARATOR
            + "exampleRegion.keys key order by key.status, key.ID desc");
    queries.put("269",
        "SELECT DISTINCT key.ID, key.status from " + SEPARATOR
            + "exampleRegion.keys key order by key.status, key.ID");
    queries.put("270",
        "SELECT DISTINCT name FROM " + SEPARATOR + "exampleRegion , secIds name where length > 0");
    queries.put("271",
        "SELECT DISTINCT p, pos from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by p.ID");
    queries.put("272",
        "SELECT DISTINCT p, pos from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by p.ID, pos.secId");
    queries.put("273",
        "SELECT DISTINCT p, pos from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by pos.secId");
    queries.put("274",
        "SELECT DISTINCT p.getID() from " + SEPARATOR + "exampleRegion p order by p.getID()");
    queries.put("275", "SELECT DISTINCT p.ID from " + SEPARATOR + "exampleRegion p order by p.ID");
    queries.put("276",
        "SELECT DISTINCT p.ID, p.status from " + SEPARATOR + "exampleRegion p order by p.ID");
    queries.put("277",
        "SELECT DISTINCT p.ID from " + SEPARATOR
            + "exampleRegion p, p.positions.values order by p.ID");
    queries.put("278",
        "SELECT DISTINCT p.ID, p.position1.secId from " + SEPARATOR
            + "exampleRegion p order by p.position1.secId");
    queries.put("279",
        "SELECT DISTINCT p.ID, p.position1.secId from " + SEPARATOR
            + "exampleRegion p order by p.position1.secId, p.ID");
    queries.put("280",
        "SELECT DISTINCT p.ID, p.status from " + SEPARATOR
            + "exampleRegion p order by p.ID desc, p.status asc");
    queries.put("281",
        "SELECT DISTINCT p.ID, p.status from " + SEPARATOR
            + "exampleRegion p, p.positions.values order by p.status");
    queries.put("282",
        "SELECT DISTINCT p.ID, p.status from " + SEPARATOR
            + "exampleRegion p, p.positions.values order by p.status, p.ID");
    queries.put("283",
        "SELECT DISTINCT p.ID, pos.secId from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by p.ID desc, pos.secId desc");
    queries.put("284",
        "SELECT DISTINCT p.ID, pos.secId from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by p.ID desc, pos.secId");
    queries.put("285",
        "SELECT DISTINCT p.ID, pos.secId from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by p.ID, pos.secId");
    queries.put("286",
        "SELECT DISTINCT p.ID, pos.secId from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by pos.secId");
    queries.put("287",
        "SELECT DISTINCT p.ID, pos.secId from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by pos.secId, p.ID");
    queries.put("288",
        "SELECT DISTINCT p.key, p.value FROM " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion p order by p.names[1]");
    queries.put("291",
        "SELECT DISTINCT p.position1.secId, p.ID from " + SEPARATOR
            + "exampleRegion p order by p.position1.secId desc, p.ID");
    queries.put("292",
        "SELECT DISTINCT p.position1.secId, p.ID from " + SEPARATOR
            + "exampleRegion p order by p.position1.secId");
    queries.put("293",
        "SELECT DISTINCT p.status, p.ID from " + SEPARATOR
            + "exampleRegion p order by p.status asc, p.ID");
    queries.put("294",
        "SELECT DISTINCT p.status, p.ID from " + SEPARATOR + "exampleRegion p order by p.status");
    queries.put("295",
        "SELECT DISTINCT p.status, p.ID from " + SEPARATOR
            + "exampleRegion p order by p.status, p.ID");
    queries.put("296",
        "SELECT DISTINCT pf FROM " + SEPARATOR
            + "exampleRegion pf,  positions.values pos where pf.description = 'XXXX'  and pos.secId= 'IBM'");
    queries.put("297",
        "SELECT DISTINCT pos.secId FROM " + SEPARATOR
            + "exampleRegion er,  positions.values AS pos  WHERE er.ID > 0");
    queries.put("298",
        "SELECT DISTINCT pos.secId FROM " + SEPARATOR
            + "exampleRegion, pos IN positions.values  WHERE pos.ID > 0");
    queries.put("299",
        "SELECT DISTINCT pos.secId from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by pos.secId");
    queries.put("300",
        "SELECT DISTINCT s.name, s.getDistricts(), ct.getName() FROM " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion order by status");
    queries.put("302",
        "SELECT DISTINCT status, ID from " + SEPARATOR + "exampleRegion order by status, ID");
    queries.put("303", "SELECT ID FROM " + SEPARATOR + "exampleRegion pf WHERE pf.ID = 1");
    queries.put("304", "SELECT ID FROM " + SEPARATOR + "exampleRegion pf WHERE pf.ID > 10");
    queries.put("305", "SELECT ID FROM " + SEPARATOR + "exampleRegion pf WHERE pf.ID > 5");
    queries.put("306", "SELECT ID FROM " + SEPARATOR + "exampleRegion.keys key WHERE key.ID = 1");
    queries.put("307", "SELECT ID FROM " + SEPARATOR + "exampleRegion.keys key WHERE key.ID > 5");
    queries.put("308",
        "SELECT k.ID, k.status FROM " + SEPARATOR
            + "exampleRegion.keys k WHERE k.ID = 1 and k.status = 'active'");
    queries.put("309",
        "SELECT key.ID FROM " + SEPARATOR
            + "exampleRegion.keys key WHERE key.ID > 5 and key.status = 'active'");
    queries.put("310", "SELECT pkid FROM " + SEPARATOR + "exampleRegion ps WHERE ps.pkid = 'abc'");
    queries.put("311", "Select * from " + SEPARATOR + "exampleRegion pf where pf.ID < 2");
    queries.put("312", "Select * from " + SEPARATOR + "exampleRegion pf where pf.ID = 2");
    queries.put("313", "Select * from " + SEPARATOR + "exampleRegion pf where pf.ID > 1");
    queries.put("314",
        "Select * from " + SEPARATOR + "exampleRegion pf where pf.position1.secId > '2'");
    queries.put("315", "Select * from " + SEPARATOR + "exampleRegion.keys key where key.ID = 2");
    queries.put("316",
        "Select distinct  * from " + SEPARATOR + "exampleRegion.keySet keys where keys = '4'");
    queries.put("317",
        "Select distinct  security from " + SEPARATOR
            + "exampleRegion  pos , secIds security where length > 2 and pos.ID > 0");
    queries.put("318",
        "Select distinct * from " + SEPARATOR + "exampleRegion e, " + SEPARATOR
            + "exampleRegion a, e.getPhoneNo(a.zipCode) ea where e.name ='empName'");
    queries.put("319",
        "Select distinct * from " + SEPARATOR + "exampleRegion pf where pf.getID() = -1");
    queries.put("320",
        "Select distinct * from " + SEPARATOR + "exampleRegion pf where pf.getID() = -2147483648");
    queries.put("321",
        "Select distinct * from " + SEPARATOR
            + "exampleRegion pf where pf.getID() = 3 and pf.getDoubleMinValue() = 4.9E-324");
    queries.put("322",
        "Select distinct * from " + SEPARATOR
            + "exampleRegion pf where pf.getID() = 3 and pf.getFloatMinValue() = 1.4E-45f");
    queries.put("323",
        "Select distinct * from " + SEPARATOR
            + "exampleRegion pf where pf.getID() = 3 and pf.getLongMinValue() = -9223372036854775808l");
    queries.put("324",
        "Select distinct * from " + SEPARATOR + "exampleRegion pf, " + SEPARATOR
            + "exampleRegion e  where e.name ='empName' and pf.status='active'");
    queries.put("325",
        "Select distinct * from " + SEPARATOR + "exampleRegion pf, " + SEPARATOR
            + "exampleRegion e  where e.name ='empName'");
    queries.put("326",
        "Select distinct * from " + SEPARATOR
            + "exampleRegion pf, pf.positions.values pos where pf.status = 'active' and pos.secId = 'IBM'");
    queries.put("327",
        "Select distinct * from " + SEPARATOR + "exampleRegion pf," + SEPARATOR
            + "exampleRegion e  where pf.status='active'");
    queries.put("328",
        "Select distinct * from " + SEPARATOR + "exampleRegion pf1 where pf1.getID() > 3");
    queries.put("329",
        "Select distinct * from " + SEPARATOR + "exampleRegion pf1 where pf1.pkid > '3'");
    queries.put("330",
        "Select distinct * from " + SEPARATOR + "exampleRegion, " + SEPARATOR + "exampleRegion");
    queries.put("331",
        "Select distinct * from " + SEPARATOR
            + "exampleRegion.entrySet pf where pf.value.getID() = 4");
    queries.put("332",
        "Select distinct e.value.secId from " + SEPARATOR + "exampleRegion, getPositions(23) e");
    queries.put("333", "Select distinct ID from " + SEPARATOR + "exampleRegion");
    queries.put("334", "Select distinct p from " + SEPARATOR + "exampleRegion p order by p");
    queries.put("335",
        "Select distinct pf from " + SEPARATOR
            + "exampleRegion pf , pf.positions.values ps where ps.secId='SUN'");
    queries.put("336",
        "Select distinct security from " + SEPARATOR
            + "exampleRegion , secIds security where security.length > 2 AND (security.intern <> 'SUN' AND security.intern <> 'DELL' )");
    queries.put("337",
        "Select distinct security  from " + SEPARATOR
            + "exampleRegion, secIds security where security.length > 1");
    queries.put("338",
        "Select distinct pos.secId from " + SEPARATOR + "exampleRegion , getPositions(23) pos");
    queries.put("339",
        "Select distinct pos.secId from " + SEPARATOR + "exampleRegion, positions pos");
    queries.put("340", "Select p.get('acc') from " + SEPARATOR + "exampleRegion p");
    queries.put("341", "Select p.get('account') from " + SEPARATOR + "exampleRegion p");
    queries.put("342",
        "Select p.shortID from " + SEPARATOR + "exampleRegion p where p.shortID < 5");
    queries.put("343",
        "Select pf.ID from " + SEPARATOR + "exampleRegion pf where pf.ID > 2 and pf.ID < 100");
    queries.put("344",
        "Select status from " + SEPARATOR + "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 "
            + SEPARATOR + "exampleRegion, (select distinct * from " + SEPARATOR
            + "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 "
            + SEPARATOR + "exampleRegion, (map<string, Position>)getPositions(23)");
    queries.put("348", "select  * from " + SEPARATOR
        + "exampleRegion pf where pf.getID  > 1 and pf.getID < 12000");
    queries.put("349",
        "select  * from " + SEPARATOR
            + "exampleRegion pf where pf.status != 'active' and pf.status != null");
    queries.put("350",
        "select  distinct p.status  from " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion p  where  p.createTime = 10l AND  p.status IN SET( 'active') AND  true");
    queries.put("354",
        "select  distinct p.status  from " + SEPARATOR
            + "exampleRegion p  where  p.createTime > 0 AND p.createTime <11 AND  p.ID IN  SET( 0)");
    queries.put("355",
        "select  distinct p.status  from " + SEPARATOR
            + "exampleRegion p  where  p.ID = 11 AND   p.createTime IN  SET( 10L)");
    queries.put("356",
        "select  distinct p.status  from " + SEPARATOR
            + "exampleRegion p  where  p.ID > 11 AND  p.ID < 19 and  p.createTime IN  SET( 10L)");
    queries.put("357",
        "select  distinct p.status  from " + SEPARATOR
            + "exampleRegion p  where  p.ID > 11 AND  p.ID < 20 AND  p.createTime <>9L");
    queries.put("358",
        "select  distinct p.status  from " + SEPARATOR + "exampleRegion p  where  true");
    queries.put("359",
        "select  p.status as sts, p as pos from " + SEPARATOR
            + "exampleRegion p  where  p.ID IN  ( Select x.ID from " + SEPARATOR
            + "exampleRegion x where x.ID > 10)");
    queries.put("360",
        "select  p.status as sts, p as pos from " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion p  where p.ID > 0 and p.createTime > 0");
    queries.put("364",
        "select  p.status as sts, p as pos from " + SEPARATOR
            + "exampleRegion p  where p.ID IN  SET( 0,1,2,3) and p.createTime > 0");
    queries.put("365",
        "select  p.status from " + SEPARATOR
            + "exampleRegion p  where p.ID > 0 and p.createTime > 0");
    queries.put("366", "select  p.status from " + SEPARATOR + "exampleRegion p where p.ID > 0");
    queries.put("367",
        "select  p.status from " + SEPARATOR + "exampleRegion p, p.positions pos where p.ID > 0");
    queries.put("368",
        "select * from " + SEPARATOR + "exampleRegion p where NOT (p.ID IN SET(1, 2))");
    queries.put("369", "select * from " + SEPARATOR + "exampleRegion sf where sf.shortField < 10");
    queries.put("370", "select * from " + SEPARATOR + "exampleRegion this where FALSE");
    queries.put("371", "select * from " + SEPARATOR + "exampleRegion this where NOT isActive");
    queries.put("372", "select * from " + SEPARATOR + "exampleRegion this where NULL");
    queries.put("373", "select * from " + SEPARATOR + "exampleRegion this where P1.secId = 'SUN'");
    queries.put("374", "select * from " + SEPARATOR + "exampleRegion this where TRUE");
    queries.put("375", "select * from " + SEPARATOR + "exampleRegion this where UNDEFINED");
    queries.put("376", "select * from " + SEPARATOR + "exampleRegion this where ID < 1");
    queries.put("377", "select * from " + SEPARATOR + "exampleRegion this where ID < 5");
    queries.put("378", "select * from " + SEPARATOR + "exampleRegion this where ID <= 1");
    queries.put("379", "select * from " + SEPARATOR + "exampleRegion this where ID <= 5");
    queries.put("380", "select * from " + SEPARATOR + "exampleRegion this where ID = 0 OR ID = 1");
    queries.put("381", "select * from " + SEPARATOR + "exampleRegion this where ID = 5");
    queries.put("382", "select * from " + SEPARATOR + "exampleRegion this where ID > 2");
    queries.put("383", "select * from " + SEPARATOR + "exampleRegion this where ID > 4 AND ID < 9");
    queries.put("384",
        "select * from " + SEPARATOR + "exampleRegion this where ID > 5 and ID <=15");
    queries.put("385", "select * from " + SEPARATOR + "exampleRegion this where ID >= 2");
    queries.put("386", "select * from " + SEPARATOR + "exampleRegion this where isActive");
    queries.put("387", "select * from " + SEPARATOR + "exampleRegion this where isActive()");
    queries.put("388", "select * from " + SEPARATOR + "exampleRegion this where pk = '2'");
    queries.put("389", "select * from " + SEPARATOR + "exampleRegion this where pk = '7'");
    queries.put("390",
        "select * from " + SEPARATOR + "exampleRegion this where status <> 'active'");
    queries.put("391",
        "select * from " + SEPARATOR
            + "exampleRegion this where status = 'active' AND ( ID = 1 OR P1.secId = 'SUN')");
    queries.put("392",
        "select * from " + SEPARATOR + "exampleRegion this where status = 'active' AND ID = 0");
    queries.put("393",
        "select * from " + SEPARATOR + "exampleRegion this where status = 'active' AND ID = 1");
    queries.put("394",
        "select * from " + SEPARATOR + "exampleRegion this where status = 'active' OR ID = 1");
    queries.put("395", "select * from " + SEPARATOR + "exampleRegion this where status = 'active'");
    queries.put("396", "select * from " + SEPARATOR + "exampleRegion this where testMethod(true)");
    queries.put("397", "select * from " + SEPARATOR + "exampleRegion this where this = 'value'");
    queries.put("398",
        "select * from " + SEPARATOR
            + "exampleRegion this where toString()='doOpDuringBucketRemove.VALUE'");
    queries.put("399", "select * from " + SEPARATOR + "exampleRegion where 3 >= length");
    queries.put("400", "select * from " + SEPARATOR + "exampleRegion where age < 50");
    queries.put("401", "select * from " + SEPARATOR + "exampleRegion where intVar = 0");
    queries.put("402",
        "select * from " + SEPARATOR + "exampleRegion.entries sf where sf.value.shortField < 10");
    queries.put("403", "select ALL * from " + SEPARATOR + "exampleRegion where 3 >= length");
    queries.put("404",
        "select distinct  key.status as st from " + SEPARATOR
            + "exampleRegion key where key.ID > 5 order by key.status");
    queries.put("405",
        "select distinct  p.position1.secId  as st from " + SEPARATOR
            + "exampleRegion p order by p.position1.secId");
    queries.put("406",
        "select distinct  p.status, p.ID from " + SEPARATOR + "exampleRegion p order by p.status");
    queries.put("407",
        "select distinct  status, ID from " + SEPARATOR + "exampleRegion order by status");
    queries.put("408", "select distinct 'a' from " + SEPARATOR + "exampleRegion p");
    queries.put("409", "select distinct 'a',1, p from " + SEPARATOR + "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 " + SEPARATOR + "exampleRegion a, " + SEPARATOR
            + "exampleRegion p, " + SEPARATOR
            + "exampleRegion e, a.street s  where s.street ='DPStreet1'");
    queries.put("413",
        "select distinct * from " + SEPARATOR + "exampleRegion a, " + SEPARATOR
            + "exampleRegion p, " + SEPARATOR
            + "exampleRegion e, a.street s where p.status='active' and s.street ='DPStreet1'");
    queries.put("414",
        "select distinct * from " + SEPARATOR
            + "exampleRegion itr1,itr1.phoneNo itr2,itr1.street itr3 where itr2.mobile>333");
    queries.put("415",
        "select distinct * from " + SEPARATOR
            + "exampleRegion itr1,itr1.street itr2,itr1.phoneNo itr3 where itr3.mobile>333");
    queries.put("416",
        "select distinct * from " + SEPARATOR + "exampleRegion p order by p.getID()");
    queries.put("417",
        "select distinct * from " + SEPARATOR + "exampleRegion p order by p.getP1().secId");
    queries.put("418",
        "select distinct * from " + SEPARATOR + "exampleRegion p order by status, ID desc");
    queries.put("419",
        "select distinct * from " + SEPARATOR + "exampleRegion p where p.ID > 1   and  p.ID < 3");
    queries.put("420", "select distinct * from " + SEPARATOR + "exampleRegion p");
    queries.put("421",
        "select distinct * from " + SEPARATOR + "exampleRegion p, " + SEPARATOR
            + "exampleRegion e  where p.pkid = '1'");
    queries.put("422", "select distinct * from " + SEPARATOR + "exampleRegion p, " + SEPARATOR
        + "exampleRegion e");
    queries.put("423",
        "select distinct * from " + SEPARATOR + "exampleRegion p, " + SEPARATOR
            + "exampleRegion e, " + SEPARATOR
            + "exampleRegion a, a.street s where s.street ='DPStreet1'");
    queries.put("424",
        "select distinct * from " + SEPARATOR + "exampleRegion p, " + SEPARATOR
            + "exampleRegion p1 where p.position1.Id = p1.position1.Id and p1.position1.secId in set('MSFT')");
    queries.put("425",
        "select distinct * from " + SEPARATOR + "exampleRegion p, p.positions where p.ID = 1");
    queries.put("426",
        "select distinct * from " + SEPARATOR + "exampleRegion p, p.positions," + SEPARATOR
            + "exampleRegion e where p.ID =  e.empId");
    queries.put("427",
        "select distinct * from " + SEPARATOR + "exampleRegion p, p.positions," + SEPARATOR
            + "exampleRegion e, " + SEPARATOR
            + "exampleRegion p1 where p.ID = 1 and p1.ID = 2 and e.empId = 1");
    queries.put("428",
        "select distinct * from " + SEPARATOR + "exampleRegion p, p.positions," + SEPARATOR
            + "exampleRegion e, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion p, p.positions," + SEPARATOR
            + "exampleRegion e, " + SEPARATOR
            + "exampleRegion p1 where p.ID =p1.ID   and e.empId = p1.ID");
    queries.put("430", "select distinct * from " + SEPARATOR
        + "exampleRegion p, p.positions.values order by p.ID");
    queries.put("431",
        "select distinct * from " + SEPARATOR
            + "exampleRegion p, p.positions.values val order by p.ID, val.secId desc");
    queries.put("432",
        "select distinct * from " + SEPARATOR
            + "exampleRegion p, p.positions.values where p.ID < 3");
    queries.put("433",
        "select distinct * from " + SEPARATOR
            + "exampleRegion p, p.positions.values where p.pkid != '53'");
    queries.put("434",
        "select distinct * from " + SEPARATOR + "exampleRegion pf where false and ID = 0");
    queries.put("435",
        "select distinct * from " + SEPARATOR + "exampleRegion pf where ID = 0 or false");
    queries.put("436",
        "select distinct * from " + SEPARATOR
            + "exampleRegion pf where nvl(pf.position2, pf.position1).secId = 'SUN'");
    queries.put("437",
        "select distinct * from " + SEPARATOR
            + "exampleRegion pf where nvl(pf.position2,'foundNull') = 'foundNull'");
    queries.put("438",
        "select distinct * from " + SEPARATOR + "exampleRegion pf where true and ID = 0");
    queries.put("439",
        "select distinct * from " + SEPARATOR + "exampleRegion pf where true or ID = 0");
    queries.put("440",
        "select distinct * from " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion pf, positions.values pos  where true = true and pf.ID > 1 and pos.secId ='IBM'");
    queries.put("442",
        "select distinct * from " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion pf, positions.values pos where false and pos.secId ='IBM'");
    queries.put("447",
        "select distinct * from " + SEPARATOR
            + "exampleRegion pf, positions.values pos where true = false and pf.ID > 1 and pos.secId ='IBM'");
    queries.put("448",
        "select distinct * from " + SEPARATOR
            + "exampleRegion pf, positions.values pos where true = true and pf.ID > 1 or pos.secId ='IBM'");
    queries.put("449",
        "select distinct * from " + SEPARATOR
            + "exampleRegion pf, positions.values pos where true = true and pos.secId ='IBM'");
    queries.put("450",
        "select distinct * from " + SEPARATOR + "exampleRegion s  where 3 >= s.length");
    queries.put("451", "select distinct * from " + SEPARATOR + "exampleRegion where 3 >= length");
    queries.put("452", "select distinct * from " + SEPARATOR + "exampleRegion where NOT isActive");
    queries.put("453", "select distinct * from " + SEPARATOR + "exampleRegion where ID != 53");
    queries.put("454", "select distinct * from " + SEPARATOR + "exampleRegion where ID < 1");
    queries.put("455", "select distinct * from " + SEPARATOR + "exampleRegion where ID >= 2");
    queries.put("456", "select distinct * from " + SEPARATOR + "exampleRegion where isActive");
    queries.put("457", "select distinct * from " + SEPARATOR + "exampleRegion where isActive()");
    queries.put("458",
        "select distinct * from " + SEPARATOR + "exampleRegion where status <> 'active'");
    queries.put("459",
        "select distinct * from " + SEPARATOR
            + "exampleRegion where status = 'active' AND ( ID = 1 OR P1.secId = 'SUN')");
    queries.put("460",
        "select distinct * from " + SEPARATOR + "exampleRegion where status = 'active' AND ID = 0");
    queries.put("461",
        "select distinct * from " + SEPARATOR + "exampleRegion where status = 'active' AND ID = 1");
    queries.put("462",
        "select distinct * from " + SEPARATOR + "exampleRegion where status = 'active' OR ID = 1");
    queries.put("463",
        "select distinct * from " + SEPARATOR + "exampleRegion where status = 'active'");
    queries.put("464",
        "select distinct * from " + SEPARATOR + "exampleRegion where testMethod(true)");
    queries.put("465",
        "select distinct * from " + SEPARATOR
            + "exampleRegion x, x.positions.values where x.pk = '1'");
    queries.put("466",
        "select distinct * from " + SEPARATOR
            + "exampleRegion x, x.positions.values where x.pkid = '1'");
    queries.put("467", "select distinct * from " + SEPARATOR + "exampleRegion");
    queries.put("468",
        "select distinct * from " + SEPARATOR + "exampleRegion.entries where key = '1'");
    queries.put("469",
        "select distinct * from " + SEPARATOR
            + "exampleRegion.entries where value.ID = 1 and key = '1'");
    queries.put("470",
        "select distinct * from " + SEPARATOR
            + "exampleRegion.entries where value.status = 'active'");
    queries.put("471",
        "select distinct * from " + SEPARATOR
            + "exampleRegion.entries x, x.value.positions.values where x.key = '1'");
    queries.put("472",
        "select distinct * from " + SEPARATOR
            + "exampleRegion.entries x, x.value.positions.values where x.value.pkid = '1'");
    queries.put("473",
        "select distinct * from " + SEPARATOR + "exampleRegion.keySet where toString = '1'");
    queries.put("474",
        "select distinct * from " + SEPARATOR + "exampleRegion.keys where toString = '1'");
    queries.put("475", "select distinct * from " + SEPARATOR + "exampleRegion.values where ID = 1");
    queries.put("476",
        "select distinct * from " + SEPARATOR + "exampleRegion.values where status = 'active'");
    queries.put("477", "select distinct * from null");
    queries.put("478", "select distinct 1 from " + SEPARATOR + "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 " + SEPARATOR
            + "exampleRegion.entrySet e order by e.key.ID desc, e.key.pkid desc");
    queries.put("482",
        "select distinct e.key, e.value from " + SEPARATOR
            + "exampleRegion.entrySet e order by e.key.ID, e.value.status desc");
    queries.put("483",
        "select distinct e.key.ID from " + SEPARATOR + "exampleRegion.entries e order by e.key.ID");
    queries.put("484",
        "select distinct e.key.ID, e.value.status from " + SEPARATOR
            + "exampleRegion.entries e order by e.key.ID");
    queries.put("485",
        "select distinct e.key.ID, e.value.status from " + SEPARATOR
            + "exampleRegion.entrySet e order by e.key.ID desc , e.value.status desc");
    queries.put("486",
        "select distinct getID, status from " + SEPARATOR
            + "exampleRegion pf where getID < 10 order by getID asc");
    queries.put("487",
        "select distinct getID, status from " + SEPARATOR
            + "exampleRegion pf where getID < 10 order by getID desc");
    queries.put("488",
        "select distinct iD, status from " + SEPARATOR + "exampleRegion order by iD");
    queries.put("489",
        "select distinct key from " + SEPARATOR
            + "exampleRegion.entrySet , value.positions.values   where value.ID = 1 and key = '1'");
    queries.put("490",
        "select distinct key.ID from " + SEPARATOR + "exampleRegion.keys key order by key.ID");
    queries.put("491",
        "select distinct key.ID, key.status from " + SEPARATOR
            + "exampleRegion.keys key order by key.status desc, key.ID");
    queries.put("492",
        "select distinct key.ID, key.status from " + SEPARATOR
            + "exampleRegion.keys key order by key.status, key.ID desc");
    queries.put("493",
        "select distinct key.ID, key.status from " + SEPARATOR
            + "exampleRegion.keys key order by key.status, key.ID");
    queries.put("494",
        "select distinct key.ID,key.status as st from " + SEPARATOR
            + "exampleRegion key where key.status = 'inactive' order by key.status desc, key.ID");
    queries.put("495",
        "select distinct nm from " + SEPARATOR + "exampleRegion prt,names nm where prt.ID>0");
    queries.put("496",
        "select distinct nvl(pf.position2, 'inProjection') from " + SEPARATOR
            + "exampleRegion pf where nvl(pf.position2, pf.position1).secId = 'SUN'");
    queries.put("497",
        "select distinct nvl(pf.position2, 'inProjection') from " + SEPARATOR
            + "exampleRegion pf where nvl(pf.position2,'foundNull') = 'foundNull'");
    queries.put("498", "select distinct p from " + SEPARATOR + "exampleRegion p where p.ID > 0");
    queries.put("499",
        "select distinct p, pos from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by p.ID");
    queries.put("500",
        "select distinct p.ID, pos.secId from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by pos.secId, p.ID");
    queries.put("501",
        "select distinct p.names[1] from " + SEPARATOR + "exampleRegion p order by p.names[1]");
    queries.put("502",
        "select distinct p.position1.secId as st from " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion p order by p.position1.secId");
    queries.put("504",
        "select distinct p.status as STATUS, SECID: p.P1.SecId, ID from " + SEPARATOR
            + "exampleRegion p ");
    queries.put("505",
        "select distinct p.status as st from " + SEPARATOR
            + "exampleRegion p where ID > 0 and status = 'inactive' order by p.status");
    queries.put("506",
        "select distinct p.status from " + SEPARATOR + "exampleRegion p order by p.status");
    queries.put("507",
        "select distinct p.status from " + SEPARATOR + "exampleRegion p where p.ID > 0");
    queries.put("508",
        "select distinct p.status, p.ID from " + SEPARATOR
            + "exampleRegion p order by p.status asc, p.ID");
    queries.put("509",
        "select distinct p.status, p.ID from " + SEPARATOR
            + "exampleRegion p order by p.status, p.ID");
    queries.put("510",
        "select distinct p.status,p.ID from " + SEPARATOR + "exampleRegion p where p.ID > 0");
    queries.put("511",
        "select distinct portfolio: p ,p.P1.SecId from " + SEPARATOR
            + "exampleRegion p where p.ID > 0 ");
    queries.put("512",
        "select distinct pos.secId from " + SEPARATOR
            + "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 "
            + SEPARATOR + "exampleRegion");
    queries.put("514",
        "select distinct prt from " + SEPARATOR
            + "exampleRegion prt, names where prt.names[3]='ddd'");
    queries.put("515",
        "select distinct status as st from " + SEPARATOR
            + "exampleRegion where ID > 0 order by status");
    queries.put("516",
        "select distinct status from " + SEPARATOR + "exampleRegion where ID > 0 order by status");
    queries.put("517",
        "select distinct status, getID from " + SEPARATOR
            + "exampleRegion pf where getID < 10 order by status asc, getID desc");
    queries.put("518",
        "select distinct status, ID from " + SEPARATOR + "exampleRegion order by status, ID");
    queries.put("519", "SELECT * FROM " + SEPARATOR + "exampleRegion WHERE \"type\" = 'type1'");
    queries.put("520", "select count(*) from " + SEPARATOR + "exampleRegion");
    queries.put("521",
        "SELECT * from " + SEPARATOR + "exampleRegion P1, P1.positions.values WHERE P1.ID = 5");
    queries.put("522", "SELECT * from " + SEPARATOR + "exampleRegion P1, " + SEPARATOR
        + "exampleRegion2 P2 WHERE P1.ID = 5");
    queries.put("523", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 = 50");
    queries.put("524", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 = 50.0");
    queries.put("525", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 = 50.0f");
    queries.put("526", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 = 50.0d");
    queries.put("527", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 > 50");
    queries.put("528", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 > 50.0");
    queries.put("529", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 > 50.0f");
    queries.put("530", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 > 50.0d");
    queries.put("531", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 < 50");
    queries.put("532", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 < 50.0");
    queries.put("533", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 < 50.0f");
    queries.put("534", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 < 50.0d");
    queries.put("535", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 <= 50");
    queries.put("536", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 <= 50.0");
    queries.put("537", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 <= 50.0f");
    queries.put("538", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 <= 50.0d");
    queries.put("539", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 >= 50");
    queries.put("540", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 >= 50.0");
    queries.put("541", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 >= 50.0f");
    queries.put("542", "SELECT * from " + SEPARATOR + "numericRegion n WHERE n.max1 >= 50.0d");
    queries.put("543",
        "select distinct * from " + SEPARATOR + "portfolios p where p.ID > -1 order by p.ID");
    queries.put("544",
        "select distinct * from " + SEPARATOR
            + "portfolios p where p.ID > -1 order by p.ID limit 100");
    queries.put("545", "select distinct * from " + SEPARATOR + "portfolios p where p.ID > -1");
    queries.put("546",
        "select distinct * from " + SEPARATOR + "portfolios p where p.ID > -1 limit 100");


    // NESTED QUERIES
    queries.put("701",
        "SELECT ID, status FROM " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion p where p.status = ELEMENT(SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion p2 WHERE p2.ID = 0).status");
    queries.put("703",
        "IMPORT org.apache.geode.cache.\"query\".data.Portfolio; SELECT * FROM " + SEPARATOR
            + "exampleRegion, (SELECT DISTINCT * from " + SEPARATOR
            + "exampleRegion p TYPE Portfolio, p.positions WHERE value!=null)");
    queries.put("704",
        "SELECT DISTINCT * FROM (SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion portfolios, positions pos) WHERE pos.value.secId = 'IBM'");
    queries.put("705",
        "SELECT * FROM " + SEPARATOR
            + "exampleRegion portfolio WHERE portfolio.ID IN (SELECT p2.ID  FROM " + SEPARATOR
            + "exampleRegion2 p2 where p2.ID > 1)");
    queries.put("706",
        "SELECT * FROM " + SEPARATOR + "root" + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf, (SELECT DISTINCT * FROM "
            + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf, (SELECT DISTINCT * FROM "
            + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion where NOT(SELECT DISTINCT * FROM "
            + SEPARATOR + "exampleRegion p where p.ID = 0).isEmpty");
    queries.put("710",
        "SELECT DISTINCT * FROM " + SEPARATOR + "root" + SEPARATOR
            + "exampleRegion p, (SELECT DISTINCT pos FROM " + SEPARATOR + "root" + SEPARATOR
            + "exampleRegion x, x.positions.values pos WHERE  x.ID = p.ID) as itrX");
    queries.put("711",
        "SELECT DISTINCT * FROM " + SEPARATOR + "root" + SEPARATOR
            + "exampleRegion p, p.positions.values outerPos, (SELECT DISTINCT key from " + SEPARATOR
            + "exampleRegion.keys key)");
    queries.put("712",
        "SELECT DISTINCT c.name, s.name, ct.name FROM " + SEPARATOR
            + "exampleRegion c, c.states s, (SELECT DISTINCT * FROM " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion c, c.states s, s.districts d, d.cities ct WHERE ct.name = element (SELECT DISTINCT ct.name FROM "
            + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion c1, c1.states s1, (SELECT DISTINCT * FROM " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion c1, c1.states s1, s1.districts d1, d1.cities ct1 WHERE ct1.name = element (SELECT DISTINCT ct3.name FROM "
            + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion pfos, pfos.positions.values outerPos, (SELECT DISTINCT key");
    queries.put("717",
        "Select distinct structset.sos, structset.key from " + SEPARATOR
            + "exampleRegion pfos, pfos.positions.values outerPos, "
            + "(SELECT DISTINCT key: key, sos: pos.sharesOutstanding from " + SEPARATOR
            + "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 "
            + SEPARATOR + "exampleRegion p , p.positions.values pos where p.status= 'active')");
    queries.put("719",
        "select distinct * from " + SEPARATOR
            + "exampleRegion p, (select distinct pos  as poos from " + SEPARATOR
            + "exampleRegion x, x.positions.values pos where pos.secId = 'YHOO') as k");
    queries.put("720",
        "select distinct * from " + SEPARATOR
            + "exampleRegion p, (select distinct pos as poos from " + SEPARATOR
            + "exampleRegion x, p.positions.values pos where x.ID = p.ID) as k");
    queries.put("721",
        "select distinct * from " + SEPARATOR
            + "exampleRegion p, (select distinct val from positions.values as val where val.secId = 'YHOO') as k");
    queries.put("722",
        "select distinct * from " + SEPARATOR
            + "exampleRegion p, (select distinct x as pf , myPos as poos from " + SEPARATOR
            + "exampleRegion x, x.positions.values as myPos) as k   where k.poos.secId = 'YHOO'");
    queries.put("723",
        "select distinct * from " + SEPARATOR
            + "exampleRegion p, (select distinct x.ID as ID  from " + SEPARATOR
            + "exampleRegion x where x.ID = p.ID) as k");

    // STRING OPERATIONS
    queries.put("800",
        "SELECT distinct *  FROM " + SEPARATOR + "exampleRegion ps WHERE ps.status like  '%'");
    queries.put("801",
        "SELECT distinct *  FROM " + SEPARATOR + "exampleRegion ps WHERE ps.status like  'a%bc%'");
    queries.put("802",
        "SELECT distinct *  FROM " + SEPARATOR
            + "exampleRegion ps WHERE ps.status like  'abc%' AND ps.ID > 2 AND ps.ID < 150");
    queries.put("803",
        "SELECT distinct *  FROM " + SEPARATOR
            + "exampleRegion ps WHERE ps.status like  'abc%' OR ps.ID > 6");
    queries.put("804",
        "SELECT distinct *  FROM " + SEPARATOR + "exampleRegion ps WHERE ps.status like  'abc%'");
    queries.put("805",
        "SELECT distinct *  FROM " + SEPARATOR + "exampleRegion ps WHERE ps.status like  'abcd'");
    queries.put("806", "SELECT distinct *  FROM " + SEPARATOR
        + "exampleRegion ps WHERE ps.status like  'abcd\\%'");
    queries.put("807", "SELECT distinct *  FROM " + SEPARATOR
        + "exampleRegion ps WHERE ps.status like  'abcd\\_'");
    queries.put("808",
        "SELECT distinct *  FROM " + SEPARATOR + "exampleRegion ps WHERE ps.status like 'a_bc'");
    queries.put("809",
        "SELECT distinct *  FROM " + SEPARATOR + "exampleRegion ps WHERE ps.status like 'abc_'");
    queries.put("810",
        "SELECT pkid FROM " + SEPARATOR
            + "exampleRegion ps WHERE ps.pkid like '%b%' and ps.pkid like '_bc'");
    queries.put("811",
        "SELECT pkid FROM " + SEPARATOR
            + "exampleRegion ps WHERE ps.pkid like '%b%' and ps.status = 'like'");
    queries.put("812",
        "SELECT pkid FROM " + SEPARATOR
            + "exampleRegion ps WHERE ps.pkid like '%b%' and ps.status like '%ike'");
    queries.put("813",
        "SELECT pkid FROM " + SEPARATOR + "exampleRegion ps WHERE ps.pkid like 'abc%'");
    queries.put("814",
        "SELECT pkid FROM " + SEPARATOR
            + "exampleRegion ps WHERE ps.pkid like 'ml%' or ps.status = 'like'");
    queries.put("815",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like '%%ti%'");
    queries.put("816", "select p from " + SEPARATOR + "exampleRegion.values p where p like '%'");
    queries.put("817",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like '%c%iv%'");
    queries.put("818",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like '%ctiv%'");
    queries.put("819",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like '%ctive'");
    queries.put("820",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like '1inact\\_+ive'");
    queries.put("821",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like '?act?ve'");
    queries.put("822", "select p from " + SEPARATOR + "exampleRegion.values p where p like 'X%X'");
    queries.put("823", "select p from " + SEPARATOR + "exampleRegion.values p where p like 'X__X'");
    queries.put("824",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'Y\\%Y'");
    queries.put("825",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'Z\\\\%Z'");
    queries.put("826",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like '^+act.ve+^'");
    queries.put("827",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like '__tive'");
    queries.put("828",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like '_c_iv_'");
    queries.put("829",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like '_ctiv%'");
    queries.put("830",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like '_ctive'");
    queries.put("831", "select p from " + SEPARATOR + "exampleRegion.values p where p like 'a%e'");
    queries.put("832",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'a%iv_'");
    queries.put("833",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'a_tiv%'");
    queries.put("834", "select p from " + SEPARATOR + "exampleRegion.values p where p like 'ac%'");
    queries.put("835",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'ac(tiv)e'");
    queries.put("836",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'ac+t+ve'");
    queries.put("837",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'ac\\%'");
    queries.put("838",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'ac\\tive'");
    queries.put("839",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'ac_ive'");
    queries.put("840",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'ac_tive'");
    queries.put("841",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'act%%ve'");
    queries.put("842",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'act()ive'");
    queries.put("843",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'act)ve^'");
    queries.put("844",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'act**ve'");
    queries.put("845",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'act*+|ve'");
    queries.put("846",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'act/exampleRegion'");
    queries.put("847",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'act[]ve'");
    queries.put("848",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'act][ve'");
    queries.put("849",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'act^[a-z]ve'");
    queries.put("850",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'act__e'");
    queries.put("851",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'activ_'");
    queries.put("852",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'active'");
    queries.put("853",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'acxtxve'");
    queries.put("854",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'inact\\%+ive'");
    queries.put("855",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like 'inactive'");
    queries.put("856",
        "select p from " + SEPARATOR + "exampleRegion.values p where p like '|+act(ve'");
    queries.put("857",
        "SELECT  *  FROM " + SEPARATOR
            + "exampleRegion ps WHERE ps.status like '%b%' and ps.pkid = '1'");
    queries.put("858", "SELECT  *  FROM " + SEPARATOR
        + "exampleRegion ps WHERE ps.status like '%b%' or ps.ID > 0");
    queries.put("859",
        "SELECT  *  FROM " + SEPARATOR
            + "exampleRegion ps WHERE ps.status like '%b%' or ps.pkid = '2'");
    queries.put("860",
        "SELECT  *  FROM " + SEPARATOR + "exampleRegion ps WHERE ps.status like '%b%'");
    queries.put("861",
        "SELECT  *  FROM " + SEPARATOR
            + "exampleRegion ps WHERE ps.status like '_b_' or ps.pkid = '2'");
    queries.put("862",
        "SELECT * FROM " + SEPARATOR
            + "exampleRegion ps WHERE ps.pkid like '%b%' and ps.status like '%ctiv%'");
    queries.put("863", "SELECT * FROM " + SEPARATOR + "exampleRegion ps WHERE ps.pkid like '_bc'");
    queries.put("864",
        "SELECT distinct *  FROM " + SEPARATOR + "exampleRegion ps WHERE ps.pkid like '%b%'");

    // LIMIT
    queries.put("900",
        "SELECT DISTINCT  key.ID, key.status as st from " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion p order by p.position1.secId, p.ID LIMIT 1");
    queries.put("906",
        "SELECT DISTINCT  p.position1.secId , p.ID as st from " + SEPARATOR
            + "exampleRegion p order by p.position1.secId, p.ID LIMIT 9");
    queries.put("907",
        "SELECT DISTINCT * from " + SEPARATOR + "exampleRegion p order by p.getID() LIMIT 9");
    queries.put("908",
        "SELECT DISTINCT * from " + SEPARATOR
            + "exampleRegion p, p.positions.values val order by p.ID, val.secId LIMIT 1");
    queries.put("909",
        "SELECT DISTINCT * from " + SEPARATOR
            + "exampleRegion p, p.positions.values val order by p.ID, val.secId LIMIT 9");
    queries.put("910",
        "SELECT DISTINCT e.key from " + SEPARATOR
            + "exampleRegion.entrySet e order by e.key.ID, e.key.pkid desc LIMIT 1");
    queries.put("911",
        "SELECT DISTINCT e.key from " + SEPARATOR
            + "exampleRegion.entrySet e order by e.key.ID, e.key.pkid desc LIMIT 4");
    queries.put("912",
        "SELECT DISTINCT e.key from " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion.entrySet e order by e.key.ID, e.value.status desc LIMIT 9");
    queries.put("916",
        "SELECT DISTINCT iD, status from " + SEPARATOR + "exampleRegion order by iD LIMIT 1");
    queries.put("917",
        "SELECT DISTINCT iD, status from " + SEPARATOR + "exampleRegion order by iD LIMIT 4");
    queries.put("918",
        "SELECT DISTINCT iD, status from " + SEPARATOR + "exampleRegion order by iD LIMIT 9");
    queries.put("919",
        "SELECT DISTINCT iD, status from " + SEPARATOR + "exampleRegion order by iD");
    queries.put("920",
        "SELECT DISTINCT key from " + SEPARATOR
            + "exampleRegion.keys key order by key.status, key.ID LIMIT 1");
    queries.put("921",
        "SELECT DISTINCT key from " + SEPARATOR
            + "exampleRegion.keys key order by key.status, key.ID LIMIT 4");
    queries.put("922",
        "SELECT DISTINCT key from " + SEPARATOR
            + "exampleRegion.keys key order by key.status, key.ID LIMIT 9");
    queries.put("923",
        "SELECT DISTINCT key.ID from " + SEPARATOR
            + "exampleRegion.keys key order by key.ID LIMIT 1");
    queries.put("924",
        "SELECT DISTINCT key.ID from " + SEPARATOR
            + "exampleRegion.keys key order by key.ID LIMIT 4");
    queries.put("925",
        "SELECT DISTINCT key.ID from " + SEPARATOR
            + "exampleRegion.keys key order by key.ID LIMIT 9");
    queries.put("926",
        "SELECT DISTINCT key.ID, key.status from " + SEPARATOR
            + "exampleRegion.keys key order by key.status desc, key.ID LIMIT 9");
    queries.put("927",
        "SELECT DISTINCT key.ID, key.status from " + SEPARATOR
            + "exampleRegion.keys key order by key.status, key.ID asc LIMIT 1");
    queries.put("928",
        "SELECT DISTINCT key.ID, key.status from " + SEPARATOR
            + "exampleRegion.keys key order by key.status, key.ID asc LIMIT 4");
    queries.put("929",
        "SELECT DISTINCT key.ID, key.status from " + SEPARATOR
            + "exampleRegion.keys key order by key.status, key.ID asc LIMIT 9");
    queries.put("930",
        "SELECT DISTINCT p, pos from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by p.ID, pos.secId desc LIMIT 1");
    queries.put("931",
        "SELECT DISTINCT p, pos from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by p.ID, pos.secId desc LIMIT 4");
    queries.put("932",
        "SELECT DISTINCT p, pos from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by p.ID, pos.secId desc LIMIT 9");
    queries.put("933",
        "SELECT DISTINCT p, pos from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by pos.secId, p.ID LIMIT 1");
    queries.put("934",
        "SELECT DISTINCT p, pos from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by pos.secId, p.ID LIMIT 4");
    queries.put("935",
        "SELECT DISTINCT p, pos from " + SEPARATOR
            + "exampleRegion p, p.positions.values pos order by pos.secId, p.ID LIMIT 9");
    queries.put("936",
        "SELECT DISTINCT p.ID, p.status from " + SEPARATOR
            + "exampleRegion p order by p.ID LIMIT 9");
    queries.put("937",
        "SELECT DISTINCT p.position1.secId as st, p.ID as ied from " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion p order by p.position1.secId, p.ID desc LIMIT 1");
    queries.put("941",
        "SELECT DISTINCT p.position1.secId, p.ID from " + SEPARATOR
            + "exampleRegion p order by p.position1.secId, p.ID desc LIMIT 4");
    queries.put("942",
        "SELECT DISTINCT p.position1.secId, p.ID from " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion p order by p.status LIMIT 9");
    queries.put("947",
        "SELECT DISTINCT p.status, p.ID from " + SEPARATOR
            + "exampleRegion p order by p.status asc, p.ID LIMIT 1");
    queries.put("948",
        "SELECT DISTINCT p.status, p.ID from " + SEPARATOR
            + "exampleRegion p order by p.status asc, p.ID LIMIT 4");
    queries.put("949",
        "SELECT DISTINCT p.status, p.ID from " + SEPARATOR
            + "exampleRegion p order by p.status asc, p.ID LIMIT 9");
    queries.put("950",
        "SELECT DISTINCT pf.ID , pf.createTime FROM " + SEPARATOR
            + "exampleRegion  pf WHERE pf.ID > 10 limit 5");
    queries.put("951",
        "SELECT DISTINCT pf.ID FROM " + SEPARATOR + "exampleRegion  pf WHERE pf.ID > 10 limit 5");
    queries.put("952",
        "SELECT DISTINCT pf.ID FROM " + SEPARATOR + "exampleRegion pf WHERE pf.ID > 0 limit 5");
    queries.put("953",
        "SELECT DISTINCT pf.ID, pf.createTime FROM " + SEPARATOR
            + "exampleRegion pf WHERE pf.ID > 0 limit 5");
    queries.put("954",
        "SELECT DISTINCT status , ID as ied from " + SEPARATOR
            + "exampleRegion where ID > 0 order by status, ID desc LIMIT 1");
    queries.put("955",
        "SELECT DISTINCT status , ID as ied from " + SEPARATOR
            + "exampleRegion where ID > 0 order by status, ID desc LIMIT 4");
    queries.put("956",
        "SELECT DISTINCT status , ID as ied from " + SEPARATOR
            + "exampleRegion where ID > 0 order by status, ID desc LIMIT 9");
    queries.put("957",
        "SELECT DISTINCT status as st from " + SEPARATOR + "exampleRegion order by status LIMIT 1");
    queries.put("958",
        "SELECT DISTINCT status as st from " + SEPARATOR + "exampleRegion order by status LIMIT 4");
    queries.put("959",
        "SELECT DISTINCT status as st from " + SEPARATOR + "exampleRegion order by status LIMIT 9");
    queries.put("960", "SELECT * FROM " + SEPARATOR + "exampleRegion p WHERE p.ID > 0 LIMIT 2");
    queries.put("961", "select * from " + SEPARATOR + "exampleRegion this where ID > 2 limit 100");

    // FUNCTIONS
    queries.put("1000",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where IS_DEFINED(P2.secId)");
    queries.put("1001",
        "SELECT DISTINCT * FROM " + SEPARATOR + "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 " + SEPARATOR
            + "exampleRegion value  where value.length > 6)");
    queries.put("1036",
        "ELEMENT(SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where ID <= 1).status");
    queries.put("1037",
        "ELEMENT(SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion where ID =1).status");
    queries.put("1038",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where status = ELEMENT(SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion p where ID = 0).status");
    queries.put("1039",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion where status = ELEMENT(SELECT DISTINCT * FROM " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion portfolio1, " + SEPARATOR
            + "exampleRegion2 portfolio2 WHERE portfolio1.status = portfolio2.status");
    queries.put("1101",
        "SELECT portfolio1.ID, portfolio2.status FROM " + SEPARATOR + "exampleRegion portfolio1, "
            + SEPARATOR + "exampleRegion2 portfolio2");
    queries.put("1102",
        "SELECT * FROM " + SEPARATOR
            + "exampleRegion portfolio1, portfolio1.positions.values positions1, " + SEPARATOR
            + "exampleRegion2 portfolio2,");
    queries.put("1103",
        "SELECT * FROM " + SEPARATOR
            + "exampleRegion portfolio1, portfolio1.positions.values positions1, " + SEPARATOR
            + "exampleRegion2 portfolio2,");
    queries.put("1104",
        "SELECT * FROM (SELECT * FROM " + SEPARATOR + "exampleRegion2 m) r2, (SELECT * FROM "
            + SEPARATOR + "exampleRegion e WHERE e.pkid IN  r2.sp) p");
    queries.put("1105",
        "SELECT * FROM (SELECT * FROM " + SEPARATOR
            + "exampleRegion2 m WHERE m.ID IN SET (1, 5, 10)) r2, (SELECT * FROM " + SEPARATOR
            + "exampleRegion e WHERE e.pkid IN  r2.sp) p");
    queries.put("1106",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "exampleRegion2 c2 WHERE c1.name = 'INDIA' AND c2.name = 'ISRAEL'");
    queries.put("1107",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion c1, c1.states s1, s1.districts d1, "
            + SEPARATOR + "exampleRegion2 c2, c2.states s2, s2.districts d2, " + SEPARATOR
            + "exampleRegion2 c3, c3.states s3, s3.districts d3 WHERE d3.name = 'PUNEDIST' AND s2.name = 'GUJARAT'");
    queries.put("1109",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion c1, c1.states s1, s1.districts d1, d1.cities ct1, d1.villages v1, "
            + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion c1, c1.states s1, s1.districts d1, d1.villages v1, d1.cities ct1, "
            + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion e WHERE pf1.status = 'active'");
    queries.put("1112",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR
            + "exampleRegion e1 WHERE pf1.status = 'active' AND e1.empId < 10");
    queries.put("1113",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR
            + "exampleRegion e1 WHERE pf1.status = 'active' AND pf2.status = 'active' AND e1.empId < 10");
    queries.put("1114",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, pf1.positions.values posit1, pf2.positions.values posit2 WHERE posit1.secId='IBM' AND posit2.secId='IBM'");
    queries.put("1115",
        "SELECT DISTINCT * FROM " + SEPARATOR
            + "exampleRegion pf1, pf1.collectionHolderMap.values coll1, pf1.positions.values posit1, "
            + SEPARATOR
            + "exampleRegion2 pf2, pf2.collectionHolderMap.values coll2, pf2.positions.values posit2  WHERE posit1.secId='IBM' AND posit2.secId='IBM'");
    queries.put("1116",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion pf1, pf1.positions.values posit1, "
            + SEPARATOR + "exampleRegion2 pf2, " + SEPARATOR
            + "exampleRegion e WHERE posit1.secId='IBM'");
    queries.put("1117",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion pf1, pf1.positions.values posit1, "
            + SEPARATOR
            + "exampleRegion2 pf2, pf2.positions.values posit2 WHERE pf2.status='active' AND posit1.secId='IBM'");
    queries.put("1118",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion pf1," + SEPARATOR
            + "exampleRegion2 pf2, pf1.positions.values posit1, pf2.positions.values posit2 WHERE posit1.secId='IBM' OR posit2.secId='IBM'");
    queries.put("1119",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion pf1," + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion2,  positions.values where status='active'");
    queries.put("1121",
        "SELECT DISTINCT * FROM " + SEPARATOR + "root" + SEPARATOR + "exampleRegion p, " + SEPARATOR
            + "root" + SEPARATOR + "exampleRegion2 p2 WHERE  p.status = 'active'");
    queries.put("1122",
        "SELECT DISTINCT c1.name, s1.name, d2.name, ct2.name FROM " + SEPARATOR
            + "exampleRegion c1, c1.states s1, s1.districts d1, d1.cities ct1, " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion c1, c1.states s1, s1.districts d1, d1.cities ct1," + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion pf1, " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion pf1, " + SEPARATOR
            + "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 " + SEPARATOR + "root" + SEPARATOR + "exampleRegion p, "
            + SEPARATOR + "root" + SEPARATOR
            + "exampleRegion2 p2 WHERE  p.ID = p2.ID and p.ID > 100 and p2.ID < 1");
    queries.put("1127",
        "SELECT p.ID FROM " + SEPARATOR + "root" + SEPARATOR + "exampleRegion p, " + SEPARATOR
            + "root" + SEPARATOR
            + "exampleRegion2 p2 WHERE  p.ID = p2.ID and p.status = 'active' and p2.status = 'active'");
    queries.put("1128",
        "Select distinct * from " + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists, dists.cities ct1, dists.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR
            + "exampleRegion3 c3 where c1.name = c2.name and ct1.name != 'PUNE' and villgs1.name = 'MAHARASHTRA_VILLAGE1'");
    queries.put("1129",
        "Select distinct * from " + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists, dists.cities ct1, dists.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR + "exampleRegion3 c3, " + SEPARATOR
            + "exampleRegion3 pfo3 where c1.name = c2.name or ct1.name != 'PUNE' or villgs1.name = 'MAHARASHTRA_VILLAGE1'");
    queries.put("1130",
        "Select distinct * from " + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, c2.states s2, " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, c2.states s2, " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, c2.states s2, " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, c2.states s2, " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, c2.states s2, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf, " + SEPARATOR
            + "exampleRegion2, " + SEPARATOR + "exampleRegion3, " + SEPARATOR
            + "exampleRegion where pf.status='active'");
    queries.put("1136",
        "Select distinct * from " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR + "exampleRegion c1, " + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR
            + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR + "exampleRegion c1, " + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR
            + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR + "exampleRegion c1, " + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR
            + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR + "exampleRegion c1, " + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR
            + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR + "exampleRegion c1, " + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR
            + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR + "exampleRegion c1, c1.states s1, " + SEPARATOR
            + "exampleRegion2 c2, c2.states s2, " + SEPARATOR + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion, " + SEPARATOR + "exampleRegion2");
    queries.put("1146",
        "Select distinct * from " + SEPARATOR + "exampleRegion, " + SEPARATOR + "exampleRegion2, "
            + SEPARATOR + "exampleRegion3, " + SEPARATOR + "exampleRegion");
    queries.put("1147",
        "select distinct * from " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and false");
    queries.put("1153",
        "select distinct * from " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and true");
    queries.put("1159",
        "select distinct * from " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name");
    queries.put("1160",
        "select distinct * from " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, " + SEPARATOR
            + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "exampleRegion2 c2 where pf1.status = pf2.status or false or c1.name = c2.name");
    queries.put("1165",
        "select distinct * from " + SEPARATOR + "exampleRegion pf1, pf1.positions.values pos1, "
            + SEPARATOR + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, pf1.positions.values pos1, "
            + SEPARATOR + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, pf1.positions.values pos1, "
            + SEPARATOR + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, pf1.positions.values pos1, "
            + SEPARATOR + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, pf1.positions.values pos1, "
            + SEPARATOR + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, pf1.positions.values pos1, "
            + SEPARATOR + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "exampleRegion2 c2 where pf1.status = pf2.status and c1.name = c2.name or pos1.secId = 'IBM'");
    queries.put("1171",
        "select distinct * from " + SEPARATOR + "exampleRegion pf1, pf1.positions.values pos1, "
            + SEPARATOR + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, pf1.positions.values pos1, "
            + SEPARATOR + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf1, pf1.positions.values pos1, "
            + SEPARATOR + "exampleRegion2 pf2, " + SEPARATOR + "exampleRegion c1, " + SEPARATOR
            + "exampleRegion2 c2 where pf1.status = pf2.status or c1.name = c2.name and pos1.secId = 'IBM' and true");
    queries.put("1174", "select distinct * from " + SEPARATOR + "root" + SEPARATOR
        + "exampleRegion, " + SEPARATOR + "root" + SEPARATOR + "exampleRegion2");
    queries.put("1175",
        "select distinct a, b.price from " + SEPARATOR + "root" + SEPARATOR + "exampleRegion a, "
            + SEPARATOR + "root" + SEPARATOR
            + "exampleRegion2 b where a.price = b.price and a.price = 50");
    queries.put("1176",
        "select distinct a, b.price from " + SEPARATOR + "root" + SEPARATOR + "exampleRegion a, "
            + SEPARATOR + "root" + SEPARATOR + "exampleRegion2 b where a.price = b.price");
    queries.put("1177",
        "SELECT DISTINCT * FROM " + SEPARATOR + "exampleRegion pf, pf.positions pos, " + SEPARATOR
            + "exampleRegion3 pf3, " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists, dists.cities ct1, dists.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR
            + "exampleRegion3 c3 where c1.name = c2.name and ct1.name != 'PUNE' and villgs1.name = 'MAHARASHTRA_VILLAGE1'");
    queries.put("1179",
        "Select distinct * from " + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists, dists.cities ct1, dists.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR + "exampleRegion3 c3, " + SEPARATOR
            + "exampleRegion3 pfo3 where c1.name = c2.name or ct1.name != 'PUNE' or villgs1.name = 'MAHARASHTRA_VILLAGE1'");
    queries.put("1180",
        "Select distinct * from " + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, c2.states s2, " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, c2.states s2, " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, c2.states s2, " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, c2.states s2, " + SEPARATOR
            + "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 " + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, c2.states s2, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pf, " + SEPARATOR
            + "exampleRegion2, " + SEPARATOR + "exampleRegion3, " + SEPARATOR
            + "exampleRegion where pf.status='active'");
    queries.put("1186",
        "Select distinct * from " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR + "exampleRegion c1, " + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR
            + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR + "exampleRegion c1, " + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR
            + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR + "exampleRegion c1, " + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR
            + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR + "exampleRegion c1, " + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR
            + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR + "exampleRegion c1, " + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR
            + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR + "exampleRegion c1, c1.states s1, " + SEPARATOR
            + "exampleRegion2 c2, c2.states s2, " + SEPARATOR + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion pfos, pfos.positions.values Pos1, "
            + SEPARATOR
            + "exampleRegion c1, c1.states sts1, sts1.districts dists1, dists1.cities ct1, dists1.villages villgs1, "
            + SEPARATOR + "exampleRegion2 c2, " + SEPARATOR + "exampleRegion3 c3, " + SEPARATOR
            + "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 " + SEPARATOR + "exampleRegion, " + SEPARATOR + "exampleRegion2, "
            + SEPARATOR + "exampleRegion3, " + SEPARATOR + "exampleRegion");
    queries.put("1196", "Select distinct * from " + SEPARATOR + "exampleRegion3 pf, pf.positions");
    queries.put("1197",
        "Select distinct * from " + SEPARATOR + "exampleRegion3, " + SEPARATOR + "exampleRegion");
    queries.put("1198",
        "select distinct * from " + SEPARATOR + "root" + SEPARATOR + "exampleRegion3");


    // Queries used for Equi-join tests
    queries.put("1199", "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR
        + "region2 r2 where r1.ID = r2.id");
    queries.put("1200",
        "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR
            + "region2 r2 where r1.ID = r2.id AND r1.ID > 5");
    queries.put("1201",
        "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR
            + "region2 r2 where r1.ID = r2.id AND r1.status = 'active'");
    queries.put("1202",
        "select distinct * from " + SEPARATOR + "region1 r1, " + SEPARATOR
            + "region2 r2 where r1.ID = r2.id ORDER BY r1.ID");
    queries.put("1203",
        "select distinct * from " + SEPARATOR + "region1 r1, " + SEPARATOR
            + "region2 r2 where r1.ID = r2.id ORDER BY r2.id");
    queries.put("1204",
        "select distinct * from " + SEPARATOR + "region1 r1, " + SEPARATOR + "region2 r2 where "
            + "r1.ID = r2.id ORDER BY r2.status");
    queries.put("1205",
        "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR + "region2 r2 where "
            + "r1.ID = r2.id AND r1.status != r2.status");
    queries.put("1206",
        "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR
            + "region2 r2 where r1.ID = r2.id AND r1.status = r2.status");
    queries.put("1207",
        "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR + "region2 r2 where "
            + "r1.ID = r2.id AND r1.positions.size = r2.positions.size");
    queries.put("1208",
        "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR + "region2 r2 where "
            + "r1.ID = r2.id AND r1.positions.size > r2.positions.size");
    queries.put("1209",
        "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR + "region2 r2 where "
            + "r1.ID = r2.id AND r1.positions.size < r2.positions.size");
    queries.put("1210",
        "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR + "region2 r2 where "
            + "r1.ID = r2.id AND r1.positions.size = r2.positions.size AND r2.positions.size > 0");
    queries.put("1211",
        "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR + "region2 r2 where "
            + "r1.ID = r2.id AND (r1.positions.size > r2.positions.size OR r2.positions.size > 0)");
    queries.put("1212",
        "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR + "region2 r2 where "
            + "r1.ID = r2.id AND (r1.positions.size < r2.positions.size OR r1.positions.size > 0)");

    queries.put("1199", "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR
        + "region2 r2, r2.positions.values pos2 where "
        + "r1.ID = pos2.id");
    queries.put("1200", "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR
        + "region2 r2, r2.positions.values pos2 where "
        + "r1.ID = pos2.id AND r1.ID > 5");
    queries.put("1201", "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR
        + "region2 r2, r2.positions.values pos2 where "
        + "r1.ID = pos2.id AND r1.status = 'active'");
    queries.put("1202",
        "select distinct * from " + SEPARATOR + "region1 r1, " + SEPARATOR
            + "region2 r2, r2.positions.values pos2 where "
            + "r1.ID = pos2.id ORDER BY r1.ID");
    queries.put("1203",
        "select distinct * from " + SEPARATOR + "region1 r1, " + SEPARATOR
            + "region2 r2, r2.positions.values pos2 where "
            + "r1.ID = pos2.id ORDER BY pos2.id");
    queries.put("1204",
        "select distinct * from " + SEPARATOR + "region1 r1, " + SEPARATOR
            + "region2 r2, r2.positions.values pos2 where "
            + "r1.ID = pos2.id ORDER BY r2.status");
    queries.put("1205", "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR
        + "region2 r2, r2.positions.values pos2 where "
        + "r1.ID = pos2.id AND r1.status != r2.status");
    queries.put("1206", "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR
        + "region2 r2, r2.positions.values pos2 where "
        + "r1.ID = pos2.id AND r1.status = r2.status");
    queries.put("1207", "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR
        + "region2 r2, r2.positions.values pos2 where "
        + "r1.ID = pos2.id AND r1.positions.size = r2.positions.size");
    queries.put("1208", "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR
        + "region2 r2, r2.positions.values pos2 where "
        + "r1.ID = pos2.id AND r1.positions.size > r2.positions.size");
    queries.put("1209", "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR
        + "region2 r2, r2.positions.values pos2 where "
        + "r1.ID = pos2.id AND r1.positions.size < r2.positions.size");
    queries.put("1210", "select * from " + SEPARATOR + "region1 r1, " + SEPARATOR
        + "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 " + SEPARATOR + "region1 r1, " + SEPARATOR
        + "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 " + SEPARATOR + "region1 r1, " + SEPARATOR
        + "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;

      @Override
      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;

      @Override
      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;

      @Override
      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") {
      @Override
      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") {
      @Override
      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;

      @Override
      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;

      @Override
      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;

      @Override
      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
   *
   * @throws Exception if an exception is encountered during query execution
   */
  public Object[] executeQueries(String[] qarr) throws Exception {
    QueryService qs = cache.getQueryService();
    Object[] result = new Object[qarr.length];
    String query = null;
    int j = 0;
    for (final String s : qarr) {
      query = queries.get(s);
      result[j++] = qs.newQuery(query).execute();
    }
    return result;
  }

  /*
   * Execute queries by removing any DISTINCT clause if present
   */
  public void executeQueriesWithoutDistinct(VM vm, final String[] qarr) {
    vm.invoke(new CacheSerializableRunnable("Executing query without distinct") {
      @Override
      public void run2() {
        executeQueriesWithoutDistinct(qarr);
      }
    });
  }

  /*
   * Execute queries by removing any DISTINCT clause if present
   */
  public Object[] executeQueriesWithoutDistinct(String[] qarr) {
    QueryService qs = cache.getQueryService();
    Object[] result = new Object[qarr.length];
    String query = null;
    int j = 0;
    for (final String s : qarr) {
      query = queries.get(s);
      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
   */
  public void executeQueriesWithDistinct(VM vm, final String[] qarr) {
    vm.invoke(new CacheSerializableRunnable("Executing query with distinct") {
      @Override
      public void run2() {
        executeQueriesWithDistinct(qarr);
      }
    });
  }

  /*
   * Execute queries by adding a DISTINCT clause if not present
   */
  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(SEPARATOR + 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);
    });
  }
}
