Skip to content

[feature request] Execute multiple statements #194

Description

@eagletmt

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions