Bug For Developers - LIST_SERVICES does not give proper output with supported service QR

Arvind_Kumar

Version -  Vertica Analytic Database v7.1.2-19

 

step 1 - Below shows usage of list services , It says QR is supported service

SELECT LIST_SERVICES('');
ERROR 0:  Usage:
Requires a Service Type to list services
Supported Service Types: 'TM', 'QR' , 'SYSTEM'
Example:
select list_services('TM');

 

step 2- When we use QR gives usage error, which is invalid

 

SELECT LIST_SERVICES('QR');
ERROR 0:  Usage:
Requires a Service Type to list services
Supported Service Types: 'TM', 'QR' , 'SYSTEM'
Example:
select list_services('TM');

 

 

e

[Deleted User]

Yes. QR is invilid service. It could have been valid service in older version of Vertica but not any more. I ran this on v7.2.3-3 and it gives me following output :

sktestnew=> SELECT LIST_SERVICES('');
ERROR 0: Usage:
Requires a Service Type to list services
Supported Service Types: 'TM', 'SYSTEM'
Example:
select list_services('TM');