question: private void testViewAlterAndCommandCache ( ) throws SQLException { deleteDb ( "view" ) ; Connection conn = getConnection ( "view" ) ; Statement stat = conn . createStatement ( ) ; stat . execute ( "create table t0(id int primary key)" ) ; stat . execute ( "create table t1(id int primary key)" ) ; stat . execute ( "insert into t0 values(0)" ) ; stat . execute ( "insert into t1 values(1)" ) ; stat . execute ( "create view v1 as select * from t0" ) ; ResultSet rs = stat . executeQuery ( "select * from v1" ) ; assertTrue ( rs . next ( ) ) ; assertEquals ( 0 , rs . getInt ( 1 ) ) ; stat . execute ( "create or replace view v1 as select * from t1" ) ; rs = stat . executeQuery ( "select * from v1" ) ; assertTrue ( rs . next ( ) ) ; assertEquals ( 1 , rs . getInt ( 1 ) ) ; conn . close ( ) ; deleteDb ( "view" ) ; }
target:  Make sure that when we change a view, that change in reflected in other sessions command cache.