Version History

Bug Fixes

1. Fixed a bug where shortcut keys would not be applied immediately after moving the grid after executing a query in the SQL editor.

Improvements

1. Improved the color of column selections when moving focus to the editor after selecting a column in the grid.
2. Improved the readability of the focused cell in the grid.

Bug Fixes

1. Bug fix where shortcut changes in the editor would not apply to open windows and would require a restart.
2. Bug fix where shortcuts in the SQL editor would not be applied immediately after moving the grid after executing a query.

New Features

1. Added a button to reopen all docking windows in the PL/SQL Debugger when they are closed (View Docking Panels).

Improvements

1. When [Auto Show] is selected in the SQL Editor AutoComplete options, [Object AutoComplete] and [SQL AutoComplete] are now clearly displayed for readability.

This release fixes bugs in key features such as the editor, autocomplete, object panel, and data export, and adds new features to improve usability. We've focused on improving multi-session management, code editing stability, and UI/UX.

Editor Improvements

Bug Fixes

1. Auto-complete error when connecting multiple sessions
   • Fixed an issue where keyword auto-completion did not work properly even after disabling one of the multiple sessions.
2. SQL content loss error when opening a file
   • Fixed an issue where the query being written would disappear when opening a file while editing SQL/PLSQL.
3. Focus position error after SQL alignment
   • Fixed an issue where the cursor did not return to its original position after SQL alignment.
4. Fixed a bug where moving focus after SQL alignment did not return to its original position.
5. File A bug has been fixed where drag-and-drop operations do not load into the split editor.
6. When opening a file with multiple editor tabs, tabs are not immediately activated.
7. A bug has been fixed where the last tab is not activated when connecting a session and loading a workspace file with multiple tabs.
8. A bug has been fixed where the contents of an existing file are loaded when opening a new editor after dragging and dropping a file when there are no editors in the main window.

New Features

1. Added [Load Initial SQL] button.
   • Support for retesting the initial SQL after changing formatting options.
2. Added the ability to specify an initial folder when saving a file with a different name.
3. When opening a file in an editor tab, the full file path is displayed in the tab hint. Added

Auto-complete Improvements

Bug Fixes

1. ​Delayed Reflection of Code Template Changes
   • Fixed an issue where template changes were not immediately reflected.
2. ​Multi-line Comment Display Error
   • Fixed an issue where text was broken in multi-line comments.
3. Fixed a bug where text was not displayed correctly in multi-line comments.

New Features

1. ​Added [Auto-Show] option
   • Provides a setting to disable all auto-complete features in the editor options.

Object Panel Improvements

Bug Fixes

1. Tab Style Initialization Error
   • "Single-Line Tab" Fixed an issue where styles were not applied during initial loading when selecting a style.
2. ​Columns not displayed when selecting a trigger
   • Fixed an issue where columns were not visible after selecting a trigger.
3. ​AV error when selecting a foreign key
   • Fixed an error that occurred when selecting a foreign key in a constraint.
4. ​Recycle Bin object information not displayed
   • Fixed an issue where objects were not visible in the [Information] tab after selecting the Recycle Bin.
5. ​Partitioning table partition area error
   • Fixed an issue where sub-partition areas were not displayed correctly when selecting a partitioned table.
6. ​Table annotation editing failed
   • Editing table annotations in the Object Explorer Fix for a bug that caused the feature to not work.
7. ​Improved error code accuracy​
   • Display a specific error code when retrieving object information fails.

New Features

1. ​Support for editing annotations for views and materialized views​
   • Added annotation editing functionality for views and materialized views.

Data Export Improvements

 Bug Fixes

1. ​Folder path error when selecting multiple tables​
   • When exporting after selecting one or more tables, the error "Folder does not exist" appears. Fixed an error issue.

Options Improvements

Bug Fixes

1. Adjusted code template font size
   • Fixed the issue where template fonts were displayed too small.
2. Keyword template label truncation
   • Fixed a UI bug that caused label text to appear truncated.

Debugger Improvements

Bug Fixes

1. Font size errors on extended displays
   • Fixed the issue where fonts appeared too small on extended Windows displays.

Grid Improvements

Bug Fixes

1. Removed Grouping/Summary Menu
   • Removed unnecessary Grouping, Summary Panel, and Column Selection items from the right-click menu.
2. Added Density Margins
   • Improved readability by adjusting margins based on grid data density.
3. Column Text Display Error
   • Fixed an issue where some text within a column was cut off.

Bug Fixes

• Fixed a bug where the Undo function in the SQL Editor did not work properly.
   Fixed a bug where the "Undo" function in the SQL Editor did not fully function in certain situations.

Bug Fixes

• Fixed SSH connection issue due to ssh-rsa algorithm being disabled in OpenSSH 8.8+
  Starting with OpenSSH 8.8, the ssh-rsa algorithm is disabled by default for security reasons, causing authentication errors during SSH connections.
  This issue has been resolved by supporting more secure algorithms such as ssh-ed25519 and ecdsa-sha2-nistp256, along with compatibility options if needed.

Bug Fixes

• Fixed SSH connection issue due to ssh-rsa algorithm being disabled in OpenSSH 8.8+
  Starting with OpenSSH 8.8, the ssh-rsa algorithm is disabled by default for security reasons, causing authentication errors during SSH connections.
  This issue has been resolved by supporting more secure algorithms such as ssh-ed25519 and ecdsa-sha2-nistp256, along with compatibility options if needed.

New Features & Improvements

• Added option to adjust main menu font size
  Users can now freely adjust the font size of the main menu for improved readability.

• Added auto-completion for bind variables
  Auto-suggestions are now provided for bind variables in the format :variableName during SQL writing.

• Improved auto-completion performance for bind variables
  The response speed of the auto-completion feature has been enhanced for a smoother user experience.

• Improved theme switching speed
  Theme transitions (e.g., Dark/Light) now occur faster with reduced latency.

New & Improved Features

• Oracle Cloud Wallet Login Support
  You can now log in using Oracle Cloud Wallets directly within SQLGate.

• Improved OCI Login Initialization
  SQLGate now prioritizes loading the TNS_ADMIN environment variable during OCI login, ensuring more stable and predictable connection handling.

• Mixed Connection Support
  Users can now use both Direct Connection and OCI Connection modes simultaneously within the same environment.

• Enhanced PL/SQL Editor Performance
  The PL/SQL editor now loads more than 3x faster, improving productivity and user experience when working with large PL/SQL scripts.

Bug Fixes

• Login Failure on Latest Oracle Versions
  Resolved an issue where users were unable to log in after updating to the latest version of Oracle.

• Object Panel – Missing Packages from Other Users
  Fixed a bug where packages or package bodies owned by other users did not appear in the Object Panel.

• Object Panel – Missing Job Schedulers from Other Users
  Fixed an issue where job scheduler entries from other users were not shown in the Object Panel.

• DBA Recognition Issue
  Fixed a bug where users with the SELECT ANY DICTIONARY privilege were not recognized as DBAs.

• SWS File Load Issue with Multiple Panels
  Fixed an issue where SWS (SQLGate Worksheet) files were not properly restored when using three-panel layouts.

• Session Statistics Display Bug
  Fixed a bug where "Session Statistics" under "Execution & Session Statistics" did not function correctly in the SQL Editor.

1. Fixed a bug where the partition table is not displayed in the object list

2. Improved the script for the partition table to appear

1. 1. Remove the feature to retrieve all records when dragging the column header in grid mode.

1. Bug fix for objects selected in Auto-Complete in Editor Options not being applied immediately

2. AV error fix in Object Highlight

3. Message processing when deleting one or more records in F6 mode

4. Bug fix for column sorting not working in grid mode

1. Improved the function to assign auto commit to each session

2. Improved the function to search for objects in the object panel without case
sensitivity

3. Fixed a bug where negative numbers were not displayed correctly in the grid

4. Fixed a bug where object scripts did not work correctly in the tabbed object panel

5. Fixed a bug where objects selected in the object auto-completion in the editor options were not immediately applied

1. Bug fix that prevents data from being modified intermittently in the grid

2. AV error fix when moving columns in table creation

3. Bug fix that prevents skins from being applied correctly when forced to close after changing the theme

4. Improved table script export speed

5. Removed inconvenience of having to add an alias name when the login password is incorrect

1. Fixed a bug where the correct value was not copied when copying to the clipboard after sorting columns in the grid.

1. Added option to add grid column header to SQL editor

2. Fixed issue where compilation error occurs during object recompilation and stops immediately

1. AV error patch when Ctrl+Click is pressed in SQL editor

2. Bug patch where object highlight in SQL editor changes to random color

1. Add CTE auto-completion feature

2. Do not display SQLGate-specific comments when dictionary query error occurs

1. Bug fix for the last logged-in tab not being activated in the free version

2. Bug fix for the compile result not being displayed in the object recompile

3. Add "New View" to the right mouse button in the view menu in the object panel

4. Added a resizing function for the data import window

5. Function improvement for loading login information of the 6.X version

6. Added a "Always on top" checkbox to the binding variable window

7. Added a load function after saving the last position to the binding variable window

8. Other bug fixes

1. Fix bug that prevents Generator64.dll from loading

SQLGate for Oracle Version 10 Released

1. Changed from 32-bit to 64-bit version

2. Oracle client supports only 64-bit version

3. Consolidated connected sessions into 1

4. Improved initial loading speed and database connection speed

5. Provided work area save and open function (sws extension)

6. Added session disconnection function during query execution

7. Added function to change to another session in the editor

8. Provided full grid column selection function in the SQL editor

9. Partial record retrieval / all record retrieval selection is possible in the SQL editor

10. More than 3 million records can be retrieved without memory error in the SQL editor

11. Improved speed of grid display after query execution in the SQL editor

12. Improved grid speed when querying CLOB, BLOB, RAW type data in the SQL editor

13. Improved speed when using binding variables in the SQL editor

14. Added function to move to the position of the ')' character when clicking the '(' character in the SQL editor

15. Binding variable window in the SQL editor Added a function to run without closing

16. Improved Replace, Undo, Redo speed in SQL editor

17. Added an icon to the tab when executing a query in SQL editor

18. Changed the color of the progress bar to the same color as the session in SQL editor

19. Added a function to specify the color of the cell when directly modifying the cell in the grid

20. If you cannot connect to the update server offline, run it without connecting to the update server

21. Changed the function to change the tab name immediately without pressing Enter

22. Added a schema filter function to the object panel

23. If the session is forcibly disconnected, the work area is not closed

24. Changed the XLS format to XLSX format in report export

25. Packaged so that it can be installed on MAC OS
 

Patches

1. Fixed a bug that caused a "database is locked" error when modifying a record

2. Fixed a bug that caused screen afterimages to appear at a specific resolution in a DVI environment

3. Fixed a bug that caused the location of a specific control in a DVI environment to keep changing

4. Fixed a bug that caused data to change when a specific folder does not exist in a virtual environment in a DVI environment Bug patch that causes an error when exporting

5. Bug patch that causes afterimages to remain when there are no records in the grid in a VDI environment

6 SQL history sorting error patch

7. Fixed the phenomenon that some records are not visible when the grid is resized

8. Fixed the phenomenon that blinks when the session is changed

9. Fixed the phenomenon that blinks when the editor tab is changed

10. Focus error patch when executing F5 in the grid tab

11. Error patch when pressing the cancel button when changing the server character set

12. Export error patch when there is no folder when exporting data

13. GDI error patch when setting Grid mode in the grid

14. Handled so that driver errors do not appear at startup when the printer driver is not set correctly

1. Bug patch where highlight keywords do not work properly

1. Patch error when compiling function
Error message> unterminated dollar-quoted string at or near "$function$

1. You can encrypt the PostgreSQL connection between SQLGate and the PostgreSQL DB instance using SSL

patched the error that prevented connection with the error message below.

no pg_hba.conf entry for host ..

1. Bug patch where colors are not displayed correctly when columns are sorted in the new connection window

2. Import data > Excel file > Change the default value to not select automatic column mapping when UPLOAD

1. Patch AV error when closing last tab in SQL editor

1. Patch for bug that does not enable subquery block execution

2. Patch for bug where OCI/Net Login tab does not open as last environment

3. Improved data import speed. Speed ​​improvement of more than 10 times when executing updates when importing data

4. Bug patch that prevents DBMS_OUPUT results from being retrieved

1. Patch for bug where duplicate connections are intermittently displayed as existing connection information

2. In the actual execution plan, set the record fetch option to “fetch all records”

1. Patch for bug that does not display when number of records is 0 after SELECT

2. Patch for bug where actual execution plan and AWR report do not work properly
3. Patch for bug where ) in (a) is not closed in auto close
4. Patch for bug where special character auto-close option does not work properly

1. Changed the function to maintain records in the data tab after executing the execution plan

2. Patch for bug where multilingual characters are not saved in SQL history

3. Change the window so that it does not close even after the session is terminated.