Skip to content

SQL SELECT action should throw an error when Statement is not Select and must not insert/modify data #39

@stas-fomenko

Description

@stas-fomenko

Description SQL SELECT action actually adding data into DB, however it shoud accept SELECT stataments only

STR:

  1. create flow with SELECT action, input (change id for your input):
INSERT INTO Employee (empid, empname, joiningdate)
VALUES (11251, 'try to insert', '2019-10-22T12:24:18.920Z');
  1. Retrieve sample

AR:
image

ER:
Error that only SELECT Statement is supported thrown
No data affected (nothing created/updated)

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions