kvm-bintar-centos5-amd64

390f2a01

funcs_1.memory_views                     w4 [ fail ]  timeout after 900 seconds

        Test ended at 2016-11-16 14:08:47

Test case timeout after 900 seconds

== /usr/local/mariadb-10.0.29-linux-x86_64/mysql-test/var/4/log/memory_views.log == 

DELETE FROM v1;

ERROR HY000: The target table v1 of the DELETE is not updatable

DROP VIEW v1;

CREATE VIEW v1 AS SELECT SUM(f59) AS f61 FROM t1;

INSERT INTO v1 VALUES (1002);

ERROR HY000: The target table v1 of the INSERT is not insertable-into

UPDATE v1 SET f61=1007;

ERROR HY000: The target table v1 of the UPDATE is not updatable

DELETE FROM v1;

ERROR HY000: The target table v1 of the DELETE is not updatable

DROP VIEW v1;

CREATE VIEW v1 AS SELECT DISTINCTROW(f61) FROM t1;

INSERT INTO v1 VALUES (1002);

ERROR HY000: The target table v1 of the INSERT is not insertable-into

UPDATE v1 SET f61=1007;

ERROR HY000: The target table v1 of the UPDATE is not updatable

DELETE FROM v1;

ERROR HY000: The target table v1 of the DELETE is not updatable

DROP VIEW v1;

CREATE VIEW v1 AS SELECT DISTINCT(f61)   FROM t1;