Skip to content

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

@stas-fomenko

Description

@stas-fomenko

Description Trigger throws an error Component did not send any data during timeout. when INSERT Statement is in input but actually data is added into DB

STR:

  1. SQL SELECT Statement input:
INSERT INTO Employee (EmpID, EmpName, JoingTimeStamp)
VALUES (13251, 'try to insert', '2019-10-22T12:24:18.920Z');
  1. Retrieve sample

AR:
Error thrown: Error! Component did not send any data during timeout. but row is actually inserted
Logs:

Starting your Docker container ...
[INFO  tini (1)] Spawned child process '/run.sh' with pid '6'
Starting application in apprunner...
Will try to start app at /home/apprunner
node: /usr/lib/libstdc++.so.6: no version information available (required by node)
node: /usr/lib/libstdc++.so.6: no version information available (required by node)
node: /usr/lib/libstdc++.so.6: no version information available (required by node)
node: /usr/lib/libstdc++.so.6: no version information available (required by node)
node: /usr/lib/libstdc++.so.6: no version information available (required by node)
node: /usr/lib/libstdc++.so.6: no version information available (required by node)
node: /usr/lib/libstdc++.so.6: no version information available (required by node)
node: /usr/lib/libstdc++.so.6: no version information available (required by node)
node: /usr/lib/libstdc++.so.6: no version information available (required by node)
Connecting to the database
Connection established
Checking if incoming messages is lightweight...
Last polling timestamp=1970-01-01T00:00:00.000Z
Query execution completed, affected=1

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