Azure SQL Edge 发行说明Azure SQL Edge release notes

本文介绍每个新的 Azure SQL Edge 内部版本中的新增功能或已更改的内容。This article describes what is new and what has changed with every new build of Azure SQL Edge.

Azure SQL Edge - 1.0.0 (RTM)Azure SQL Edge - 1.0.0 (RTM)

SQL 引擎内部版本号 - 15.0.2000.1552SQL Engine build number - 15.0.2000.1552

新增功能What's new?

  1. 基于 Ubuntu 18.04 的容器映像。Ubuntu 18.04 based container images.
  2. 支持包含 LAST_VALUE()FIRST_VALUE() 函数的 IGNORE NULLRESPECT NULL 语法。Support for IGNORE NULL and RESPECT NULL syntax with LAST_VALUE() and FIRST_VALUE() functions.
  3. 针对 PREDICT with ONNX 的可靠性改进。Reliability improvements for PREDICT with ONNX.
  4. 支持基于数据保留策略的清理。Support for Data Retention policy based cleanup.
    • 环形缓冲区支持用于故障排除的保留清理任务。Ring Buffer support for retention cleanup task for troubleshooting.
  5. 新功能支持New feature support
    • 快速恢复Fast Recovery
    • 自动优化查询Auto Tuning of queries
    • 启用并行执行方案Enable Parallel Execution scenarios
  6. 针对低功耗模式的节能改进Power saving improvements for low-power mode
  7. 流式处理新功能支持Streaming new feature support
    • 快照窗口:一种新的窗口类型,允许按同一时间到达的事件进行分组。Snapshot Windows : new window type allowing to group by events arriving at the exact same time.
    • 启用 TopOneCollectTop 作为分析函数,这将允许返回按所选列排序的记录,而无需成为窗口的一部分。Enable TopOne and CollectTop as analytic function, This will allow to return records ordered by the column of your choice, without the needed to be part of a window.
    • MATCH_RECOGNIZE 的改进。Improvements to MATCH_RECOGNIZE.

修复项Fixes

  1. 用于排查 TSQL 流式处理操作问题的附加错误消息和详细信息。Additional error messages and details for troubleshooting TSQL Streaming operations.
  2. 为了在空闲模式下维持电池寿命进行的改进。Improvements to preserve Battery life in Idle mode.
  3. TSQL 流式处理引擎修复:TSQL Streaming engine fixes:
    • 清理了已停止的流式处理作业Cleanup for stopped streaming job
    • 修复了本地化问题并改进了 unicode 处理方式Fixes for localization and unicode handling improvements
    • 提高了 Edge TSQL 流式处理的可调试性,允许用户从 get_streaming_job 查询作业失败错误。Improve debuggability for Edge TSQL-streaming, allow users to query job failure errors from get_streaming_job.
  4. 基于数据保留策略的清理Data Retention policy based cleanup
    • 修复了保留策略创建和清理方案。Fixes for retention policy creation and cleanup scenarios.
  5. 修复了后台计时器任务,以提高低功耗模式下的节能能力。Fixes for background timer tasks to improve power savings for low-power mode.

已知问题Known Issues

  1. 无法在计算列中使用 Date_Bucket T-SQL 函数。Date_Bucket T-SQL Function cannot be used in a computed column.

CTP 2.3CTP 2.3

SQL 引擎内部版本号 - 15.0.2000.1549SQL Engine build number - 15.0.2000.1549

新增功能What's new?

  1. 支持 Date_Bucket() 函数中的自定义原点。Support for custom origins in the Date_Bucket() function.
  2. 在 SQL 部署中支持 BacPac 文件。Support for BacPac files as part of SQL deployment.
  3. 支持基于数据保留策略的清理。Support for Data Retention policy based cleanup.
    • DDL 支持启用保留策略DDL support for enabling retention policy
    • 清理存储过程和后台清理任务Cleanup stored procedures and background cleanup task
    • 用于监视清理任务的扩展事件Extended Events to monitor cleanup tasks

修复项Fixes

  1. 用于排查 TSQL 流式处理操作问题的附加错误消息和详细信息。Additional error messages and details for troubleshooting TSQL Streaming operations.
  2. 为了在空闲模式下维持电池寿命进行的改进。Improvements to preserve Battery life in Idle mode.
  3. TSQL 流式处理引擎修复:TSQL Streaming engine fixes:
    • 修复了子流跳跃窗口的卡水印问题Fix stuck watermark issue with substreamed hopping window
    • 修复了框架异常处理,以确保将其收集为用户可操作的错误Fix framework exception handling to make sure it is collected as user actionable error

CTP 2.2CTP 2.2

SQL 引擎内部版本号 - 15.0.2000.1546SQL Engine build number - 15.0.2000.1546

新增功能What's new?

  1. 支持非根容器Support for non-root containers
  2. 支持使用情况和诊断数据收集Support for Usage and Diagnostic data collection
  3. T-SQL 流式处理更新T-SQL Streaming updates
    • 支持流对象名称的 Unicode 字符Support for Unicode characters for stream object names

修复项Fixes

  1. T-SQL 流式处理更新T-SQL Streaming updates
    • 进程清理改进Process cleanup improvements
    • 日志记录和诊断改进Logging and diagnostics improvements
  2. 针对数据引入的性能改进Performance improvement for data ingestion

CTP 2.1CTP 2.1

SQL 引擎内部版本号 - 15.0.2000.1545SQL Engine build number - 15.0.2000.1545

修复项Fixes

  1. 修复了 PREDICT with ONNX 模型,以处理 ARM 中的 CPUID 问题Fix the PREDICT with ONNX models to handle CPUID issue in ARM
  2. 修复以改进 TSQL 流式处理启动时对故障路径的处理Fix to improve the handling of failure path in startup of TSQL streaming
  3. 修复了没有数据时,作业指标中水印延迟的错误值。Fix the incorrect value of watermark delay in job metrics when there is no data.
  4. 修复了输出适配器在批之间具有可变架构时出现的问题。Fix the issue with output adapter when adapter has variable schema between batches.

CTP 2.0CTP 2.0

SQL 引擎内部版本号 - 15.0.2000.1401SQL Engine build number - 15.0.2000.1401

新增功能What's new?

  1. 产品名称更新为“Azure SQL Edge”Product name updated to 'Azure SQL Edge'

  2. Date_bucket 函数Date_bucket function

    i.i. 支持日期、时间、日期/时间类型Support for Date, Time, DateTime type

  3. PREDICT with ONNXPREDICT with ONNX

    i.i. ONNX 需要 RUNTIME 参数RUNTIME parameter required for ONNX

  4. TSQL 流式处理支持(受限预览版)TSQL Streaming support (limited preview)

已知问题Known Issues

  1. 问题:如果在启动时应用 dacpac,可能会因计时问题而出现故障。Issue: Potential failures with applying dacpac on startup due to timing issue.

    解决方法:重新启动 SQL Server 或容器将重试应用 dacpac,应该可以解决此问题Workaround: Restarting SQL Server or container will retry applying the dacpac and should fix the issue

请求支持Request Support

  1. 可以在支持页面中请求支持。You can request support in the support page.

  2. 确保选择以下字段:Ensure that the following fields are selected:

    • 问题类型 - 技术Issue type - Technical
    • 服务 - IoT EdgeService - IoT Edge
    • 问题类型 - 我的问题与 IoT Edge 模块有关Problem Type - My problem relates to an IoT Edge module
    • 问题子类型 - Azure SQL EdgeProblem subtype - Azure SQL Edge

    支持票证示例

CTP 1.5CTP 1.5

SQL 引擎内部版本号 - 15.0.2000.1331SQL Engine build number - 15.0.2000.1331

新增功能What's new?

  1. Date_bucket 函数Date_bucket function

    i.i. 支持 DateTimeOffset 类型Support for DateTimeOffset type

  2. PREDICT with ONNX 模型PREDICT with ONNX models

    i.i. nvarchar 支持nvarchar support

CTP 1.4CTP 1.4

SQL 引擎内部版本号 - 15.0.2000.1247SQL Engine build number - 15.0.2000.1247

新增功能What's new?

  1. PREDICT with ONNX 模型PREDICT with ONNX models

    i.i. Varchar 支持Varchar support

    ii.ii. 迁移到 ONNX 运行时版本 1.0Migration to ONNX runtime version 1.0

  2. 功能支持 - 启用了以下功能:Feature support - The following features are enabled:

    i.i. CDC 支持CDC support

    ii.ii. 带压缩功能的历史记录表History table with compression

    iii.iii. 提高预读日志的比例因子Higher scale factor for log read ahead

    iv.iv. 批处理模式 ES 筛选器下推Batch mode ES filter pushdown

    v.v. 预读优化Read ahead optimizations

CTP 1.3CTP 1.3

SQL 引擎内部版本号 - 15.0.2000.1147SQL Engine build number - 15.0.2000.1147

新增功能What's new?

  1. Azure IOT 门户部署Azure IOT Portal Deployment

    i.i. 支持部署 AMD64 和 ARM 映像Support for deploying AMD64 and ARM images

    ii.ii. 支持创建流式处理作业Support for streaming job creation

    iii.iii. Dacpac 部署Dacpac deployment

  2. PREDICT with ONNX 模型PREDICT with ONNX models

    i.i. 数值类型支持Numeric type support

  3. 功能支持 - 启用了以下功能:Feature support - The following features are enabled:

    i.i. 将聚合下推到列存储扫描Pushdown aggregate to column store scan

    ii.ii. 旋转木马式扫描Merry-go-round scans

  4. 占用空间和内存消耗缩减工作Footprint and memory consumption reduction work