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

Sorting is allowed for blobs [CORE859] #1249

Open
firebird-issue-importer opened this issue Jul 19, 2006 · 19 comments
Open

Sorting is allowed for blobs [CORE859] #1249

firebird-issue-importer opened this issue Jul 19, 2006 · 19 comments

Comments

@firebird-issue-importer

Submitted by: @dyemanov

Relate to QA71
Is duplicated by CORE3253
Is duplicated by CORE3252

The engine allows blobs and arrays to be sorted on. Both GROUP BY and ORDER BY on blobs can prepared successfully. All versions (except v2.1) throw a runtime error for GROUP BY due to inability to convert from a blob. ORDER BY [a kind of] works in all versions.

As it produces wrong or undesirable results, cannot be implemented properly due to the sorter restrictions and makes very little sense in practice, I'm going to reject this on the prepare stage.

Commits: b32234e fec2f3e a05bc8f 653dfe8

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 19, 2006

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.1 [ 10041 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 21, 2007

Commented by: @pcisar

Fix confirmed for 2.1 Alpha 1. Test added.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 21, 2007

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 26, 2007

Commented by: @pcisar

Reopened to update ticket information.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 26, 2007

Modified by: @pcisar

status: Closed [ 6 ] => Reopened [ 4 ]

resolution: Fixed [ 1 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 26, 2007

Modified by: @pcisar

Fix Version: 2.1 Alpha 1 [ 10150 ]

Fix Version: 2.1.0 [ 10041 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 26, 2007

Modified by: @pcisar

status: Reopened [ 4 ] => Closed [ 6 ]

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 17, 2007

Modified by: @pcisar

Link: This issue is related to QA71 [ QA71 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 26, 2008

Commented by: @dyemanov

Restored the legacy behavior until we're able to implement DISTINCT for blobs properly.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 26, 2008

Modified by: @dyemanov

status: Closed [ 6 ] => Reopened [ 4 ]

resolution: Fixed [ 1 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 26, 2008

Modified by: @dyemanov

Fix Version: 2.1 Alpha 1 [ 10150 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 28, 2008

Modified by: @pcisar

Workflow: jira [ 11082 ] => Firebird [ 14448 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 4, 2008

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 4, 2008

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 26, 2009

Modified by: @pcisar

Link: This issue relate to QA71 [ QA71 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 26, 2009

Modified by: @pcisar

Link: This issue is related to QA71 [ QA71 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 20, 2010

Modified by: @dyemanov

Link: This issue is duplicated by CORE3253 [ CORE3253 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 20, 2010

Modified by: @dyemanov

Link: This issue is duplicated by CORE3252 [ CORE3252 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 3, 2014

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ] =>

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