| Subject | Re[4]: [firebird-support] Why PLAN token is not allowed after ORDER BY? |
|---|---|
| Author | Dmitry Kuzmenko |
| Post date | 2012-06-02T22:27:42Z |
Hello, Alec!
AS> 2. Changed the query to "A INNER JOIN B ORDER BY X PLAN P", where P is the
AS> plan generated by FB in #1. Received "Unexpected token PLAN" error.
AS> 3. Change the query to "A INNER JOIN B PLAN P ORDER BY X" - success!
AS> Why does #3 succeed but #2 fail?
because inner join is not equal to left join.
--
Dmitry Kuzmenko, www.ib-aid.com
AS> 2. Changed the query to "A INNER JOIN B ORDER BY X PLAN P", where P is the
AS> plan generated by FB in #1. Received "Unexpected token PLAN" error.
AS> 3. Change the query to "A INNER JOIN B PLAN P ORDER BY X" - success!
AS> Why does #3 succeed but #2 fail?
because inner join is not equal to left join.
--
Dmitry Kuzmenko, www.ib-aid.com