← Back to branch summary

~drizzle-developers/drizzle/elliott-release

« back to all changes in this revision

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

  • Committer: Patrick Crews
  • Date: 2011-02-01 20:33:06 UTC
  • mfrom: (1845.2.288 drizzle)
  • Revision ID: gleebix@gmail.com-20110201203306-mwq2rk0it81tlwxh
Merged Trunk

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;