gotta be a bug....it's broke in my 4.2.X AIX server, too, but...

select device,device_type from drives

works, and

select device,element from drives

has device blank.....  WEIRD.....

-drs-

>>> xjolliff AT TI DOT COM 09/19/02 09:13AM >>>
Something odd I noticed this morning about 4.2.x servers on AIX and
Solaris
-

"query drive f=d"
and
"select * from drives"

Displays values in the Device field, whereas a

"select device from drives"

displays a blank device field.

This holds for 4.2.1.15 on Solaris and 4.2.2.{patch of the day} on
AIX.

I went back to an older server (3.x) on AIX, and a "select device from
drives"  shows the devices, as I expected.

Anyone else able to reproduce this?  Is this WAD or a new 'feature'?