1

Topic: request

Decided to use somehow  long request for Firebird 3
Tried to use for this purpose the user variables, it is similar to generators. Does not quit.
certainly stops, but on it hangs up. Tried IBExpert, and IBX:
To begin with I start:
SELECT RDB$SET_CONTEXT (' USER_SESSION ', ' D1363D9B6BA947ADB970E802E2380960 ', ' 1 ') FROM RDB$DATABASE
SELECT * FROM BIG_TABLE WHERE RDB$GET_CONTEXT (' USER_SESSION ', ' D1363D9B6BA947ADB970E802E2380960 ') = ' 1'
Also I complete:
SELECT RDB$SET_CONTEXT (' USER_SESSION ', ' D1363D9B6BA947ADB970E802E2380960 ', ' 0 ') FROM RDB$DATABASE

2

Re: request

guestnewguest;
to invent any nonsense if there is a regular means delete from mon$statements?

3

Re: request

Simonov Denis;
Well i.e. this standard behavior?
Feature?

4

Re: request

guestnewguest;
What feature? Monitoring tables this regular feature. Is still asynchronous cancellings of the operator through API

5

Re: request

guestnewguest wrote:

SELECT * FROM BIG_TABLE WHERE
RDB$GET_CONTEXT (' USER_SESSION ', ' D1363D9B6BA947ADB970E802E2380960 ') = ' 1'
Also I complete:
SELECT RDB$SET_CONTEXT (' USER_SESSION ', ' D1363D9B6BA947ADB970E802E2380960 ', ' 0 ') FROM
RDB$DATABASE

Give I will guess: you send "completing" request in other flow?. It is stupid to stop  and
To close request - a way not for Samurais? For a call fb_cancel the programmer, and near at hand is necessary
Any is not present?.

6

Re: request

guestnewguest wrote:

well i.e. this standard behavior?

The odd fellow, at Firebird the optimizer, especially  are not able constant expression
elimination. That you installed a variable checked in WHERE, does not stop request.
It will continue  all table, simply ceases to give the found. And you could
And itself it to guess if involved a brain instead of : a trick with the generator
Does not cancel request, and carries out loop termination as it is used exceptional in
PSQL.