package com.orientechnologies.orient.core.sql.parser;

import com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx;
import com.orientechnologies.orient.core.metadata.schema.OClass;
import com.orientechnologies.orient.core.metadata.schema.OProperty;
import com.orientechnologies.orient.core.metadata.schema.OType;
import org.junit.Assert;
import org.junit.Test;

public class OExecutionPlanCacheTest {

  @Test
  public void testCacheInvalidation1() throws InterruptedException {
    String testName = "testCacheInvalidation1";
    ODatabaseDocumentTx db = new ODatabaseDocumentTx("memory:OExecutionPlanCacheTest");
    db.create();
    OExecutionPlanCache cache = OExecutionPlanCache.instance(db);
    String stm = "SELECT FROM OUser";

    //schema changes
    db.query(stm).close();
    cache = OExecutionPlanCache.instance(db);
    Assert.assertTrue(cache.contains(stm));

    OClass clazz = db.getMetadata().getSchema().createClass(testName);
    Assert.assertFalse(cache.contains(stm));

    /*
     * the cache has a mechanism that guarantees that if you are doing execution planning
     * and the cache is invalidated in the meantime, the newly generated execution plan
     * is not cached. This mechanism relies on a System.currentTimeMillis(), so it can happen
     * that the execution planning is done right after the cache invalidation, but still in THE SAME
     * millisecond, this Thread.sleep() guarantees that the new execution plan is generated
     * at least one ms after last invalidation, so it is cached.
     */
    Thread.sleep(1);

    //schema changes 2
    db.query(stm).close();
    cache = OExecutionPlanCache.instance(db);
    Assert.assertTrue(cache.contains(stm));

    OProperty prop = clazz.createProperty("name", OType.STRING);
    Assert.assertFalse(cache.contains(stm));

    Thread.sleep(1);

    //index changes
    db.query(stm).close();
    cache = OExecutionPlanCache.instance(db);
    Assert.assertTrue(cache.contains(stm));

    prop.createIndex(OClass.INDEX_TYPE.NOTUNIQUE);
    Assert.assertFalse(cache.contains(stm));

    db.close();

  }

}

package com.orientechnologies.orient.core.sql.parser;

import com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx;
import com.orientechnologies.orient.core.metadata.schema.OClass;
import com.orientechnologies.orient.core.metadata.schema.OProperty;
import com.orientechnologies.orient.core.metadata.schema.OType;
import org.junit.Assert;
import org.junit.Test;

public class OExecutionPlanCacheTest {

  @Test
  public void testCacheInvalidation1() throws InterruptedException {
    String testName = "testCacheInvalidation1";
    ODatabaseDocumentTx db = new ODatabaseDocumentTx("memory:OExecutionPlanCacheTest");
    db.create();
    OExecutionPlanCache cache = OExecutionPlanCache.instance(db);
    String stm = "SELECT FROM OUser";

    /*
     * the cache has a mechanism that guarantees that if you are doing execution planning
     * and the cache is invalidated in the meantime, the newly generated execution plan
     * is not cached. This mechanism relies on a System.currentTimeMillis(), so it can happen
     * that the execution planning is done right after the cache invalidation, but still in THE SAME
     * millisecond, this Thread.sleep() guarantees that the new execution plan is generated
     * at least one ms after last invalidation, so it is cached.
     */
    Thread.sleep(2);

    //schema changes
    db.query(stm).close();
    cache = OExecutionPlanCache.instance(db);
    Assert.assertTrue(cache.contains(stm));

    OClass clazz = db.getMetadata().getSchema().createClass(testName);
    Assert.assertFalse(cache.contains(stm));

    Thread.sleep(2);

    //schema changes 2
    db.query(stm).close();
    cache = OExecutionPlanCache.instance(db);
    Assert.assertTrue(cache.contains(stm));

    OProperty prop = clazz.createProperty("name", OType.STRING);
    Assert.assertFalse(cache.contains(stm));

    Thread.sleep(2);

    //index changes
    db.query(stm).close();
    cache = OExecutionPlanCache.instance(db);
    Assert.assertTrue(cache.contains(stm));

    prop.createIndex(OClass.INDEX_TYPE.NOTUNIQUE);
    Assert.assertFalse(cache.contains(stm));

    db.close();

  }

}

fix test case on query cache implementation