← Back to branch summary

~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/t/update.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/update.test
483
483
SET SESSION sql_safe_updates = DEFAULT;
484
484
DROP TABLE t1;
485
485
DROP VIEW v1;
 
486
 
 
487
--echo #
 
488
--echo # Bug#54734 assert in Diagnostics_area::set_ok_status
 
489
--echo #
 
490
 
 
491
--disable_warnings
 
492
DROP TABLE IF EXISTS t1, not_exists;
 
493
DROP FUNCTION IF EXISTS f1;
 
494
DROP VIEW IF EXISTS v1;
 
495
--enable_warnings
 
496
 
 
497
CREATE TABLE t1 (PRIMARY KEY(pk)) AS SELECT 1 AS pk;
 
498
CREATE FUNCTION f1() RETURNS INTEGER RETURN (SELECT 1 FROM not_exists);
 
499
CREATE VIEW v1 AS SELECT pk FROM t1 WHERE f1() = 13;
 
500
--error ER_VIEW_INVALID
 
501
UPDATE v1 SET pk = 7 WHERE pk > 0;
 
502
 
 
503
DROP VIEW v1;
 
504
DROP FUNCTION f1;
 
505
DROP TABLE t1;