Hi,

the following query takes a very short time (seconds):

select node_name as "Node_________________Name", -
platform_name,client_os_level as "OS-LVL", -
char(client_version,2) as "VV", -
char(client_release,2) as "RR", -
char(client_level,2) as "LL", -
domain_name,option_set, date(LASTACC_TIME) from nodes

after adding "client_sublevel" the query will never end:

select node_name as "Node_________________Name", -
platform_name,client_os_level as "OS-LVL", -
char(client_version,2) as "VV", -
char(client_release,2) as "RR", -
char(client_level,2) as "LL", -
char(client_sublevel,2) as "SL", -
domain_name,option_set, date(LASTACC_TIME) from nodes

Can anybody tell me, why?
(Server: good old VM 3.1.2.50)

Regards,
Gerhard Ginzler