diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2021-01-21 16:40:36 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2021-01-22 00:04:31 +0100 |
| commit | 4e503aec7feaeb2297035f565ca92c98d4557577 (patch) | |
| tree | 35574fc7d97078a9dd7f92615efa959551271182 /mysql-test/main/information_schema.result | |
| parent | 61feb568bbbfc3ea68060bf9f59b4c3eeb999ca0 (diff) | |
| download | mariadb-git-4e503aec7feaeb2297035f565ca92c98d4557577.tar.gz | |
MDEV-24593 Signal 11 when group by primary key of table joined to information_schema.columns
I_S tables were materialized too late, an attempt to use table
statistics before the table was created caused a crash.
Let's move table creation up. it only needs read_set to
be calculated properly, this happens in JOIN::optimize_inner(),
after semijoin transformation.
Note that tables are not populated at that point, so most of the
statistics would make no sense anyway. But at least field sizes
will be correct. And it won't crash.
Diffstat (limited to 'mysql-test/main/information_schema.result')
| -rw-r--r-- | mysql-test/main/information_schema.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/main/information_schema.result b/mysql-test/main/information_schema.result index 7aa7a075eb0..dc8a23bf511 100644 --- a/mysql-test/main/information_schema.result +++ b/mysql-test/main/information_schema.result @@ -2282,5 +2282,14 @@ create table t2 (n int); insert into t1 set n = (select table_rows from information_schema.tables where table_name='t2'); drop table t1, t2; # +# MDEV-24593 Signal 11 when group by primary key of table joined to information_schema.columns +# +create table t1 (f varchar(64) primary key); +select f from information_schema.columns i +inner join t1 on f=i.column_name +group by f; +f +drop table t1; +# # End of 10.3 tests # |