[feature request] Execute multiple statements
eagletmt opened this issue · 0 comments
eagletmt commented
Currently, Bdash executes one statement at the cursor position. It would be great if Bdash executes multiple statements with the same connection.
This feature request is similar to #14 but not limited to MySQL variables.
Use case
I'd like to set session variables to execute query. A simple example is setting timezone in the current session.
set timezone to 'Asia/Tokyo';
show timezone;
Another example is SUPER data type in Redshift. It requires set enable_case_sensitive_identifier to true
to refer mixed case fields.
https://docs.aws.amazon.com/redshift/latest/dg/super-configurations.html
SET enable_case_sensitive_identifier to TRUE;
SELECT json_table.data."ITEMS"."Name",
json_table.data."price"
FROM
(SELECT json_parse('{"ITEMS":{"Name":"TV"}, "price": 345}') AS data) AS json_table;
Bdash doesn't display ITEMS.Name field for now.