Updated 3/1/2023

About Vertica Release Notes

These release notes contain the latest information on new features, changes, fixes, and known issues in Vertica 12.0.x.

They also contain information about issues resolved in major and minor releases, service packs, and hotfixes.

Downloads

For Vertica major, minor, and service pack releases:

Hotfix releases: Contact Vertica support

Contents

Vertica 12.0.3

Vertica 12.0.2

Vertica 12.0.1

Vertica 12.0.0

Vertica 12.0.3

Deprecated and Removed in 12.0.3

Vertica retires product functionality in two phases:

  1. Deprecated: Vertica announces deprecated features and functionality in a major or minor release. Deprecated features remain in the product and are functional. Published release documentation announces deprecation on this page. When users access this functionality, it may return informational messages about its pending removal.

    Deprecated in 12.0.2 Notes
    JDBC 4.0 and 4.1 support  
    The following parameters for CREATE NOTIFIER and ALTER NOTIFIER:
    • TLSMODE
    • CA BUNDLE
    • CERTIFICATE
    Use the TLS CONFIGURATION parameter instead. For details, see Creating a Kafka Notifier.
    The TLSMODE PREFER parameter for CONNECT TO VERTICA. Use the TLS CONFIGURATION parameter instead.
  2. Removed: Vertica removes a feature in a major or minor release that follows the deprecation announcement. Users can no longer access the functionality, and this page is updated to verify removal. Documentation that describes this functionality is removed, but remains in previous documentation versions.

    No functionality was removed in this release.

Resolved in 12.0.3

12.0.3-3

Updated 03/01/2023

Issue Key Component Description
VER‑85643 Database Designer Core DESIGNER_DESIGN_PROJECTION_ENCODINGS returned with an error if a period was embedded in the design name. This issue has been resolved.

12.0.3-1

Updated 02/08/2023

Issue Key Component Description
VER‑85014 Security Enabling data-channel encryption with a self-signed certificate could cause the database to go down. This issue has been resolved.
VER-85070 UI - Management Console Errors were appearing on Activity -> Table Utilization and Table Details pages of the MC. Those errors were related to the references of columns in system tables that have been deleted. The issue was resolved.
VER-85236 Security

The "starttls" LDAP authentication parameter is no longer deprecated and should generally be used when the LDAPAuth TLS Configuration is not granular enough to handle your environment. For example, if you have several LDAPAuth servers and only some of them can handle TLS, you should set (using ALTER AUTHENTICATION) "starttls" to "soft" in your authentication record to make TLS a preference and not a requirement.

For details, see the Vertica documentation on LDAP authentication parameters.

12.0.3-0

Updated 01/31/2023

Issue Key Component Description
VER-72373 UDX Creation of SQL macros with MapJSONExtractor failed with a 0-length string error. This issue has been resolved.
VER-79167 Execution Engine Table update operations that involved very long (> 1MB) row sizes attempted to preallocate more memory than was available to the resource pool, based on excessive block size calculations, and failed for lack of resourcer pool capacity. This issue was resolved by avoiding excessively large block sizes.
VER-80639 UI - Management Console Removed references to the columns in system tables that have been deleted.
VER-81348 Procedural Languages Previously, running ANALYZE_STATISTICS through a stored procedure without superuser privileges could cause the database to go down. This issue has been resolved.
VER-82297 Client Drivers - ODBC, Client Drivers - VSQL vsql now dynamically links the kerberos library in macOS.
VER-83000 Optimizer When UPDATE referenced a table column with an access policy, the access policy rule was applied twice instead of once. This issue has been resolved: now the access policy rule is applied only once.
VER-83292 Admin Tools Recent Linux distributions such as RHEL 8 and Ubuntu 20 (and higher) introduced _bracketed paste mode_ which, if enabled, broke intall_vertica and re_ip. This issue has been resolved.
VER-83408 Optimizer If a query with an ORDER BY clause also contained a WITH clause with its own ORDER BY clause, and configuration EnableWITHTempRelReuseLimit=1, Vertica occasionally crashed in the late stages of query planning. This issue has been resolved.
VER-83532 Optimizer Queries with string expressions in SELECT statements that were part of other expressions and also contained constant expressions sometimes returned an error. The issue has been resolved.
VER-83609 Backup/DR Backup and restore on FIPS-enabled systems using object storage systems such as S3 could fail due to unavailability of the MD5 checksum implementation. These operations do not use MD5 for security, and this issue was resolved by flagging the uses of MD5 as not-for-security, thus enabling its use even with FIPS mode enabled.
VER-83649 Kubernetes The vdb-gen tool now picks the correct ksafety value from the database.
VER-83700 Storage and Access Layer If you added a column to a table in an Eon database with active subscribers to the shard of a DOWN node, Vertica failed to create storage containers for that column. As a result, attempts to query that column failed. This issue has been resolved: given the same conditions, Vertica now returns an error on attempts to add a table column.
VER-83735 Optimizer Queries with complicated WITH clauses sometimes hung in Materialized WITH mode when directed queries or saved query plans were present in a database. The issue has been resolved.
VER-83865 Cloud - Amazon, UI - Management Console In MC for AWS, the i4i.8xlarge instance had both NVMe volumes assigned to temp. This issue has beenn resolved: now, temp and depot each have one NVMe volume.
VER-83943 Backup/DR, Optimizer When shard segmentation bounds and non-resharded storage container segmentation bounds did not match, reshard_database() returned with an error, and a hint to recreate problematic tables with CREATE TABLE AS; however, the CREATE operation resulted in tables that were missing rows. This issue has been resolved by changing the hint guidance: export the table data, truncate the table, and then use COPY to reload the table with the exported data.
VER-83974 Data Export Export to delimited did not allow the same character to be used for both 'escapeAs' and 'enclosedBy'. This restriction has been removed.
VER-83988 Admin Tools admintools uses a pseudoterminal (ssh + expect) to transfer data between nodes. When sending data larger than 4k, successful transfer depends on disabling canonical mode in the pseudoterminal. In some cases, this setting was ignored. This issue has been resolved.
VER-84073 Backup/DR The vbr listbackup task failed with an error when nodes in the configuration file's [mapping] section did not match the nodes in database. This issue has been resolved: listbackup now returns with a warning about nodes that are missing in the configuration file.
VER-84122 Optimizer Optimizer did not recognize valid FK-PK joins in some multi-key joins over inputs with Unique/Primary Key constraints. This issue has been resolved.
VER-84141 Optimizer In some cases, row count estimate for joins on complex predicates was inaccurate. Recent improvements have addressed this issue.
VER-84187 Admin Tools The problem was environmental. Fixing the configuration of the CipherTrust encryption system resolved the problem.
VER-84250 SDK Loading JSON data into a geospatial column (geometry or geography) using FJSONParser errored out with unknown data type error. This issue has been resolved.
VER-84475 Optimizer Queries with several subqueries in SELECT that were are also in the GROUP BY clause sometimes returned with an error. This issue has been resolved.
VER-84674 Recovery Recovery from scratch reset cpe to 0, but mergeout was disabled for the projection whose cpe was 0. This restriction has been removed to allow concurrent data loading.
VER-84783 ILM, Recovery During recovery, bulk loads blocked application of missed partition events. This issue has been resolved: now, missed drop partition events are applied by acquiring a D lock instead of an O lock.

Known Issues in 12.0.3

None

Vertica 12.0.2

Deprecated and Removed in 12.0.2

Vertica retires product functionality in two phases:

  1. Deprecated: Vertica announces deprecated features and functionality in a major or minor release. Deprecated features remain in the product and are functional. Published release documentation announces deprecation on this page. When users access this functionality, it may return informational messages about its pending removal.

    Deprecated in 12.0.2 Notes
    JDBC 4.0 and 4.1 support  
    The following parameters for CREATE NOTIFIER and ALTER NOTIFIER:
    • TLSMODE
    • CA BUNDLE
    • CERTIFICATE
    Use the TLS CONFIGURATION parameter instead. For details, see Creating a Kafka Notifier.
    The TLSMODE PREFER parameter for CONNECT TO VERTICA. Use the TLS CONFIGURATION parameter instead.
  2. Removed: Vertica removes a feature in a major or minor release that follows the deprecation announcement. Users can no longer access the functionality, and this page is updated to verify removal. Documentation that describes this functionality is removed, but remains in previous documentation versions.

    No functionality was removed in this release.

Resolved in 12.0.2

12.0.2-2

Updated 12/12/2022

Issue Key Component Description
VER‑84523 Admin Tools admintools uses a pseudoterminal (ssh + expect) to transfer data between nodes. When sending data larger than 4k, successful transfer depends on disabling canonical mode in the pseudoterminal. In some cases, this setting was ignored. This issue has been resolved.

12.0.2-1

Updated 11/28/2022

Issue Key Component Description
VER‑84166 Procedural Languages Previously, running ANALYZE_STATISTICS through a stored procedure without superuser privileges could cause the database to go down. This issue has been resolved.
VER‑84169 Data Export Export to delimited did not allow the same character to be used for both 'escapeAs' and 'enclosedBy'. This restriction has been removed.
VER‑84195 Storage and Access Layer If you added a column to a table in an Eon database with active subscribers to the shard of a DOWN node, Vertica failed to create storage containers for that column. As a result, attempts to query that column failed. This issue has been resolved: given the same conditions, Vertica now returns an error on attempts to add a table column.
VER‑84239 Optimizer Queries with string expressions in SELECT statements that were part of other expressions and also contained constant expressions sometimes returned an error. The issue has been resolved.
VER‑84243 Backup/DR The vbr listbackup task failed with an error when nodes in the configuration file's [mapping] section did not match the nodes in database. This issue has been resolved: listbackup now returns with a warning about nodes that are missing in the configuration file.
VER‑84335 Backup/DR, Optimizer When shard segmentation bounds and non-resharded storage container segmentation bounds did not match, reshard_database() returned with an error, and a hint to recreate problematic tables with CREATE TABLE AS; however, the CREATE operation resulted in tables that were missing rows. This issue has been resolved by changing the hint guidance: export the table data, truncate the table, and then use COPY to reload the table with the exported data.

12.0.2-0

Updated 11/17/2022

Issue Key Component Description
VER‑67030 Security ALTER TABLE...OWNER TO now properly changes the owner of table comments and projections.
VER‑72375 ComplexTypes, Database Designer Core When using DBD for encoding design on native tables with collection type columns (array/set), column statistics were ignored even when statistics for scalar type columns were available. This issue has been resolved: available statistics on scalar columns are now used in DBD encoding design.
VER‑73290 Documentation The documentation was unclear regarding proper usage of the coercion operator ::!. This issue has been resolved: the documentation now states that this operator only applies to table data, otherwise it returns an error.
VER‑74015 Data load / COPY For profiling COPY FROM STDIN, the data_bytes_loaded column of the dc_execution_summaries table reported an incorrect value of zero. This issue has been resolved: the column now reflects the total number of bytes transferred from the client.
VER‑74675 Documentation Documentation's description of the algorithm that Database Designer uses to recommend replicated over segmented projections was incomplete. The issue has been resolved.
VER‑78428 UI - Management Console If a database with extended monitoring enabled went down, its Extended Monitoring page displayed no data. This issue has been resolved.
VER‑79231 UI - Management Console The Management Console Java version was upgraded to Java 11.
VER‑80367 Backup/DR VBR uploads to S3 storage sometimes returned with error messages that the upload failed. This issue has been resolved: on receiving these messages, VBR now retries the upload operation.
VER‑81135 Documentation Description of support for running multiple databases in the same cluster was updated.
VER‑81195 Documentation The documentation's descriptiopn of upgrade paths was updated.
VER‑81454 AMI The Vertica server AMI and SSH configurations were updated to use more secure ciphers.
VER‑81654 Installation Program Previously, the Vertica installer logged into each host twice during install process. It now logs in just once, reducing the installation time.
VER‑82240 Optimizer Queries such as INSERT SELECT with reused WITH queries that had multipart DML query plans returned with errors when executed on an EON cluster with subclusters . This issue has been resolved.
VER‑82430 Optimizer Previously, duplicate join predicates in an event series join query caused Vertica to crash. This issue has been resolved: users now see results as expected when submitting queries with repeating predicates.
VER‑82691 UI - Management Console Microsecond values for the TIMESTAMPTZ data type were truncated in the Management Console interface. This issue has been resolved. Now, database server timestamps with UTC offset values display properly.
VER‑82725 Client Drivers - JDBC, Sessions JDBC now properly runs PreparedStatement.execute() for insert statements with complex types.
VER‑82785 UI - Management Console Vertica packages for SUSE Linux Enterprise Server did not include the Apache Log4j JAR files required for extended monitoring. This issue has been resolved.
VER‑82928 EON, Tuple Mover The MaxMrgOutROSSizeMB is now ignored for big resharded containers, allowing tuple mover to pick and remove the unnecessary data from big resharded containers one by one.
VER‑82959 Kafka Integration Under certain conditions, Vertica crashed when exporting data to Kafka. This issue has been resolved.
VER‑82984 EON On AWS, the control mode for Eon Mode databases must be set to pt2pt, not broadcast. Previously, users had to manually set the control mode to pt2pt after migrating their Eon Mode database from on-prem to AWS. Vertica now detects whether the Eon Mode database is running on AWS, and if so, sets the control mode to pt2pt when running revive_db.
VER‑83003 Control Networking Previously, addition of standby nodes changed the assignment of control nodes and number of fault groups. This issue has been resolved: standby nodes are no longer set as control nodes.
VER‑83068 Client Drivers - JDBC, Client Drivers - VSQL, Execution Engine In the 12.0.0 release, the default values of Vertica KeepAlive parameters were non-NULL values, which overrode the equivalent kernel TCP keepalive parameters. This issue has been resolved: now, all Vertica KeepAlive parameters are set to 0 (NULL), so effective settings are obtained from TCP keepalive parameters.
VER‑83076 Security In some cases, the LDAP Link service could fail to create users due circular assignment after the first synchronization. This has been fixed.
VER‑83150 UI - Management Console If you used a small subnet on AWS, SSH connections timed out when you ran the upgrade_vertica script. This issue has been resolved.
VER‑83200 Data Removal - Delete, Purge, Partitioning If insufficent resources were available to complete a background repartitioning task, the responsible thread failed to retry the operation. This issue has been resolved: a given background repartitioning request now has multiple chances to complete.
VER‑83214 SDK-Java Java SDK function setRowFromMap used to raise a exception when writing to BINARY type columns with the standard type coercion. The issue was fixed. Now standard type coercion successfully writes byte data to binary columns.
VER‑83225 DDL The REPLACE function occasionally produced a string that exceeded the maximum string length of 65000 octets, and returned with an error. This issue has been resolved: the function no longer creates a result string that exceeds 65000 octets.
VER‑83295 ComplexTypes, Optimizer The parameter "TryPruneUnusedDataEdges" toggles an optimization which tries to identify data edges of a query plan which are not necessary to compute the final result. This optimization would raise an INTERNAL error in rare situations with queries that perform a network resegment. This issue has been fixed.
VER‑83323 Admin Tools Works as expected: the installer option --accept-eula allows users to avoid admintools prompts.
VER‑83377 Optimizer The path_id for StorageUnion and Sort operators was sometimes reported to be -1. This issue has been resolved: path_id is now reported correctly.
VER‑83436 Catalog Engine System table vs_storage_reference_counts was not updating the counter values in column num_accesses. This issue has been resolved.
VER‑83517 Backup/DR Previously, the vbr replicate task returned an error if the source and destination databases shared the same database name and IP addresses. This issue has been resolved: these restrictions no longer apply.
VER‑83798 Documentation The section that describes the algorithm used by DBD to determine whether to recommend unsegmented projections contained a couple of typos. This issue has been resolved.
VER‑83809 Backup/DR Backup and restore on FIPS-enabled systems using object storage systems such as S3 could fail due to unavailability of the MD5 checksum implementation. These operations do not use MD5 for security, and this issue was resolved by flagging the uses of MD5 as not-for-security, thus enabling its use even with FIPS mode enabled.
VER‑83900 Optimizer If a query with an ORDER BY clause also contained a WITH clause with its own ORDER BY clause, and configuration EnableWITHTempRelReuseLimit=1, Vertica occasionally crashed in the late stages of query planning. This issue has been resolved.
VER‑83905 Cloud - Amazon, UI - Management Console In MC for AWS, the i4i.8xlarge instance had both NVMe volumes assigned to temp. This issue has been resolved: now, temp and depot each have one NVMe volume.

Known Issues in 12.0.2

None

Vertica 12.0.1

Deprecated and Removed in 12.0.1

Vertica retires product functionality in two phases:

  1. Deprecated: Vertica announces deprecated features and functionality in a major or minor release. Deprecated features remain in the product and are functional. Published release documentation announces deprecation on this page. When users access this functionality, it may return informational messages about its pending removal.

    No functionality was deprecated in this release.

  2. Removed: Vertica removes a feature in a major or minor release that follows the deprecation announcement. Users can no longer access the functionality, and this page is updated to verify removal. Documentation that describes this functionality is removed, but remains in previous documentation versions.

    Removed in 12.0.1 Notes
    Internet Explorer 11 Internet Explorer 11 web browser is retired and out of support as of June 15, 2022.

Resolved in 12.0.1

12.0.1-0

Updated 08/31/2022

Issue Key Component Description
VER‑74916 Optimizer REFRESH_COLUMNS on a table with a partition range projection returned an error if partitions in the target range were already merged with other partitions outside the specified range. REFRESH_COLUMNS now supports a Boolean ForceSplit parameter, by default set to true, which handles this case by forcing split partitioning.
VER‑78868 Cloud - Azure, UI - Management Console

If an Eon mode database used Microsoft Azure, Management Console was unable to use the user-assigned identities when system-assigned identity was enabled. This issue has been resolved: now MC can use a user-assigned identity when a system-assigned identity is enabled.

VER‑78873 Cloud - Azure, UI - Management Console When provisioning new nodes on an Eon mode database running on Microsoft Azure and system-assigned identity was enabled, Management Console MC did not assign tags to support authentication of Vertica nodes. This issue has been resolved.
VER‑80763 Client Drivers - VSQL The vsql client now returns an error code when it encounters an error while running a long query--for example, the query exceeds the resource pool's RUNTIMECAP setting.
VER‑81774 Execution Engine, Optimizer If join output required sorting and was used by another merge join, but had multiple equivalent sort keys, the sort keys were not fully maintained. In this case, the query returned with incorrect results. This issue has been resolve by maintaining the necessary sort keys for merge join input.
VER‑81944 Cloud - Amazon, UI - Management Console When a previously used IP address was repeated from the subnet, Management Console failed to add hosts to the cluster. This issue is now resolved.
VER‑82084 Catalog Engine Previously, containers generated by reshard_database() could not be tracked. This issue has been resolved by adding a new old_storage_oid column to dc_roses_created. This column helps trace new containers to the original containers from which they were derived.
VER‑82093 Depot If the depot had no space to download a new file, the data loading plan did not write the file to the depot. Instead, it viewed the file as already in the depot, and incorrectly returned an error that the file size did not match the catalog. This issue has been resolved: the data loading plan no longer regards the absent file as in the depot.
VER‑82097 EON, ResourceManager Previously, altering the max size of resource pools for non-local subclusters sometimes returned an error. This issue has been resolved.
VER‑82151 ComplexTypes, FlexTable When parsing arrays of primitive types using the JSON parser, COPY failed with a message about records being too large. This issue has been resolved.
VER‑82198 Execution Engine The optimizer removes predicates from a query if expression analysis finds them to be true for entire storage containers. When the same predicate appeared multiple times in a given query, and one of those predicates passed expression analysis, sometimes the optimizer removed all instances of that predicate. This issue has been resolved: the optimizer no longer removes multiple instances of the same predicate when one of them passes expression analysis.
VER‑82290 Backup/DR If you restored a backup to another database with a different communal storage location, startup on the target database failed if the database's oid was assigned to another object. This issue has been resolved.
VER‑82316 AP-Geospatial In some cases, ST_GeomFromGeoJSON returned non-null results on null input. This issue has been resolved.
VER‑82327 ComplexTypes The array_count function read all fields of a complex array from storage. Doing so resulted in high cost estimates and sub-optimal query plans. This issue has been resolved: array_count now reads only one field.
VER‑82341 Data Export, Data load / COPY, Hadoop When reading partition values from file paths, values that contained a '/' character were being read incorrectly by Vertica. This issue has been resolved.
VER‑82395 Admin Tools pexpect inefficiently closed potential file descriptors when the nofile limit was high, attempting to close all file descriptors whether they were open or closed. This issue has been addressed: when the number of file descriptors is ≤ 2000, pexpect uses closerange to close the file descriptors, as it preforms better than close in a loop. When the number of file descriptors > 2000, pexpect iterates over the file descriptors in /proc/self/fd, which contains open file descriptors only, and closes them.
VER‑82425 Cloud - Amazon, UI - Management Console After using Management Console to revive a database in the cloud, the database sometimes failed to start because of a lost+found directory in the catalog path. This issue is now resolved.
VER‑82439 Execution Engine Queries with multipart plans that produced large temporay relations sometimes failed to clean up temporary files. This issue has been resolved.
VER‑82444 Optimizer Queries with a UNION on EON subclusters resegmented grouped UNION leg outputs, even if UNION legs were segmented on group keys. This issue has been resolved, thereby improving query performance.
VER‑82445 Execution Engine In some queries with highly selective predicates, StorageMerge ran slower than expected, especially with higher CPU core counts. This issue has been resolved.
VER‑82486 Execution Engine If the REPLACE function was called with an empty string as the replacement (third) argument, it always returned a single-character result. This issue has been resolved.
VER‑82489 DDL - Table After renaming a table with ALTER TABLE, the DDL for its projections continued to reference the previous name as an alias of the new name. This issue has been resolved: when a table is renamed, the DDL of its projections is also updated.
VER‑82492 Database Designer Core When Database Designer processed queries that referenced non-table objects such as projections with pre-aggregated data such as live aggregate projections, it sometimes failed or produced core dumps and database crashes. This issue has been resolved: now Database Designer skips queries of these types.
VER‑82502 Execution Engine The makeutf8 function sometimes caused undefined behavior when given maximum-length inputs for the argument column type. This issue has been resolved.
VER‑82572 Documentation The INSERT documentation erroneously cited an limitation of 2000 rows for multi-row INSERT statements. This limitation has been removed.
VER‑82576 Client Drivers - JDBC When JDBC connected to the server with BinaryTransfer and the JVM timezone had a historical or future Daylight Saving Time (DST) schedule, querying DST start dates in the JVM timezone sometimes returned incorrect data. This issue has been resolved; however, performance of BinaryTransfer for DATE data is worse than that of TextTransfer.
VER‑82622 Execution Engine The makeutf8 function sometimes caused undefined behavior when given maximum-length inputs for the argument column type. This issue has been resolved.
VER‑82676 Data load / COPY Flex table parsers did not reserve enough buffer space to correctly process certain inputs to NUMERIC-type columns. This issue has been resolved.
VER‑82683 DDL Vertica allows any partition expression that resolves to non-NULL values, even in cases where the expression columns originally contained NULL values. Conversely, Vertica no longer allows a partition expression that produces NULL values even if the expression columns contain no NULL values.
VER‑82729 Optimizer Queries with complex WITH clauses that used materialized WITH were running out of memory at the parsing stage. This issue has been resolved.
VER‑82730 Execution Engine When processing the LAST_VALUE() function, the sort column was initialized using the input column's data type. In cases where the data types of the input and sort columns differed, Vertica used the wrong null representation. This issue has been resolved: now, the sort column is correctly initialized as per the ORDER BY column data type.
VER‑83043 Client Drivers - JDBC, Sessions JDBC now properly runs PreparedStatement.execute() for insert statements with complex types.

Known Issues in 12.0.1

None

Vertica 12.0.0

Deprecated and Removed

Vertica retires product functionality in two phases:

  1. Deprecated: Vertica announces deprecated features and functionality in a major or minor release. Deprecated features remain in the product and are functional. Published release documentation announces deprecation on this page. When users access this functionality, it may return informational messages about its pending removal.

    Deprecated in 12.0.0 Notes
    hive_partition_cols parameter for PARQUET and ORC parsers Use COPY...PARTITION COLUMNS instead. See Partitioned File Paths.
    The following ODBC/JDBC OAuth parameters:
    • OAuthAccessToken/oauthaccesstoken
    • OAuthRefreshToken/oauthrefreshtoken
    • OAuthClientId/oauthclientid
    • OAuthClientSecret/oauthclientsecret
    • OAuthTokenUrl/oauthtokenurl
    • OAuthDiscoveryUrl/oauthdiscoveryurl
    • OAuthScope/oauthscope
    Replaced by OAuthJsonConfig (ODBC) and oauthjsonconfig (JDBC).
  2. Removed: Vertica removes a feature in a major or minor release that follows the deprecation announcement. Users can no longer access the functionality, and this page is updated to verify removal. Documentation that describes this functionality is removed, but remains in previous documentation versions.

    Removed in 12.0.0 Notes
    Mac 10.12

    ODBC client driver supporT

    AWS Library (S3EXPORT) Replaced by File Export.

Resolved in 12.0.0

12.0.0-0

Updated 06/17/2022

Issue Key Component Description
VER‑61257 Data load / COPY

The load option "ON EACH NODE" was developed. If data to be loaded resides under the same file path on the filesystem of multiple nodes, a query can be run with "ON EACH NODE" instead of "path ON node1, path ON node2, ...". This will load data from the same file path on every node where the data is available.

VER‑67109 Catalog Engine

In a database with large number of projections, querying system table vs_segment or views of vs_segment somettimes returned with an error that the MaxParsedQuerySizeMB limit had been exceeded. This issue has been resolved.

VER‑73674 Admin Tools

Adding two nodes to a one-node enterprise database required the database to be rebalanced and made K-safe. Attempts to rebalance and achieve K-safety on the admintool command line ended in an error, while attempts to update K-safety in the admintools GUI also failed. These issues have been resolved.

VER‑79756 Client Drivers - VSQL, Security

When TLSMode is set to require, vsql did not allow connections if the SSL certificates were expired. This issue has been resolved.

VER‑80448 UI - Management Console

Some cookie features were not set properly in HTTP headers. This issue has been resolved.

VER‑80619 Backup/DR

vbr calls to the AWS function DeleteObjects() did not gracefully handle SlowDown errors. This issue has been resolved by changing the boto3 retry logic, so SlowDown errors are less likely to occur.

VER‑80890 Catalog Engine

Vertica 10.1 added support for bounds to array types. The addition of these bounds made changes to "typemod," which has represented the details of a column (e.g. VARCHAR length, timestamp precision). The changes to "typemod" were not correctly accounted for in the "odbc_columns" and "jdbc_columns" metadata tables, which resulted in inconsistent TIMESTAMP column definitions. This issue has been fixed.

VER‑81033 Security

OpenSSL has been upgraded to 1.1.1n.

VER‑81074 Execution Engine

'= ANY' expressions on arrays expect an array literal expression argument. If the argument was a string_to_array function, Vertica tried to interpret it as an array literal and produced a wrong result. This issue has been resolved: before passing a string_to_array function as an argument to an ' = ANY' expression, Vertica now constant-folds the function into an array literal, so the '= ANY' expression' can read the argument as expected.

VER‑81121 Admin Tools

Attempts to replace a down node in the admintools GUI or on the command line by calling db_replace_node or restart_node with the --force option failed. This issue has been resolved.

VER‑81214 UI - Management Console

Previously, when the MC was configured to use LDAP authentication and the MC restarted or the machine rebooted, MC users would be unable to log in to the MC with LDAP authentication. The issue has been resolved.

VER‑81248 Admin Tools

In previous releases, the default setting to rotate admintools.log was set to monthly, which was too infrequent for many clients, given the rapid growth of log size. This issue has been resolved: the default rotation frequency for admintools.log is now set to daily. A minimum log size limit is also set, which prevents rotation of logs if their size is less than 512kb.

VER‑81318 UI - Management Console

In some circumstances, the MC browser session would timeout after a period of inactivity. This issue has been resolved.

VER‑81358 Execution Engine

Addition of configuration parameter EnablePredicateRemoval introduced performance regressions in certain queries. This regression has been corrected.

VER‑81418 EON, Subscriptions

When an Eon Mode database was in read-only mode, unsegmented projected queries failed. Now, unsegmented projected queries succeed if there are active replica shard subscriptions on at least one node.

VER‑81470 Tuple Mover

Mergeout plans converted StorageMerge to StorageUnion+Sort, which slowed down mergeout and adversely affeced performance. This issue has been resolved: StorageMerge is no longer converrted to StorageUnion+Sort.

VER‑81474 Execution Engine

Changed misleading counter name from "number of bytes read from communal storage" to "number of bytes read from persistent storage"

VER‑81526 Backup/DR

When vbr failed to launch vertica-download-file or vertica-download-file ended with error, vbr raised an error because it tried to load the error message as json. This issue has been resolved with more error handling.

VER‑81572 Kubernetes

In Kubernetes environments, it was possible to report the memory usage in the memory_usage view as a negative value. This occurred because the overall memory size in the system was reduced, but the other memory usage components, like bytes free, were not reduced. Because memory usage was reported at the host level, we reported the usage as a negative percentage when free memory was greater than total memory. This issue has been resolved. Now, Kubernetes environments gather all memory information from cgroup information (/sys/fs/cgroup/memory) rather than /proc/memory.

VER‑81639 Execution Engine

Running analyze_statistics sometimes caused significant, unexpected slowdowns on concurrent queries. This slowdown was most noticeable on subsecond queries with StorageMerge operators in the plan. This issue has been resolved.

VER‑81684 Client Drivers - ODBC

TIMESTAMPTZ and TIMETZ values map to SQL_TYPE_TIMESTAMP and SQL_TYPE_TIME types in the ODBC Specification and do not include the timezone. The ODBC driver handles them identically to the TIMESTAMP and TIMETZ types.

VER‑81692 Client Drivers - ODBC

Previously, the ODBC driver could crash when using OCaml due to a bug in the Simba SDK. Version 12.0 Vertica ODBC driver uses an updated version of the Simba SDK that fixes this issue.

VER‑81694 Catalog Engine

Queries on system view V_MONITOR.PARTITIONS occasionally returned with an error that the limit set by MaxParsedQuerySizeMB had been exceeded. This issue has been resolved.

VER‑81729 UI - Management Console Management Console was unable to start a database if the URL for communal storage ended with a backslash ('/'). This issue has been resolved.
VER‑81751 Execution Engine

There was a performance issue when you executed a query on the VARBINARY(16) data type. This issue has been resolved.

VER‑81830 Security

Users synced from LDAP with an obsolete DN are orphaned. Previously, if you dropped these orphaned users and recreated them with LDAP Link, their roles would not be preserved. This issue has been fixed; these types of users now retain their roles on recreation with LDAP Link.

VER‑81845 Optimizer Previously, if a partition range projection included a column defined by an expression derived from another table column, querying on the projection sometimes caused the server to crash. This issue has been resolved.
VER‑81920 Tuple Mover

For projections with partition grouping, Reshard Mergeout can now efficiently merge both resharded and regular containers placed in different layers of strata.

VER‑81986 Depot

In Eon Mode, if the service shard was a non-participating primary subscriber, it could not fetch data from communal storage and cache it in the depot. This issue has been resolved. Now, if a node is down and another node temporarily served the shard, it fetches the file from communal storage and caches it in the depot without evicting any data.

VER‑82102 Security

Previously, running LDAP_LINK_DRYRUN_SEARCH and LDAP_LINK_DRYRUN_SYNC without the optional parameter 'LDAPLinkJoinAttr' would cause the database to go down. This issue has been fixed.

VER‑82114 Catalog Engine, DDL, UDX

Previously, CREATE PROCEDURE would not properly check for duplicate formal parameters in cases where they only differed by letter case (that is, upper or lower). This issue has been fixed.

Known Issues in 12.0.0

Updated 06/17/2022

Vertica makes every attempt to provide you with an up-to-date list of significant known issues in each release. We will update this list as we resolve issues and as we learn of new issues.

Issue Key Component Description
VER‑61069 Execution Engine

In very rare circumstances, if a Vertica process crashes during shutdown, the remaining processes might hang indefinitely.

VER‑61420 Data Removal - Delete, Purge, Partitioning

Partition operations such as move_partitions_to_table must split storage containers that have partitions that match and do not match the operation. Version 9.1 introduced an inefficiency where such a split can split a storage container into an extra storage container. In this case, the tuple mover eventually merged the extra container.

VER‑62983 Hadoop

When hcatalogconnector schemas are created with custom_partitions enabled, poor performance has been observed when there are many (500+) partitions. By default, custom_partitions are disabled on hcatalogconnector schemas.

VER‑64352 SDK

Under special circumstances, a sequence of statements to create and drop Python libraries fails. For example, the following session statements attempt to create Python libraries lib1 and lib2: CREATE LIBRARY lib1 AS :lib1_path DEPENDS :numpy_path LANGUAGE 'Python'; DROP LIBRARY lib1; CREATE LIBRARY lib2 AS :lib2_path DEPENDS :sklearn_path LANGUAGE 'Python'; Here, lib1 is a Python library that imports module numpy, while lib2 imports module sklearn, which relies on numpy. After lib1 is dropped, the CREATE LIBRARY statement for lib2 fails.

VER‑64916 Kafka Integration

When Vertica exports data collector information to Kafka via notifier, the serialization logic does not properly handle Vertica internal data type translation. When importing or copying that data back into the Management Console, Vertica uses the raw data in Kafka and inserts garbled data into the extended monitoring database.

VER‑69803 Hadoop

The infer_external_table_ddl meta-function will hang if you do not set authentication information in the current session when analyzing a file on GCP.

VER‑78074 Procedural Languages, UDX

Stored procedures that contain DML queries on tables with key constraints do not return a value.

VER‑78310 Client Drivers - JDBC

JDBC complex types return NULL arrays as empty arrays. For example, when executing this SQL statement: SELECT ARRAY[null,ARRAY[1,2,3],null,ARRAY[4,5],null] as array; The array column the server returns will be: [[],[1,2,3],[],[4,5],[]] Because of the null values in the string literal, it should return this value: [null,[1,2,3],null,[4,5],null] This is a work around to a limitation in Simba.

Legal Notices

Warranty

The only warranties for products and services are set forth in the express warranty statements accompanying such products and services. Nothing herein should be construed as constituting an additional warranty. Micro Focus shall not be liable for technical or editorial errors or omissions contained herein.

The information contained herein is subject to change without notice.

Restricted Rights Legend

Confidential computer software. Valid license from Micro Focus required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license.

Copyright Notice

© Copyright 2006 - 2022 Micro Focus, Inc.

Trademark Notices

Adobe® is a trademark of Adobe Systems Incorporated.

Microsoft® and Windows® are U.S. registered trademarks of Microsoft Corporation.

UNIX® is a registered trademark of The Open Group.