We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


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

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

Arvind_KumarArvind_Kumar Community Edition User

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

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file