跳转至

11.0.x Resolved issues

11.0.2-25

Updated 09/05/2023

Issue Key Component Description
VER-88819 Data load / COPY, Execution Engine On Vertica 11.0.2, loading malformed or corrupted parquet files could cause Vertica nodes to crash. Now, these circumstances produce an error.
在 Vertica 11.0.2 上,加载格式错误或损坏的 parquet 文件可能导致 Vertica 节点崩溃。现在,这些情况会产生错误。

11.0.2-24

Updated 08/29/2023

Issue Key Component Description
VER-88087 Execution Engine Queries with large tables stopped the DB as navigation indices consumed too much RAM; indices now use less RAM.
查询大表时导航索引消耗过多 RAM 导致数据库停止;索引现在使用更少的 RAM。
VER-88268 Data load / COPY, Execution Engine Malformed/corrupted parquet loading could crash nodes; now produces an error instead.
加载格式错误/损坏的 parquet 可能导致节点崩溃;现在会产生错误。
VER-88277 ComplexTypes Creating a local temp table with complex data type previously caused a node failure; resolved.
创建包含复杂数据类型的本地临时表此前会导致节点故障;已解决。
VER-88284 Performance tests NVL2 function caused Vertica to crash when returning an array type; resolved.
NVL2 函数在返回数组类型时导致 Vertica 崩溃;已解决。

11.0.2-23

Updated 07/27/2023

Issue Key Component Description
VER-87802 Optimizer Planning performance for updates on tables with thousands of columns using many SET USING clauses was improved.
对具有数千列并使用许多 SET USING 子句的表进行更新的计划性能已改进。

11.0.2-22

Updated 06/26/2023

Issue Key Component Description
VER-86941 Data Export, S3 Export to Parquet sometimes logged errors in a DC table for successful exports; resolved.
导出到 Parquet 有时在成功导出时仍会在 DC 表中记录错误;已解决。
VER-87257 Optimizer Merge queries with INTO...USING calling a subquery returned errors with Set Using/Default query columns; resolved.
带有 INTO...USING 调用子查询的合并查询在使用 Set Using/Default 查询列时返回错误;已解决。
VER-87296 Optimizer Queries eligible for TOPK projections and no-op join elimination sometimes exited with internal error; resolved.
符合 TOPK 投影和无操作连接消除条件的查询有时会以内部错误退出;已解决。

11.0.2-21

Updated 06/06/2023

Issue Key Component Description
VER-85650 Database Designer Core DESIGNER_DESIGN_PROJECTION_ENCODINGS returned an error if design name contained a period; resolved.
如果设计名称包含句点,DESIGNER_DESIGN_PROJECTION_ENCODINGS 返回错误;已解决。
VER-86343 Data load / COPY TOCTOU privilege escalation check issued false positives when a file is appended during COPY; updated.
当文件在 COPY 期间被追加时,TOCTOU 权限提升检查发出误报;已更新。
VER-86348 Admin Tools, Security Paramiko upgraded to 2.10.1 to address CVE-2022-24302.
Paramiko 已升级到 2.10.1 以解决 CVE-2022-24302。
VER-87121 Kafka Integration, Security Kafka Notifier with SASL_SSL or SASL_PLAINTEXT incorrectly used SSL instead; fixed.
使用 SASL_SSL 或 SASL_PLAINTEXT 的 Kafka Notifier 错误地使用了 SSL;已修复。
VER-87145 Catalog Engine Truncating a local temp table unnecessarily required a global catalog lock; resolved.
截断本地临时表不必要地需要全局目录锁;已解决。

11.0.2-20

Updated 04/12/2023

Issue Key Component Description
VER-85442 AMI Vertica server AMI and SSH configurations updated to use more secure ciphers.
Vertica 服务器 AMI 和 SSH 配置已更新以使用更安全的密码。
VER-85572 Catalog Engine Typemod changes for array bounds were not accounted for in odbc_columns/jdbc_columns, causing inconsistent TIMESTAMP column definitions; resolved.
数组边界的 Typemod 更改未在 odbc_columns/jdbc_columns 中考虑,导致 TIMESTAMP 列定义不一致;已解决。

11.0.2-19

Updated 02/21/2023

Issue Key Component Description
VER-85078 UI - Management Console Two Activity pages erroneously referenced columns in system tables that were deleted; resolved.
两个 Activity 页面错误地引用了系统表中已删除的列;已解决。
VER-85238 Security LDAP starttls parameter is no longer deprecated and should generally be used when TLS config isn't granular enough.
LDAP starttls 参数不再被弃用,当 TLS 配置不够精细化时通常应使用。
VER-85494 Tuple Mover Mergeout strata algorithm had overflow due to incorrect type casting for projections with >4095 columns; resolved.
由于对超过 4095 列的投影进行了不正确的类型转换,Mergeout strata 算法发生溢出;已解决。

11.0.2-18

Updated 12/01/2022

Issue Key Component Description
VER-84168 Procedural Languages Running ANALYZE_STATISTICS via stored procedure without superuser privileges sometimes caused DB crash; resolved.
通过存储过程以非超级用户权限运行 ANALYZE_STATISTICS 有时导致数据库崩溃;已解决。
VER-84172 Data Export Export to delimited no longer restricts using same char for both 'escapeAs' and 'enclosedBy'.
导出到分隔格式不再限制对 'escapeAs' 和 'enclosedBy' 使用相同字符。
VER-84174 Control Networking Standby nodes no longer set as control nodes; previously changed assignment of control nodes and fault groups.
备用节点不再被设置为控制节点;此前会改变控制节点和故障组的分配。
VER-84241 Optimizer Queries with string expressions in SELECT that were part of other expressions with constants sometimes returned error; resolved.
SELECT 中包含作为带常量表达式一部分的字符串表达式的查询有时返回错误;已解决。
VER-84245 Backup/DR vbr listbackup failed when nodes in [mapping] didn't match DB nodes; now returns warning instead.
当 [mapping] 中的节点与数据库节点不匹配时,vbr listbackup 失败;现在返回警告。
VER-84412 Backup/DR vbr raised error trying to load error message as json when vertica-download-file failed; improved error handling.
当 vertica-download-file 失败时,vbr 尝试将错误消息作为 json 加载而引发错误;改进了错误处理。
VER-84525 Admin Tools Admintools pseudoterminal data transfer with ssh+expect ignored canonical mode setting for >4k data; resolved.
Admintools 使用 ssh+expect 的伪终端数据传输忽略了超过 4k 数据的规范模式设置;已解决。

11.0.2-17

Updated 11/16/2022

Issue Key Component Description
VER-83717 Client Drivers - JDBC, Client Drivers - VSQL, Execution Engine KeepAlive parameters now default to 0 (NULL) so kernel TCP keepalive settings are used, overriding the 12.0.0 change.
KeepAlive 参数现在默认为 0(NULL),因此使用内核 TCP keepalive 设置,覆盖了 12.0.0 的更改。
VER-83733 UI - Management Console timestamptz column microsecond values truncated in MC; DB server timestamps with zone offset now properly represented.
timestamptz 列微秒值在 MC 中被截断;带时区偏移的数据库服务器时间戳现在正确表示。
VER-83751 Backup/DR VBR uploads to S3 that failed now retry the upload operation.
VBR 上传到 S3 失败时现在重试上传操作。
VER-83859 Backup/DR Backup/restore on FIPS-enabled systems with S3 failed due to MD5 unavailability; resolved by flagging MD5 as not-for-security.
在启用 FIPS 的系统上使用 S3 进行备份/恢复因 MD5 不可用而失败;通过将 MD5 标记为非安全用途来解决。
VER-83922 Optimizer UPDATE referencing a column with an access policy applied the rule twice instead of once; resolved.
引用具有访问策略的列的 UPDATE 将规则应用了两次而不是一次;已解决。
VER-84000 Admin Tools, Security Upgraded urllib3 (1.26.5) and bottle (0.12.20) to fix CVE-2021-28363.
已升级 urllib3 (1.26.5) 和 bottle (0.12.20) 以修复 CVE-2021-28363。

11.0.2-16

Updated 09/28/2022

Issue Key Component Description
VER-83307 Kafka Integration Vertica crashed when exporting data to Kafka under certain conditions; resolved.
Vertica 在特定条件下导出数据到 Kafka 时崩溃;已解决。
VER-83465 Security LDAP Link service could fail to create users due to circular assignment after first sync; resolved.
LDAP Link 服务在首次同步后可能因循环分配而无法创建用户;已解决。
VER-83482 Database Designer Core DBD processing queries referencing non-table objects (e.g., projections with pre-aggregated data) sometimes crashed; DBD now skips such queries.
DBD 处理引用非表对象(例如具有预聚合数据的投影)的查询时有时崩溃;DBD 现在跳过此类查询。
VER-83485 Security LDAP Link service could fail creating users due to circular assignment after first sync; resolved.
LDAP Link 服务在首次同步后可能因循环分配而无法创建用户;已解决。
VER-83548 Catalog Engine System table vs_storage_reference_counts was not updating num_accesses counter values; resolved.
系统表 vs_storage_reference_counts 未更新 num_accesses 计数器值;已解决。

11.0.2-15

Updated 09/12/2022

Issue Key Component Description
VER-83072 Optimizer UNION on EON subclusters resegmented grouped UNION leg outputs even when segmented on group keys; resolved, improving performance.
EON 子集群上的 UNION 即使在组键上分段时也会重新分段分组的 UNION 分支输出;已解决,改进了性能。
VER-83089 Backup/DR vbr calls to AWS DeleteObjects() didn't handle SlowDown errors gracefully; boto3 retry logic changed.
vbr 调用 AWS DeleteObjects() 时未能优雅处理 SlowDown 错误;boto3 重试逻辑已更改。
VER-83195 UI - Management Console Extended Monitoring page showed no data if DB with extended monitoring went down; resolved.
如果启用了扩展监控的数据库宕机,扩展监控页面不显示数据;已解决。

11.0.2-14

Updated 08/19/2022

Issue Key Component Description
VER-82378 Admin Tools Adding two nodes to a one-node enterprise DB required rebalance and K-safe; command-line and GUI attempts failed; resolved.
向单节点企业数据库添加两个节点需要重新平衡和 K-safe;命令行和 GUI 尝试均失败;已解决。
VER-82630 Client Drivers - VSQL vsql now returns error code when encountering an error during a long query exceeding RUNTIMECAP.
vsql 现在在超过 RUNTIMECAP 的长查询遇到错误时返回错误码。
VER-82636 Optimizer Querying a partition range projection with a column defined by an expression from another column sometimes crashed the server; resolved.
查询具有由另一列表达式定义的列的分区范围投影有时导致服务器崩溃;已解决。
VER-82760 Execution Engine, Optimizer Join output requiring sorting with multiple equivalent sort keys didn't maintain keys fully, causing incorrect results; resolved.
需要排序且具有多个等效排序键的连接输出未能完全维护键,导致错误结果;已解决。
VER-82775 Execution Engine makeutf8 function caused undefined behavior with maximum-length inputs; resolved.
makeutf8 函数在最大长度输入下导致未定义行为;已解决。
VER-82805 Backup/DR Restoring backup to another DB with different communal storage failed startup if oid was assigned elsewhere; resolved.
如果 oid 已分配到他处,将备份恢复到具有不同公共存储的其他数据库时启动失败;已解决。
VER-82815 Data Export, Data load / COPY, Hadoop Partition values containing '/' in file paths were read incorrectly; resolved.
文件路径中包含 '/' 的分区值被错误读取;已解决。
VER-82850 DDL - Table After table rename, projection definition wasn't updated; projection no longer references old table name as alias.
表重命名后,投影定义未更新;投影不再引用旧表名作为别名。
VER-82881 DDL Vertica no longer allows partition expressions that produce NULL values even if expression columns contain no NULLs.
Vertica 不再允许产生 NULL 值的分区表达式,即使表达式列本身不包含 NULL。
VER-82906 Depot Data loading plan incorrectly returned error about file size mismatch when depot had no space; resolved.
当 depot 空间不足时,数据加载计划错误地返回文件大小不匹配的错误;已解决。
VER-82942 Client Drivers - JDBC JDBC BinaryTransfer with JVM timezone having DST schedule returned incorrect data for DST start dates; resolved, though DATE performance is worse than TextTransfer.
具有夏令时安排的 JVM 时区下的 JDBC BinaryTransfer 在夏令时开始日期返回错误数据;已解决,但 DATE 性能不如 TextTransfer。
VER-82969 Data load / COPY Flex table parsers didn't reserve enough buffer for certain NUMERIC-type inputs; resolved.
Flex 表解析器未为某些 NUMERIC 类型输入保留足够的缓冲区;已解决。

11.0.2-13

Updated 07/11/2022

Issue Key Component Description
VER-82382 AP-Geospatial ST_GeomFromGeoJSON returned non-null result on null input; resolved.
ST_GeomFromGeoJSON 在 null 输入时返回非 null 结果;已解决。

11.0.2-12

Updated 06/23/2022

Issue Key Component Description
VER-81853 UI - Management Console MC couldn't start DB if communal storage URL ended with backslash; resolved.
如果公共存储 URL 以反斜杠结尾,MC 无法启动数据库;已解决。
VER-81863 Hadoop Configuration parameter UseServerIdentityOverUserIdentity omitted from configuration_parameters table; now included.
配置参数 UseServerIdentityOverUserIdentity 从 configuration_parameters 表中遗漏;现已包含。
VER-82037 Execution Engine Counter renamed from "number of bytes read from communal storage" to "number of bytes read from persistent storage."
计数器名称从 "number of bytes read from communal storage" 更改为 "number of bytes read from persistent storage."
VER-82042 Execution Engine EnablePredicateRemoval parameter caused performance regressions in certain queries; regression resolved.
EnablePredicateRemoval 参数导致某些查询性能退化;退化已解决。
VER-82246 Execution Engine Queries on VARBINARY(16) data type performed suboptimally; resolved.
对 VARBINARY(16) 数据类型的查询性能不够理想;已解决。

11.0.2-11

Updated 05/27/2022

Issue Key Component Description
VER-81739 UI - Management Console Some cookie features not set properly in HTTP headers; resolved.
某些 Cookie 功能未在 HTTP 标头中正确设置;已解决。
VER-81770 Tuple Mover Tuple Mover used slow SysInfo function for storage location size; now gets info from resource manager.
Tuple Mover 使用了缓慢的 SysInfo 函数获取存储位置大小;现在从资源管理器获取信息。
VER-81776 Optimizer DBD functions DESIGNER_ADD_DESIGN_QUERIES and DESIGNER_RUN_POPULATE_DESIGN_AND_DEPLOY now support communal storage locations.
DBD 函数 DESIGNER_ADD_DESIGN_QUERIES 和 DESIGNER_RUN_POPULATE_DESIGN_AND_DEPLOY 现在支持公共存储位置。
VER-81808 Catalog Engine Querying system tables referencing vs_segment in DB with many projections exceeded MaxParsedQuerySizeMB; resolved.
在具有许多投影的数据库中查询引用 vs_segment 的系统表超过了 MaxParsedQuerySizeMB;已解决。
VER-81850 Tuple Mover Mergeout plans converting StorageMerge to StorageUnion+Sort slowed mergeout; no longer converted.
将 StorageMerge 转换为 StorageUnion+Sort 的 Mergeout 计划减慢了 mergeout 速度;不再进行转换。
VER-81914 Execution Engine Running analyze_statistics caused slowdowns on concurrent queries with StorageMerge operators; resolved.
运行 analyze_statistics 导致具有 StorageMerge 运算符的并发查询变慢;已解决。

11.0.2-10

Updated 05/05/2022

Issue Key Component Description
VER-81386 Backup/DR vbr returned error connecting to Vertica through non-primary subscriber node during Eon replication; resolved.
vbr 在 Eon 复制期间通过非主要订阅者节点连接到 Vertica 时返回错误;已解决。
VER-81559 UI - Management Console Alert email for Node State Change custom threshold was not sent; resolved.
节点状态更改自定义阈值的警报电子邮件未发送;已解决。

11.0.2-9

Updated 04/21/2022

Issue Key Component Description
VER-81357 Admin Tools Replacing a down node in admintools GUI, db_replace_node, or restart_node --force failed; resolved.
在 admintools GUI 中替换故障节点、db_replace_node 或 restart_node --force 失败;已解决。

11.0.2-8

Updated 04/18/2022

Issue Key Component Description
VER-81044 UI - Management Console When AWS cluster scaled up, MC didn't load all data with custom file system and key pair not populated; resolved.
AWS 集群扩展时,MC 未加载所有数据,自定义文件系统和密钥对未填充;已解决。
VER-81048 Execution Engine Event series join crashed when initializing cached rows with wrong tuple schema; now uses correct schema.
事件序列连接在初始化缓存行时使用了错误的元组架构导致崩溃;现在使用正确的架构。
VER-81144 Admin Tools admintools re_ip options -T and -U didn't update admintools.conf with correct control messaging protocol; resolved.
admintools re_ip 的 -T 和 -U 选项未使用正确的控制消息协议更新 admintools.conf;已解决。
VER-81254 Data load / COPY Operations over directories with many external data files on object stores consumed excess CPU; algorithm improved.
对象存储上包含许多外部数据文件的目录操作消耗过多 CPU;算法已改进。
VER-81255 Client Drivers - JDBC, Sessions Each node now uses TCP keepalive to detect disconnection and free resources for clients.
每个节点现在使用 TCP keepalive 检测断开连接并为客户端释放资源。
VER-81269 Data Collector Setting an empty channel in SET_DATA_COLLECTOR_NOTIFY_POLICY is now disallowed.
现在禁止在 SET_DATA_COLLECTOR_NOTIFY_POLICY 中设置空通道。
VER-81278 UI - Management Console MC database now restored after upgrade when /tmp files removed; previously clients lost data.
升级后当 /tmp 文件被移除时,MC 数据库现在可以恢复;此前客户端会丢失数据。

11.0.2-7

Updated 03/29/2022

Issue Key Component Description
VER-80840 Execution Engine IN expression evaluation detection was flawed for non-subquery/non-constant cases, sometimes causing crashes; resolved.
IN 表达式求值检测在非子查询/非常量情况下存在缺陷,有时导致崩溃;已解决。
VER-80847 AP-Geospatial STV_Create_Index could create incorrect indexes on large polygon sets, causing query failure or node crashes; resolved.
STV_Create_Index 可能在大型多边形集上创建错误索引,导致查询失败或节点崩溃;已解决。
VER-80895 Backup/DR, Migration Tool After migrating from Enterprise to Eon mode, loading data into unsegmented projections could fail; resolved.
从 Enterprise 模式迁移到 Eon 模式后,向非分段投影加载数据可能失败;已解决。
VER-80898 Admin Tools db_add_node failed if first node in cluster was down; now uses any UP node for syncing.
如果集群中的第一个节点宕机,db_add_node 失败;现在使用任意 UP 节点进行同步。
VER-80906 UI - Management Console MC saved DBD-generated design only when K-safety was 0; now saves regardless of K-safety setting.
MC 仅在 K-safety 为 0 时保存 DBD 生成的设计;现在无论 K-safety 设置如何都保存。
VER-80909 UI - Management Console MC included unsupported characters in IAM role name from key pair name, blocking cluster creation; now removes them.
MC 从密钥对名称中包含了 IAM 角色名称中的不支持字符,阻止了集群创建;现在会移除它们。
VER-80911 Optimizer Live aggregate projections had difficulty rewriting AVG() with INT argument; resolved.
实时聚合投影在重写带有 INT 参数的 AVG() 时遇到困难;已解决。
VER-80914 Monitoring ros_count column in projection_storage was removed in 11.0.2; now restored per client requests.
projection_storage 中的 ros_count 列在 11.0.2 中被移除;现根据客户请求已恢复。
VER-80916 UI - Management Console Same as VER-80909 — unsupported characters in IAM role name removed.
同 VER-80909 — 移除了 IAM 角色名称中不支持字符。
VER-80918 Data Networking TCP connections considered alive for down nodes causing query stalls/hangs; improved TCP connection handling.
TCP 连接对故障节点被视为活动状态导致查询停滞/挂起;改进了 TCP 连接处理。

11.0.2-6

Updated 03/04/2022

Issue Key Component Description
VER-80630 Client Drivers - JDBC, Execution Engine JDBC/ADO.net binary encoding queries with NUMERIC literals using parameterized prepared statements had incorrect precision/scale; resolved.
JDBC/ADO.net 使用参数化预准备语句的 NUMERIC 文字二进制编码查询具有错误的精度/标度;已解决。
VER-80738 Execution Engine regexp_like() returned incorrect results when regex contained zero-match characters like "?" and ""; resolved.
regexp_like() 在正则表达式包含零匹配字符(如 "?" 和 "
")时返回错误结果;已解决。

11.0.2-5

Updated 02/17/2022

Issue Key Component Description
VER-80474 Backup/DR On LINUX_FILESYSTEM, snapshot backup failed if stat() error occurred between glob() and stat(); snapshot now only calls stat().
在 LINUX_FILESYSTEM 上,如果在 glob() 和 stat() 之间发生 stat() 错误,快照备份失败;快照现在只调用 stat()。
VER-80477 ComplexTypes Nested case statement parsing became inefficient; now linear in number of nesting levels.
嵌套 case 语句解析变得低效;现在与嵌套层数成线性关系。
VER-80498 Optimizer, Performance tests analyze_statistics('') on large catalog ran out of memory or triggered OOM; resolved.
在大型目录上运行 analyze_statistics('') 耗尽内存或触发 OOM;已解决。
VER-80524 ComplexTypes, Execution Engine Expressions with "subquery." as arguments could cause undefined behavior; now expands into complex ROW expression.
以 "subquery.
" 作为参数的表达式可能导致未定义行为;现在扩展为复杂的 ROW 表达式。
VER-80532 Kafka Integration KafkaExport returns when detecting all messages sent, reducing execution time up to 10 seconds.
KafkaExport 在检测到所有消息已发送时返回,减少最多 10 秒的执行时间。
VER-80548 DDL IMPORT_STATISTICS couldn't import from EXPORT_STATISTICS_PARTITION output; resolved.
IMPORT_STATISTICS 无法从 EXPORT_STATISTICS_PARTITION 输出导入;已解决。

11.0.2-4

Updated 01/28/2022

Issue Key Component Description
VER-80423 Client Drivers - ADO VARCHAR and LONGVARCHAR had incorrect SqlType mappings; now consistently map to 12 and -1 respectively.
VARCHAR 和 LONGVARCHAR 具有错误的 SqlType 映射;现在分别一致映射到 12 和 -1。
VER-80440 ComplexTypes Vertica crashed when adding a column with default to a table with complex type columns; now returns error.
向具有复杂类型列的表添加带有默认值的列时 Vertica 崩溃;现在返回错误。
VER-80451 Execution Engine, UDX RIGHT function was an inline SQL function that returned error with volatile UDA parameter; now defined internally.
RIGHT 函数是一个内联 SQL 函数,使用易变 UDA 参数时返回错误;现在在内部定义。

11.0.2-3

Updated 01/25/2022

Issue Key Component Description
VER-80234 Admin Tools create_db failed in FIPS mode; resolved.
create_db 在 FIPS 模式下失败;已解决。
VER-80236 Backup/DR vbr misinterpreted newline characters in multi-line vsql output, causing query result misattribution; now correctly detects end of each query result.
vbr 误解了多行 vsql 输出中的换行符,导致查询结果归因错误;现在正确检测每个查询结果的结尾。
VER-80238 Recovery After rebalance, Tuple Mover now groups ROS containers in batches smaller than MaxMrgOutROSSizeMB; larger containers merged individually.
重新平衡后,Tuple Mover 现在将小于 MaxMrgOutROSSizeMB 的 ROS 容器分批分组;较大的容器单独合并。
VER-80371 DDL, Execution Engine Server crashed when system queries used large strings as predicate constants; resolved.
当系统查询使用大字符串作为谓词常量时服务器崩溃;已解决。

11.0.2-2

Updated 01/11/2022

Issue Key Component Description
VER-80157 UI - Management Console Apache log4j CVE-2021-45105 vulnerability in MC; library updated.
MC 中的 Apache log4j CVE-2021-45105 漏洞;库已更新。
VER-80168 Kafka Integration log4j CVEs CVE-2021-45105 and CVE-2021-44832 in Kafka integration; library updated.
Kafka 集成中的 log4j CVE-2021-45105 和 CVE-2021-44832 漏洞;库已更新。
VER-80242 UI - Management Console log4j CVE-2021-44832 in MC; library updated.
MC 中的 log4j CVE-2021-44832 漏洞;库已更新。
VER-80252 Execution Engine Ill-formed predicates with many fields caused OOM while returning error message; now can build operator-not-found errors regardless of length.
包含许多字段的格式错误谓词在返回错误消息时导致 OOM;现在无论长度如何都可以构建 operator-not-found 错误。

11.0.2-0

Updated 12/23/2021

Issue Key Component Description
VER-50526 Data Removal - Delete, Purge, Partitioning, EON Eon mode now supports optimized delete and merge for unsegmented projections.
Eon 模式现在支持非分段投影的优化删除和合并。
VER-77427 Client Drivers - JDBC JDBC truststore and password fallback logic improved — checks default JVM locations and uses "changeit" when unspecified.
JDBC truststore 和密码回退逻辑已改进——检查默认 JVM 位置并在未指定时使用 "changeit"。
VER-78338 Execution Engine query_consumption calculated peak_memory_kb by summing across nodes; now finds max among nodes.
query_consumption 通过跨节点求和计算 peak_memory_kb;现在在节点间取最大值。
VER-78671 Execution Engine Query predicates reordered at runtime caused failures comparing numeric values to non-numeric strings like 'abc'; resolved.
运行时重排序的查询谓词导致将数值与非数字字符串(如 'abc')比较时失败;已解决。
VER-78833 Optimizer Optimizer occasionally chose regular projection even when directed to use LAP/Top-K projections; resolved.
优化器偶尔会选择常规投影,即使被指示使用 LAP/Top-K 投影;已解决。
VER-79001 Admin Tools Starting EncryptSpreadComm-enabled DB with "command_host -c start" or "restart_node" now gives useful error directing use of start_db.
使用 "command_host -c start" 或 "restart_node" 启动启用了 EncryptSpreadComm 的数据库时,现在会给出有用错误提示使用 start_db。
VER-79057 Backup/DR Hash function changed in 11.0; backup manifest digests from pre-11 releases now have mismatches ignored.
哈希函数在 11.0 中已更改;来自 11 之前版本的备份清单摘要的不匹配现在被忽略。
VER-79085 Admin Tools, Database Designer Core admintools rebalance_data with ksafe=1 returned error when DB K-safety was 0; resolved.
当数据库 K-safety 为 0 时,admintools rebalance_data 设置 ksafe=1 返回错误;已解决。
VER-79135 Client Drivers - JDBC getAdjustedTimestamp() now properly returns timestamp based on session timezone in both text and binary transfer modes.
getAdjustedTimestamp() 现在在文本和二进制传输模式下都正确基于会话时区返回时间戳。
VER-79141 Tuple Mover MaxDVROSPerContainer knob now accepts any value >1 with new formula: "max(2, (MaxDVROSPerContainer+1)/2)" — two-level strata avoids excessive DVMergeouts.
MaxDVROSPerContainer 参数现在接受任何大于 1 的值,使用新公式 "max(2, (MaxDVROSPerContainer+1)/2)"——两级分层避免了过多的 DVMergeout。
VER-79146 EON, ResourceManager Subcluster-level resource pool creation now supports cpuaffinityset and cpuaffinitymode.
子集群级资源池创建现在支持 cpuaffinityset 和 cpuaffinitymode。
VER-79180 UI - Management Console Feedback feature now sends information by email instead of uploading.
反馈功能现在通过电子邮件发送信息,而不是上传。
VER-79236 Tuple Mover DVMergeout no longer accesses storage files during plan compilation to determine column offsets/length, avoiding S3 API calls.
DVMergeout 不再在计划编译期间访问存储文件来确定列偏移量/长度,避免 S3 API 调用。
VER-79259 FlexTable MapToString returned null when underlying VMap was not null in rare cases; fixed (no data loss).
MapToString 在底层 VMap 不为空时在极少数情况下返回 null;已修复(无数据丢失)。
VER-79349 Data Export, S3 S3EXPORT failed to authenticate server certificate via https without aws_ca_bundle; system CA bundle now used by default.
S3EXPORT 在没有 aws_ca_bundle 的情况下通过 https 验证服务器证书失败;现在默认使用系统 CA 包。
VER-79350 Optimizer Joins with interpolated predicate didn't recognize equivalency between date/time types specifying and omitting precision; resolved.
带有插值谓词的连接未能识别指定和省略精度的日期/时间类型之间的等价性;已解决。
VER-79383 Execution Engine Database crashed when query plans with filter operators canceled on rare occasions; resolved.
当带有过滤运算符的查询计划在极少数情况下被取消时数据库崩溃;已解决。
VER-79475 Hadoop hdfs_cluster_config_check failed on SSL-enabled HDFS clusters; fixed.
hdfs_cluster_config_check 在启用 SSL 的 HDFS 集群上失败;已修复。
VER-79510 Admin Tools Admintools now uses data base path as set in admintools.conf, distinct from catalog path base.
Admintools 现在使用 admintools.conf 中设置的数据基础路径,与目录路径基础不同。
VER-79513 Optimizer Flaws in duplicate key checking logic under certain conditions; resolved.
在特定条件下重复键检查逻辑中的缺陷;已解决。
VER-79548 Scrutinize 11.0 agent change prevented scrutinize from sending zip files; resolved.
11.0 代理更改阻止了 scrutinize 发送 zip 文件;已解决。
VER-79562 Depot copy_partitions_to_table on two tables with same pinning policies where target had no projection data crashed server; resolved.
在两个具有相同固定策略且目标没有投影数据的表上执行 copy_partitions_to_table 导致服务器崩溃;已解决。
VER-79742 Security Changes to LDAPLinkURL and LDAPLinkSearchBase orphaned LDAPLinked users; users no longer orphaned if new URL/search base contains same users.
更改 LDAPLinkURL 和 LDAPLinkSearchBase 导致 LDAPLinked 用户孤立;如果新 URL/搜索基础包含相同用户,则不再孤立用户。
VER-79757 Kafka Integration Certain Kafka notifier errors tried to allocate memory pool twice triggering assert; resolved.
某些 Kafka notifier 错误尝试两次分配内存池触发断言;已解决。
VER-79820 Backup/DR Multi-line vsql output misattribution issue (same as VER-80236); newline detection fixed.
多行 vsql 输出归因错误问题(同 VER-80236);换行符检测已修复。

11.0.1-3

Updated 12/16/2021

Issue Key Component Description
VER-79881 Tuple Mover Same as VER-79141 — MaxDVROSPerContainer formula updated: "max(2, (MaxDVROSPerContainer+1)/2)".
同 VER-79141 — MaxDVROSPerContainer 公式已更新:"max(2, (MaxDVROSPerContainer+1)/2)"。
VER-79886 Scrutinize Same as VER-79548 — scrutinize prevented from sending zip files; resolved.
同 VER-79548 — scrutinize 无法发送 zip 文件;已解决。
VER-79910 Security Same as VER-79742 — LDAPLinkURL/LDAPLinkSearchBase changes no longer orphan users.
同 VER-79742 — LDAPLinkURL/LDAPLinkSearchBase 更改不再孤立用户。
VER-80080 Kafka Integration Log4j library updated addressing CVE-2021-44228 and CVE-2021-45046.
log4j 库已更新以解决 CVE-2021-44228 和 CVE-2021-45046。
VER-80081 UI - Management Console Log4j library updated addressing CVE-2021-44228 and CVE-2021-45046.
log4j 库已更新以解决 CVE-2021-44228 和 CVE-2021-45046。

11.0.1-2

Updated 11/24/2021

Issue Key Component Description
VER-79278 UI - Management Console KPI dropdown on Manage page didn't open correctly; Activity Page showed as unauthorized; resolved.
Manage 页面上的 KPI 下拉菜单未正确打开;Activity 页面显示为未授权;已解决。
VER-79587 Backup/DR Same as VER-79057 — manifest digest mismatches from pre-11 backups ignored.
同 VER-79057 — 忽略来自 11 之前版本的备份清单摘要不匹配。
VER-79621 Optimizer Same as VER-78833 — optimizer occasionally chose regular projection over LAP/Top-K; resolved.
同 VER-78833 — 优化器偶尔选择常规投影而非 LAP/Top-K;已解决。
VER-79667 FlexTable Same as VER-79259 — MapToString returned null when VMap was not null; resolved.
同 VER-79259 — MapToString 在 VMap 不为空时返回 null;已解决。
VER-79743 Hadoop Same as VER-79475 — hdfs_cluster_config_check failed on SSL-enabled clusters; resolved.
同 VER-79475 — hdfs_cluster_config_check 在启用 SSL 的集群上失败;已解决。
VER-79780 Data Removal - Delete, Purge, Partitioning Eon mode now supports optimized delete and merge for unsegmented projections.
Eon 模式现在支持非分段投影的优化删除和合并。

11.0.1-1

Updated 11/10/2021

Issue Key Component Description
VER-79417 Tuple Mover Same as VER-79236 — DVMergeout no longer accesses storage files during plan compilation.
同 VER-79236 — DVMergeout 不再在计划编译期间访问存储文件。
VER-79516 Execution Engine Same as VER-79383 — DB crashed when filter operator query plans canceled; resolved.
同 VER-79383 — 过滤运算符查询计划取消时数据库崩溃;已解决。
VER-79525 Data Export, S3 Same as VER-79349 — S3EXPORT authentication with https; system CA bundle used by default.
同 VER-79349 — S3EXPORT 使用 https 认证;默认使用系统 CA 包。
VER-79535 Admin Tools, Database Designer Front-End/UI Same as VER-79085 — rebalance_data with ksafe=1 error when K-safety=0; resolved.
同 VER-79085 — 当 K-safety=0 时 rebalance_data 设置 ksafe=1 出现错误;已解决。
VER-79540 Admin Tools, Database Designer Core Same as VER-79085.
同 VER-79085。
VER-79581 Admin Tools Same as VER-79510 — admintools uses data base path distinct from catalog path base.
同 VER-79510 — admintools 使用与目录路径基础不同的数据基础路径。

11.0.1-0

Updated 10/25/2021

Issue Key Component Description
VER-67295 Security LDAPLink now properly handles nested groups.
LDAPLink 现在正确处理嵌套组。
VER-68210 UI - Management Console MC failed to import DB containing a table named "users" in public schema; resolved.
MC 导入包含 public 模式中名为 "users" 的表的数据库失败;已解决。
VER-75768 Data Removal - Delete, Purge, Partitioning drop_location now returns error if storage location contains temporary table data.
如果存储位置包含临时表数据,drop_location 现在返回错误。
VER-75794 Data Removal - Delete, Purge, Partitioning CALENDAR_HIERARCHY_DAY with active_years/active_months set to 0 now returns a warning about considerable I/O.
CALENDAR_HIERARCHY_DAY 将 active_years/active_months 设置为 0 时,现在会返回关于大量 I/O 的警告。
VER-77175 Execution Engine Sessions using User Defined Load code accumulated memory on non-initiator nodes through session life; resolved.
使用用户定义加载代码的会话在整个会话生命周期中在非发起者节点上累积内存;已解决。
VER-77583 Installation: Server RPM/Deb Python scripts using old print command updated for Python 3 compatibility.
使用旧 print 命令的 Python 脚本已更新以兼容 Python 3。
VER-77688 Documentation Script to backup/restore UDx library grants in documentation corrected.
文档中用于备份/恢复 UDx 库授权的脚本已更正。
VER-77771 Documentation Documentation now warns not to embed spaces before/after comma delimiters in --restore-objects list.
文档现在警告不要在 --restore-objects 列表中的逗号分隔符前后嵌入空格。
VER-77818 Client Drivers - ADO Canceled query with immediate DataReader.close() left cleanup incomplete and propagated exception; resolved.
取消查询后立即调用 DataReader.close() 导致清理不完整并传播异常;已解决。
VER-77999 Kafka Integration Loading small messages with filters like KafkaInsertDelimiters could return VIAssert error; resolved.
使用 KafkaInsertDelimiters 等过滤器加载小消息可能返回 VIAssert 错误;已解决。
VER-78001 Backup/DR Full restore no longer overwrites AWS configuration parameters (AWSEndpoint, AWSAuth, AWSEnableHttps) with backup settings.
完全恢复不再使用备份设置覆盖 AWS 配置参数(AWSEndpoint、AWSAuth、AWSEnableHttps)。
VER-78313 Optimizer Memory consumption issues improved — memory allocated to query tree objects freed when no longer in use.
内存消耗问题已改进——分配给查询树对象的内存在不再使用时释放。
VER-78391 Admin Tools Package installation md5sum mismatch error message improved to show mismatch as failure reason.
包安装的 md5sum 不匹配错误消息已改进,显示不匹配为失败原因。
VER-78470 DDL - Table Table drop operation not always logged; resolved.
表删除操作未始终记录;已解决。
VER-78555 Database Designer Core Database Designer generated files with wrong permissions; resolved.
Database Designer 生成了具有错误权限的文件;已解决。
VER-78576 ComplexTypes Constant folding incorrectly folded IN expressions with string value lists; fixed.
常量折叠错误地折叠了带有字符串值列表的 IN 表达式;已修复。
VER-78577 UI - Management Console MC returned errors configuring email gateway aliases with hyphen (-) characters; resolved.
MC 配置包含连字符 (-) 的电子邮件网关别名时返回错误;已解决。
VER-78578 DDL ALTER TABLE to change column data type threw syntax error if column name embedded a period with DEFAULT/SET USING; resolved.
如果列名嵌入了句点并使用了 DEFAULT/SET USING,ALTER TABLE 更改列数据类型时会抛出语法错误;已解决。
VER-78612 Catalog Engine COPY rejected data to table became unreadable after node removal; rejected data now readable from any UP node.
节点移除后,COPY 拒绝数据写入的表变得不可读;拒绝的数据现在可从任何 UP 节点读取。
VER-78619 Execution Engine Queries on EXTERNAL_TABLE_DETAILS with complex predicates returned wrong results or crashed cluster; resolved.
对 EXTERNAL_TABLE_DETAILS 使用复杂谓词的查询返回错误结果或导致集群崩溃;已解决。
VER-78632 Optimizer Multiple distinct aggregates sometimes produced wrong results with same-segmentation inputs; resolved.
多个不同聚合函数有时在相同分段输入上产生错误结果;已解决。
VER-78682 Data Removal - Delete, Purge, Partitioning, DDL SWAP_PARTITIONS_BETWEEN_TABLES now ignores metadata differences in epoch columns when comparing types.
SWAP_PARTITIONS_BETWEEN_TABLES 现在在比较类型时忽略 epoch 列中的元数据差异。
VER-78726 Optimizer Partition statistics now support partition expressions including date_trunc().
分区统计信息现在支持包含 date_trunc() 的分区表达式。
VER-78730 DDL ENABLE_WITH_CLAUSE_MATERIALIZATION hint didn't enable materialization; resolved.
ENABLE_WITH_CLAUSE_MATERIALIZATION 提示未启用物化;已解决。
VER-78750 Catalog Engine CatalogSyncInterval changes now immediately implemented rather than waiting for next scheduled sync.
CatalogSyncInterval 更改现在立即生效,而不是等待下一个计划同步。
VER-78767 Optimizer Adding column with default including TIMESERIES clause returned ROLLBACK; resolved.
添加包含 TIMESERIES 子句的默认值的列返回 ROLLBACK;已解决。
VER-78856 DDL - Projection, Optimizer Eligible predicates not pushed down into subqueries with LIMIT OVER clause; resolved.
符合条件的谓词未被下推到带有 LIMIT OVER 子句的子查询中;已解决。
VER-78969 Hadoop Parquet export with over 2^31 rows caused node failures; limit raised to 2^64 rows.
超过 2^31 行的 Parquet 导出导致节点故障;限制已提高到 2^64 行。
VER-79260 UI - Management Console Feedback feature now sends information by email instead of uploading.
反馈功能现在通过电子邮件发送信息,而不是上传。

11.0.0-3

Updated 10/06/2021

Issue Key Component Description
VER-78945 UI - Management Console Email gateway aliases with hyphen (-) characters caused errors; resolved.
带有连字符 (-) 的电子邮件网关别名导致错误;已解决。
VER-78986 Client Drivers - ADO Same as VER-77818 — query cancel + immediate DataReader.close() issue.
同 VER-77818 — 查询取消并立即关闭 DataReader.close() 问题。
VER-78988 Optimizer Same as VER-78767 — adding column with TIMESERIES default returned ROLLBACK; resolved.
同 VER-78767 — 添加带有 TIMESERIES 默认值的列返回 ROLLBACK;已解决。
VER-79042 Optimizer Same as VER-78726 — partition statistics now support date_trunc().
同 VER-78726 — 分区统计信息现在支持 date_trunc()。
VER-79045 Optimizer Same as VER-78632 — multiple distinct aggregates with wrong results.
同 VER-78632 — 多个不同聚合函数产生错误结果。
VER-79065 Kafka Integration Same as VER-77999 — small messages with KafkaInsertDelimiters returning VIAssert error.
同 VER-77999 — 带有 KafkaInsertDelimiters 的小消息返回 VIAssert 错误。

11.0.0-2

Updated 9/23/2021

Issue Key Component Description
VER-78927 Security TLS configurations simplified for LDAP Link/Authentication; StartTLS set automatically based on TLSMODE. StartTLS incorrectly enabled with ldaps:// regardless of TLSMODE; resolved.
LDAP Link/身份验证的 TLS 配置已简化;StartTLS 根据 TLSMODE 自动设置。无论 TLSMODE 如何,StartTLS 都错误地在 ldaps:// 下启用;已解决。

11.0.0-1

Updated 9/14/2021

Issue Key Component Description
VER-78586 Database Designer Core Database Designer generated SQL files with permissions 600 instead of 666; resolved.
Database Designer 生成了权限为 600 而不是 666 的 SQL 文件;已解决。
VER-78663 Execution Engine Same as VER-78619 — EXTERNAL_TABLE_DETAILS complex predicate queries returned wrong results or crashed.
同 VER-78619 — EXTERNAL_TABLE_DETAILS 复杂谓词查询返回错误结果或崩溃。
VER-78668 Backup/DR Same as VER-78001 — AWS config params no longer overwritten during full restore.
同 VER-78001 — 完全恢复期间不再覆盖 AWS 配置参数。
VER-78712 Optimizer Same as VER-78313 — MaxParsedQuerySizeMB memory consumption improvements.
同 VER-78313 — MaxParsedQuerySizeMB 内存消耗改进。

11.0.0-0

Updated 8/11/2021

Issue Key Component Description
VER-68406 Tuple Mover With Mergeout Cache enabled, dc_mergeout_requests now contains valid transaction IDs instead of zero.
启用 Mergeout Cache 后,dc_mergeout_requests 现在包含有效的事务 ID 而不是零。
VER-71064 Catalog Sync and Revive, Depot, EON Restarting a node in a secondary subcluster no longer loses its depot files.
重启辅助子集群中的节点不再丢失其 depot 文件。
VER-72596 Data load / COPY, Security COPY REJECTED DATA to TABLE now properly distributes between identical-named tables in different schemas.
COPY REJECTED DATA to TABLE 现在在不同模式中相同名称的表之间正确分发。
VER-73751 Tuple Mover Tuple Mover logged excessive PURGE requests on a projection during another MERGEOUT job on same projection; resolved.
当另一个 MERGEOUT 作业在同一投影上运行时,Tuple Mover 记录了过多的 PURGE 请求;已解决。
VER-73773 Tuple Mover Tuple Mover now considers resource pool capacity when creating mergeout plans, adjusting ROS container count accordingly.
Tuple Mover 现在在创建 mergeout 计划时考虑资源池容量,相应调整 ROS 容器数量。
VER-74554 Tuple Mover Tuple Mover dequeued DVMERGEOUT and MERGEOUT simultaneously, leaving MERGEOUT pending indefinitely; now checks for outstanding MERGEOUT after DVMERGEOUT.
Tuple Mover 同时出队 DVMERGEOUT 和 MERGEOUT,使 MERGEOUT 无限期挂起;现在在 DVMERGEOUT 后检查未完成的 MERGEOUT。
VER-74615 Hadoop Parquet predicate pushdown bug on HDFS caused some rowgroups not to be pruned; fixed.
HDFS 上的 Parquet 谓词下推错误导致某些行组未被修剪;已修复。
VER-74619 Hadoop ZSTD compressed parquet files with all-NULL columns from external tools (e.g., Impala) now readable.
来自外部工具(如 Impala)的包含全 NULL 列的 ZSTD 压缩 parquet 文件现在可读。
VER-74814 Hadoop Parquet generation library patched to buffer nulls in encoded format, optimizing memory usage.
Parquet 生成库已修补,以编码格式缓冲 null 值,优化内存使用。
VER-74974 Database Designer Core Database Designer no longer designs projections unrefreshable by refresh_columns().
Database Designer 不再设计无法由 refresh_columns() 刷新的投影。
VER-75139 DDL Adding columns to large tables with many columns on Eon mode no longer slow or resource-heavy.
在 Eon 模式下向具有许多列的大表添加列不再缓慢或占用大量资源。
VER-75496 Depot System tables no longer report files in depot after eviction, preventing "File not found" errors.
系统表在逐出后不再报告 depot 中的文件,防止 "File not found" 错误。
VER-75715 Backup/DR STDOUT during coexist mode restore now contains correct schema name prefix.
共存模式恢复期间的 STDOUT 现在包含正确的模式名称前缀。
VER-75778 Execution Engine Complex memory-intensive queries with analytical function feeding into merge caused crash with high EXECUTIONPARALLELISM; resolved.
分析函数馈送到合并的复杂内存密集型查询在高 EXECUTIONPARALLELISM 下导致崩溃;已解决。
VER-75783 Optimizer NO HISTOGRAM event incorrectly set on dc_optimizer_events epoch column, causing incorrect suggested_action; resolved.
NO HISTOGRAM 事件错误设置在 dc_optimizer_events 的 epoch 列上,导致错误的 suggested_action;已解决。
VER-75806 UI - Management Console COPY-type queries added to Completed Queries on Query Monitoring Activity page.
COPY 类型查询已添加到 Query Monitoring Activity 页面的 Completed Queries 中。
VER-75864 Data Export Parquet export wrote timestamp time portion as negative for pre-2000 dates; fixed.
Parquet 导出将 2000 年之前日期的时间戳时间部分写为负数;已修复。
VER-75881 Security No longer takes catalog lock during authentication after password algorithm changed from MD5 to SHA512.
密码算法从 MD5 更改为 SHA512 后,身份验证期间不再获取目录锁。
VER-75898 Execution Engine export_objects memory accumulation from repeated privilege checks freed more promptly to prevent OOM.
export_objects 因重复权限检查导致的内存累积现在更快释放以防止 OOM。
VER-75933 Catalog Engine export_objects meta-function could not be canceled; resolved.
export_objects 元函数无法取消;已解决。
VER-76094 Data Removal - Delete, Purge, Partitioning Dropping local USER storage location on cluster with standby nodes no longer fails.
在具有备用节点的集群上删除本地 USER 存储位置不再失败。
VER-76125 Backup/DR Access permission check for S3 bucket root removed; users with directory-level access can backup/restore.
已移除对 S3 存储桶根目录的访问权限检查;具有目录级访问权限的用户可以备份/恢复。
VER-76131 Kafka Integration Documentation updated to mention SCRAM-SHA-256/512 support.
文档已更新,提及 SCRAM-SHA-256/512 支持。
VER-76200 Admin Tools Adding node to Eon-mode DB no longer prompts for rebalance (unsupported in Eon).
向 Eon 模式数据库添加节点不再提示重新平衡(Eon 中不支持)。
VER-76244 Depot Depot now only fetches files from shared storage that are actually read by a statement.
Depot 现在仅从共享存储获取语句实际读取的文件。
VER-76349 Optimizer Combining two NotNull predicates into single Boolean predicate returned error; resolved.
将两个 NotNull 谓词组合为单个布尔谓词返回错误;已解决。
VER-76384 Execution Engine Variable-length-optimized joins had small crash risk with NULL join keys; resolved.
变长优化连接存在 NULL 连接键的小概率崩溃风险;已解决。
VER-76424 Execution Engine 'count(s.)' with subquery now returns error message that multi-valued expressions are not supported.
带有子查询的 'count(s.
)' 现在返回不支持多值表达式的错误消息。
VER-76449 Sessions Better detection of multiple Vertica processes started simultaneously on the same node.
改进了在同一节点上同时启动多个 Vertica 进程的检测。
VER-76511 Sessions, Transactions Single-node transaction no longer sends commit message to all nodes for content-free commits.
单节点事务不再为无内容提交向所有节点发送提交消息。
VER-76543 Optimizer, Security Users no longer need USAGE privilege on schema B to SELECT view A.v1 when base table B.t1 has an access policy.
当基表 B.t1 具有访问策略时,用户不再需要对模式 B 的 USAGE 权限来 SELECT 视图 A.v1。
VER-76584 Security Vertica now auto-creates default key projections for users with DML access when inserting into table with primary key and no projections.
Vertica 现在为具有 DML 访问权限的用户在向具有主键但无投影的表插入时自动创建默认键投影。
VER-76815 Optimizer Unary operators as GROUP BY/ORDER BY in WITH clause crashed Vertica; resolved.
在 WITH 子句中将一元运算符用作 GROUP BY/ORDER BY 导致 Vertica 崩溃;已解决。
VER-76824 Optimizer View calling UDx with '' argument crashed if queried table changed; view now returns same results.
使用 '
' 参数调用 UDx 的视图在查询的表更改时崩溃;视图现在返回相同结果。
VER-76851 Data Export UUID types now supported via s3export; previously caused initiator node crashes.
UUID 类型现在可通过 s3export 支持;此前导致发起者节点崩溃。
VER-76874 Optimizer Updating result set of query calling volatile LISTAGG resulted in unequal row counts among projections; resolved.
更新调用易变 LISTAGG 的查询结果集导致投影之间行数不相等;已解决。
VER-76952 DDL - Projection Users can now alter metadata of columns not participating in live aggregate or Top-K projections.
用户现在可以更改不参与实时聚合或 Top-K 投影的列的元数据。
VER-76961 Spread Spread now correctly detects old tokens as duplicates.
Spread 现在正确检测旧令牌为重复。
VER-77006 Machine Learning PREDICT_SVM_CLASSIFIER with invalid "type" parameter now returns error message instead of crashing.
PREDICT_SVM_CLASSIFIER 使用无效 "type" 参数时现在返回错误消息而不是崩溃。
VER-77007 Catalog Engine Standby nodes now get changes to GENERAL resource pool when replacing a down node.
备用节点在替换故障节点时现在接收 GENERAL 资源池的更改。
VER-77026 Execution Engine Queries on v_internal tables with equality predicates on relname/nspname now optimized correctly for embedded characters and multiple predicates.
对 v_internal 表使用 relname/nspname 上的相等谓词的查询现在针对嵌入字符和多个谓词正确优化。
VER-77134 Backup/DR CREATE TABLE AS during replication target operation now returns clear error message.
复制目标操作期间的 CREATE TABLE AS 现在返回清晰的错误消息。
VER-77173 Monitoring Startup.log now contains stage identifying when node received initial catalog.
Startup.log 现在包含标识节点何时接收初始目录的阶段。
VER-77190 Optimizer CASE expressions with constant conditions and shorter string results causing internal error in joins with aggregation; resolved.
具有常量条件和较短字符串结果的 CASE 表达式在带聚合的连接中导致内部错误;已解决。
VER-77199 Kafka Integration Kafka Scheduler now allows initial offset of -3 (read from consumer group offset).
Kafka Scheduler 现在允许初始偏移量为 -3(从消费者组偏移量读取)。
VER-77227 Admin Tools admintools startup failure messages now provide details on failure cause.
admintools 启动失败消息现在提供失败原因的详细信息。
VER-77265 Catalog Sync and Revive More detailed messages added when permission is denied.
权限被拒绝时添加了更详细的消息。
VER-77278 Catalog Engine close_session() during analyze_statistics() on local temp table crashed Vertica; resolved.
在本地临时表上执行 analyze_statistics() 期间调用 close_session() 导致 Vertica 崩溃;已解决。
VER-77387 Directed Query, Optimizer Materialized WITH clause with unused CTE referencing unknown column threw error; now ignored consistently with unmaterialized WITH.
物化 WITH 子句中使用未使用的 CTE 引用未知列时抛出错误;现在与非物化 WITH 一致地被忽略。
VER-77394 Execution Engine Unsafe predicate reordering with leading sort order constant restrictions and SIPS predicate from merge join on non-leading columns; no longer reorderable.
具有引导排序顺序常量限制和来自非引导列上合并连接的 SIPS 谓词的不安全谓词重排序;不再可重排序。
VER-77584 Execution Engine Incorrect null count check on blocks caused mistaken row pruning using max value of all-null block; resolved.
块上不正确的 null 计数检查导致使用全 null 块的最大值错误修剪行;已解决。
VER-77695 Admin Tools start_db --force no longer deletes data directory if user lacks read/execute permissions; admintools cancels or gives 10s to abort.
如果用户缺少读取/执行权限,start_db --force 不再删除数据目录;admintools 取消或给予 10 秒中止时间。
VER-77814 Optimizer TABLESAMPLE option now supported for views.
TABLESAMPLE 选项现在支持用于视图。
VER-77904 Admin Tools create_db prompt now times out after 120 seconds; previously incomplete DB creation if user didn't respond.
create_db 提示现在在 120 秒后超时;此前如果用户未响应,将创建不完整的数据库。
VER-77905 Execution Engine throw_error function now marked immutable so SQL macros can call it multiple times.
throw_error 函数现在被标记为不可变,因此 SQL 宏可以多次调用它。
VER-77962 Catalog Engine Vertica now restarts properly for nodes with very large checkpoint files.
Vertica 现在对于具有非常大检查点文件的节点可以正常重启。
VER-78251 Data Networking Socket accepting internal connections erroneously closed under rare circumstances, causing many socket errors; fixed.
接受内部连接的套接字在极少数情况下被错误关闭,导致许多套接字错误;已修复。