Bug 1061955 - job.product_id column has wrong type and no foreign key
Summary: job.product_id column has wrong type and no foreign key
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Beaker
Classification: Retired
Component: web UI
Version: 0.15
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: 19.0
Assignee: Dan Callaghan
QA Contact: tools-bugs
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-02-05 22:55 UTC by Dan Callaghan
Modified: 2018-02-06 00:41 UTC (History)
8 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-11-25 07:18:06 UTC
Embargoed:

Attachments (Terms of Use)

Description Dan Callaghan 2014-02-05 22:55:46 UTC 
The job.product_id column has type VARCHAR(100) but it actually holds ids from the product table, so it should be an INT with a foreign key to product.id.
Comment 2 wangjing 2014-02-07 06:37:20 UTC 
(In reply to Dan Callaghan from comment #0)
> The job.product_id column has type VARCHAR(100) but it actually holds ids
> from the product table, so it should be an INT with a foreign key to
> product.id.

so for testing this bug, just check the job.product_id column should be an INT  Type and  a foreign key to product.id in DB?
and if no regression after an acceptance test, this bug could be verified?
Comment 3 Dan Callaghan 2014-02-07 06:40:00 UTC 
(In reply to wangjing from comment #2)

Yes.
Comment 4 Dan Callaghan 2014-10-10 06:10:53 UTC 
This is one of the inconsistencies which I found and fixed by running our new db migration tests against a production schema.

http://gerrit.beaker-project.org/3390
Comment 7 Dan Callaghan 2014-11-25 07:18:06 UTC 
Beaker 19.0 has been released.
Note You need to log in before you can comment on or make changes to this bug.