MonetDB

Tracker: Bugs

5 SQL: incomplete documentation - ID: 2879823

Last Update: Settings changed ( mr-meltdown )

Details:

On the website, the following string operations are shown:

string_funcs:
SUBSTRING ( scalar_exp FROM scalar_exp FOR scalar_exp )
| SUBSTRING ( scalar_exp, scalar_exp, scalar_exp )
| SUBSTRING ( scalar_exp FROM scalar_exp )
| SUBSTRING ( scalar_exp, scalar_exp )
| SUBSTRING ( scalar_exp <int_value> scalar_exp )
| scalar_exp CONCATSTRING scalar_exp

However,
scalar_exp CONCATSTRING scalar_exp
doesn't appear to be valid.
Instead,
concat(scalar_exp, scalar_exp)
seems to d the job.

Submitted:

Roberto Cornacchia ( cornuz ) - 2009-10-15 11:36

Priority:

Status:

Closed

Resolution:

Fixed

Assigned:

Sjoerd Mullender

Category:

Documentation

Group:

Website

Visibility:

Public

Comments ( 2 )

Date: 2009-10-22 15:38 Sender: sjoerd I fixed the documentation in CVS by replacing CONCATSTRING with '\|\|'. The remaining question is, do we need to explain that \|\| is string concatenation?
Date: 2009-10-15 11:42 Sender: cornuz After talking to Fabian, I learned that CONCATSTRING is defined as \|\|. But how am I (as a user) supposed to know that? So, the real problem of this bug report is that documentation on web is not incorrect, but just incomplete (also in many other points). Making a documentation out of sources can be ok, but then it must be complete.

Attached File

Changes ( 4 )

Field	Old Value	Date	By
status_id	Open	2009-10-27 13:31	mr-meltdown
resolution_id	None	2009-10-27 13:31	mr-meltdown
close_date	-	2009-10-27 13:31	mr-meltdown
summary	SQL: scalar_exp CONCATSTRING scalar_exp	2009-10-15 11:42	cornuz

MonetDB

Tracker: Bugs

Comments ( 2 )

Attached File

No Files Currently Attached

Changes ( 4 )

About SourceForge

Find Software

Develop Software

Community

Help