| Subject | Re[2]: [firebird-support] Why PLAN token is not allowed after ORDER BY? |
|---|---|
| Author | Dmitry Kuzmenko |
| Post date | 2012-06-02T21:17:16Z |
Hello, Alec!
AS> The question is why FB complains about PLAN token after ORDER BY clause?
the answer is that PLAN is wrong. ORDER BY in query affects PLAN, it
will contain PLAN SORT or TABLE ORDER INDEX specification. Your PLAN
specification is crap, sorry for rude answer.
As I said before, you need to know how Firebird produces plan
specification and how it accepts it.
--
Dmitry Kuzmenko, www.ib-aid.com
AS> The question is why FB complains about PLAN token after ORDER BY clause?
the answer is that PLAN is wrong. ORDER BY in query affects PLAN, it
will contain PLAN SORT or TABLE ORDER INDEX specification. Your PLAN
specification is crap, sorry for rude answer.
As I said before, you need to know how Firebird produces plan
specification and how it accepts it.
--
Dmitry Kuzmenko, www.ib-aid.com