diff options
| author | He Zhenxing <hezx@mysql.com> | 2008-09-06 08:51:17 +0800 |
|---|---|---|
| committer | He Zhenxing <hezx@mysql.com> | 2008-09-06 08:51:17 +0800 |
| commit | b17458dcc14882dcb2565bcbb92115ed786fe7c1 (patch) | |
| tree | 81eaef221aa476a0279c43f5e5c6df9c91924e44 /mysql-test/r/myisam.result | |
| parent | d0edf322306221f2e662a54a9feecc78378d6dfe (diff) | |
| parent | d70d171ceef259920d975fa2ddccaa6a41ba91fe (diff) | |
| download | mariadb-git-b17458dcc14882dcb2565bcbb92115ed786fe7c1.tar.gz | |
Merge 5.1 main -> 5.1-rpl
Diffstat (limited to 'mysql-test/r/myisam.result')
| -rw-r--r-- | mysql-test/r/myisam.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index 8d20490cbe9..6f26135ce45 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -1831,6 +1831,28 @@ id ref 3 2 4 5 DROP TABLE t1, t2; +CREATE TABLE t1 (a INT) ENGINE=MyISAM CHECKSUM=1 ROW_FORMAT=DYNAMIC; +INSERT INTO t1 VALUES (0); +UPDATE t1 SET a=1; +SELECT a FROM t1; +a +1 +CHECK TABLE t1; +Table Op Msg_type Msg_text +test.t1 check status OK +INSERT INTO t1 VALUES (0), (5), (4), (2); +UPDATE t1 SET a=2; +SELECT a FROM t1; +a +2 +2 +2 +2 +2 +CHECK TABLE t1; +Table Op Msg_type Msg_text +test.t1 check status OK +DROP TABLE t1; End of 5.0 tests create table t1 (a int not null, key `a` (a) key_block_size=1024); show create table t1; |