SQLDEV DOC

# Upgrade

# [v2.2.61] - 2022-12-05

# Fix

  • Fix the format conversion problem of file import.
  • Fix the problem of upgrade failure caused by the non-existence of folder during online upgrade.
  • Fix the problem of conflicting CHARACTER keywords in Oracle database.
  • Fix the error of PostgresSQL showing creation statement.
  • Repair the problem that some DML statements cannot get the number of affected rows correctly.

# Update

  • Support flashback of DML operations, (Oracle/MySQL/PostgresSQL/MSSQL).
  • Optimize file import performance.
  • Data source management module supports multi-view display and optimizes query function.
  • Support manual auditing of failed parsing scripts.
  • SQL editor interaction optimization.

# [v2.2.60] - 2022-11-09

# Fix

  • Fix a problem where some pg syntax parsing fails.

# Update

  • Add table file import function.
  • Add database TDengine support.

# [v2.2.59] - 2022-09-28

# Fix

  • Fix the bug that the execution of workflow fails but the status is really successful.
  • Fix the bug that adding comments in SQL statement causes parsing failure.
  • Fix the problem that the return of specific fields may cause the program to crash.
  • Fix the problem that mongoDB low version synchronization fails.

# Update

  • Refine permission granularity, support finer granularity operation permission setting.
  • Optimize table display, support detail view and one-click copy.
  • Application Management-Functional Settings Support to enable "Disable page copy data".
  • System Settings - Notification Add "SMS notification setting" function.
  • Data source supports SSH connection.
  • Audit log is added to audit management.
  • Personal Center - Security Settings - Two-step Authentication Add SMS authentication method.
  • Personal Center-Workspace, you can check personal execution/audit logs and workflow records, and support downloading and exporting.

# [v2.0.18] - 2021-10-27

# Fix

  • Fix the bug that Oracle blocks in certain cases.
  • Fix the bug of special character escaping in MySQL.
  • Fix a bug that some field length definitions are not valid for table structure synchronization.

# Update

  • Add metadata node and detail display for data query.
  • The data query interface supports theme setting.
  • Add platform message module.
  • Add user avatar setting.
  • Add online remote upgrade function.
  • Add LDAP login configuration to System Management -> Login Settings.
  • The login page supports LDAP login.

# [v2.0.17] - 2021-08-19

# Fix

  • Fix the bug that MySQL policy desensitization settings are not working.
  • Change MyCat in-memory paging to paging with limit statement.
  • MySQL DML update using auto transaction mode autocommit=1
  • Upgrade Oracle table build statement to show full content.
  • Optimize role setting permission color display.
  • Fix the problem of database synchronization failure under some MongoDB authority scenarios.
  • Repair the bug of unresponsive open file button in workflow pop-up window.
  • Fix the problem that asynchronous query results are not displayed.

# Update

  • Add the function of turning on/off two-factor authentication for login.
  • System-security settings support defining whitelist and blacklist network segments and ip addresses (CIDR).
  • MySQL workflow supports data backup function.
  • Support opening workflow approval policy on project workflow, support query, export and asynchronous workflow types. Support immediate empowerment requirements.
  • Add the three authority mode and add the roles of system administrator, security administrator and audit administrator. The original administrator role is unchanged and upgraded to super administrator.
  • Add "Test Connection" button for new data sources.
  • Add system backup function, supporting local backup and remote backup and recovery.
  • Add "Test Connection" button for new data source.

# [v2.0.16] - 2021-05-04

# FIx

  • Fix the problem of MySQL workflow execution failure.
  • Fix the problem of primary key conflict in workflow query log.
  • Fix the bug of MySQL table structure display
  • Fix the bug that policy desensitization fails in some cases.

# Update

  • Add the security function of two-factor authentication.
  • Add start-up banner
  • Support webhook notification for project approval
  • Support query and export through workflow approval

←