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

Wrong result of select distinct with decfload/timezone/collated column [CORE5974] #6226

Closed
firebird-issue-importer opened this issue Dec 18, 2018 · 6 comments

Comments

@firebird-issue-importer

Submitted by: Alex Bekhtin (afgm)

with A(val) as (
select cast(15514 as decfloat(34)) from rdb$database union all
select cast(15514 as decfloat(34)) from rdb$database union all
select cast(15514 as decfloat(34)) from rdb$database
)
select distinct val from A
---
VAL
15514
15514

Commits: 272a49e 8258e51

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

Currently only DECFLOAT type is ckecked.
No check for TIMEZONE and COLLATED columns.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 19, 2018

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 19, 2018

Modified by: @asfernandes

summary: Wrong result of select distinct with decfload column => Wrong result of select distinct with decfload/timezone/collated column

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 19, 2018

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 4.0 Beta 1 [ 10750 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 19, 2018

Modified by: @asfernandes

Version: 4.0 Beta 1 [ 10750 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 21, 2018

Modified by: @pavel-zotov

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

QA Status: No test => Done with caveats

Test Details: Currently only DECFLOAT type is ckecked.
No check for TIMEZONE and COLLATED columns.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 21, 2018

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
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants