Feature #7667
open
Hierarchy columns should not be nullables
Added by Etienne Massip over 13 years ago.
Updated 3 days ago.
Description
The root_id
, lft
, rgt
columns of issues
table, as well as lft
and rgt
of projects
table should be defined as NOT NULL
.
This could prevent users from running Redmine with corrupted data due to a wrong db migration by import/export.
Files
- Target version set to Candidate for next major release
Hi Etienne,
I just found this on the roadmap.
Any news on this issue? :-)
- Tracker changed from Defect to Feature
- Subject changed from Hierarchy columns should not be nullables. to Hierarchy columns should not be nullables
The attached patches add not null constraints to "root_id", "lft", and "rgt" columns in issues and projects tables.
- Target version changed from Candidate for next major release to 6.0.0
- Target version changed from 6.0.0 to Candidate for next major release
- Target version changed from Candidate for next major release to 6.1.0
Also available in: Atom
PDF