Nested subquery limits / Max length for queries?

@SarahL,

Are you referring to the "System Limits" page in the Online Doc where it says:

Query length: No limit
Depth of nesting subqueries: Unlimited in FROM, WHERE, and HAVING clause

See:
https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/SQLReferenceManual/SystemLimits.htm

As the doc says, there are no limits

Although, there is a DB parameter that limits the max memory allowed for parsing:

dbadmin=> \x
Expanded display is on.

dbadmin=> SELECT default_value, current_value, description FROM configuration_parameters WHERE parameter_name = 'MaxParsedQuerySizeMB';
-[ RECORD 1 ]-+--------------------------------------------------------------------------------------------------------------------------------------
default_value | 1024
current_value | 512
description   | Maximum amount of memory allowed for parsing a single request; Increasing this value may help with 'Request size too big' errors (MB)

I wanted to check and make sure the doc was correct because a customer brought this up.