Skip to main content

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

  • Jan 26, 2017 12:04 PM UTC
  • 1 reply
  • 6 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
  • Jan 31, 2017 9:40 PM UTC

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