Mantis Bugtracker 

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0003855TestLinkDatabase Postgrespublic2010-10-05 09:342010-10-09 08:00
Assigned Tofman 
PlatformLinuxOSSUSE Linux Enterprise ServerOS Version10 SP3
Product Versiontestlink_1_9_rc1-qa-20100926 
Fixed in Version1.9 RC 1 
Summary0003855: Upgrading from 1.8 to 1.9 does not work with PostgreSQL
DescriptionFor example

    ALTER TABLE /*prefix*/builds ADD COLUMN release_date DATE NOT NULL;

does not work if there's already data in the table because release_date for the existing rows is NULL.

This should be fixed by adding new column with no column constraints.

If the constraint is really needed, release_date for existing rows should be set to epoch or copied from creation_ts. After that the constraint can be added.
Additional Information% psql testlink <<EOF
> ALTER TABLE /*prefix*/builds ADD COLUMN release_date DATE NOT NULL;
ERROR: column "release_date" contains null values
TagsNo tags attached.
Database (MySQL,Postgres,etc)PostgreSQL 8.1.21
PHP Version5.2.5 with Suhosin-Patch 0.9.6
QA Team - Task Workflow Status
Attached Files

- Relationships

-  Notes
fman (administrator)
2010-10-05 10:20

Typo error
ALTER TABLE /*prefix*/builds ADD COLUMN release_date DATE NOT NULL;

ALTER TABLE /*prefix*/builds ADD COLUMN release_date DATE NULL;
fman (administrator)
2010-10-09 08:00

Release 1.9 RC1

- Issue History
Date Modified Username Field Change
2010-10-05 09:34 haba713 New Issue
2010-10-05 10:20 fman Note Added: 0011633
2010-10-05 10:22 fman Status new => resolved
2010-10-05 10:22 fman Fixed in Version => 1.9 RC 1
2010-10-05 10:22 fman Resolution open => fixed
2010-10-05 10:22 fman Assigned To => fman
2010-10-09 08:00 fman Note Added: 0011707
2010-10-09 08:00 fman Status resolved => closed

Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker