9.2.x Resolved Issues¶
9.2.1-28¶
Updated 01/11/2022
| Issue Key | Component | Description |
|---|---|---|
| VER-80173 | Kafka Integration | Updated log4j library to address CVE-2021-45105 and CVE-2021-44832. 更新了 log4j 库以解决 CVE-2021-45105 和 CVE-2021-44832。 |
9.2.1-27¶
Updated 12/23/2021
| Issue Key | Component | Description |
|---|---|---|
| VER-80120 | Kafka Integration | Updated Log4j library to address CVE-2021-44228 and CVE-2021-45046. 更新了 Log4j 库以解决 CVE-2021-44228 和 CVE-2021-45046。 |
9.2.1-26¶
Updated 04/13/21
Internal hotfix — no customer-facing issues.
9.2.1-25¶
Updated 4/13/2021
| Issue Key | Component | Description |
|---|---|---|
| VER-76255 | Data Export | Parquet files exported by Vertica now display date values correctly when imported to Impala. Vertica 导出的 Parquet 文件在导入到 Impala 时现在可以正确显示日期值。 |
| VER-76480 | Execution Engine | Fixed crash with complex memory-intensive queries using analytical functions feeding merge operations on high-core-count machines with high EXECUTIONPARALLELISM. 修复了在高核心数机器上使用高 EXECUTIONPARALLELISM 时，使用分析函数进行合并操作的复杂内存密集型查询导致的崩溃。 |
| VER-76791 | Kafka Integration, Security | SSL handshake error resolved when Kafka ingests avro data connecting to Vertica via schema registry URL. 解决了 Kafka 通过 schema registry URL 连接到 Vertica 摄取 avro 数据时出现的 SSL 握手错误。 |
9.2.1-24¶
Updated 3/16/2021
| Issue Key | Component | Description |
|---|---|---|
| VER-75249 | Security | DROP privilege now sufficient to replace a view, not just ownership. DROP 权限现在足以替换视图，而不仅限于拥有者权限。 |
| VER-75790 | Kafka Integration | Data ingested through Kafka during a timezone change no longer produces duplicate records. 在时区变更期间通过 Kafka 摄取的数据不再产生重复记录。 |
| VER-75942 | Tuple Mover | Fixed excessive PURGE logging by Tuple Mover on a projection during another MERGEOUT job. 修复了 Tuple Mover 在另一个 MERGEOUT 作业期间对投影记录过多 PURGE 日志的问题。 |
| VER-76127 | Monitoring | Output of get_expected_recovery_epoch no longer truncated on clusters with more than 20 nodes. get_expected_recovery_epoch 的输出在超过 20 个节点的集群上不再被截断。 |
9.2.1-23¶
Updated 2/2/2021
| Issue Key | Component | Description |
|---|---|---|
| VER-74964 | Storage and Access Layer | Fixed failure when cancelling INSERT/COPY transaction on EON under certain conditions. 修复了在特定条件下取消 EON 上的 INSERT/COPY 事务时的失败问题。 |
| VER-75014 | Tuple Mover | Mergeout caching auto-disabled when reflexive mergeout is enabled, resolving performance issues on new/restarted databases. 启用反射性 mergeout 时自动禁用 Mergeout 缓存，解决了新建/重启数据库上的性能问题。 |
| VER-75535 | Optimizer | Analytic functions no longer trigger Optimizer error when used with LIMIT OVER clause. 分析函数与 LIMIT OVER 子句一起使用时不再触发优化器错误。 |
| VER-75641 | Optimizer | Queries with subqueries on tables with TopK projections no longer return errors. 在具有 TopK 投影的表上使用子查询的查询不再返回错误。 |
9.2.1-22¶
Updated 11/24/2020
| Issue Key | Component | Description |
|---|---|---|
| VER-75095 | Execution Engine | Improved performance for inter-node encryption across various workloads. 改进了各种工作负载下节点间加密的性能。 |
9.2.1-21¶
Updated 11/6/2020
| Issue Key | Component | Description |
|---|---|---|
| VER-74170 | Data Load / COPY | Added 'UDLMaxDataBufferSize' parameter (default 256 MB) to avoid insufficient memory errors during User Define Load. 新增了 UDLMaxDataBufferSize 参数（默认 256 MB），以避免在用户自定义加载期间出现内存不足错误。 |
| VER-74650 | UI - Management Console | Vertica prioritizes reachable IP host addresses when trying JDBC connections. Vertica 在尝试 JDBC 连接时优先选择可达的 IP 主机地址。 |
| VER-74715 | UI - Management Console | Agent IP reachability confirmed from MC host when multiple IPs are available. 当有多个可用 IP 时，从 MC 主机确认代理 IP 可达性。 |
| VER-74779 | Optimizer | Reduced unusual optimizer planning time for queries on tables with complex live aggregate projections. 减少了对具有复杂实时聚合投影的表的查询的异常优化器规划时间。 |
9.2.1-20¶
Updated 9/9/2020
| Issue Key | Component | Description |
|---|---|---|
| VER-73876 | Backup/DR | vbr backup tool confirms Vertica session containing the snapshot runs throughout the backup task. vbr 备份工具确认包含快照的 Vertica 会话在整个备份任务期间持续运行。 |
| VER-74004 | Execution Engine | query_profiles table now reports correct row counts when querying external parquet tables on HDFS. query_profiles 表在查询 HDFS 上的外部 parquet 表现在报告正确的行数。 |
9.2.1-19¶
Updated 8/5/2020
| Issue Key | Component | Description |
|---|---|---|
| VER-72841 | Catalog Engine, Execution Engine | Dropping a column no longer corrupts partition-level statistics. 删除列不再损坏分区级统计信息。 |
| VER-73174 | Hadoop | Fixed connection to wrong HDFS cluster when multiple namenodes share the same hostname. 修复了当多个 namenode 共享相同主机名时连接到错误的 HDFS 集群的问题。 |
| VER-73264 | Execution Engine | Cancelling a query no longer causes subsequent queries in the same transaction to falsely report cancellation. 取消查询不再导致同一事务中的后续查询错误报告取消。 |
| VER-73485 | Tuple Mover | Large ROS containers of inactive partitions now merge with smaller ones under specific conditions. 非活动分区的大型 ROS 容器现在在特定条件下与较小的容器合并。 |
| VER-73486 | Data Load / COPY | Fixed database panic when FJsonParser rejects rows under certain circumstances. 修复了 FJsonParser 在特定情况下拒绝行时数据库崩溃的问题。 |
9.2.1-18¶
Updated 7/8/2020
| Issue Key | Component | Description |
|---|---|---|
| VER-72949 | Backup/DR | Backups now correctly delete old restore points when backup objects exceed 10,000. 当备份对象超过 10,000 个时，备份现在正确删除旧的恢复点。 |
| VER-72969 | Backup/DR | No longer fails when object restoration and creation share the same name in different character cases. 当对象恢复和创建在不同字符大小写下共享相同名称时不再失败。 |
| VER-72999 | Cloud - Amazon, Security | Instances can only access the S3 bucket specified for communal storage. 实例只能访问为公共存储指定的 S3 存储桶。 |
| VER-73075 | Kafka Integration | KafkaExport can run in fenced mode with SSL enabled. KafkaExport 可以在启用 SSL 的隔离模式下运行。 |
| VER-73109 | Kafka Integration | Updated kafkacat utility now works with TLS/SSL encryption enabled. 更新后的 kafkacat 工具现在可以在启用 TLS/SSL 加密的情况下工作。 |
9.2.1-17¶
Updated 6/22/2020
| Issue Key | Component | Description |
|---|---|---|
| VER-72906 | Data Load / COPY, SDK | Fixed bug causing fenced-mode user-defined parser to process the same data multiple times. 修复了导致隔离模式下用户自定义解析器多次处理相同数据的错误。 |
| VER-72971 | Kafka Integration, Security | All CA certificates now loaded from kafka_SSL_CA parameter, not just one. 现在从 kafka_SSL_CA 参数加载所有 CA 证书，而不仅仅是单个证书。 |
| VER-72972 | Kafka Integration | When omitting --ssl-ca-alias, scheduler loads all certificates into trust store. 省略 --ssl-ca-alias 时，调度程序将所有证书加载到信任库。 |
9.2.1-16¶
Updated 6/15/2020
| Issue Key | Component | Description |
|---|---|---|
| VER-72906 | Data Load / COPY, SDK | Fixed bug causing fenced-mode user-defined parser to process same data multiple times. 修复了导致隔离模式下用户自定义解析器多次处理相同数据的错误。 |
| VER-72971 | Kafka Integration, Security | All CA certificates now loaded from kafka_SSL_CA parameter. 现在从 kafka_SSL_CA 参数加载所有 CA 证书。 |
| VER-72972 | Kafka Integration | Scheduler loads all certificates when --ssl-ca-alias omitted. 省略 --ssl-ca-alias 时，调度程序加载所有证书。 |
9.2.1-15¶
Updated 5/13/2020
| Issue Key | Component | Description |
|---|---|---|
| VER-70708 | UI - Management Console | Fixed LDAP anonymous bind setting not taking effect in MC Admin. 修复了 LDAP 匿名绑定设置在 MC Admin 中不生效的问题。 |
| VER-72347 | Optimizer | Fixed incorrect results from queries mixing single-table predicates with EXISTS subqueries. 修复了混合单表谓词与 EXISTS 子查询的查询返回错误结果的问题。 |
| VER-72421 | Hadoop | Improved error message and cancelability for HDFS SASL handshake timeouts. 改进了 HDFS SASL 握手超时的错误消息和可取消性。 |
9.2.1-14¶
Updated 4/22/2020
| Issue Key | Component | Description |
|---|---|---|
| VER-72111 | DDL - Table | Fixed database failure when inserting into columns with constraints containing ASCII and non-ASCII characters. 修复了插入包含 ASCII 和非 ASCII 字符约束的列时数据库故障的问题。 |
| VER-72114 | Data Removal - Delete, Purge, Partitioning | Clearer messages when drop_partitions fails due to insufficient resource pool. 当 drop_partitions 因资源池不足而失败时提供更清晰的消息。 |
| VER-72116 | Hadoop | Vertica now retries HDFS operations on 403 errors instead of failing immediately. Vertica 现在在遇到 403 错误时重试 HDFS 操作，而不是立即失败。 |
| VER-72118 | Optimizer, Recovery | Projection data remains consistent after MERGE during node recovery in Enterprise mode. 企业模式下节点恢复期间执行 MERGE 后，投影数据保持一致性。 |
| VER-72256 | Execution Engine | Fixed database failure from malformed constraint definitions or improper transformations. 修复了因约束定义格式错误或转换不当导致的数据库故障。 |
9.2.1-13¶
Updated 4/8/2020
| Issue Key | Component | Description |
|---|---|---|
| VER-70461 | AP-Advanced | Fixed "DataArea overflow" error with user-defined aggregates or ACD library. 修复了用户自定义聚合或 ACD 库中的 DataArea 溢出错误。 |
| VER-71623 | Backup/DR | vbr no longer logs dbadmin password when debug level is 3 and password is stored in a file. 当调试级别为 3 且密码存储在文件中时，vbr 不再记录 dbadmin 密码。 |
| VER-72069 | Execution Engine | Loading Kafka messages larger than 5MB no longer causes insufficient memory error. 加载大于 5MB 的 Kafka 消息不再导致内存不足错误。 |
9.2.1-12¶
Updated 2/26/2020
| Issue Key | Component | Description |
|---|---|---|
| VER-71087 | Security, Third Party Tools Integration | NULL input to VoltageSecureProtect and VoltageSecureAccess now returns NULL. 向 VoltageSecureProtect 和 VoltageSecureAccess 输入 NULL 现在返回 NULL。 |
| VER-70963 | Third Party Tools Integration | Output buffer length now at least input length + 100 bytes for numeric format encryption. 对于数字格式加密，输出缓冲区长度现在至少为输入长度加 100 字节。 |
9.2.1-11¶
Updated 1/31/2020
| Issue Key | Component | Description |
|---|---|---|
| VER-70086 | Backup/DR | Deleting an object during EON backup no longer potentially causes backup failure. 在 EON 备份期间删除对象不再可能导致备份失败。 |
| VER-70149 | Client Drivers - VSQL | VSQL -B and -k/-K options can now be set together. VSQL 的 -B 和 -k/-K 选项现在可以同时设置。 |
| VER-70236 | Data Removal - Delete, Purge, Partitioning | Improved error message when DROP_PARTITIONS force-split fails due to concurrent mergeout. 改进了 DROP_PARTITIONS 强制拆分因并发 mergeout 而失败时的错误消息。 |
| VER-70704 | Optimizer - Statistics and Histogram | ANALYZE_ROW_COUNT can no longer change STATISTICS_TYPE from FULL to ROWCOUNT. ANALYZE_ROW_COUNT 不再能将 STATISTICS_TYPE 从 FULL 更改为 ROWCOUNT。 |
9.2.1-10¶
Updated 1/13/2020
| Issue Key | Component | Description |
|---|---|---|
| VER-69658 | Backup/DR | Supports replication from 9.2SP1-10 to 9.3 and later. 支持从 9.2SP1-10 复制到 9.3 及更高版本。 |
| VER-70673 | Data Load / COPY | Excessively long inputs to NUMERIC column in COPY no longer cause failure. COPY 中向 NUMERIC 列输入过长的数据不再导致失败。 |
9.2.1-9¶
Updated 11/20/2019
| Issue Key | Component | Description |
|---|---|---|
| VER-68935 | Cloud - Amazon | Fixed verticad script OS detection error on Amazon Linux. 修复了 Amazon Linux 上 verticad 脚本的 OS 检测错误。 |
| VER-69321 | UDX | GRANT and REVOKE now support ALTER and DROP privileges for user-defined functions. GRANT 和 REVOKE 现在支持用户自定义函数的 ALTER 和 DROP 权限。 |
| VER-69642 | Kafka Integration | No longer fails on improper Kafka SSL key/certificate errors on RedHat Linux. 在 RedHat Linux 上不再因 Kafka SSL 密钥/证书错误而失败。 |
| VER-69667 | Backup/DR | Fixed missing data on target cluster when copycluster and swap partition ran concurrently. 修复了 copycluster 和 swap partition 并发运行时目标集群数据丢失的问题。 |
| VER-69672 | LocalPlanner | Fixed failure with COUNT DISTINCT queries using predicates on lead columns in sort order. 修复了对排序顺序中前导列使用谓词的 COUNT DISTINCT 查询失败的问题。 |
| VER-69674 | Monitoring | Error now returned if SaveDCEEProfileThresholdUS exceeds maximum range. 如果 SaveDCEEProfileThresholdUS 超过最大范围，现在返回错误。 |
| VER-69784 | Execution Engine | Fixed memory conflict causing incorrect results with COUNT(DISTINCT) and aggregates on numeric datatype. 修复了在数值数据类型上使用 COUNT(DISTINCT) 和聚合导致结果不正确的内存冲突。 |
9.2.1-8¶
Updated 10/31/2019
| Issue Key | Component | Description |
|---|---|---|
| VER-67898 | Tuple Mover | Mergeout thread now scans entire queue for eligible jobs instead of stopping at first non-eligible. Mergeout 线程现在扫描整个队列以查找符合条件的作业，而不是在第一个不符合条件的作业处停止。 |
| VER-68936 | UI - Management Console | MC now generates alert for CRC Mismatch SNMP trap. MC 现在为 CRC 不匹配 SNMP 陷阱生成警报。 |
| VER-69389 | SAL | Fixed queries failing when reading ROS file format from Vertica 6.0 or earlier. 修复了从 Vertica 6.0 或更早版本读取 ROS 文件格式时查询失败的问题。 |
| VER-69354 | Tuple Mover | Changed mergeout prioritization algorithm to prevent indefinite queuing of slow-loading jobs. 更改了 mergeout 优先级算法以防止慢速加载作业无限期排队。 |
| VER-69398 | Security | Non-owners with inherited privileges on a view now correctly checked for view owner's SELECT WITH GRANT OPTION. 对视图具有继承权限的非拥有者现在正确检查视图拥有者的 SELECT WITH GRANT OPTION。 |
| VER-69144 | Security | Reverted Database Designer script permissions from 600 back to 666. 将数据库设计器脚本权限从 600 恢复为 666。 |
9.2.1-7¶
Updated 10/3/2019
| Issue Key | Component | Description |
|---|---|---|
| VER-68932 | UI - Management Console | Fixed version mismatch error after manual MC and Vertica server upgrade on AWS. 修复了在 AWS 上手动升级 MC 和 Vertica 服务器后的版本不匹配错误。 |
| VER-68863 | Optimizer | Fixed inconsistent results from queries sorting on subquery outputs. 修复了对子查询输出进行排序的查询结果不一致的问题。 |
| VER-69228 | Execution Engine | Fixed UUID sorting failure when ORDER BY clause didn't specify UUID column first. 修复了 ORDER BY 子句未首先指定 UUID 列时 UUID 排序失败的问题。 |
| VER-68864 | UI - Management Console | MC now properly handles user names with special characters in Extended Monitoring. MC 现在在扩展监控中正确处理包含特殊字符的用户名。 |
9.2.1-6¶
Updated 9/12/2019
| Issue Key | Component | Description |
|---|---|---|
| VER-68707 | Data Export, Hadoop | Date columns now include Parquet Logical type for tool recognition. 日期列现在包含 Parquet 逻辑类型以便于工具识别。 |
| VER-68706 | Data Export | EXPORT TO PARQUET supports zh_CN.utf8 and ja_JP.utf8. EXPORT TO PARQUET 支持 zh_CN.utf8 和 ja_JP.utf8 编码。 |
| VER-68703 | UI - Management Console | Fixed wrong order and timestamps in Events history tab of MC Design page. 修复了 MC 设计页面事件历史选项卡中顺序和时间戳错误的问题。 |
| VER-68575 | UI - Management Console | MC no longer fails to add tables with Japanese characters to a design. MC 不再因向设计中添加包含日文字符的表而失败。 |
| VER-68574 | Tuple Mover | Reflexive Mergeout no longer generates PURGE requests for containers without valid partition keys. 反射性 Mergeout 不再为没有有效分区键的容器生成 PURGE 请求。 |
9.2.1-5¶
Updated 8/18/2019
| Issue Key | Component | Description |
|---|---|---|
| VER-68429 | License | Fixed license tampering startup issues when upgrading 8.1.1-x with Autopass license to 9.0+. 修复了使用 Autopass 许可证从 8.1.1-x 升级到 9.0+ 时许可证篡改导致的启动问题。 |
| VER-68497 | Nimbus, Optimizer | Fixed incorrect/inconsistent results with multiple analytic functions and complex expressions in Enterprise/EON. 修复了企业/EON 模式下使用多个分析函数和复杂表达式时结果不正确/不一致的问题。 |
| VER-68498 | Catalog Engine | Exporting catalog on a self-referencing view no longer causes failure. 在自引用视图上导出目录不再导致失败。 |
9.2.1-4¶
Updated 7/31/2019
| Issue Key | Component | Description |
|---|---|---|
| VER-68236 | Optimizer | Prepared statements now throw a warning and process WITH clause without materializing it instead of an error. 预处理语句现在抛出警告并处理 WITH 子句而不物化它，而不是报错。 |
| VER-68156 | Optimizer | Fixed crash from certain analytic function combinations applied to merge join output. 修复了某些分析函数组合应用于合并连接输出时导致的崩溃。 |
| VER-68136 | Tuple Mover | TM_MOVESTORAGE no longer runs in infinite loop when default storage location is labeled. 当默认存储位置被标记时，TM_MOVESTORAGE 不再无限循环运行。 |
| VER-68111 | QA | Fixed misleading "Request size too big" error message. 修复了误导性的"请求大小过大"错误消息。 |
| VER-68078 | Nimbus | DDL transactions no longer delayed by pending file deletions in Eon mode. DDL 事务不再因 Eon 模式下待处理的文件删除而延迟。 |
| VER-68225 | Data Load / COPY | Fixed failure when reading Parquet files with large Varchar statistics due to C++ library bug. 修复了由于 C++ 库 bug 导致读取具有大 Varchar 统计信息的 Parquet 文件时失败的问题。 |
9.2.1-3¶
Updated 7/2/2019
| Issue Key | Component | Description |
|---|---|---|
| VER-67872 | Catalog Engine | Now generates up to 10 dependency messages then displays total, instead of one per dependency. 现在生成最多 10 条依赖消息，然后显示总数，而不是每个依赖一条消息。 |
| VER-67938 | Data Load / COPY | Fixed failure when client disconnects during COPY LOCAL with REJECTED DATA. 修复了客户端在使用 REJECTED DATA 进行 COPY LOCAL 期间断开连接时的失败问题。 |
9.2.1-2¶
Updated 6/17/2019
| Issue Key | Component | Description |
|---|---|---|
| VER-67632 | Execution Engine | Fixed ignored cancel attempts on queries with complex predicates. 修复了对具有复杂谓词的查询忽略取消尝试的问题。 |
| VER-67593 | Client Drivers - ODBC, Data Removal | Made SWAP_PARTITIONS_BETWEEN_TABLES atomic to prevent empty query results. 使 SWAP_PARTITIONS_BETWEEN_TABLES 原子化以防止空查询结果。 |
9.2.1-1¶
Updated 5/23/2019
| Issue Key | Component | Description |
|---|---|---|
| VER-67038 | Build and Release | Added error code to Export To Parquet error message. 向导出到 Parquet 的错误消息中添加了错误代码。 |
| VER-67339 | Backup/DR | Dropping user that owns an object during replicate/restore no longer causes node failure. 在复制/恢复期间删除拥有对象的用户不再导致节点故障。 |
| VER-67362 | Data Export, Hadoop | Dictionary size now accounted for when estimating row group sizes during parquet export. 在 parquet 导出期间估算行组大小时，现在会考虑字典大小。 |
| VER-67400 | UDX | Flex table views properly show UTF-8 encoded multi-byte characters. Flex 表视图正确显示 UTF-8 编码的多字节字符。 |
| VER-67408 | Client Drivers - Installation Package | Fixed incorrect permissions on ODBC driver message files. 修复了 ODBC 驱动程序消息文件的权限不正确问题。 |
| VER-67409 | DDL - Table | ANALYZE_STATISTICS no longer acquires GCL-X lock on local temp tables. ANALYZE_STATISTICS 不再获取本地临时表上的 GCL-X 锁。 |
| VER-67410 | Optimizer | Subqueries now supported in the ON clause of a query. 子查询现在支持在查询的 ON 子句中使用。 |
| VER-67411 | Execution Engine | Fixed query exceeding runtime cap auto-restarting instead of reporting timeout. 修复了超过运行时上限的查询自动重启而不是报告超时的问题。 |
| VER-67412 | Installation Program | Fixed standby node startup failure after upgrade due to deprecated projections. 修复了升级后因已废弃的投影导致备用节点启动失败的问题。 |
| VER-67414 | Optimizer | Inner join queries with grouping now return consistent results. 带分组的内部连接查询现在返回一致的结果。 |
| VER-67425 | Hadoop | Can now read tinyint values in parquet files from Apache Spark. 现在可以读取 Apache Spark 的 parquet 文件中的 tinyint 值。 |
| VER-67459 | Execution Engine | run_index_tool meta-function is now cancellable. run_index_tool 元函数现在可以取消。 |
9.2.1-0¶
Updated 5/8/2019
| Issue Key | Component | Description |
|---|---|---|
| VER-36308 | UI - Management Console | /etc/init.d/vertica-consoled status now shows actual MC state instead of always "OK." /etc/init.d/vertica-consoled status 现在显示实际的 MC 状态，而不是始终显示"OK。" |
| VER-36987 | Optimizer - Statistics and Histogram | DROP_STATISTICS with HISTOGRAMS now drops only histograms, not all statistics. 带 HISTOGRAMS 参数的 DROP_STATISTICS 现在只删除直方图，而不是所有统计信息。 |
| VER-38419 | Optimizer - GrpBy and Pre Pushdown | Aggregate functions can now be pushed down into UNION-ALL subqueries when safe. 聚合函数现在可以在安全的情况下下推到 UNION-ALL 子查询中。 |
| VER-43373 | DDL - Table | CREATE TABLE LIKE...INCLUDING PROJECTIONS no longer aliases new table with original name. CREATE TABLE LIKE...INCLUDING PROJECTIONS 不再用原始名称作为新表的别名。 |
| VER-55257 | Client Drivers - ODBC | Fixed "Multiple commands cannot be active" error when closing statement early with large result sets. 修复了在大型结果集下提前关闭语句时出现"多个命令不能同时活动"错误的问题。 |
| VER-56790 | Client Drivers - JDBC, ODBC | Server errors now correctly propagated with native error code via SQLGetDiagRec(). 服务器错误现在通过 SQLGetDiagRec() 正确传播本机错误代码。 |
| VER-58419 | UI - Management Console | 'Export Design' button now enabled after design completion. '导出设计'按钮现在在设计完成后启用。 |
| VER-59114 | Client Drivers - VSQL | vsql can now locate Kerberos KDC identified via specially-named DNS records. vsql 现在可以通过特殊命名的 DNS 记录定位 Kerberos KDC。 |
| VER-62414 | Hadoop | Fixed Parquet files with too many rowgroups. 修复了具有过多行组的 Parquet 文件。 |
| VER-63297 | Client Drivers - ADO | Fixed integer column value split across multiple reads. 修复了整数列值在多次读取中被拆分的问题。 |
| VER-63389 | Data Export, Hadoop | Fixed Parquet files with too many rowgroups causing performance degradation. 修复了具有过多行组的 Parquet 文件导致性能下降的问题。 |
| VER-63769 | Data Export, Error Handling, Hadoop | New allow_no_match parser option returns empty set instead of error for empty folders. 新增的 allow_no_match 解析器选项为空文件夹返回空集而不是错误。 |
| VER-64592 | DDL - Table | Constraint name conflicts now checked only within the same table. 约束名称冲突现在仅在同一表内检查。 |
| VER-64912 | Backup/DR | Altering replicated schema owner with CASCADE no longer crashes target database node. 使用 CASCADE 更改复制模式的所有者不再导致目标数据库节点崩溃。 |
| VER-64941 | DDL - Table | ADD COLUMN now supports ALL PROJECTIONS option. ADD COLUMN 现在支持 ALL PROJECTIONS 选项。 |
| VER-65065 | Kafka Integration | TLS certificate chains supported for Kafka Scheduler and UDx. Kafka Scheduler 和 UDx 支持 TLS 证书链。 |
| VER-65082 | Execution Engine | Detects and consolidates free memory in glibc arenas back to OS. 检测并整合 glibc arenas 中的空闲内存返回给操作系统。 |
| VER-65137 | Data Load / COPY | Rejected data and exceptions files now created with permissions 666. 拒绝数据和异常文件现在以 666 权限创建。 |
| VER-65154 | License | Fixed incorrectly large standard error in license auditor sampling mode. 修复了许可证审计器采样模式中标准误差过大错误。 |
| VER-65249 | UI - Management Console | License page now shows all licenses the database may contain. 许可证页面现在显示数据库可能包含的所有许可证。 |
| VER-65257 | Hadoop | Export to Parquet no longer crashes with Select statement combinations. 导出到 Parquet 不再因 Select 语句组合而崩溃。 |
| VER-65333 | Nimbus Subscriptions | Eon database crash after rebalance_shards fixed. 修复了 rebalance_shards 后 Eon 数据库崩溃的问题。 |
| VER-65338 | UI - Management Console | License usage graph now displays consistently. 许可证使用情况图现在一致地显示。 |
| VER-65419 | Security | Row-based access policy on view underlying table no longer denies view access. 视图基础表上的行级访问策略不再拒绝视图访问。 |
| VER-65484 | Backup/DR | Removed redundant "Missing info files" warnings from vbr log. 从 vbr 日志中删除了冗余的"缺少信息文件"警告。 |
| VER-65501 | Backup/DR | Fixed incorrect "snapshotName" in vbr config removing manifest entries. 修复了 vbr 配置中错误的"snapshotName"导致清单条目被删除的问题。 |
| VER-65604 | Security | Passwords with semicolons no longer printed in logs. 包含分号的密码不再打印到日志中。 |
| VER-65718 | Tuple Mover | Upgraded databases ignore MergeoutCache=1 if set; must also disable EnableReflexiveMergeout to enable it. 升级后的数据库忽略设置的 MergeoutCache=1；必须同时禁用 EnableReflexiveMergeout 才能启用它。 |
| VER-65776 | UI - Management Console | Non-admin MC users now see all running Vertica schedulers on Load page. 非管理员 MC 用户现在可以在加载页面上看到所有正在运行的 Vertica 调度程序。 |
| VER-65801 | Catalog Engine, Subscriptions | Fixed database starting with missing shards. 修复了数据库启动时缺少分片的问题。 |
| VER-65818 | Client Drivers - ADO | Fixed memory leak in ADO.NET driver statement tracking. 修复了 ADO.NET 驱动程序语句跟踪中的内存泄漏。 |
| VER-65866 | Execution Engine, Nimbus, S3 | Fixed rare S3 streaming read fatal errors. 修复了罕见的 S3 流式读取致命错误。 |
| VER-66058 | DDL | Fixed "System is not k-safe" error in Eon mode with DFS when a node was down. 修复了节点宕机时 Eon 模式配合 DFS 下出现的"系统不符合 k-safe"错误。 |
| VER-66080 | Execution Engine | Long 'like' patterns with non-ASCII characters no longer crash the server. 包含非 ASCII 字符的长 like 模式不再导致服务器崩溃。 |
| VER-66088 | Scrutinize | Now uses specified temp directory instead of /tmp. 现在使用指定的临时目录而不是 /tmp。 |
| VER-66095 | Data Load / COPY | FJsonParser no longer fails with >4KB keys and reject_on_duplicate_key=true. FJsonParser 在键超过 4KB 且 reject_on_duplicate_key=true 时不再失败。 |
| VER-66136 | UI - Management Console | Fixed "no metadata available" error when explaining unsegmented projections. 修复了解释未分段投影时出现"无可用元数据"错误的问题。 |
| VER-66228 | Optimizer | Fast const loading disabled when using hierarchical partitioning. 使用分层分区时禁用快速常量加载。 |
| VER-66240 | Optimizer - Statistics and Histogram | ANALYZE_STATISTICS no longer fails when cluster is in critical state. 当集群处于关键状态时，ANALYZE_STATISTICS 不再失败。 |
| VER-66308 | Hadoop | Fixed null pointer exception for NULLs in text struct data via HCatalog Connector. 修复了通过 HCatalog Connector 处理文本结构数据中 NULL 时的空指针异常。 |
| VER-66327 | Client Drivers - JDBC, Security | New tls_renegotiation_limit parameter; set to 0 to avoid stack overflow with >512MB data. 新增 tls_renegotiation_limit 参数；设置为 0 可避免超过 512MB 数据时的堆栈溢出。 |
| VER-66345 | Data Load / COPY | Parquet parser no longer incorrectly rejects rows with mixed zero/nonzero max definition levels. Parquet 解析器不再错误地拒绝具有混合零/非零最大定义级别的行。 |
| VER-66489 | Optimizer | Fixed error from double-planning of DELETE portion in optimized MERGE. 修复了优化 MERGE 中 DELETE 部分重复规划导致的错误。 |
| VER-66589 | Execution Engine | Partition pruning now works with TIMESTAMP column and TIMESTAMPTZ predicate. 分区修剪现在可以用于 TIMESTAMP 列和 TIMESTAMPTZ 谓词。 |
| VER-67056 | Admin Tools | Database revive no longer treats s3/hdfs storage locations as local filesystem paths. 数据库恢复不再将 s3/hdfs 存储位置视为本地文件系统路径。 |
9.2.0-8¶
Updated 1/27/2020
| Issue Key | Component | Description |
|---|---|---|
| VER-70856 | LocalPlanner | Fixed occasional failure with COUNT DISTINCT queries using predicates on lead columns in sort order. 修复了对排序顺序中前导列使用谓词的 COUNT DISTINCT 查询偶尔失败的问题。 |
9.2.0-7¶
Updated 4/11/2019
| Issue Key | Component | Description |
|---|---|---|
| VER-66705 | Data Load / COPY | FJsonParser no longer fails with >4KB keys and reject_on_duplicate_key=true. FJsonParser 在键超过 4KB 且 reject_on_duplicate_key=true 时不再失败。 |
| VER-66730 | UI - Management Console | Fixed "no metadata available" error when explaining unsegmented projections. 修复了解释未分段投影时出现"无可用元数据"错误的问题。 |
| VER-66742 | UI - Management Console | License chart now displays properly when usage exceeds 10TB. 当使用量超过 10TB 时，许可证图表现在正确显示。 |
| VER-66750 | Kafka Integration | TLS certificate chains supported for Kafka Scheduler and UDx. Kafka Scheduler 和 UDx 支持 TLS 证书链。 |
| VER-66765 | Hadoop | Export to Parquet no longer crashes with Select statement combinations. 导出到 Parquet 不再因 Select 语句组合而崩溃。 |
| VER-66808 | Backup/DR | Altering replicated schema owner with CASCADE no longer crashes target node. 使用 CASCADE 更改复制模式的所有者不再导致目标节点崩溃。 |
| VER-66810 | Optimizer Statistics and Histogram | ANALYZE_STATISTICS no longer fails when cluster is in critical state. 当集群处于关键状态时，ANALYZE_STATISTICS 不再失败。 |
| VER-66838 | Optimizer | Fast const loading disabled for hierarchical partitioning. 分层分区禁用快速常量加载。 |
| VER-66839 | Client Drivers - JDBC, Security | New tls_renegotiation_limit parameter to avoid stack overflow with >512MB data. 新增 tls_renegotiation_limit 参数以避免超过 512MB 数据时的堆栈溢出。 |
| VER-66856 | Optimizer | Fixed double-planning of DELETE portion in optimized MERGE. 修复了优化 MERGE 中 DELETE 部分的重复规划问题。 |
9.2.0-6¶
Updated 3/21/2019
| Issue Key | Component | Description |
|---|---|---|
| VER-66271 | Scrutinize | Now uses specified temp directory instead of /tmp. 现在使用指定的临时目录而不是 /tmp。 |
| VER-66411 | S3 | Removed unnecessary file check on communal storage that slowed deletes and increased costs. 移除了公共存储上不必要的文件检查，该检查拖慢了删除速度并增加了成本。 |
| VER-66498 | Data Load / COPY | Rejected data and exception files now created with permissions 666. 拒绝数据和异常文件现在以 666 权限创建。 |
| VER-66526 | DDL | Fixed "System is not k-safe" error in Eon mode with DFS when a node was down. 修复了节点宕机时 Eon 模式配合 DFS 下出现的"系统不符合 k-safe"错误。 |
| VER-66527 | Execution Engine | Long 'like' patterns with non-ASCII characters no longer cause failure. 包含非 ASCII 字符的长 like 模式不再导致失败。 |
9.2.0-5¶
Updated 3/5/2019
| Issue Key | Component | Description |
|---|---|---|
| VER-66420 | Data Load / COPY | Parquet files with columns of max definition level zero no longer have rows erroneously rejected. 包含最大定义级别为零的列的 Parquet 文件不再错误地拒绝行。 |
9.2.0-4¶
Updated 2/14/2019
| Issue Key | Component | Description |
|---|---|---|
| VER-66009 | Execution Engine, Nimbus, S3 | Fixed rare fatal errors from S3 streaming read bug. 修复了 S3 流式读取错误导致的罕见致命错误。 |
| VER-65851 | Security | Row-based access policy on underlying view table no longer denies view access. 视图基础表上的行级访问策略不再拒绝视图访问。 |
9.2.0-3¶
Updated 1/29/2019
| Issue Key | Component | Description |
|---|---|---|
| VER-65822 | Data Load / COPY | Empty S3 response (code 0) no longer causes database operation failures. 空 S3 响应（代码 0）不再导致数据库操作失败。 |
| VER-65772 | UI - Management Console | Fixed miscalculation in license auditor's standard error display. 修复了许可证审计器标准错误显示中的计算错误。 |
| VER-65767/65765 | Execution Engine | Reduced S3 List requests when querying out-of-depot ROS files in Eon mode. 减少了在 Eon 模式下查询存储库外 ROS 文件时的 S3 List 请求。 |
| VER-65736 | Backup/DR | Fixed incorrect "snapshotName" in vbr config removing manifest entries. 修复了 vbr 配置中错误的"snapshotName"导致清单条目被删除的问题。 |
| VER-65556 | UI - Management Console | License usage no longer shows 0% with Autopass license. 使用 Autopass 许可证时，许可证使用率不再显示为 0%。 |
9.2.0-2¶
Updated 1/3/2019
| Issue Key | Component | Description |
|---|---|---|
| VER-65444 | UI - Management Console | MC on AWS now displays AMI version. AWS 上的 MC 现在显示 AMI 版本。 |
| VER-65395 | UI - Management Console | Fixed error when on-premises MC attempted to download Vertica AMI repository file. 修复了本地 MC 尝试下载 Vertica AMI 仓库文件时的错误。 |
9.2.0-1¶
Updated 12/12/2018
| Issue Key | Component | Description |
|---|---|---|
| VER-65348 | DDL - Table | CREATE TABLE LIKE no longer loses column default expressions when one column uses a sequence default. 当一个列使用序列默认值时，CREATE TABLE LIKE 不再丢失列的默认表达式。 |
| VER-65407 | Eon, Subscriptions | Fixed Eon database crash after rebalance_shards following upgrade to 9.2. 修复了升级到 9.2 后执行 rebalance_shards 时 Eon 数据库崩溃的问题。 |
9.2.0-0¶
Updated 11/27/2018
| Issue Key | Component | Description |
|---|---|---|
| VER-63430 | Optimizer | Improved suboptimal query performance with subqueries in outer joins. 改进了在外连接中使用子查询时的次优查询性能。 |
| VER-62662 | Data Load / COPY | Fixed occasional node crash from COPY or external table query. 修复了 COPY 或外部表查询偶尔导致节点崩溃的问题。 |
| VER-48026 | DDL - Table | Moving a table with foreign keys to a new schema no longer blocks dropping original schema without CASCADE. 将带有外键的表移动到新模式不再阻止删除没有 CASCADE 的原始模式。 |
| VER-62002 | DDL - Table | Fixed prolonged GCL lock from CREATE TABLE AS causing OOM and cluster shutdown. 修复了 CREATE TABLE AS 导致长时间 GCL 锁定引发 OOM 和集群关闭的问题。 |
| VER-59212 | Sessions | DDL statements no longer fail when user has privileges on a user resource pool but not GENERAL pool. 当用户在用户资源池上有权限但在 GENERAL 池上没有权限时，DDL 语句不再失败。 |
| VER-63405 | Catalog Engine, Spread | Fixed child node restart failure when control node and child both went down. 修复了控制节点和子节点同时宕机时子节点重启失败的问题。 |
| VER-63839 | Data Load / COPY | SKIP keyword now properly supported with FIXEDWIDTH format. SKIP 关键字现在正确支持 FIXEDWIDTH 格式。 |
| VER-62810 | Data Load / COPY | Excessively long invalid date/time inputs no longer cause stack overflow crashes. 过长的无效日期/时间输入不再导致堆栈溢出崩溃。 |
| VER-64716 | Data Load / COPY, FlexTable | FJSON PARSER now returns consistent results for arrays across versions. FJSON PARSER 现在跨版本返回一致的数组结果。 |
| VER-61431 | Optimizer - Plan Stability | Optimizer now considers active directed queries with LABEL hints. 优化器现在考虑带有 LABEL 提示的活动定向查询。 |
| VER-60716 | FlexTable | MAPITEMS function no longer returns truncated map values. MAPITEMS 函数不再返回截断的 map 值。 |
| VER-63650 | DDL | ADD COLUMN with NOT NULL constraint now includes the constraint. 带 NOT NULL 约束的 ADD COLUMN 现在包含该约束。 |
| VER-63550 | S3 | S3Export now thread-safe with time/date values. S3Export 现在对时间/日期值是线程安全的。 |
| VER-64421 | Cloud - Amazon, UI - MC | MC no longer fails to add new host after long wait. MC 在长时间等待后不再无法添加新主机。 |
| VER-61289 | Execution Engine, Hadoop | Fixed crash from very large Parquet file metadata consuming excessive memory. 修复了非常大的 Parquet 文件元数据消耗过多内存导致的崩溃。 |
| VER-63742 | AMI, UI - MC | MC CloudFormation template in existing VPN/subnet now provisions correctly. 现有 VPN/子网中的 MC CloudFormation 模板现在正确配置。 |
| VER-64645 | UI - MC | SMTP alerts now reliably received. SMTP 警报现在可靠地接收。 |
| VER-64705 | UI - MC | /opt/vconsole/mcdb/derby/mcdb/tmp permissions now maintained securely across restarts. /opt/vconsole/mcdb/derby/mcdb/tmp 的权限现在在重启间安全地维护。 |
| VER-61351 | Admin Tools | Adding large numbers of nodes at once no longer causes parsing error. 一次性添加大量节点不再导致解析错误。 |
| VER-60695 | Optimizer | Refresh on tables with multiple live aggregate projections now applies fast plan per projection. 对具有多个实时聚合投影的表执行 Refresh 现在为每个投影应用快速计划。 |
| VER-63861 | AP-Advanced | APPROXIMATE_COUNT_DISTINCT_SYNOPSIS no longer returns larger synopsis with NULLs. APPROXIMATE_COUNT_DISTINCT_SYNOPSIS 在包含 NULL 时不再返回更大的摘要。 |
| VER-45444 | DDL - Projection | Tuple Mover operations improved by fixing high default segmentation/sort columns in superprojections. 通过修复超投影中默认分段/排序列过高的问题改进了 Tuple Mover 操作。 |
| VER-64112 | Optimizer | Fixed node crash from very large expressions running out of stack. 修复了非常大的表达式耗尽堆栈导致的节点崩溃。 |
| VER-51210 | Execution Engine, Optimizer | ANY/ALL operators now correctly throw errors for array evaluation. ANY/ALL 运算符现在对数组求值正确抛出错误。 |
| VER-64351 | Tuple Mover | Fixed memory accumulation in Tuple Mover during extended heavy workloads. 修复了长时间重负载下 Tuple Mover 中的内存积累问题。 |
| VER-63844 | DDL - Projection | Catalog now stores correct information about pinned projections. 目录现在存储关于固定投影的正确信息。 |
| VER-63841 | Execution Engine | Fixed crash in regex scalar functions with certain long input strings. 修复了正则表达式标量函数在特定长输入字符串下的崩溃问题。 |
| VER-62988 | Data Load / COPY, Hadoop | Fixed crash from join of two external Parquet tables due to memory misalignment. 修复了由于内存对齐问题导致两个外部 Parquet 表连接时崩溃的问题。 |
| VER-58472 | UI - MC | MC can now import multiple clusters with same private IP addresses. MC 现在可以导入具有相同私有 IP 地址的多个集群。 |
| VER-61741 | Optimizer | Pinned projections created with just PINNED keyword no longer incorrectly treated as segmented. 仅使用 PINNED 关键字创建的固定投影不再被错误地视为分段投影。 |
| VER-63728 | Catalog Engine | Fixed memory leak from frequent CREATE/INSERT/DROP tables. 修复了频繁 CREATE/INSERT/DROP 表导致的内存泄漏。 |
| VER-63044 | Optimizer | Fixed internal error in MERGE USING and INSERT SELECT with subqueries under Outer Joins. 修复了在外连接下使用子查询的 MERGE USING 和 INSERT SELECT 中的内部错误。 |
| VER-62249 | Optimizer | Fixed GCLX timeout when creating external tables with problematic external file systems. 修复了在有问题的外部文件系统上创建外部表时的 GCLX 超时问题。 |
| VER-57071 | Optimizer | Fixed parsing failure when WITH clause aliases match regular table names. 修复了 WITH 子句别名与常规表名匹配时的解析失败问题。 |
| VER-64269 | UDX | Fixed "Function can't be used with an operator" error in CASE-like expressions over inline functions returning strings. 修复了在返回字符串的内联函数上的类 CASE 表达式中出现的"函数不能与运算符一起使用"错误。 |
| VER-47310 | Installation Program | Fixed installation on OpenStack virtual machines. 修复了在 OpenStack 虚拟机上的安装问题。 |
| VER-63969 | Front end - Parse & Analyze | Fixed VAssert(0) crash when meta-function used in materialized WITH clause. 修复了在物化 WITH 子句中使用元函数时的 VAssert(0) 崩溃问题。 |
| VER-64858 | Optimizer | Historical queries now fold stable functions into constants properly. 历史查询现在正确地将稳定函数折叠为常量。 |
| VER-64378 | Data Load / COPY | COPY with AUTO mode now properly handles TRICKLE mode when WOS pool is full. 使用 AUTO 模式的 COPY 现在在 WOS 池满时正确处理 TRICKLE 模式。 |
| VER-60916 | DDL, Hadoop | View creation no longer always plans the view query; can disable with DisableViewQueryPlanning. 视图创建不再总是规划视图查询；可以通过 DisableViewQueryPlanning 禁用。 |
| VER-60247 | Kafka Integration | Scheduler can now be configured and microbatches added dynamically while running. 调度程序现在可以在运行时进行配置并动态添加微批次。 |