With the following query, the plugin treats each line as a separate query (and places a green run triangle before each line).
CALL dbms.procedures() YIELD name, signature
RETURN name
If I execute the first line, the Log tab only shows the first line executing, and the Table tab shows the name and signature columns.
If I execute the second line, I get an error ("Variable name not defined").
What SHOULD happen is that: (1) there should only be a single run triangle, and it should be on the first line), (2) both lines should be executed as part of a single query, (3) the Log tab should show both lines executing, and (4) the Table tab should show only the name column.
NOTE: The fix for a previous issue (#89) addresses this, but only if the YIELD is followed by a WHERE clause. For example, this works as expected:
CALL dbms.procedures() YIELD name, signature
WHERE name STARTS WITH 'dbms.'
RETURN name
With the following query, the plugin treats each line as a separate query (and places a green run triangle before each line).
If I execute the first line, the Log tab only shows the first line executing, and the Table tab shows the name and signature columns.
If I execute the second line, I get an error ("Variable
name
not defined").What SHOULD happen is that: (1) there should only be a single run triangle, and it should be on the first line), (2) both lines should be executed as part of a single query, (3) the Log tab should show both lines executing, and (4) the Table tab should show only the
name
column.NOTE: The fix for a previous issue (#89) addresses this, but only if the YIELD is followed by a WHERE clause. For example, this works as expected: