Hi!
Faced with a confusing situation after upgrading to the latest version.
There are two tables:
In the first two records, in the second one.
I do SELECT * FROM ferst_table; The result is two records.
Then I do SELECT * FROM next_table; The result is two records.
Why does the second one return two records instead of one?
P.S. I saw that in version 117 added the ability to select the transaction, I do not know whether it could have some effect.
Sorry for the long response.
Workflow and database schema below.
I expect that on each query, I get the data that is in the database, but it is not…
SQL Shema
CREATE TABLE IF NOT EXISTS first_table(
name VARCHAR
);
INSERT INTO first_table (name) VALUES ('first'), ('second');
CREATE TABLE IF NOT EXISTS next_table(
name VARCHAR
);
INSERT INTO next_table (name) VALUES ('first');
Since your previous node returns 2 items, the next node gets executed twice. If the first node returns 10 items, the next node will be executed 10 times. Since you are not using the information coming from the previous node and you want to execute your query only once, you can set the Execute Once option to true. You can find that option in the node’s setting tab. Below is a screenshot