NAN

SQL Navigator
1

Hello,

When I export some selected data as spool text, some columns with NULL values are indicated as being “NAN”, some are not. What I did to reproduce this phenomenon, and the results:

CREATE TABLE x ( c1 NUMBER(1), c2 NUMBER(2), c3 NUMBER(9), c4 INTEGER, c5 NUMBER(4, 1));
INSERT INTO x VALUES (1, 1, 1, 1, 1);
INSERT INTO x VALUES (2, NULL, NULL, NULL, NULL);
INSERT INTO x VALUES (NULL, NULL, NULL, NULL, NULL);

SELECT * FROM x;

– CTRL-E in the results tab, Format: “Spool Text”

C1 C2 C3 C4 C5

     1 1 1 1 1
     2 NAN NAN
   NAN NAN NAN
2

Ahem, the formatting is pretty much gone in my previous message. I’ve attached a text file that should have the formatting preserved…
B91_01.txt (875 Bytes)

3

Hi Dominique,

Thank you for your note. This has been reported earlier. Roman has already made changes to fix this issue, and it will be in the first build for next Beta round in a near future.

Thanks and regards,
Bruce

4

Sorry to re-report the issue - eagerly awaiting the next beta!

5

Browsing through my older posts, I found this problem - it is fixed in 6.4.0.1901 (and probably in several previous releases, too).