numeric.sql

关系型数据库 Postgresql 6.5.2

-- ******************************
-- * Test suite for the Postgres NUMERIC data type
-- ******************************

CREATE TABLE num_data (id int4, val numeric(300,100));
CREATE TABLE num_exp_add (id1 int4, id2 int4, expected numeric(300,100));
CREATE TABLE num_exp_sub (id1 int4, id2 int4, expected numeric(300,100));
CREATE TABLE num_exp_div (id1 int4, id2 int4, expected numeric(300,100));
CREATE TABLE num_exp_mul (id1 int4, id2 int4, expected numeric(300,100));
CREATE TABLE num_exp_sqrt (id int4, expected numeric(300,100));
CREATE TABLE num_exp_ln (id int4, expected numeric(300,100));
CREATE TABLE num_exp_log10 (id int4, expected numeric(300,100));
CREATE TABLE num_exp_power_10_ln (id int4, expected numeric(300,100));

CREATE TABLE num_result (id1 int4, id2 int4, result numeric(300,100));


-- ******************************
-- * The following EXPECTED results are computed by bc(1)
-- * with a scale of 300
-- ******************************

BEGIN TRANSACTION;
INSERT INTO num_exp_add VALUES (0,0,'0');
INSERT INTO num_exp_sub VALUES (0,0,'0');
INSERT INTO num_exp_mul VALUES (0,0,'0');
INSERT INTO num_exp_div VALUES (0,0,'NaN');
INSERT INTO num_exp_add VALUES (0,1,'6852398049310715');
INSERT INTO num_exp_sub VALUES (0,1,'-6852398049310715');
INSERT INTO num_exp_mul VALUES (0,1,'0');
INSERT INTO num_exp_div VALUES (0,1,'0');
INSERT INTO num_exp_add VALUES (0,2,'525431716055.9015691580565052917944596016796880085633089915820638527');
INSERT INTO num_exp_sub VALUES (0,2,'-525431716055.9015691580565052917944596016796880085633089915820638527');
INSERT INTO num_exp_mul VALUES (0,2,'0');
INSERT INTO num_exp_div VALUES (0,2,'0');
INSERT INTO num_exp_add VALUES (0,3,'-7183563573679774924366799392868392833.5301026242198333296741957378887077660318525485624537205656408078348');
INSERT INTO num_exp_sub VALUES (0,3,'7183563573679774924366799392868392833.5301026242198333296741957378887077660318525485624537205656408078348');
INSERT INTO num_exp_mul VALUES (0,3,'0');
INSERT INTO num_exp_div VALUES (0,3,'0');
INSERT INTO num_exp_add VALUES (0,4,'-8017.65083172522815926582280177128402125550786396441005929613300980559517228382913472514');
INSERT INTO num_exp_sub VALUES (0,4,'8017.65083172522815926582280177128402125550786396441005929613300980559517228382913472514');
INSERT INTO num_exp_mul VALUES (0,4,'0');
INSERT INTO num_exp_div VALUES (0,4,'0');
INSERT INTO num_exp_add VALUES (0,5,'4747823160689824275992795.7435482860759268553304894546094806090945079504233968784096390051002696894595');
INSERT INTO num_exp_sub VALUES (0,5,'-4747823160689824275992795.7435482860759268553304894546094806090945079504233968784096390051002696894595');
INSERT INTO num_exp_mul VALUES (0,5,'0');
INSERT INTO num_exp_div VALUES (0,5,'0');
INSERT INTO num_exp_add VALUES (0,6,'9701245686868266153803441967720286769.407169905329625973842950739045885275761695735066657060982526493385549754095268799351802753812697995');
INSERT INTO num_exp_sub VALUES (0,6,'-9701245686868266153803441967720286769.407169905329625973842950739045885275761695735066657060982526493385549754095268799351802753812697995');
INSERT INTO num_exp_mul VALUES (0,6,'0');
INSERT INTO num_exp_div VALUES (0,6,'0');
INSERT INTO num_exp_add VALUES (0,7,'53434539.68545099977243923072935225137418842885023333327396090427200310074108059093125006857544132591');
INSERT INTO num_exp_sub VALUES (0,7,'-53434539.68545099977243923072935225137418842885023333327396090427200310074108059093125006857544132591');
INSERT INTO num_exp_mul VALUES (0,7,'0');
INSERT INTO num_exp_div VALUES (0,7,'0');
INSERT INTO num_exp_add VALUES (0,8,'-457327386.06988997533660667782229300572256009704377756762897876252237581486843');
INSERT INTO num_exp_sub VALUES (0,8,'457327386.06988997533660667782229300572256009704377756762897876252237581486843');
INSERT INTO num_exp_mul VALUES (0,8,'0');
INSERT INTO num_exp_div VALUES (0,8,'0');
INSERT INTO num_exp_add VALUES (0,9,'-88.46458030244467528082162887102125086097032072434060205');
INSERT INTO num_exp_sub VALUES (0,9,'88.46458030244467528082162887102125086097032072434060205');
INSERT INTO num_exp_mul VALUES (0,9,'0');
INSERT INTO num_exp_div VALUES (0,9,'0');
INSERT INTO num_exp_add VALUES (1,0,'6852398049310715');
INSERT INTO num_exp_sub VALUES (1,0,'6852398049310715');
INSERT INTO num_exp_mul VALUES (1,0,'0');
INSERT INTO num_exp_div VALUES (1,0,'NaN');
INSERT INTO num_exp_add VALUES (1,1,'13704796098621430');
INSERT INTO num_exp_sub VALUES (1,1,'0');
INSERT INTO num_exp_mul VALUES (1,1,'46955359026197292120686613811225');
INSERT INTO num_exp_div VALUES (1,1,'1.00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000');
INSERT INTO num_exp_add VALUES (1,2,'6852923481026770.9015691580565052917944596016796880085633089915820638527');
INSERT INTO num_exp_sub VALUES (1,2,'6851872617594659.0984308419434947082055403983203119914366910084179361473');
INSERT INTO num_exp_mul VALUES (1,2,'3600467266147441403089014425.5541960577252991267479438180864818403209543243522916805');
INSERT INTO num_exp_div VALUES (1,2,'13041.46255339804569229508591213994397015575245900117122118955181562389218923779048729758262833024493179626088334628');
INSERT INTO num_exp_add VALUES (1,3,'-7183563573679774924359946994819082118.5301026242198333296741957378887077660318525485624537205656408078348');
INSERT INTO num_exp_sub VALUES (1,3,'7183563573679774924373651790917703548.5301026242198333296741957378887077660318525485624537205656408078348');
INSERT INTO num_exp_mul VALUES (1,3,'-49224637019382798398286089985690389639602359684244071.8922490981929824142037859047091476226940833710558275205179115898820');
INSERT INTO num_exp_div VALUES (1,3,'-.00000000000000000000095389954846610752011339200947088050119215342248625968059695305811628936066357124751029522');
INSERT INTO num_exp_add VALUES (1,4,'6852398049302697.34916827477184073417719822871597874449213603558994070386699019440482771617086527486');
INSERT INTO num_exp_sub VALUES (1,4,'6852398049318732.65083172522815926582280177128402125550786396441005929613300980559517228382913472514');
INSERT INTO num_exp_mul VALUES (1,4,'-54940134919368385120.81248970674354050332848113219828602170849782121055619598327514099607745684798187510');
INSERT INTO num_exp_div VALUES (1,4,'-854664064715.35309911226020771070940019422228278351569218979570098037472670246888235920622757240622598318683302025848981052');
INSERT INTO num_exp_add VALUES (1,5,'4747823167542222325303510.7435482860759268553304894546094806090945079504233968784096390051002696894595');
INSERT INTO num_exp_sub VALUES (1,5,'-4747823153837426226682080.7435482860759268553304894546094806090945079504233968784096390051002696894595');
INSERT INTO num_exp_mul VALUES (1,5,'32533974164783185236339609841060881373431.6550414328018350920135515227035510735313827063024184400528958439610759085425');
INSERT INTO num_exp_div VALUES (1,5,'.00000000144327154095501553056995066374088123864817940925759336929056755983657662675588749627446067324624955846');
INSERT INTO num_exp_add VALUES (1,6,'9701245686868266153810294365769597484.407169905329625973842950739045885275761695735066657060982526493385549754095268799351802753812697995');
INSERT INTO num_exp_sub VALUES (1,6,'-9701245686868266153796589569670976054.407169905329625973842950739045885275761695735066657060982526493385549754095268799351802753812697995');
INSERT INTO num_exp_mul VALUES (1,6,'66476797020580094465930712987070250507406412849448592.522195655411103744823989913087360677019949974915069138259147140772652577099849554445015124212516425');
INSERT INTO num_exp_div VALUES (1,6,'.00000000000000000000070634207920187107398465954304992037673604087551275840261421484560438951119409119228358599');
INSERT INTO num_exp_add VALUES (1,7,'6852398102745254.68545099977243923072935225137418842885023333327396090427200310074108059093125006857544132591');
INSERT INTO num_exp_sub VALUES (1,7,'6852397995876175.31454900022756076927064774862581157114976666672603909572799689925891940906874993142455867409');
INSERT INTO num_exp_mul VALUES (1,7,'366154735506400417524126.93601516766992631704359744516379145673308396857521100653889582991884867371603707540117012565');
INSERT INTO num_exp_div VALUES (1,7,'128239114.43138090520585793163352899949315764107209783134973172830134337338301750228626553646806130348366969432201461594');
INSERT INTO num_exp_add VALUES (1,8,'6852397591983328.93011002466339332217770699427743990295622243237102123747762418513157');
INSERT INTO num_exp_sub VALUES (1,8,'6852398506638101.06988997533660667782229300572256009704377756762897876252237581486843');
INSERT INTO num_exp_mul VALUES (1,8,'-3133789288201682323403927.58107656590501917041554111733256373697509660048884635492500991422745');
INSERT INTO num_exp_div VALUES (1,8,'-14983572.50852131012973097522758686514275190244256289893022945850962088894207780677166406982475205389104657596671339859');
INSERT INTO num_exp_add VALUES (1,9,'6852398049310626.53541969755532471917837112897874913902967927565939795');
INSERT INTO num_exp_sub VALUES (1,9,'6852398049310803.46458030244467528082162887102125086097032072434060205');