--disable_abort_on_error --disable_warnings drop table if exists t1 ; drop view if exists v1 ; --enable_warnings # let $engine= innodb; eval CREATE TABLE t1 (f1 CHAR) ENGINE = $engine; INSERT INTO t1 VALUES ('A'); SELECT * FROM t1; CREATE VIEW v1 AS SELECT * FROM t1; --enable_info INSERT INTO t1 VALUES('B'); --disable_info SELECT * FROM v1; SELECT * from t1; sleep 3; SELECT * FROM v1;