Skip to content

RETURNING keyword not implemented? #2720

@tinxx

Description

@tinxx

Details for the issue

What did you do?

Inserting data into a table using the RETURNING keyword in the tab 'Execute SQL'.

CREATE TABLE t0(
  a INTEGER PRIMARY KEY,
  b DATE DEFAULT CURRENT_TIMESTAMP,
  c INTEGER
);
INSERT INTO t0(c) VALUES(random()) RETURNING *;

See here for more information and above example query.

What did you expect to see?

The returned data in the output window element.

Note: The data is correctly returned as expected when manually executed via command line.

What did you see instead?

Empty table with correct header, in this case:

a b c

Useful extra information

The info below often helps, please fill it out if you're able to. :)

What operating system are you using?

  • Windows: ( version: ___ )
  • Linux: Arch Linux
  • macOS: ( version: ___ )
  • Other: ___

What is your DB4S version?

  • 3.12.2
  • 3.12.1
  • 3.12.0
  • 3.11.x
  • Other: ___

Did you also

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions