Bug For Developers - LIST_SERVICES does not give proper output with supported service QR
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
0
Comments
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');