Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
Description
create table t1 (i int);
|
insert into t1 values (1);
|
ANALYZE SELECT ... INTO @var will not set @var:
analyze select * from t1 into @var;
|
+------+-------------+-------+------+---------------+------+---------+------+------+--------+----------+------------+-------+
|
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | r_rows | filtered | r_filtered | Extra |
|
+------+-------------+-------+------+---------------+------+---------+------+------+--------+----------+------------+-------+
|
| 1 | SIMPLE | t1 | ALL | NULL | NULL | NULL | NULL | 1 | 1 | 100.00 | 100.00 | |
|
+------+-------------+-------+------+---------------+------+---------+------+------+--------+----------+------------+-------+
|
1 row in set (0.00 sec)
|
 |
MariaDB [j14]> select @var;
|
+------+
|
| @var |
|
+------+
|
| NULL |
|
+------+
|
1 row in set (0.00 sec)
|
If we assume that ANALYZE $stmt should make the action specified by $stmt, then @var should be set.
Attachments
Issue Links
- relates to
-
MDEV-406 ANALYZE $stmt
- Closed