← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_math.test

  • Committer: Brian Aker
  • Date: 2008-09-21 14:47:59 UTC
  • Revision ID: brian@tangent.org-20080921144759-bfl0nnj6ntkp55cu
Remove tiny/small int.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/func_math.test
210
210
# Bug #30587: mysql crashes when trying to group by TIME div NUMBER
211
211
#
212
212
 
213
 
CREATE TABLE t1 (a timestamp, b varchar(20), c bit);
 
213
CREATE TABLE t1 (a timestamp, b varchar(20), c int);
214
214
INSERT INTO t1 VALUES('1998-09-23', 'str1', 1), ('2003-03-25', 'str2', 0);
215
215
SELECT a DIV 900 y FROM t1 GROUP BY y;
216
216
SELECT DISTINCT a DIV 900 y FROM t1;