Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

RETURNING keyword not implemented? #2720

Copy link
Copy link
@tinxx

Description

@tinxx
Issue body actions

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

AlttiRi

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      Morty Proxy This is a proxified and sanitized view of the page, visit original site.