Issue Details (XML | Word | Printable)

Key: CORE-6108
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Gilberto Ximenes
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Regression: FB3 throws "Datatypes are not comparable in expression" in procedure parameters

Created: 24/Jul/19 02:01 PM   Updated: 17/Dec/19 08:36 AM
Component/s: None
Affects Version/s: 3.0.4
Fix Version/s: 3.0.5, 4.0 Beta 2

Issue Links:
Relate
 

QA Status: Done successfully
Test Details: Don't close until 3.0.x will be fixed (4.x now is OK).


 Description  « Hide
Test case:

SET TERM ^ ;

CREATE OR ALTER procedure TEST_PROC (
    P_DATE date)
returns (
    OUT_VALUE date)
as
begin
  OUT_VALUE = P_DATE;

  suspend;
end^

SET TERM ; ^


SELECT OUT_VALUE
FROM TEST_PROC('2019-'|| COALESCE(:ID_MES, 1) ||'-01');
/*
FB2.5 - OK

FB3.0.4.33054-0_x64- Raises
Invalid token.
SQL error code = -104.
Datatypes are not comparable in expression .
*/


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Adriano dos Santos Fernandes added a comment - 06/Aug/19 03:27 PM
Please test the fix in next FB 4 snapshot if possible.

Gilberto Ximenes added a comment - 06/Aug/19 04:27 PM
Will it be fixed in FB 3 series too?

Adriano dos Santos Fernandes added a comment - 06/Aug/19 05:58 PM
Yes, but I would prefer if you validate your real cases first in FB 4 snapshot.

Gilberto Ximenes added a comment - 07/Aug/19 06:10 PM
Tested in Firebird-4.0.0.1572-0_Win32 and everything works fine. Thank you!

Pavel Zotov added a comment - 30/Aug/19 02:18 PM
Adriano,

i've tested on 4.0.0.1573 x64 - all fine; but 3.0.5.33162 is not yet fixed and bug remains there.