Able to export columns data with table structure for only those selected columns like sqlYog (MXS-4143)

[MXS-4876] Split query Created: 2023-11-24  Updated: 2024-01-03  Resolved: 2024-01-03

Status: Closed
Project: MariaDB MaxScale
Component/s: maxgui
Affects Version/s: None
Fix Version/s: N/A

Type: Sub-Task Priority: Major
Reporter: Duong Thien Ly Assignee: Duong Thien Ly
Resolution: Won't Do Votes: 0
Labels: None

Sprint: MXS-SPRINT-194, MXS-SPRINT-195, MXS-SPRINT-196, MXS-SPRINT-197, MXS-SPRINT-199

 Description   

Knowing the result sets of a statement would be informative to the users.
Currently, all the statements in the SQL editor are executed as a batch of SQL statements. The returned results don't store the exact SQL query that was executed. Therefore, the query must be split into particular statements before sending to the API.

The `splitQuery` helper can be used for splitting the statements, however, for
compound statements, it requires the changing of DELIMITER to split correctly. In other words, the users must specify a distinct delimiter in the query. This limitation should be added to the documentation.



 Comments   
Comment by Duong Thien Ly [ 2023-11-29 ]

This may not be necessary if the API can provide metadata of the resultset. https://jira.mariadb.org/browse/MXS-4883

Generated at Thu Feb 08 04:31:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.