~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/type_float.test

  • Committer: Brian Aker
  • Date: 2008-10-02 19:18:43 UTC
  • mto: (438.4.1 drizzle-clean-code)
  • mto: This revision was merged to the branch mainline in revision 435.
  • Revision ID: brian@tangent.org-20081002191843-tw3nnufik8qwf9rz
Removed UNSIGNED from parser.

Show diffs side-by-side

added added

removed removed

Lines of Context:
95
95
drop table if exists t1;
96
96
--enable_warnings
97
97
 
98
 
# Don't allow 'double unsigned' to be set to a negative value (Bug #7700)
99
 
create table t1 (d1 double, d2 double unsigned);
 
98
# Don't allow 'double' to be set to a negative value (Bug #7700)
 
99
create table t1 (d1 double, d2 double);
100
100
insert into t1 set d1 = -1.0;
101
101
update t1 set d2 = d1;
102
102
select * from t1;
130
130
#
131
131
 
132
132
CREATE TABLE t1 (
133
 
  reckey int unsigned NOT NULL,
 
133
  reckey int NOT NULL,
134
134
  recdesc varchar(50) NOT NULL,
135
135
  PRIMARY KEY  (reckey)
136
136
) ENGINE=MyISAM DEFAULT CHARSET=latin1;