diff options
| author | unknown <hf@deer.(none)> | 2005-02-04 19:12:15 +0400 |
|---|---|---|
| committer | unknown <hf@deer.(none)> | 2005-02-04 19:12:15 +0400 |
| commit | 8ed40c4b09bb4c56f17a1432fc9024a5dfc4e04a (patch) | |
| tree | d6e7caeeab6ee1fdff4d7c2ceb1cb7d859c41e2d /mysql-test | |
| parent | 1a3a4ee3e64c6418300d9afa0ba0e402407917c8 (diff) | |
| download | mariadb-git-8ed40c4b09bb4c56f17a1432fc9024a5dfc4e04a.tar.gz | |
Embedded version of test fixed
mysql-test/r/insert_select.result.es:
Test.es fixed
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/insert_select.result.es | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/insert_select.result.es b/mysql-test/r/insert_select.result.es index 9e11402733d..9cac6d31b8f 100644 --- a/mysql-test/r/insert_select.result.es +++ b/mysql-test/r/insert_select.result.es @@ -633,3 +633,15 @@ No Field Count 0 1 100 0 2 100 drop table t1, t2; +CREATE TABLE t1 ( +ID int(11) NOT NULL auto_increment, +NO int(11) NOT NULL default '0', +SEQ int(11) NOT NULL default '0', +PRIMARY KEY (ID), +KEY t1$NO (SEQ,NO) +) ENGINE=MyISAM; +INSERT INTO t1 (SEQ, NO) SELECT "1" AS SEQ, IF(MAX(NO) IS NULL, 0, MAX(NO)) + 1 AS NO FROM t1 WHERE (SEQ = 1); +select SQL_BUFFER_RESULT * from t1 WHERE (SEQ = 1); +ID NO SEQ +1 1 1 +drop table t1; |