v0.6.42

### 赞助信息

- 赞助伙伴 PackyCode 入驻，主流大模型 API 中转服务，DBX 已内置预设，新用户享 $1 免费额度 + 首充折扣，[注册入口](https://www.packyapi.ai/register?aff=wyDA)

### 新功能

- 达梦支持通过原生 dexp/dimp (.dmp) 快速导出和导入整个模式 (contributed by @yiqiui) (PR [#9976](https://github.com/t8y2/dbx/pull/9976))
- SQL 文件面板支持新建、重命名和删除文件夹 (contributed by @eryajf) (PR [#11891](https://github.com/t8y2/dbx/pull/11891))
- GaussDB 和 openGauss 连接支持手动事务管理 (contributed by @AndrewDi) (PR [#11888](https://github.com/t8y2/dbx/pull/11888))
- Web 部署可通过环境变量将已保存连接的凭据保留在服务端，接口不再返回明文密码 (contributed by @zipg) (PR [#11902](https://github.com/t8y2/dbx/pull/11902))
- MQTT 消息列表支持按方向筛选（全部 / 已接收 / 已发送） (contributed by @ma123456mai) (PR [#11904](https://github.com/t8y2/dbx/pull/11904))
- 单元格右键筛选子菜单新增「自定义筛选」入口，可直接打开条件筛选面板并预填当前单元格值 (contributed by @hongshuo-wang) (PR [#11880](https://github.com/t8y2/dbx/pull/11880))
- 卸载插件时会列出并确认仍在使用该插件的已保存连接 (contributed by @Abeautifulsnow) (PR [#11872](https://github.com/t8y2/dbx/pull/11872))
- 侧边栏的表、视图等对象行也会显示生产环境徽章，连接行滚出视野后仍可识别 (contributed by @hongshuo-wang) (PR [#11852](https://github.com/t8y2/dbx/pull/11852))
- 虚谷 Xugu 支持 schema 范围的字段血缘分析 (contributed by @mapan0424) (PR [#11622](https://github.com/t8y2/dbx/pull/11622))
- Redis 列表推入时可选插入队头 (LPUSH) 或队尾 (RPUSH) (contributed by @yangzidemuou) (PR [#11784](https://github.com/t8y2/dbx/pull/11784))
- 标签页支持自定义标题后缀，替代自动编号以区分同名对象的页签 (contributed by @peakxy) (PR [#11708](https://github.com/t8y2/dbx/pull/11708))

### 改进

- SQL INSERT 复制与导出统一主键处理模式，新增「排除自动生成主键」和「排除全部主键」选项并迁移旧设置 (contributed by @ma123456mai) (PR [#11713](https://github.com/t8y2/dbx/pull/11713))

### 修复

- Oracle 时间字段复制和截图不再输出 ISO 原始串，与网格显示格式一致 (contributed by @lxk955) (PR [#11913](https://github.com/t8y2/dbx/pull/11913))
- 通过通用 JDBC 连接 Oracle 时，执行或保存函数、过程和包体不再被内部分号截断成无效对象 (contributed by @jeff377) (PR [#11915](https://github.com/t8y2/dbx/pull/11915))
- Oracle 查询结果含重复列名时点击列排序不再报 ORA-00918 (contributed by @jeff377) (PR [#11889](https://github.com/t8y2/dbx/pull/11889))
- Oracle 数据库导出现在包含序列对象，触发器引用的序列可完整回放 (contributed by @jeff377) (PR [#11836](https://github.com/t8y2/dbx/pull/11836))
- Oracle 到 Oracle 传输复用源表 DDL 时会拆分建表语句与二级索引、触发器，目标库不再建表失败 (contributed by @jeff377) (PR [#11849](https://github.com/t8y2/dbx/pull/11849))
- OceanBase Oracle 模式下无主键单表的隐藏定位键与显式 ROWID 查询的编辑开放边界恢复正确 (contributed by @efeire) (PR [#11781](https://github.com/t8y2/dbx/pull/11781))
- OceanBase Oracle 结果网格的 LOB 读取、保存、复制和导出不再把预览当完整值，并保留会话与 locator 身份 (contributed by @efeire) (PR [#11782](https://github.com/t8y2/dbx/pull/11782))
- OceanBase Oracle 大 schema 的对象搜索分页、断连后元数据回填和包成员、同义词补全的目标身份修复 (contributed by @efeire) (PR [#11783](https://github.com/t8y2/dbx/pull/11783))
- 达梦账号缺少 DBMS_METADATA 权限时，查看和编辑触发器改走字典视图降级，不再直接报错 (contributed by @xuchaoqaq) (PR [#11887](https://github.com/t8y2/dbx/pull/11887))
- MySQL 及 Doris、StarRocks 的常用日期和工具函数（如 DATE_ADD、EXTRACT）恢复自动补全 (contributed by @lxk955) (PR [#11833](https://github.com/t8y2/dbx/pull/11833))
- InterSystems Cache / IRIS 表数据视图支持编辑和添加行 (contributed by @lxk955) (PR [#11826](https://github.com/t8y2/dbx/pull/11826))
- 数据传输到非 MySQL 目标库时保留源表自增列，改用目标库原生 identity 属性 (contributed by @Tong-bit-art) (PR [#11813](https://github.com/t8y2/dbx/pull/11813))
- 停止查询时 JDBC 连接上运行中的语句会被取消，不再阻塞同连接的下一条语句 (contributed by @jeff377) (PR [#11890](https://github.com/t8y2/dbx/pull/11890))
- AI 助手的 @ 表引用列出所有选中数据库的表，不再只取第一个 (contributed by @Abeautifulsnow) (PR [#11853](https://github.com/t8y2/dbx/pull/11853))
- Excel（xlsx / xlsm）导入不再受残留的 100 MB 体积限制，大工作簿可正常流式导入 (contributed by @zipg) (PR [#11878](https://github.com/t8y2/dbx/pull/11878))
- SQL 文件面板默认同时显示 .sql 和 .ddl 文件 (contributed by @eryajf) (PR [#11873](https://github.com/t8y2/dbx/pull/11873))
- MQTT 控制台断开重连后保留订阅配置和消息历史，并保留最近一次发布表单内容 (contributed by @ma123456mai) (PR [#11871](https://github.com/t8y2/dbx/pull/11871))
- 侧边栏不再为 MQTT Console 的 topic 叶子节点显示无效的展开箭头 (contributed by @ma123456mai) (PR [#11906](https://github.com/t8y2/dbx/pull/11906))
- macOS 暗色外观下应用图标在 Dock 和 Finder 中保持深色，不再恢复为浅色 (contributed by @ma123456mai) (PR [#11809](https://github.com/t8y2/dbx/pull/11809))
- 双击数据库/模式总览行时按所点击的 schema 打开对象浏览器，不再加载连接默认 schema (contributed by @Tong-bit-art) (PR [#11824](https://github.com/t8y2/dbx/pull/11824))
- 侧边栏聚焦时 Ctrl/Cmd+T 新建查询跟随侧边栏选中的连接，而不是上次使用的连接 (contributed by @lxk955) (PR [#11818](https://github.com/t8y2/dbx/pull/11818))
- 快捷键搜索忽略空格、大小写和全半角差异，输入 Ctrl+T 也能匹配显示为 Ctrl + T 的快捷键 (contributed by @Abeautifulsnow) (PR [#11817](https://github.com/t8y2/dbx/pull/11817))
- 工具栏大小写切换按钮现在会同时把编辑器中 SQL 关键字就地转换为目标大小写，不再只改格式化偏好 (contributed by @hongshuo-wang) (PR [#11899](https://github.com/t8y2/dbx/pull/11899))

---
<!-- dbx-cnb-mirror -->
> 国内下载：如果 GitHub 下载较慢，可从 [CNB 镜像](https://cnb.cool/dbxio.com/dbx/-/releases/tag/v0.6.42) 下载桌面端安装包，Docker 镜像从 `docker.cnb.cool/dbxio.com/dbx:v0.6.42` 拉取。