Hi, Federico!
On May 12, Federico Razzoli wrote:
Hi Sergej,
Thank you for this update. I'm still curious: does CONNECT read the
rows several times? If so, is there a way to avoid this until the bug
is solved?
I suppose you've seen the answer in the bug report. But just for the
sake of
Hi, Roberto!
On May 26, Roberto Spadim wrote:
maybe include at extra estimative rows count
just to understand what happened
Row count in the EXPLAIN output is *always* an estimation, there is no
need to specify it explicitly because it is always the case.
I suppose you've seen the answer in
Hi, Federico!
On Mar 27, Federico Razzoli wrote:
Hi Sergei
You can repeat this very easily:
MariaDB [test] CREATE TABLE t_connect (c INT PRIMARY KEY) ENGINE=CONNECT
TABLE_TYPE=CSV;
Query OK, 0 rows affected, 1 warning (0.11 sec)
Warning (Code 1105): No file name. Table will use
: Re: [Maria-discuss] EXPLAIN and CONNECT
Para: Federico Razzoli federico_...@yahoo.it
CC: maria-discuss@lists.launchpad.net
Fecha: lunes, 12 de mayo, 2014 15:40
Hi, Federico!
On Mar 27, Federico Razzoli
wrote:
Hi Sergei
You can repeat this very easily:
MariaDB [test]
CREATE
| |
+--+-+---+--+---+--+-+--+--+---+
1 row in set (0.00 sec)
But adding more rows, the difference between the rows value and the reality
becomes big.
Regards
Federico
Mer 26/3/14, Sergei Golubchik s...@mariadb.org ha scritto:
Oggetto: Re: [Maria-discuss] EXPLAIN
Hello list
I found out that EXPLAIN SELECT aggregate_func() FROM connect_table returns a
rows value which is much greater than the rows in the table. For example:
MariaDB [test] SELECT COUNT(*) FROM t;
+--+
| COUNT(*) |
+--+
| 100 |
+--+
1 row in set (0.49 sec)
6 matches
Mail list logo