Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

new Client 2.5.8 to server 2.5.7 server caused problem [CORE5709] #5975

Open
firebird-automations opened this issue Jan 15, 2018 · 1 comment

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Tommi Prami (mwaltari)

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-

@firebird-automations
Copy link
Collaborator Author

Commented by: Tommi Prami (mwaltari)

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant