← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/microtime_type/t/decimal.test

  • Committer: Brian Aker
  • Date: 2011-01-19 18:03:32 UTC
  • mfrom: (2088.8.12 timestamp)
  • mto: This revision was merged to the branch mainline in revision 2098.
  • Revision ID: brian@tangent.org-20110119180332-acfk5i8oofp63s40
Merge in time code.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/microtime_type/t/decimal.test
 
1
CREATE TABLE t1 (    
 
2
    _value decimal(20,6)
 
3
 );
 
4
  
 
5
INSERT INTO t1 VALUES ("20030101000000.90000"), ("20030101000000.00000"), ("20030101000000.123456") ;
 
6
--sorted_result
 
7
SELECT _value FROM t1;
 
8
 
 
9
CREATE TABLE t2 (
 
10
  _value TIMESTAMP(6)
 
11
);
 
12
  
 
13
INSERT INTO t2 SELECT _value from t1;
 
14
--sorted_result
 
15
SELECT _value FROM t2;
 
16
    
 
17
DROP TABLE t1,t2;