8.test

来自「《嵌入式Linux应用开发详解》中的源代码」· TEST 代码 · 共 37 行

# Check out the correct handling of money values

create table bad_money( v1 money)\p\g

insert into bad_money values (29.00)\p\g
insert into bad_money values (29.01)\p\g
insert into bad_money values (29.03)\p\g
insert into bad_money values (29.04)\p\g
insert into bad_money values (29.05)\p\g
insert into bad_money values (29.06)\p\g
insert into bad_money values (29.07)\p\g
insert into bad_money values (29.08)\p\g
insert into bad_money values (29.09)\p\g
insert into bad_money values (29.10)\p\g
insert into bad_money values (29.11)\p\g
insert into bad_money values (29.97)\p\g
insert into bad_money values (29.98)\p\g
insert into bad_money values (29.99)\p\g
insert into bad_money values (30.00)\p\g

insert into bad_money values (-30.04)\p\g
insert into bad_money values (-30.03)\p\g
insert into bad_money values (-30.02)\p\g
insert into bad_money values (-30.01)\p\g
insert into bad_money values (-30.00)\p\g
insert into bad_money values (-29.99)\p\g
insert into bad_money values (-29.98)\p\g
insert into bad_money values (-29.97)\p\g
insert into bad_money values (-29.96)\p\g
insert into bad_money values (-29.95)\p\g
insert into bad_money values (-29.94)\p\g
insert into bad_money values (-29.93)\p\g
insert into bad_money values (-29.92)\p\g
insert into bad_money values (-29.91)\p\g

select * from bad_money order by v1 \p\g