[Firebird-devel] ORDER BY and nested IF-ELSE-IF Problems

[Chris K. <ch...@e-...>]

Howdy,

I've got an SP which simply contains:

FOR SELECT flt_from,flt_to,flt_a,flt_b
  FROM tlkp_paygcoeff
  WHERE str_payg = :str_payg
  ORDER BY flt_from
  INTO :flt_from,:flt_to,:flt_a,:flt_b
DO SUSPEND;

I'm running 1.5RC8 Classic Server on FreeBSD.
When I add it to a database with isql, I get:

Statement failed, SQLCODE = -104

Dynamic SQL Error
-SQL error code = -104
-Invalid expression in the ORDER BY clause (not contained in either an
aggregate function or the GROUP BY clause)
Statement failed, SQLCODE = -607

This works fine under 1.0.2 on FreeBSD. What gives?

Also, if you have nested IF-ELSE-IF's, isql generates an 'Unexpected end of
command' error at the 25th nested IF. Again, 1.0.2 on FreeBSD doesn't
exhibit this problem. How did this get broken?

Regards,
Chris Knight
Systems Administrator
E-Easy
Tel: +61 3 6334 9995  Fax: +61 3 6331 7032  Mob: +61 419 528 795
Web: http://www.e-easy.com.au