OceanBase Developer Center (ODC) V3.2.2 released in December 2021 updated the management of homepage and public resources, SQL window, database object, and other features. The following table describes the updates of modules and features.
Updated modules and features
| Feature | Module | Description |
|---|---|---|
| Homepage management | ODC homepage of Web ODC | * In the list of private connections: * Added filters to the Cluster and Tenant columns. * Added Empty as a filter condition to filter unidentified clusters, tenants, or tags. * Changed the default value of the Default Database parameter from mysql to information_scema. You specify this parameter when you create a new connection to a database under a MySQL tenant. * Changed the Account Name in the top navigation bar to the logged-on account name. For more information about connection-related operations, see Manage private connections and Manage public connections. |
| Homepage management | ODC homepage of Client ODC | * In the Private Connection tab: * Added filters to the Cluster and Tenant columns. * Added Empty as a filter condition to filter unidentified clusters, tenants, or tags. * Changed the default value of the Default Database parameter from mysql to information_scema. You can specify this parameter when you create a new connection to a database in a MySQL tenant. * For more information about connection-related operations, see Manage connections. |
| Public resource management | User management | * After you log on to ODC, you cannot edit or disable your account. * Hardened password security. You will be prompted to change the user password when you log on to ODC as a new user or after the administrator changes the user password. This hardens password security and prevents password leakage. |
| Public resource management | Manage public connections | * Added filters to the Cluster and Tenant columns. * Added Empty as a filter condition to filter unidentified clusters, tenants, or resource groups. * Added Copy in the Actions column. |
| Public resource management | Manage resource groups | Updated parameters of public connection in the Create Resource Group panel. |
| Workspace | SQL window | * SQL editing area: * Supports the autocomplete of table names in cross-database queries when you edit SQL statements as a read-only user. * Supports the intelligent identification of PL/SQL code. You can directly edit and execute PL/SQL statements in the editing area without setting delimiters. * Optimized the formatting. The formatting will be completed in 2s. * Added check boxes in the Execution Record tab for batch deletion of execution records. * Added the Logs tab to display the execution records of the current SQL window. * In the Results tab: * Added remarks for the fields on the Column Mode page. * Supports data export in SQL, CSV, and EXCEL formats. * Supports the selection of consecutive rows or columns while holding the Shift key, and inconsecutive rows or columns while holding the Ctrl or Command key. * Added the large field viewer. * Added action options on rows. You can perform the following operations by right-clicking a row ID: * Copy Row: click this option to copy the selected row. * Freeze this row: click this option to freeze the selected row and pin it to the top. You can freeze multiple rows. The rows under the table header and frozen rows can be vertically scrolled. * Unlock all frozen rows: click this option to unfreeze all frozen rows. |
| PL/SQL debugging | ODC supports PL/SQL debugging when you connect to OBServer by using OBProxy. For more information, see Anonymous block window, Manage functions, and Manage stored procedures. | |
| Database objects | Added alert icons  to PL objects. You can click the icon to display the details of an alert. |
|
| Database objects | Table objects | Manage table attributes: * Added a filter icon to the Field Name column for you to filter or search for fields. * Supports the management of foreign key constraints. |
| Database objects | Stored procedure objects | * Manage stored procedures: * Added a close button to the debugging window for you to directly close the window. * Added compilation alerts in the compilation results. * Supports the highlighting of code lines that contain the name of external objects that cannot be referenced during the compilation. * Supports the display of the execution results of stored procedures on the Output page. |
| Use tools | Asynchronous execution | Limited the maximum size of the SQL statements that can be entered in the SQL window to 500,000 characters. If the SQL script to be executed has more than 500,000 characters, you can upload it in the form of a *.sql file. |
| Deployment of high-availability ODC | Deploy the NGINX proxy | Modified the load balancing configurations to ensure sufficient proxy server timeout. |
| Upgrade of high-availability ODC | Upgrade NGINX image | Modified the load balancing configurations to ensure sufficient proxy server timeout. |