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

COLLATE PXW_CSY doesn't work [CORE6066] #6316

Closed
firebird-automations opened this issue May 23, 2019 · 6 comments
Closed

COLLATE PXW_CSY doesn't work [CORE6066] #6316

firebird-automations opened this issue May 23, 2019 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Roland Turcan (rotursoft)

select * from DRUHY_DOKLADOV_COMBO
where upper(nazov_skratka collate pxw_csy) = 'ABC';

raises exception:

Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -204
COLLATION PXW_CSY for CHARACTER SET NONE is not defined

Database Default Character Set WIN1250

but this works on 3.0.3 fine with the same environment, it must be a bug in shapshots.

====== Test Details ======

See core_1056.fbt; core_1802.fbt; core_6336.fbt

@firebird-automations
Copy link
Collaborator Author

Modified by: Roland Turcan (rotursoft)

summary: COLLATE PXW_CSY does't work on build 3.0.5.33126-0_x64_win => COLLATE PXW_CSY doesn't work on build 3.0.5.33126-0_x64_win

@firebird-automations
Copy link
Collaborator Author

Modified by: Roland Turcan (rotursoft)

Version: 3.0.4 [ 10863 ]

description: select * from DRUHY_DOKLADOV_COMBO
where upper(nazov_skratka collate pxw_csy) = 'ABC';

raises exception:

Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -204
COLLATION PXW_CSY for CHARACTER SET NONE is not defined

Database Default Character Set WIN1250

but this works on 3.0.4 fine with the same environment, it must be a bug in shapshots.

=>

select * from DRUHY_DOKLADOV_COMBO
where upper(nazov_skratka collate pxw_csy) = 'ABC';

raises exception:

Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -204
COLLATION PXW_CSY for CHARACTER SET NONE is not defined

Database Default Character Set WIN1250

but this works on 3.0.3 fine with the same environment, it must be a bug in shapshots.

summary: COLLATE PXW_CSY doesn't work on build 3.0.5.33126-0_x64_win => COLLATE PXW_CSY doesn't work

Version: 3.0.5 [ 10885 ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: Roland Turcan (rotursoft)

I have checked in 3.0.7 and it works fine again. This issue can be closed.

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Covered by another test(s)

Test Details: See core_1056.fbt; core_1802.fbt; core_6336.fbt

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

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