Issue Details (XML | Word | Printable)

Key: CORE-5709
Type: Bug Bug
Status: Open Open
Priority: Minor Minor
Assignee: Unassigned
Reporter: Tommi Prami
Votes: 0
Watchers: 2
Operations

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

new Client 2.5.8 to server 2.5.7 server caused problem

Created: 15/Jan/18 06:57 AM   Updated: 15/Jan/18 08:37 AM
Component/s: API / Client Library
Affects Version/s: 2.5.8
Fix Version/s: None

Environment: Windows 10

QA Status: No test


 Description  « Hide
We accidentally updated 2.5.8 client to environment where is older 2.5.7 server.

With field defined as

CREATE DOMAIN CMN_BOOLEAN AS SMALLINT
CHECK (VALUE IS NULL OR VALUE IN (0, 1));

Now it crashes in our Delphi client application (Using IbDAC from DevArt) that field can't be accessed AsBoolean. (Just fixed from reading it AsInteger to AsBoolean to work with new client and server and with pure 2.5.7 environment)

This might be IbDAC issue, or Firebird issue.

Just filed this ticket to Firebird team can check is there some difference reading same field with 2.5.7 or 2.5.8 client when server is 2.5.7.

I have feeling that using mismatched fbclient.dll have not been much of a problem in past versions, (If it is same major version at least)

-Tee-



 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Tommi Prami added a comment - 15/Jan/18 08:37 AM
Seems that this is caused by nested Query in 2.5.7

SELECT BOOLFIELD ... FROM
(
  ...
  SELECT DS2.BOOLFIELD
  INNER JOIN TABLE2 DS2 ON ..
     

  UNION ALL

  ...
  SELECT DS2.BOOLFIELD
  INNER JOIN TABLE2 DS2 ON ..
)

So the CMN_BOOLEAN domain don't got passed trough some how.

If we put that field as Inner join at the outer SELECT it works just fine.