Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.11.1, 10.6.12
-
None
Description
When using multi-statement capability, using multiple "SET STATEMENT sql_select_limit=xx FOR" in one query will set first "sql_select_limit" at session level, not only for the current query.
example executing command :
"SET STATEMENT sql_select_limit=2 FOR SELECT * FROM seq_1_to_5;SELECT * FROM seq_1_to_5;SET STATEMENT sql_select_limit=3 FOR SELECT * FROM seq_1_to_5;SELECT * FROM seq_1_to_5"
will return correctly return 2, 2, 3 and 3 rows, problem is that session sql_select_limit is then incorrectly set to value 2.
Attachments
Issue Links
- duplicates
-
MDEV-17711 Assertion `arena_for_set_stmt== 0' failed in LEX::set_arena_for_set_stmt upon SET STATEMENT
- Closed