Edgewall Software
Modify

Opened 18 years ago

Closed 18 years ago

#3656 closed defect (fixed)

Default reports in db_default.py have invalid operators for MySQL for concat operations

Reported by: jnanney@… Owned by: Matthew Good
Priority: low Milestone: 0.10.1
Component: report system Version: devel
Severity: minor Keywords: mysql
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

While not critical to 0.10 release, there are several reports in

db_default.py that use the operator
to concatenate the results set

with a * for reports that have been assigned. While this does not work in MySQL, it does not break the actual reports.

In MySQL 4.1.12 this operator is not supported. You have to use this.

concat(owner, '*')

instead of

owner||' *'

Attachments (0)

Change History (3)

comment:1 by Christian Boos, 18 years ago

Keywords: mysql added

comment:2 by Matthew Good, 18 years ago

Owner: changed from daniel to Matthew Good
SQLite does not have a "concat" function, and AFAICT neither does PostgreSQL. I'm surpised MySQL still doesn't support the "
" concatenation operator since it's part of the ANSI standard.

I'll take a look at making the reports work correctly on MySQL.

comment:3 by Matthew Good, 18 years ago

Resolution: fixed
Status: newclosed

Fixed with r4028 (trunk) and r4029 (0.10)

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Matthew Good.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Matthew Good to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.