📄 floattypes.out
字号:
ij> select dc from t where dc > r;DC -------------ij> select dc from t where dc > d;DC -------------ij> select dc from t where dc > dc;DC -------------ij> -- test >=select dc from t where dc >= 10;DC -------------10.00 1234.56 ij> select dc from t where dc >= -10;DC -------------10.00 -10.00 0.00 1234.56 ij> select dc from t where dc >= 0;DC -------------10.00 0.00 1234.56 ij> select dc from t where dc >= 1234.45;DC -------------1234.56 ij> select dc from t where dc >= i;DC -------------10.00 -10.00 0.00 1234.56 ij> select dc from t where dc >= l;DC -------------10.00 -10.00 0.00 1234.56 ij> select dc from t where dc >= s;DC -------------10.00 -10.00 0.00 1234.56 ij> select dc from t where dc >= r;DC -------------10.00 -10.00 0.00 1234.56 ij> select dc from t where dc >= d;DC -------------10.00 -10.00 0.00 1234.56 ij> select dc from t where dc >= dc;DC -------------10.00 -10.00 0.00 1234.56 ij> -- test <select dc from t where dc < 10;DC --------------10.00 0.00 ij> select dc from t where dc < -10;DC -------------ij> select dc from t where dc < 0;DC --------------10.00 ij> select dc from t where dc < 1234.45;DC -------------10.00 -10.00 0.00 ij> select dc from t where dc < i;DC -------------ij> select dc from t where dc < l;DC -------------ij> select dc from t where dc < s;DC -------------ij> select dc from t where dc < r;DC -------------ij> select dc from t where dc < d;DC -------------ij> select dc from t where dc < dc;DC -------------ij> -- test <=select dc from t where dc <= 10;DC -------------10.00 -10.00 0.00 ij> select dc from t where dc <= -10;DC --------------10.00 ij> select dc from t where dc <= 0;DC --------------10.00 0.00 ij> select dc from t where dc <= 1234.45;DC -------------10.00 -10.00 0.00 ij> select dc from t where dc <= i;DC -------------10.00 -10.00 0.00 ij> select dc from t where dc <= l;DC -------------10.00 -10.00 0.00 ij> select dc from t where dc <= s;DC -------------10.00 -10.00 0.00 ij> select dc from t where dc <= r;DC -------------10.00 -10.00 0.00 1234.56 ij> select dc from t where dc <= d;DC -------------10.00 -10.00 0.00 1234.56 ij> select dc from t where dc <= dc;DC -------------10.00 -10.00 0.00 1234.56 ij> -- test <>select dc from t where dc <> 10;DC --------------10.00 0.00 1234.56 ij> select dc from t where dc <> -10;DC -------------10.00 0.00 1234.56 ij> select dc from t where dc <> 0;DC -------------10.00 -10.00 1234.56 ij> select dc from t where dc <> 1234.45;DC -------------10.00 -10.00 0.00 1234.56 ij> select dc from t where dc <> i;DC -------------1234.56 ij> select dc from t where dc <> l;DC -------------1234.56 ij> select dc from t where dc <> s;DC -------------1234.56 ij> select dc from t where dc <> r;DC -------------ij> select dc from t where dc <> d;DC -------------ij> select dc from t where dc <> dc;DC -------------ij> ---- test a variety of inserts and updates--drop table t2;ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T2' because it does not exist.ij> create table t2 (i int, l bigint, s smallint, d double precision, r real, dc decimal(10,2));0 rows inserted/updated/deletedij> insert into t2 select * from t;5 rows inserted/updated/deletedij> -- add a few indexescreate index dcindex on t2(dc);0 rows inserted/updated/deletedij> create unique index dcuniqueindex on t2(dc);0 rows inserted/updated/deletedij> -- now do updates and confirm they are okupdate t2 set dc = dc + 1.1;5 rows inserted/updated/deletedij> select dc from t2;DC --------------8.90 1.10 11.10 1235.66 NULL ij> update t2 set dc = dc - 1.1;5 rows inserted/updated/deletedij> select dc from t2;DC --------------10.00 0.00 10.00 1234.56 NULL ij> update t2 set dc = dc / 1.1;5 rows inserted/updated/deletedij> select dc from t2;DC --------------9.09 0.00 9.09 1122.32 NULL ij> update t2 set dc = dc * 1.1;5 rows inserted/updated/deletedij> select dc from t2;DC --------------9.99 0.00 9.99 1234.55 NULL ij> -- try some deletesdelete from t2 where dc > 0;2 rows inserted/updated/deletedij> select dc from t2;DC --------------9.99 0.00 NULL ij> delete from t2 where dc = 0;1 row inserted/updated/deletedij> select dc from t2;DC --------------9.99 NULL ij> delete from t2 where dc < 0;1 row inserted/updated/deletedij> select dc from t2;DC -------------NULL ij> drop table t2;0 rows inserted/updated/deletedij> drop table t;0 rows inserted/updated/deletedij> -- test that we recycle values correctly-- when reading from a decimal table with-- variable length byte arrays stored-- via write externalcreate table t (c1 char(1), d dec(20,4), c2 char(1));0 rows inserted/updated/deletedij> create unique index tu on t(d);0 rows inserted/updated/deletedij> insert into t values ('a', 1.123, 'Z');1 row inserted/updated/deletedij> insert into t values ('a', 11111.123, 'Z');1 row inserted/updated/deletedij> insert into t values ('a', 11111111.123, 'Z');1 row inserted/updated/deletedij> insert into t values ('a', 6.123, 'Z');1 row inserted/updated/deletedij> insert into t values ('a', 666.123, 'Z');1 row inserted/updated/deletedij> insert into t values ('a', .6, 'Z');1 row inserted/updated/deletedij> insert into t values ('a', 0, 'Z');1 row inserted/updated/deletedij> insert into t values ('a', 666666.123, 'Z');1 row inserted/updated/deletedij> insert into t values ('a', 99999999999999.123, 'Z');1 row inserted/updated/deletedij> insert into t values ('a', 9.123, 'Z');1 row inserted/updated/deletedij> select * from t;C1 |D |C2 ---------------------------------a |1.1230 |Z a |11111.1230 |Z a |11111111.1230 |Z a |6.1230 |Z a |666.1230 |Z a |0.6000 |Z a |0.0000 |Z a |666666.1230 |Z a |99999999999999.1230 |Z a |9.1230 |Z ij> update t set d = d + .0007;10 rows inserted/updated/deletedij> select * from t;C1 |D |C2 ---------------------------------a |1.1237 |Z a |11111.1237 |Z a |11111111.1237 |Z a |6.1237 |Z a |666.1237 |Z a |0.6007 |Z a |0.0007 |Z a |666666.1237 |Z a |99999999999999.1237 |Z a |9.1237 |Z ij> drop table tmp;ERROR 42Y55: 'DROP TABLE' cannot be performed on 'TMP' because it does not exist.ij> drop table bad;ERROR 42Y55: 'DROP TABLE' cannot be performed on 'BAD' because it does not exist.ij> drop table t;0 rows inserted/updated/deletedij> -- ** insert double.sql---- Test the builtin type 'double precision'-- assumes these builtin types exist:⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -