Re: nvl and shared memory

Andrzej Sawicki wrote: > > server: IDS 7.30TC3 Developer Edition > > I have table 'points_adr' with 4000 rows in it. > Fields 'rotation', 'offsetx', 'offsety' can be null. > > This select: > SELECT id, nr , nvl(rotation, 0), nvl(offsetx,0), nvl(offsety, 0) > FROM points_adr;> cause IDS to add 6 new shared memory segment (size 8388608) > > when > SELECT id, nr, > CASE WHEN rotation is null then 0 else rotation END, > CASE WHEN offsetx is null then 0 else offsetx END, > CASE WHEN offsety is null then 0 else offsety END > FROM points_adr;> works fine - don't allocate memory. > I have used onmode -F before each test to free unused memory segments. > > Is there a bug in nvl function ??? Yes there is. I don't know which version it is fixed in for NT. Check with tech support and log a case. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+