~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

Viewing changes to mysql-test/suite/engines/iuds/r/insert_year.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
ImportĀ upstreamĀ versionĀ 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
2431
2431
2155    2155    1998-12-26      1998-12-26 11:30:45
2432
2432
SELECT count(*) as total_rows, min(c2) as min_value, max(c2) FROM t3;
2433
2433
total_rows      min_value       max(c2)
2434
 
21      1901    2155
 
2434
21      0       2155
2435
2435
SELECT * FROM t3 WHERE c3 = '1998-12-11';
2436
2436
c1      c2      c3      c4
2437
2437
1990    1990    1998-12-11      1998-12-11 11:30:45
2838
2838
2155    2155    1998-12-26      1998-12-26 11:30:45
2839
2839
SELECT count(*) as total_rows, min(c2) as min_value, max(c2) FROM t3;
2840
2840
total_rows      min_value       max(c2)
2841
 
21      1901    2155
 
2841
21      0       2155
2842
2842
SELECT * FROM t3 WHERE c3 = '1998-12-11';
2843
2843
c1      c2      c3      c4
2844
2844
1990    1990    1998-12-11      1998-12-11 11:30:45