Wrong result of select distinct with decfload/timezone/collated column [CORE5974] #6226
Assignees
Comments
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandessummary: Wrong result of select distinct with decfload column => Wrong result of select distinct with decfload/timezone/collated column |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 Beta 1 [ 10750 ] |
Modified by: @asfernandesVersion: 4.0 Beta 1 [ 10750 ] => |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Done with caveats Test Details: Currently only DECFLOAT type is ckecked. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
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.
The text was updated successfully, but these errors were encountered: