| Subject | Re: [firebird-support] Why PLAN token is not allowed after ORDER BY? |
|---|---|
| Author | Dmitry Kuzmenko |
| Post date | 2012-06-02T20:31:46Z |
Hello, Alec!
Saturday, June 2, 2012, 11:28:52 PM, you wrote:
AS> specify a plan for a query that has ORDER BY clause. I get a "invalid
AS> token PLAN" error if I specify the plan after ORDER BY, but it works
AS> COPY INDEX ("PK_ZM6SRonqR8AHSQuCISgvnQ=="))
and, finally, who told you about "COPY" word in a plan,
or where you got it?
--
Dmitry Kuzmenko, www.ib-aid.com
Saturday, June 2, 2012, 11:28:52 PM, you wrote:
AS> specify a plan for a query that has ORDER BY clause. I get a "invalid
AS> token PLAN" error if I specify the plan after ORDER BY, but it works
AS> COPY INDEX ("PK_ZM6SRonqR8AHSQuCISgvnQ=="))
and, finally, who told you about "COPY" word in a plan,
or where you got it?
--
Dmitry Kuzmenko, www.ib-aid.com