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: | 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
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 , 18 years ago
Keywords: | mysql added |
---|
comment:2 by , 18 years ago
Owner: | changed from | to
---|
comment:3 by , 18 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
I'll take a look at making the reports work correctly on MySQL.