Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0001845TestLinkDatabase Generalpublic2008-11-08 04:472009-05-30 15:07
Reporterdmilet 
Assigned To 
PrioritynormalSeverityminorReproducibilityalways
StatusacknowledgedResolutionopen 
PlatformOSOS Version
Product Version1.7.4 
Fixed in Version 
Summary0001845: Orphan remains after test case create failure
DescriptionI created a test case whose steps include a lot of meta-data (copy-paste from Word). The steps accidentally exceeded the MySQL TEXT size of the "Steps" fields in the "tcversions" table.
The insert failed, and the error was not handled properly.
The test case was NOT created (did not appear in tcversions), but still, "nodes_hierarchy" table references this non-existing test case.

There is no was from the GUI to remove a test case from a test suite when the test case itself does not exist.

I suggest that the "nodes_hierarchy" table be updated only after the insert in the tcversions table is successful.
TagsNo tags attached.
Database (MySQL,Postgres,etc)
BrowserIE
PHP Version5.2.6
TestCaseID
QA Team - Task Workflow Status
Attached Files

- Relationships

-  Notes
(0007094)
mhavlat (reporter)
2009-05-29 17:26

Acknowledged. This request is valid. Low priority because there is no significant harm.

1. We must check a result of adding data and rollback previous SQL request.
2. We should add a new administration page that allow run a script that check DB consistency as we have not transaction and FK available in MySQL.

Note: Investigate transaction support in AdoDB component. Can we support transactions for DB types where it's possible?
(0007096)
amitkhullar (reporter)
2009-05-30 15:07

http://dev.mysql.com/doc/refman/5.0/en/commit.html [^]

- Issue History
Date Modified Username Field Change
2008-11-08 04:47 dmilet New Issue
2008-11-08 04:47 dmilet Browser => IE
2008-11-08 04:47 dmilet PHP Version => 5.2.6
2009-05-29 17:26 mhavlat Note Added: 0007094
2009-05-29 17:26 mhavlat Status new => acknowledged
2009-05-30 15:07 amitkhullar Note Added: 0007096



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker