Skip to main content

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

  • January 26, 2017
  • 1 reply
  • 3 views

Arvind_Kumar
Forum|alt.badge.img+1

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

1 reply

Forum|alt.badge.img+2
  • Participating Frequently
  • January 31, 2017

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');