spetrunia

Stop #2:

  Breakpoint 9, mysql_make_view (thd=0x7fffd1633070, parser=0x7fffe15c2088, table=0x7fffe15e3088, flags=0) at /home/psergey/dev-git/10.1/sql/sql_view.cc:1209
(gdb)  
(gdb) next
(gdb) p lex
  $312 = (LEX *) 0x7fffe15e3660
(gdb) p view_select->select_number
  $313 = 3
(gdb) p view_select

spetrunia

  Breakpoint 8, mysql_new_select (lex=0x7fffe1610088, move_down=true) at /home/psergey/dev-git/10.1/sql/sql_parse.cc:6252
(gdb) next
(gdb) next
(gdb) p lex
  $315 = (LEX *) 0x7fffe1610088
(gdb) p select_lex
  $316 = (SELECT_LEX *) 0x7fffe1611470
(gdb) p select_lex->select_number
  $317 = 4
(gdb) wher

spetrunia

 
  Breakpoint 8, mysql_new_select (lex=0x7fffe15e9088, move_down=true) at /home/psergey/dev-git/10.1/sql/sql_parse.cc:6252
(gdb) next
(gdb) next
(gdb) p lex
  $332 = (LEX *) 0x7fffe15e9088
(gdb) p select_lex
  $333 = (SELECT_LEX *) 0x7fffe15ea470
(gdb) p select_lex->select_number
  $334 = 2

spetrunia

  Breakpoint 9, mysql_make_view (thd=0x7fffd1633070, parser=0x7fffe157b088, table=0x7fffe1613088, flags=0) at /home/psergey/dev-git/10.1/sql/sql_view.cc:1209
(gdb) next
(gdb) p view_select
  $336 = (SELECT_LEX *) 0x7fffe1613e10
(gdb) p view_select0->select_number
  No symbol "view_select0" in current context.
(gdb) p view_select->select_number
  $337 = 3
(gdb) wher
  #0  mysql_make_view (thd=0x7fffd1633070, parser=0x7fffe157b088, table=0x7fffe1613088, flags=0) at /home/psergey/dev-git/10.1/sql/sql_view.cc:1211

spetrunia

  
  Breakpoint 8, mysql_new_select (lex=0x7fffe160d088, move_down=true) at /home/psergey/dev-git/10.1/sql/sql_parse.cc:6252
(gdb) next
(gdb) next
(gdb) p select_lex->select_number
  $338 = 4
(gdb) p select_lex
  $339 = (SELECT_LEX *) 0x7fffe160e470
(gdb) p lex
  $340 = (LEX *) 0x7fffe160d088

spetrunia

 
  Breakpoint 9, mysql_make_view (thd=0x7fffd1633070, parser=0x7fffe157b088, table=0x7fffe15e0088, flags=0) at /home/psergey/dev-git/10.1/sql/sql_view.cc:1209
(gdb) next
(gdb) p lex
  $341 = (LEX *) 0x7fffe1689088
(gdb) p view_select
  $342 = (SELECT_LEX *) 0x7fffe1689838
(gdb) p view_select->select_number
  $343 = 2
(gdb) wher

spetrunia

  
  Breakpoint 3, JOIN::optimize (this=0x7fffe168c088) at /home/psergey/dev-git/10.1/sql/sql_select.cc:1022
(gdb) down
  Bottom (innermost) frame selected; you cannot go down.
(gdb) p select_lex
  $344 = (SELECT_LEX *) 0x7fffe15ea470
(gdb) p select_lex->select_number
  $345 = 2
(gdb) c
  Continuing.

spetrunia

# Modified by YaST2. Last modification on Sat Apr 26 06:20:01 UTC 2008
default 0
timeout 30
gfxmenu (hd0,1)/boot/message

title Windows XP
    map (hd0) (hd1)
    map (hd1) (hd0)
    rootnoverify (hd1,1)
    chainloader (hd1,1)+1

spetrunia

Query OK, 0 rows affected (0.00 sec)

MariaDB [j58]> explain SELECT alias2.pk    FROM A    LEFT JOIN B AS alias1    INNER JOIN B AS alias2      ON alias1.col_int_key = alias2.col_int_key      ON alias2.col_varchar_10_latin1 = A.col_varchar_1024_utf8_key  ORDER BY alias2.pk LIMIT 10;
+------+-------------+--------+------+---------------+-------------+---------+------------------------+------+---------------------------------+
| id   | select_type | table  | type | possible_keys | key         | key_len | ref                    | rows | Extra                           |
+------+-------------+--------+------+---------------+-------------+---------+------------------------+------+---------------------------------+
|    1 | SIMPLE      | A      | ALL  | NULL          | NULL        | NULL    | NULL                   |  100 | Using temporary; Using filesort |
|    1 | SIMPLE      | alias2 | ALL  | col_int_key   | NULL        | NULL    | NULL                   |    7 | Using where                     |

spetrunia

MariaDB [j58]> explain SELECT alias2.pk    FROM A    LEFT JOIN B AS alias1    INNER JOIN B AS alias2      ON alias1.col_int_key = alias2.col_int_key      ON alias2.col_varchar_10_latin1 = A.col_varchar_1024_utf8_key  ORDER BY alias2.pk LIMIT 10;
+------+-------------+--------+------+---------------+-------------+---------+------------------------+------+---------------------------------+
| id   | select_type | table  | type | possible_keys | key         | key_len | ref                    | rows | Extra                           |
+------+-------------+--------+------+---------------+-------------+---------+------------------------+------+---------------------------------+
|    1 | SIMPLE      | A      | ALL  | NULL          | NULL        | NULL    | NULL                   |  100 | Using temporary; Using filesort |
|    1 | SIMPLE      | alias2 | ALL  | col_int_key   | NULL        | NULL    | NULL                   |    7 | Using where                     |
|    1 | SIMPLE      | alias1 | ref  | col_int_key