~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to tests/r/group_min_max.result

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-10-02 14:17:48 UTC
  • mfrom: (1.1.1 upstream)
  • mto: (2.1.17 sid)
  • mto: This revision was merged to the branch mainline in revision 3.
  • Revision ID: james.westby@ubuntu.com-20101002141748-m6vbfbfjhrw1153e
Tags: 2010.09.1802-1
* New upstream release.
* Removed pid-file argument hack.
* Updated GPL-2 address to be new address.
* Directly copy in drizzledump.1 since debian doesn't have sphinx 1.0 yet.
* Link to jquery from libjs-jquery. Add it as a depend.
* Add drizzled.8 symlink to the install files.

Show diffs side-by-side

added added

removed removed

Lines of Context:
1611
1611
select distinct t1.a1,t2.a1 from t1,t2;
1612
1612
a1      a1
1613
1613
a       a
1614
 
b       a
1615
 
c       a
1616
 
d       a
1617
1614
a       b
1618
 
b       b
1619
 
c       b
1620
 
d       b
1621
1615
a       c
 
1616
a       d
 
1617
a       e
 
1618
b       a
 
1619
b       b
1622
1620
b       c
1623
 
c       c
1624
 
d       c
1625
 
a       d
1626
1621
b       d
 
1622
b       e
 
1623
c       a
 
1624
c       b
 
1625
c       c
1627
1626
c       d
1628
 
d       d
1629
 
a       e
1630
 
b       e
1631
1627
c       e
 
1628
d       a
 
1629
d       b
 
1630
d       c
 
1631
d       d
1632
1632
d       e
1633
1633
explain select distinct a1,a2,b from t1;
1634
1634
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra