ndb_types.test
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:3k
- -- source include/have_ndb.inc
- -- source include/not_embedded.inc
- --disable_warnings
- DROP TABLE IF EXISTS t1;
- --enable_warnings
- #
- # Test creation of different column types in NDB
- #
- CREATE TABLE t1 (
- auto int(5) unsigned NOT NULL auto_increment,
- string char(10) default "hello",
- vstring varchar(10) default "hello",
- bin binary(7),
- vbin varbinary(7),
- tiny tinyint(4) DEFAULT '0' NOT NULL ,
- short smallint(6) DEFAULT '1' NOT NULL ,
- medium mediumint(8) DEFAULT '0' NOT NULL,
- long_int int(11) DEFAULT '0' NOT NULL,
- longlong bigint(13) DEFAULT '0' NOT NULL,
- real_float float(13,1) DEFAULT 0.0 NOT NULL,
- real_double double(16,4),
- utiny tinyint(3) unsigned DEFAULT '0' NOT NULL,
- ushort smallint(5) unsigned zerofill DEFAULT '00000' NOT NULL,
- umedium mediumint(8) unsigned DEFAULT '0' NOT NULL,
- ulong int(11) unsigned DEFAULT '0' NOT NULL,
- ulonglong bigint(13) unsigned DEFAULT '0' NOT NULL,
- options enum('one','two','tree') not null,
- flags set('one','two','tree') not null,
- date_field date,
- year_field year,
- time_field time,
- date_time datetime,
- time_stamp timestamp not null default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
- PRIMARY KEY (auto),
- KEY (utiny),
- KEY (tiny),
- KEY (short),
- KEY any_name (medium),
- KEY (longlong),
- KEY (real_float),
- KEY (ushort),
- KEY (umedium),
- KEY (ulong),
- KEY (ulonglong,ulong),
- KEY (options,flags)
- );
- set @now = now();
- sleep 1;
- insert into t1
- (string,vstring,bin,vbin,tiny,short,medium,long_int,longlong,
- real_float,real_double, utiny, ushort, umedium,ulong,ulonglong,
- options,flags,date_field,year_field,time_field,date_time)
- values
- ("aaaa","aaaa",0xAAAA,0xAAAA,-1,-1,-1,-1,-1,1.1,1.1,1,1,1,1,1,
- 'one','one', '1901-01-01','1901','01:01:01','1901-01-01 01:01:01');
- select auto,string,vstring,bin,vbin,tiny,short,medium,long_int,longlong,
- real_float,real_double, utiny, ushort, umedium,ulong,ulonglong,
- options,flags,date_field,year_field,time_field,date_time
- from t1;
- select time_stamp>@now from t1;
- set @now = now();
- sleep 1;
- update t1 set string="bbbb",vstring="bbbb",bin=0xBBBB,vbin=0xBBBB,
- tiny=-2,short=-2,medium=-2,long_int=-2,longlong=-2,real_float=2.2,
- real_double=2.2,utiny=2,ushort=2,umedium=2,ulong=2,ulonglong=2,
- options='one',flags='one', date_field='1902-02-02',year_field='1902',
- time_field='02:02:02',date_time='1902-02-02 02:02:02' where auto=1;
- select auto,string,vstring,bin,vbin,tiny,short,medium,long_int,longlong,
- real_float,real_double, utiny, ushort, umedium,ulong,ulonglong,
- options,flags,date_field,year_field,time_field,date_time
- from t1;
- select time_stamp>@now from t1;
- drop table t1;
- # End of 4.1 tests