MantisBT - TestLink
View Issue Details
0005921TestLinkDatabase Postgrespublic2013-09-16 15:342013-11-17 09:53
lczub 
fman 
normalblockalways
closedfixed 
1.9.8 (2013 Q3 - bug fixing) 
1.9.9 (2013 Q4 - bug fixing) 
postgres 9.2
READY FOR TESTING
0005921: POSTGRESQL - Update 1.9.7 to 1.9.8 fails because db_schema_update.sql use unknown typ number()
migration of a 1.9.7 testlink installation under postgres 9.2 fails, cause
   install\sql\alter_tables\1.9.8\postgres\DB.1.9.8\step1\db_schema_update.sql
uses wrong typ number() instead numeric()
psql -h localhost -U TLDBUSER -f DB.1.9.8/step1/db_schema_update.sql TLDB

psql:DB.1.9.8/step1/db_schema_update.sql:28: FEHLER: Typ »number« existiert nicht
ZEILE 2: ...*/tcversions ADD COLUMN "estimated_exec_duration" number(6,2...
                                                              ^
psql:DB.1.9.8/step1/db_schema_update.sql:31: FEHLER: Typ »number« existiert nicht
ZEILE 2: ...refix*/executions ADD COLUMN "execution_duration" number(6,2...
                                                              ^
ALTER TABLE
...

WorkAround: replace number() with numeric()

/* tcversions */
-- Failure: wrong typ 'number'
-- ALTER TABLE /*prefix*/tcversions ADD COLUMN "estimated_exec_duration" number(6,2) NULL;
ALTER TABLE /*prefix*/tcversions ADD COLUMN "estimated_exec_duration" numeric(6,2) NULL;


/* executions */
-- Failure: wrong typ 'number'
-- ALTER TABLE /*prefix*/executions ADD COLUMN "execution_duration" number(6,2) NULL;
ALTER TABLE /*prefix*/executions ADD COLUMN "execution_duration" numeric(6,2) NULL;
 
No tags attached.
has duplicate 0005978closed fman Update script 1.9.8 for Postgres 9.1 not correct 
child of 0005897closed fman Availables hot-fixes for 1.9.8 & How To get full fixed package from gitorious 
Issue History
2013-09-16 15:34lczubNew Issue
2013-09-16 19:24fmanNote Added: 0019636
2013-09-16 19:31fmanQA Team - Task Workflow StatusTBD => READY FOR TESTING
2013-09-16 19:31fmanStatusnew => resolved
2013-09-16 19:31fmanFixed in Version => 1.9.9 (2013 Q4 - bug fixing)
2013-09-16 19:31fmanResolutionopen => fixed
2013-09-16 19:31fmanAssigned To => fman
2013-09-16 19:31fmanRelationship addedchild of 0005897
2013-10-17 06:05fmanRelationship addedhas duplicate 0005978
2013-10-17 06:06fmanSummaryUpdate 1.9.7 to 1.9.8 fails because db_schema_update.sql use unknown typ number() => POSTGRESQL - Update 1.9.7 to 1.9.8 fails because db_schema_update.sql use unknown typ number()
2013-11-17 09:53fmanNote Added: 0020073
2013-11-17 09:53fmanStatusresolved => closed

Notes
(0019636)
fman   
2013-09-16 19:24   
ok, thanks
(0020073)
fman   
2013-11-17 09:53   
1.9.9 Released