[firebird-support] FB 3.0, Dialect 1 and SQL Error

[michael.vilhelm...@microcom.dk [firebird-support]]

Hi

I have installed Firebird 3.0. I'm testing our program up against this one. 
Our databases are in SQL dialect 1.

I have a table like this:

CREATE TABLE MYTABLE 
(
  ID                      INTEGER         NOT NULL,
  NAME_                   VARCHAR(    30),
  VALUEFLOAT              NUMERIC( 18, 2) DEFAULT 0,
  VALUEINT                INTEGER         DEFAULT 0,
  AAR                     INTEGER         DEFAULT 0,
  MDR                     INTEGER         DEFAULT 0,
 CONSTRAINT PK_MYTABLE PRIMARY KEY (ID)
);


If I do this SQL, I get an error:

SELECT
  MYTABLE.NAME_,
  Sum(MYTABLE.VALUEFLOAT) AS SumFloat,
  Sum(MYTABLE.VALUEINT) AS SumInteger
FROM
  MYTABLE        
WHERE
  ((MYTABLE.AAR * 100) + MYTABLE.MDR) >= ((:PAar * 100) + :PMDR)
GROUP BY
  NAME_
  

ERROR:
Dynamic SQL Error expression evaluation not supported Invalid data type for 
multiplication in dialect 1

 It works if I replace the parameters with numbers like this:
 

 SELECT
  MYTABLE.NAME_,
  Sum(MYTABLE.VALUEFLOAT) AS SumFloat,
  Sum(MYTABLE.VALUEINT) AS SumInteger
FROM
  MYTABLE        
WHERE
  ((MYTABLE.AAR * 100) + MYTABLE.MDR) >= ((2016 * 100) + 5)
GROUP BY
  NAME_
  

 

 

 So my question is, if there is a simple workaround to avoid this?
 I have tried googling something on this, but havn't found anything so far.
 I have read the release notes, but either cant find anything on this or I'm 
not looking good enough.
 

 Michael