diff options
| author | unknown <monty@narttu.mysql.fi> | 2003-05-13 20:07:43 +0300 |
|---|---|---|
| committer | unknown <monty@narttu.mysql.fi> | 2003-05-13 20:07:43 +0300 |
| commit | d4ae4f0ec0e43f395722dbd1153938c66658b037 (patch) | |
| tree | 3c15703914b849da6efe79f06b0c60a0892d5afd /mysql-test/r/update.result | |
| parent | d05cd28c10bdc94783074ebaba40a3ed1fabe6a6 (diff) | |
| download | mariadb-git-d4ae4f0ec0e43f395722dbd1153938c66658b037.tar.gz | |
Fixed 'Unknown error' when using 'UPDATE ... LIMIT'. Bug 373
mysql-test/r/update.result:
new test
mysql-test/t/update.test:
Test of UPDATE ... LIMIT
sql/sql_update.cc:
Fixed 'Unknown error' when using 'UPDATE ... LIMIT'
Diffstat (limited to 'mysql-test/r/update.result')
| -rw-r--r-- | mysql-test/r/update.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/update.result b/mysql-test/r/update.result index 86647e845a9..5357e8367e3 100644 --- a/mysql-test/r/update.result +++ b/mysql-test/r/update.result @@ -138,3 +138,15 @@ a b 111 100 111 100 drop table t1; +CREATE TABLE t1 ( +`id_param` smallint(3) unsigned NOT NULL default '0', +`nom_option` char(40) NOT NULL default '', +`valid` tinyint(1) NOT NULL default '0', +KEY `id_param` (`id_param`,`nom_option`) +) TYPE=MyISAM; +INSERT INTO t1 (id_param,nom_option,valid) VALUES (185,'600x1200',1); +UPDATE t1 SET nom_option='test' WHERE id_param=185 AND nom_option='600x1200' AND valid=1 LIMIT 1; +select * from t1; +id_param nom_option valid +185 test 1 +drop table t1; |