Optimizer table elimination suggestion

Asked by Nikolay Mihaylov

I believe it will be easy, if you implement following cases for optimizer table elimination:
create view v_xxx as

   (select first_name from users where id = products.user) as product

then user can do:

select id from v_xxx ;

this case is almost identical to left outher join you already implemented. You do not need to know "first_name" column. Is eighter set or is NULL.

Question information

English Edit question
MariaDB Edit question
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Igor Babaev (igorb-seattle) said :

I hardly can associate this case with table elimination. Rather this is an optimization for selection from views. If you have a patch for it we'll add it to the server.

Can you help with this problem?

Provide an answer of your own, or ask Nikolay Mihaylov for more information if necessary.

To post a message you must log in.