← Back to branch summary

~ubuntu-branches/ubuntu/hardy/mysql-dfsg-5.0/hardy-updates

« back to all changes in this revision

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

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2007-04-02 16:10:53 UTC
  • mfrom: (1.1.9 upstream)
  • Revision ID: james.westby@ubuntu.com-20070402161053-zkil9hjq9k5p1uzv
Tags: 5.0.37-0ubuntu1
https://launchpad.net/bugs/95821
* New upstream bugfix release.
  - Fixes replication failure with auto-increment and on duplicate key
    update, a regression introduced into 5.0.24. (LP: #95821)
* debian/control: Set Ubuntu maintainer.
* debian/rules: Change comments from 'Debian etch' to 'Ubuntu 7.04'.

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/delete.test
163
163
delete FROM `4.t1` USING t1 as `4.t1` where `4.t1`.a = 5;
164
164
drop table t1;
165
165
 
 
166
#
 
167
# Bug#17711: DELETE doesn't use index when ORDER BY, LIMIT and
 
168
#            non-restricting WHERE is present.
 
169
#
 
170
create table t1(f1 int primary key);
 
171
insert into t1 values (4),(3),(1),(2);
 
172
delete from t1 where (@a:= f1) order by f1 limit 1;
 
173
select @a;
 
174
drop table t1;
 
175
 
 
176
--echo End of 4.1 tests
166
177
# End of 4.1 tests
167
178
 
168
179
#