Comment 2 for bug 794038

Revision history for this message
Igor Babaev (igorb-seattle) wrote :

Similar problems can be observed for DELETE and UPDATE:

MariaDB [test]> DELETE FROM v1;
ERROR 1288 (HY000): The target table v1 of the DELETE is not updatable
MariaDB [test]> DELETE FROM v2;
ERROR 1288 (HY000): The target table v2 of the DELETE is not updatable
MariaDB [test]> DELETE FROM v3;
ERROR 2013 (HY000): Lost connection to MySQL server during query

MariaDB [test]> UPDATE v1 SET a=0;
ERROR 1288 (HY000): The target table v1 of the UPDATE is not updatable
MariaDB [test]> UPDATE v2 SET a=0;
ERROR 1288 (HY000): The target table v2 of the UPDATE is not updatable
MariaDB [test]> UPDATE v3 SET a=0;
ERROR 2013 (HY000): Lost connection to MySQL server during query