← Back to branch summary

~clint-fewbar/drizzle/regex-policy-cache-limiter

« back to all changes in this revision

Viewing changes to tests/std_data/mysqlmigrate_double_type.dat

  • Committer: Clint Byrum
  • Date: 2012-03-15 18:05:43 UTC
  • mfrom: (2224.1.302 workspace)
  • Revision ID: clint@ubuntu.com-20120315180543-9jxxm4q10k3np2ws
merging with latest trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/std_data/mysqlmigrate_double_type.dat
 
1
CREATE TABLE double_table(description TEXT,
 
2
col_double_unsigned double unsigned,
 
3
col_double24 double(24,0),
 
4
col_double24_1 double(24,1),
 
5
col_double_53 double(53,1),
 
6
col_double_not_null double NOT NULL,
 
7
col_double_default_null double DEFAULT NULL,
 
8
col_double_24_12_default double(24,12) DEFAULT 99999999999.999999999999
 
9
) ENGINE=MyISAM;
 
10
 
 
11
INSERT INTO double_table VALUES('MIN',0,-999999999999999999999999,-99999999999999999999999.9,-9999999999999999999999999999999999999999999999999999.9,-999999999999999999999999,DEFAULT,DEFAULT);
 
12
INSERT INTO double_table VALUES('MAX',999999999999999999999999,999999999999999999999999,99999999999999999999999.9,9999999999999999999999999999999999999999999999999999.9,999999999999999999999999,DEFAULT,DEFAULT);
 
13
INSERT INTO double_table VALUES('NULL',NULL,NULL,NULL,NULL,42,DEFAULT,DEFAULT);
 
14