ij> -- This tests for the fix of a bug in the readExternal method of -- org.apache.derby.iapi.types.execution.SQLDecimal -- (Track # 2834) create table test_numeric (v numeric(31,28)); 0 rows inserted/updated/deleted ij> insert into test_numeric values(0.153659349252549204400963844818761572241783142089843750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.155519172871977917615993192157475277781486511230468750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.156845683349995823618883150629699230194091796875000000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.167771342363935538344321685144677758216857910156250000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.169551943407624583493031877878820523619651794433593750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.171827807248857933331009917310439050197601318359375000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.172725514170567251426291477400809526443481445312500000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.173790440056551531711193092633038759231567382812500000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.178284396304296932633803862700005993247032165527343750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.190443865345212404172059450502274557948112487792968750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.204708121258723396707068786781746894121170043945312500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.204925853612388464419780120806535705924034118652343750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.206782991393041903904759237775579094886779785156250000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.208975811755244267331477203697431832551956176757812500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.219113708053228051220173711044481024146080017089843750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.219350734394552437933612054621335119009017944335937500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.221012255176880945128914390807040035724639892578125000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.233852021438996970914558914955705404281616210937500000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.250165879091443721371490482852095738053321838378906250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.254732077306483950529525372985517606139183044433593750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.256652589621466642455516193876974284648895263671875000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.259177521128625021340496914490358904004096984863281250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.259711742936781675439306127373129129409790039062500000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.263426083107227371193914677860448136925697326660156250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.265153938284969137306745778914773836731910705566406250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.284394754291467433127138519921572878956794738769531250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.284501720963279192133654760255012661218643188476562500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.285773541682349141446195517346495762467384338378906250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.293670096014542747475672967993887141346931457519531250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.298141579351063668035237697040429338812828063964843750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.300830762733429235566973147797398269176483154296875000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.301480275672052488999952402082271873950958251953125000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.313410495834889335498019136139191687107086181640625000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.315596999671068245696403664624085649847984313964843750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.316767836466031571518442433443851768970489501953125000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.319831561014056187097764905047370120882987976074218750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.321581867590551295776890583510976284742355346679687500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.330044919065760167242729039571713656187057495117187500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.340170172948979998572838212567148730158805847167968750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.343023330195411535470384478685446083545684814453125000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.343528838909644917976038414053618907928466796875000000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.348038324953031108499601486983010545372962951660156250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.348176589940960012903303777420660480856895446777343750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.348387561880196816588295405381359159946441650390625000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.348957260513803158019641159626189619302749633789062500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.353760949608404873245603994291741400957107543945312500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.353904370909915555465374836785485967993736267089843750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.355196672070496766160374590981518849730491638183593750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.356598092009570155624942344729788601398468017578125000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.361891550398754757722485919657628983259201049804687500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.363017511046693774900973039621021598577499389648437500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.364295947573769596239401380444178357720375061035156250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.365173282132318477444243853824445977807044982910156250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.366457422041641223131591686978936195373535156250000000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.373406205230288557039841634832555428147315979003906250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.379451243731913856471749113552505150437355041503906250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.387571502139793078178797713917447254061698913574218750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.391076141514143826860561148350825533270835876464843750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.394079701321526587598498281295178458094596862792968750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.408450075488608899121345530147664248943328857421875000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.413805706051468047412811301910551264882087707519531250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.418969557566636341405796883918810635805130004882812500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.426813242129662429036329740483779460191726684570312500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.437034717190214694326755306974519044160842895507812500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.448146058677034719863740974687971174716949462890625000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.448560403250551353870889670361066237092018127441406250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.453820269616386329225576901080785319209098815917968750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.456269809786531088668937172769801691174507141113281250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.461855255922355767417286642739782109856605529785156250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.469232123754527163939087586186360567808151245117187500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.470105968957435504940178816468687728047370910644531250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.471049530443553798875200300244614481925964355468750000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.471801288954409425713265591184608638286590576171875000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.472098174014232152551073795621050521731376647949218750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.479998044300088966274131507816491648554801940917968750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.487510348557400718938481531949946656823158264160156250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.488344394316039820402863824710948392748832702636718750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.491453931889371697927515469928039237856864929199218750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.492811951393927194509103628661250695586204528808593750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.498686934685222960084161059057805687189102172851562500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.508551183317009658502172442240407690405845642089843750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.510021698576308746275742578291101381182670593261718750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.514641581305544493218917523336131125688552856445312500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.514838599259439644306723948830040171742439270019531250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.516254456787693660757554425799753516912460327148437500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.517424998087975929195181379327550530433654785156250000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.520617556348049959069612668827176094055175781250000000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.523540519518414626531921385321766138076782226562500000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.526207255428038367384147022676188498735427856445312500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.536035818449368539617694295884575694799423217773437500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.538519356120012004929265003738692030310630798339843750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.539919567857022331125449454702902585268020629882812500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.546738509435749198139831150911049917340278625488281250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.555397163378280045442636492225574329495429992675781250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.556609269078325530344386606884654611349105834960937500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.559546306378952973403784199035726487636566162109375000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.562659733610342049914265771803911775350570678710937500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.563120243089950678339050682552624493837356567382812500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.564708580310341101693438758957199752330780029296875000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.575994406119186841408463806146755814552307128906250000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.577354105251341342963655733910854905843734741210937500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.580863074718258265427550668391631916165351867675781250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.582986835256425472984176394675159826874732971191406250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.591042132949047616108373404131270945072174072265625000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.598743143052751891630691716272849589586257934570312500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.600505989779717141985315720376092940568923950195312500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.617877239310097192692694534343900159001350402832031250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.622180218573680554605687120783841237425804138183593750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.627353931494473160412894685578066855669021606445312500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.640540141483764813301604590378701686859130859375000000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.643952050290426791789855087699834257364273071289062500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.645499424366119400886532275762874633073806762695312500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.650971601226496998648940461862366646528244018554687500000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.651357394998915650852211456367513164877891540527343750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.656225638072990613558488348644459620118141174316406250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.658941700667530216861678127315826714038848876953125000000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.661191909165676716675363877584459260106086730957031250000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.666205794165350417834758900426095351576805114746093750000000000000000); 1 row inserted/updated/deleted ij> insert into test_numeric values(0.666413162385818269584092377044726163148880004882812500000000000000000); 1 row inserted/updated/deleted ij> select v from test_numeric where v < 0.55 order by v; V ---------------------------------- 0.1536593492525492044009638448 0.1555191728719779176159931921 0.1568456833499958236188831506 0.1677713423639355383443216851 0.1695519434076245834930318778 0.1718278072488579333310099173 0.1727255141705672514262914774 0.1737904400565515317111930926 0.1782843963042969326338038627 0.1904438653452124041720594505 0.2047081212587233967070687867 0.2049258536123884644197801208 0.2067829913930419039047592377 0.2089758117552442673314772036 0.2191137080532280512201737110 0.2193507343945524379336120546 0.2210122551768809451289143908 0.2338520214389969709145589149 0.2501658790914437213714904828 0.2547320773064839505295253729 0.2566525896214666424555161938 0.2591775211286250213404969144 0.2597117429367816754393061273 0.2634260831072273711939146778 0.2651539382849691373067457789 0.2843947542914674331271385199 0.2845017209632791921336547602 0.2857735416823491414461955173 0.2936700960145427474756729679 0.2981415793510636680352376970 0.3008307627334292355669731477 0.3014802756720524889999524020 0.3134104958348893354980191361 0.3155969996710682456964036646 0.3167678364660315715184424334 0.3198315610140561870977649050 0.3215818675905512957768905835 0.3300449190657601672427290395 0.3401701729489799985728382125 0.3430233301954115354703844786 0.3435288389096449179760384140 0.3480383249530311084996014869 0.3481765899409600129033037774 0.3483875618801968165882954053 0.3489572605138031580196411596 0.3537609496084048732456039942 0.3539043709099155554653748367 0.3551966720704967661603745909 0.3565980920095701556249423447 0.3618915503987547577224859196 0.3630175110466937749009730396 0.3642959475737695962394013804 0.3651732821323184774442438538 0.3664574220416412231315916869 0.3734062052302885570398416348 0.3794512437319138564717491135 0.3875715021397930781787977139 0.3910761415141438268605611483 0.3940797013215265875984982812 0.4084500754886088991213455301 0.4138057060514680474128113019 0.4189695575666363414057968839 0.4268132421296624290363297404 0.4370347171902146943267553069 0.4481460586770347198637409746 0.4485604032505513538708896703 0.4538202696163863292255769010 0.4562698097865310886689371727 0.4618552559223557674172866427 0.4692321237545271639390875861 0.4701059689574355049401788164 0.4710495304435537988752003002 0.4718012889544094257132655911 0.4720981740142321525510737956 0.4799980443000889662741315078 0.4875103485574007189384815319 0.4883443943160398204028638247 0.4914539318893716979275154699 0.4928119513939271945091036286 0.4986869346852229600841610590 0.5085511833170096585021724422 0.5100216985763087462757425782 0.5146415813055444932189175233 0.5148385992594396443067239488 0.5162544567876936607575544257 0.5174249980879759291951813793 0.5206175563480499590696126688 0.5235405195184146265319213853 0.5262072554280383673841470226 0.5360358184493685396176942958 0.5385193561200120049292650037 0.5399195678570223311254494547 0.5467385094357491981398311509 ij> drop table test_numeric; 0 rows inserted/updated/deleted ij> exit;