Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
N/A
Description
MariaDB [test]> analyze insert into t1 values (1),(2); |
Query OK, 2 rows affected (0.07 sec) |
Records: 2 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [test]> explain insert into t1 values (1),(2); |
+------+-------------+-------+------+---------------+------+---------+------+------+-------+ |
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | |
+------+-------------+-------+------+---------------+------+---------+------+------+-------+ |
| 1 | INSERT | t1 | ALL | NULL | NULL | NULL | NULL | NULL | NULL | |
+------+-------------+-------+------+---------------+------+---------+------+------+-------+ |
1 row in set (0.00 sec) |
MariaDB [test]> analyze replace into t1 values (1),(2); |
Query OK, 2 rows affected (0.05 sec) |
Records: 2 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [test]> explain replace into t1 values (1),(2); |
+------+-------------+-------+------+---------------+------+---------+------+------+-------+ |
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | |
+------+-------------+-------+------+---------------+------+---------+------+------+-------+ |
| 1 | INSERT | t1 | ALL | NULL | NULL | NULL | NULL | NULL | NULL | |
+------+-------------+-------+------+---------------+------+---------+------+------+-------+ |
1 row in set (0.00 sec) |
Branch: 10.1
|
commit b95ec135533b13e921aa8de1b9c769d47b2efe60
|
Author: Alexey Botchkov <holyfoot@montyprogram.com>
|
Date: Thu Jun 26 11:37:24 2014 +0500
|
Attachments
Issue Links
- relates to
-
MDEV-406 ANALYZE $stmt
-
- Closed
-
Activity
| Description |
MariaDB [test]> analyze insert into t1 values (1),(2); Query OK, 2 rows affected (0.07 sec) Records: 2 Duplicates: 0 Warnings: 0 {code:sql} MariaDB [test]> explain insert into t1 values (1),(2); +------+-------------+-------+------+---------------+------+---------+------+------+-------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+------+---------------+------+---------+------+------+-------+ | 1 | INSERT | t1 | ALL | NULL | NULL | NULL | NULL | NULL | NULL | +------+-------------+-------+------+---------------+------+---------+------+------+-------+ 1 row in set (0.00 sec) {code} {code:sql} MariaDB [test]> analyze replace into t1 values (1),(2); Query OK, 2 rows affected (0.05 sec) Records: 2 Duplicates: 0 Warnings: 0 MariaDB [test]> explain replace into t1 values (1),(2); +------+-------------+-------+------+---------------+------+---------+------+------+-------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+------+---------------+------+---------+------+------+-------+ | 1 | INSERT | t1 | ALL | NULL | NULL | NULL | NULL | NULL | NULL | +------+-------------+-------+------+---------------+------+---------+------+------+-------+ 1 row in set (0.00 sec) {code} {noformat} Branch: 10.1 commit b95ec135533b13e921aa8de1b9c769d47b2efe60 Author: Alexey Botchkov <holyfoot@montyprogram.com> Date: Thu Jun 26 11:37:24 2014 +0500 {noformat} |
{code:sql} MariaDB [test]> analyze insert into t1 values (1),(2); Query OK, 2 rows affected (0.07 sec) Records: 2 Duplicates: 0 Warnings: 0 MariaDB [test]> explain insert into t1 values (1),(2); +------+-------------+-------+------+---------------+------+---------+------+------+-------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+------+---------------+------+---------+------+------+-------+ | 1 | INSERT | t1 | ALL | NULL | NULL | NULL | NULL | NULL | NULL | +------+-------------+-------+------+---------------+------+---------+------+------+-------+ 1 row in set (0.00 sec) {code} {code:sql} MariaDB [test]> analyze replace into t1 values (1),(2); Query OK, 2 rows affected (0.05 sec) Records: 2 Duplicates: 0 Warnings: 0 MariaDB [test]> explain replace into t1 values (1),(2); +------+-------------+-------+------+---------------+------+---------+------+------+-------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-------+------+---------------+------+---------+------+------+-------+ | 1 | INSERT | t1 | ALL | NULL | NULL | NULL | NULL | NULL | NULL | +------+-------------+-------+------+---------------+------+---------+------+------+-------+ 1 row in set (0.00 sec) {code} {noformat} Branch: 10.1 commit b95ec135533b13e921aa8de1b9c769d47b2efe60 Author: Alexey Botchkov <holyfoot@montyprogram.com> Date: Thu Jun 26 11:37:24 2014 +0500 {noformat} |
| Component/s | Optimizer [ 10200 ] | |
| Fix Version/s | 10.1.1 [ 16801 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Labels | analyze-stmt |
| Workflow | MariaDB v2 [ 48415 ] | MariaDB v3 [ 65254 ] |
| Workflow | MariaDB v3 [ 65254 ] | MariaDB v4 [ 147999 ] |