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

  • Committer: Bazaar Package Importer
  • Author(s): sean finney
  • Date: 2007-05-13 12:32:45 UTC
  • mfrom: (1.1.11 upstream)
  • Revision ID: james.westby@ubuntu.com-20070513123245-8c3l187dk34cz2ar
Tags: 5.0.41-2
the previous "translation changes" inadvertently introduced unrelated
changes in the package control file.

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/temp_table.result
152
152
i
153
153
DROP TABLE t1;
154
154
End of 4.1 tests.
 
155
CREATE TABLE t1 ( c FLOAT( 20, 14 ) );
 
156
INSERT INTO t1 VALUES( 12139 );
 
157
CREATE TABLE t2 ( c FLOAT(30,18) );
 
158
INSERT INTO t2 VALUES( 123456 );
 
159
SELECT AVG( c ) FROM t1 UNION SELECT 1;
 
160
AVG( c )
 
161
12139
 
162
1
 
163
SELECT 1 UNION SELECT AVG( c ) FROM t1;
 
164
1
 
165
1
 
166
12139
 
167
SELECT 1 UNION SELECT * FROM t2 UNION SELECT 1;
 
168
1
 
169
1
 
170
123456
 
171
SELECT c/1 FROM t1 UNION SELECT 1;
 
172
c/1
 
173
12139
 
174
1
 
175
DROP TABLE t1, t2;