9.12.0 ~ 9.12.14

QueryPie 9.12.14 Release

2024. 1. 30.

Bug Fix & Enhancement

• [MongoDB] Improved memory performance related to proxy connections.

QueryPie 9.12.13 Release

2024. 1. 8.

Bug Fix & Enhancement

• [Proxy] Resolved error when connecting via Agentless method for MySQL 8.0.26 and above.

QueryPie 9.12.12 Release

2023. 12. 8.

Bug Fix & Enhancement

• [Oracle] Added support for unsupported CharacterSets (KO16MSWIN949, KO16KSC5601).

QueryPie 9.12.11 Release

2023. 10. 25.

Bug Fix & Enhancement

• [Connection] Improved Health Check functionality.

QueryPie 9.12.10 Release

2023. 9. 8.

New Feature

• [Workflow] Added support for background execution when executing SQL requests (Lezhin Entertainment/KakaoPay).

• [QSI] Improved to refresh the QSI schema cache in the cluster group when DDL occurs on instances within the cluster group.

Bug Fix & Enhancement

• [Web Editor] Adjusted connection timeout from 30 seconds to 60 seconds when connecting.

• [Syslog] Added filtering options for Proxy-related logs in Syslog.

• [Agent] Resolved agent connection issues on Amazon Workspaces (Windows Server 2016).

• [Web Editor] Fixed issues related to displaying Cluster and Instance information in the connection list.

• [Proxy] Addressed intermittent disconnection issues with Proxy connections.

• [MySQL] Fixed errors occurring when using Having without GroupBy.

• [Agent] Added User-Agent header during agent communication.

• [Web Editor] Resolved connection timeout issues when connecting to DocumentDB 3.6.

• [Connection] Fixed usage increase issues due to DB session leaks.

QueryPie 9.12.9 Release

2023. 7. 26.

New Feature

• [Alert] Added a link to the New Request > Template.

Bug Fix & Enhancement

• [Alert] Fixed issue where Last Event Time is displayed even when creating an Alert.

• [Proxy] Resolved problem where 'DB Access History' is not logged upon connection failure.

• [Proxy] Improved accuracy of identifying Client IP in both Agent and Agentless environments.

• [Proxy] Fixed issue where cancelling DDL execution in LOCAL IDE (DBeaver) did not halt execution.

• [Proxy] Resolved ArgumentOutOfRangeException and IndexOutOfRangeException issues during recording of First 10 rows.

• [SSL] Fixed issue preventing SSL mode connection due to OpenSSL version differences.

• [Session] Improved behavior when transitioning from non-logged-in to Okta login, ensuring redirection to the target URL.

• [LDAP] Enhanced Group synchronization to reference the Group Base DN value.

• [Workflow] Improved access control so that only users with valid step-by-step permissions can view detailed pages.

• [Web Editor] Fixed error occurring when clicking on JSON data in Object Info > Data.

• [Web Editor] Resolved issue where unexpected Object Info Panel data was displayed upon selecting a database in Object Browser.

• [Web Editor] Fixed 'uuid' was not found error when viewing Data Viewer after executing a query.

• [Web Editor] Fixed error when accessing Data Viewer with a restored Result window after reconnecting to the same connection.

• [User Access History] Fixed issue where hostname value remained as 127.0.0.1 when logging in via SAML.

QueryPie 9.12.8 Release

2023. 7. 4.

Bug Fix & Enhancement

• [Agent] [Windows10/11] Improved login failure after update and installation by resolving issue with immediate execution.

• [Vendor] Fixed error occurring in MySQL when using Grant with Role.

• [Proxy] Improved behavior in 3rd-party tools where schema must be specified even if Database Name is not entered during MySQL creation, regardless of USE statement.

QueryPie 9.12.7 Release

2023. 6. 15.

Bug Fix & Enhancement

• [Agent] Fixed issue where Query Audit IP in Agent environment was fixed to container IP, now records Client IP.

QueryPie 9.12.6 Release

2023. 6. 12.

Bug Fix & Enhancement

• [MariaDB] Improved policy enforcement to include SET statements.

• [SQL Server] Implemented additional proxy unimplemented types.

• [SQL Server] Fixed errors in Data Access and Data Masking application in Proxy environment.

• [Performance] Resolved connection pool depletion issue when recording DML Snapshots concurrently.

• [Performance] Fixed issue where SQL Audit logs remain as Running Query when API response is delayed.

• [SAML] Fixed error during initial login.

• [MySQL] Resolved mysqldump errors.

• [Proxy] Fixed error occurring when attempting to open more than 2 connections simultaneously.

QueryPie 9.12.5 Release

2023. 5. 19.

Bug Fix & Enhancement

• [Alert] Improved SQL maximum length from 100 characters to 1000 characters.

• [Agent] Modified to prevent automatic activation of open options during login.

• [Agent] Modified so that connection is terminated when agent session ends.

• [SQL Server] Resolved issue where queries were not executed when DML Snapshot was enabled.

• [Agent] Enhanced proxy connection using MariaDB JDBC driver versions 1.x and 2.x.

QueryPie 9.12.4 Release

2023. 5. 17.

Bug Fix & Enhancement

• [Agent/Linux] Fixed tray icon not appearing issue.

• [Alert] Resolved error with "Executed Result: {{execResult}}".

• [Authentication] Fixed Cluster Group NotFound error during Okta sync.

• [Editor] Ensured proper display of datetime column values.

• [MariaDB] Fixed issue where SQL Type remains as Set in Audit when executing Set statements via proxy.

• [MariaDB] Improved SET statement parsing.

• [Oracle] Updated queries for script and schema list retrieval in Oracle.

• [Oracle] Disabled autocomplete feature in SQL Editor.

• [Privilege] Resolved authorization check errors due to cache mismatch.

• [Proxy] Fixed issue where connection is terminated when invalid data exists in Datetime format.

• [Query Audit] Fixed CSV file download causing database overload.

• [SQL Job] Modified SQL Jobs tab to be activatable.

• [Workflow] Ensured canceled approvals are not displayed in "in progress" section of sent requests.

QueryPie 9.12.3 Release

2023. 5. 10.

Bug Fix

• [Agent] Fixed issue where the API was sending duplicate node lists to the agent upon user connection.

• [Performance] Resolved sigsegv error and process termination occurring in gRPC C Binding library.

QueryPie 9.12.2 Release

2023. 5. 2.

Bug Fix

• [Proxy] Resolved proxy error occurring when PPv2 option is set.

• [Export] Fixed issue where temporary files created during export were not deleted, leading to disk full errors.

• [License] Changed license issuance timezone from UTC to KST.

QueryPie 9.12.1 Release

2023. 4. 25.

Bug Fix

• [Performance] Fixed issue where snapshots were occurring even when DML snapshots were not activated.

• [Performance] Resolved long query occurrences due to missing index processing.

• [PostgreSQL] Fixed frequent errors in agent connections caused by memory usage.

QueryPie 9.12.0 Release

2023. 4. 13.

New Feature

• [Menu] Revamped the entire QueryPie menu and improved URL structure.

• [License] Enhanced the UI for license management.

• [Application log] Handled menu exclusion for application logs.

• [Impala] Added support for Web Proxy when using UIDPWD authentication method.

• [Workflow] Included ledger information in columns when extracting query audit.

• [LDAP] Added option to deactivate accounts and reference fields upon organizational changes.

Bug Fix & Enhancement

• [Agent] Improved version 9.12.0.

• [Agent] Resolved installation issues on Linux environments.

• [Alert] Fixed errors related to Workflow Slack channel functionality.

• [Authentication] Resolved issues with displaying okta and onelogin SAML metadata.

• [Authentication] Restored automatic addition of LDAP users when synchronization option is disabled.

• [Authentication] Fixed SSL authentication errors.

• [AzureSQL] Fixed errors occurring when clicking on 'Trigger' or 'Info' in SQL Editor > Object Info.

• [Channel] Excluded Kakao Work from the Channel Type dropdown.

• [Cloud Provider] Provided AWS as an only option in the Create Provider > Cloud Provider dropdown.

• [Connection] Fixed bugs related to forced deactivation of Multiple Database Accounts.

• [Connection] Changed tooltip message for Multiple Database Accounts.

• [Connection] Resolved issues with engine crashes when invoking rpc GrpcGitService.SaveFile.

• [DML Snapshot] Added beta tags next to DML Snapshot option for 11 vendors.

• [DynamoDB] Improved display of return values as original integers.

• [Export] Resolved errors occurring during export.

• [External API] Fixed errors in Update Cluster Group (PATCH) External API.

• [Impala] Fixed errors occurring when querying tables after registering columns in Sensitive Data.

• [LDAP] Fixed errors occurring during group synchronization when there are users not included in any groups.

• [Oracle] Fixed ORA-00900: invalid SQL statement errors.

• [Oracle] Fixed errors occurring when viewing function > script in web SQL.

• [Performance] Improved slow connection issues via Agent.

• [Performance] Added warning notifications before executing queries to check for full scans.

• [Privilege] Fixed issue where Json Data copying was blocked even without Copy Clipboard permission.

• [Privilege Type] Fixed issue where tag fonts appeared differently for each user.

• [Proxy/MariaDB] Improved error handling when using libmariadb driver.

• [Query Audit] Fixed issue where Execution Reason was not logged after enabling SQL Execution Purpose option.

• [Query Audit] Applied masking pattern to password setting logs (only for MySQL).

• [Redis] Fixed issue where Wrongtype DB errors were categorized as Engine errors.

• [Redis] Handled errors properly in Redis driver by treating them as exceptions.

• [Setting] Fixed issue where Account Expiration Period option only checked Last Login, causing account lockouts when only using Proxy.

• [SQLServer] Resolved Internal connection fatal error occurring during connection.

• [Syslog] Fixed IP logging errors.

• [Workflow] Fixed expiration date specification error during Access Request.

• [Workflow] Fixed issue where canceled requests showed Status as None in Reviews.

• [Workflow] Resolved inability to retrieve connection information from Multi-Account for user data.