Databases 5 min read

SQLE 1.2207.0‑pre1 Release Notes: New OceanBase MySQL Support, Feature Updates, and Bug Fixes

The SQLE 1.2207.0‑pre1 pre‑release introduces OceanBase MySQL‑mode audit plugins, exclusive OceanBase rules, enhanced table‑name case checks, count(*) recommendations, adds TiDB audit‑log support, fixes several MySQL‑related bugs, and outlines future plans for more OceanBase and Oracle‑mode auditing capabilities.

Aikesheng Open Source Community
Aikesheng Open Source Community
Aikesheng Open Source Community
SQLE 1.2207.0‑pre1 Release Notes: New OceanBase MySQL Support, Feature Updates, and Bug Fixes

Project Overview SQLE is an open‑source SQL audit tool for database users and administrators, supporting multiple audit scenarios, standardized release processes, native MySQL auditing, and extensible to other database types.

New Version Highlights

Support for OceanBase MySQL‑mode audit plugin (Enterprise edition) – integrates most MySQL audit rules while removing incompatible scenarios.

Exclusive OceanBase‑specific audit rules, including two new OB‑only checks based on official OceanBase documentation.

Enforced uniform case for table names; mixed‑case names trigger a rule.

Recommendation to use COUNT(*) instead of COUNT(column).

Images illustrate the OceanBase‑MySQL rule set and the UI for adding OceanBase instances.

Release Notes Details

Feature: Support for TiDB audit‑log auditing (Enterprise edition).

Feature: Full support for OceanBase MySQL‑mode auditing (Enterprise edition).

Bug Fixes

Fixed issue where MySQL lower_case_table_names=2 caused incorrect database/table checks.

Resolved false "table does not exist" errors when system tables appear in MySQL audit statements.

Addressed several Enterprise‑edition license problems.

Future Plans

Research and add more audit rules for OceanBase MySQL mode.

Research and support auditing for OceanBase Oracle mode.

Additional resources include links to the source repository, documentation, release pages, and online demos for both community and enterprise editions.

Original Source

Signed-in readers can open the original source through BestHub's protected redirect.

Sign in to view source
Republication Notice

This article has been distilled and summarized from source material, then republished for learning and reference. If you believe it infringes your rights, please contactadmin@besthub.devand we will review it promptly.

mysqlDatabase AuditingOceanBaseRelease NotesSQLE
Aikesheng Open Source Community
Written by

Aikesheng Open Source Community

The Aikesheng Open Source Community provides stable, enterprise‑grade MySQL open‑source tools and services, releases a premium open‑source component each year (1024), and continuously operates and maintains them.

0 followers
Reader feedback

How this landed with the community

Sign in to like

Rate this article

Was this worth your time?

Sign in to rate
Discussion

0 Comments

Thoughtful readers leave field notes, pushback, and hard-won operational detail here.