Edgewall Software

Ticket #3656 (closed defect: fixed)

Opened 2 years ago

Last modified 23 months ago

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

Reported by: jnanney@… Owned by: mgood
Priority: low Milestone: 0.10.1
Component: report system Version: devel
Severity: minor Keywords: mysql
Cc:

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

Change History

Changed 2 years ago by cboos

  • keywords mysql added

Changed 2 years ago by mgood

  • owner changed from daniel to mgood

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.

Changed 23 months ago by mgood

  • status changed from new to closed
  • resolution set to fixed

Fixed with r4028 (trunk) and r4029 (0.10)

Add/Change #3656 (Default reports in db_default.py have invalid operators for MySQL for concat operations)

Author



Change Properties
<Author field>
Action
as closed
Next status will be 'reopened'
 
Note: See TracTickets for help on using tickets.