| Issue 268: | upgrade016_017_mysql.sql incorrectly populates changes.change_key | |
| Back to list |
Reported by Benjamin Gilbert <bgilbert@backtick.net> on Wed Aug 26 10:10:21 PDT 2009
Source: JIRA GERRIT-269
Affected Version: 2.0.19.1
Environment: MySQL 5.0.75 from Ubuntu Jaunty
The statement:
UPDATE changes SET change_key = 'I' || (SELECT p.revision FROM patch_sets p
WHERE p.change_id = changes.change_id AND p.patch_set_id = 1);
in upgrade016_017_mysql.sql always sets change_key to either 0 or 1, since ||
is the logical-OR operator. I think you want:
UPDATE changes SET change_key = CONCAT('I', (SELECT p.revision FROM patch_sets
p WHERE p.change_id = changes.change_id AND p.patch_set_id = 1));
Sep 24, 2009
#1
code-rev...@gtempaccount.com
Sep 24, 2009
Update by Shawn Pearce <sop@google.com> on Wed Aug 26 10:14:06 PDT 2009 Fixed in version 2.0.20.
Status:
Fixed
Sep 25, 2009
(No comment was entered for this change.)
Labels:
FixedIn-2.0.20
Oct 21, 2012
(No comment was entered for this change.)
Status:
Released
|
|
| ► Sign in to add a comment |