Ticket #10764 (assigned defect)

Opened 5 months ago

Last modified 1 month ago

Not able to create new TestPlans with 1.5.2 and Trac 0.12 and PostgreSQL

Reported by: michael.kroell@gmail.com Assigned to: seccanj (accepted)
Priority: normal Component: TestManagerForTracPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.12

Description

With Trac 0.12 and PostgreSQL there is a datatype issue. For example when trying to create a TestPlan? Pg won't store it because the value for the "time" column does not fit into the integer type range.

As a work-around I changed the data type on my local instance using "alter table testplan alter column time type bigint;" but I guess resorting to bigint is not the nicest resolution.

Looks like

tracgenericclass/trunk/tracgenericclass/util.py:66 to_utimestamp(date_obj)

generate those too large values

INSERT INTO testplan (id,catid,page_name,name,author,time,contains_all,freeze_tc_versions) VALUES (E'42',E'43',E'TC_TT43',E'testtestplan',E'mkroell',1357563642946958,1,0)

Attachments

Change History

01/07/13 14:51:23 changed by michael.kroell@gmail.com

Btw, just had to convert the type of testcasehistory.time too ;-)

01/16/13 17:25:23 changed by seccanj

  • status changed from new to assigned.

Thanks Michael :D

I'll add your fix into next release.

01/16/13 19:07:06 changed by michael.kroell@gmail.com

I think there were more time related columns to be updated. Also, is it really a fix and not a workaround? Is it really required to have bigint there?

~michael


Add/Change #10764 (Not able to create new TestPlans with 1.5.2 and Trac 0.12 and PostgreSQL)




Change Properties
Action