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

Allow usage of functions in LIST delimiter parameter [CORE1453] #1871

Closed
firebird-issue-importer opened this issue Sep 12, 2007 · 9 comments
Closed

Comments

@firebird-issue-importer

Submitted by: Poul Dige (tabulex)

Is duplicated by CORE3104
Is related to QA303

In the LIST function it would be codewise nice to be able to use ASCII_CHAR as separator, e.g. in connection with creating a comment list like

SELECT discussion_id, LIST( comment, ASCII_CHAR(13) )
from tcomments
group by discussion_id

As it is now, you can acheive the same functionality by using

SELECT discussion_id, LIST( comment || ASCII_CHAR(13) , '' )
from tcomments
group by discussion_id

Commits: 3e13fd7 f19d9ec FirebirdSQL/fbt-repository@8a3d33b

@firebird-issue-importer
Copy link
Author

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

Modified by: @pcisar

Workflow: jira [ 13031 ] => Firebird [ 13931 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 5, 2008

Modified by: @asfernandes

Fix Version: 2.5 Alpha 1 [ 10224 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

summary: Improvement of the LIST() function in FB => Allow usage of functions in LIST delimiter parameter

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 5, 2008

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Development: Finished

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 14, 2010

Modified by: @asfernandes

Version: 2.1.4 [ 10361 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 14, 2010

Modified by: @asfernandes

Link: This issue is duplicated by CORE3104 [ CORE3104 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 23, 2011

Modified by: @pcisar

Link: This issue is related to QA303 [ QA303 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 23, 2011

Modified by: @pmakowski

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 19, 2016

Modified by: @pavel-zotov

QA Status: No test

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 19, 2016

Modified by: @pavel-zotov

QA Status: No test => Done successfully

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