← 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/r/subselect2.result

  • 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/r/subselect2.result
126
126
1       PRIMARY t2      ALL     DDOCTYPEID_IDX  NULL    NULL    NULL    9       Using where
127
127
1       PRIMARY t1      eq_ref  PRIMARY PRIMARY 34      test.t2.DOCID   1       
128
128
1       PRIMARY t4      eq_ref  PRIMARY PRIMARY 34      test.t2.DOCTYPEID       1       
129
 
2       DEPENDENT SUBQUERY      t3      unique_subquery PRIMARY,FFOLDERID_IDX   PRIMARY 34      func    1       Using index; Using where
130
 
3       DEPENDENT SUBQUERY      t3      unique_subquery PRIMARY,FFOLDERID_IDX   PRIMARY 34      func    1       Using index; Using where
131
 
4       DEPENDENT SUBQUERY      t3      unique_subquery PRIMARY,FFOLDERID_IDX   PRIMARY 34      func    1       Using index; Using where
132
 
5       DEPENDENT SUBQUERY      t3      unique_subquery PRIMARY,FFOLDERID_IDX   PRIMARY 34      func    1       Using index; Using where
133
 
6       DEPENDENT SUBQUERY      t3      unique_subquery PRIMARY,FFOLDERID_IDX,CMFLDRPARNT_IDX   PRIMARY 34      func    1       Using index; Using where
 
129
2       DEPENDENT SUBQUERY      t3      unique_subquery PRIMARY,FFOLDERID_IDX   PRIMARY 34      func    1       Using where
 
130
3       DEPENDENT SUBQUERY      t3      unique_subquery PRIMARY,FFOLDERID_IDX   PRIMARY 34      func    1       Using where
 
131
4       DEPENDENT SUBQUERY      t3      unique_subquery PRIMARY,FFOLDERID_IDX   PRIMARY 34      func    1       Using where
 
132
5       DEPENDENT SUBQUERY      t3      unique_subquery PRIMARY,FFOLDERID_IDX   PRIMARY 34      func    1       Using where
 
133
6       DEPENDENT SUBQUERY      t3      unique_subquery PRIMARY,FFOLDERID_IDX,CMFLDRPARNT_IDX   PRIMARY 34      func    1       Using where
134
134
drop table t1, t2, t3, t4;
135
135
CREATE TABLE t1 (a int(10) , PRIMARY KEY (a)) Engine=InnoDB;
136
136
INSERT INTO t1 VALUES (1),(2);