@@ -0,0 +1,1184 @@
+package com.orientechnologies.orient.core.sql.executor;%0A%0Aimport com.orientechnologies.orient.core.db.document.ODatabaseDocument;%0Aimport com.orientechnologies.orient.core.db.document.ODatabaseDocumentTx;%0Aimport com.orientechnologies.orient.core.metadata.schema.OSchema;%0Aimport com.orientechnologies.orient.core.metadata.schema.OView;%0Aimport org.junit.AfterClass;%0Aimport org.junit.Assert;%0Aimport org.junit.BeforeClass;%0Aimport org.junit.Test;%0A%0A/**%0A * @author Luigi Dell'Aquila (l.dellaquila-(at)-orientdb.com)%0A */%0Apublic class OCreateViewStatementExecutionTest %7B%0A  static ODatabaseDocument db;%0A%0A  @BeforeClass%0A  public static void beforeClass() %7B%0A    db = new ODatabaseDocumentTx(%22memory:OCreateViewStatementExecutionTest%22);%0A    db.create();%0A  %7D%0A%0A  @AfterClass%0A  public static void afterClass() %7B%0A    db.close();%0A  %7D%0A%0A  @Test%0A  public void testPlain() %7B%0A    String className = %22testPlain%22;%0A    OResultSet result = db.command(%22create view %22 + className + %22  FROM (SELECT FROM V)%22);%0A    OSchema schema = db.getMetadata().getSchema();%0A    OView view = schema.getView(className);%0A    Assert.assertNotNull(view);%0A    Assert.assertEquals(className, view.getName());%0A    result.close();%0A  %7D%0A%0A%7D%0A

add test case for SQL CREATE VIEW