0008406: Postgres DB script error

testlink.org

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0008406

TestLink

Installer

public

2018-10-09 15:42

2018-10-09 16:48

Reporter

salas

Assigned To

fman

Priority

normal

Severity

major

Reproducibility

always

Status

feedback

Resolution

open

Platform

Linux/Lighttpd/Postgres/PHP

Linux Wheezy

OS Version

Debian 7.11

Product Version

1.9.18 (2018 Q3)

Fixed in Version

Summary

0008406: Postgres DB script error

Description

3 SQL lines for upgrading the DB shows "not null" errors. We should replace :
ALTER TABLE tlkreq_coverage ADD COLUMN req_version_id INTEGER NOT NULL;
ALTER TABLE tlkreq_coverage ADD COLUMN tcversion_id INTEGER NOT NULL;
...
ALTER TABLE tlktestcase_keywords ADD COLUMN tcversion_id INTEGER NOT NULL;

by

ALTER TABLE tlkreq_coverage ADD COLUMN req_version_id INTEGER NOT NULL DEFAULT 0;
ALTER TABLE tlkreq_coverage ADD COLUMN tcversion_id INTEGER NOT NULL DEFAULT 0;
...
ALTER TABLE tlktestcase_keywords ADD COLUMN tcversion_id INTEGER NOT NULL DEFAULT 0;

Steps To Reproduce

Trying to launch the script in Testlink\install\sql\alter_tables\1.9.18\mysql\DB.1.9.17\step1\db_schema_update.sql

Tags

No tags attached.

Database (MySQL,Postgres,etc)

Postgres 9.1.24

Browser

PHP Version

5.3

TestCaseID

QA Team - Task Workflow Status

Attached Files

Relationships

Notes
(0027974) fman (administrator) 2018-10-09 16:48	I will retest because on my postgres installation I've got no errors I'm using: "PostgreSQL 9.5.1 on x86_64-apple-darwin14.5.0, compiled by Apple LLVM version 7.0.0 (clang-700.1.76), 64-bit"

Issue History
Date Modified	Username	Field	Change
2018-10-09 15:42	salas	New Issue
2018-10-09 16:48	fman	Note Added: 0027974
2018-10-09 16:48	fman	Assigned To	=> fman
2018-10-09 16:48	fman	Status	new => feedback