|Anonymous | Login | Signup for a new account||2019-12-14 10:46 UTC|
|Main | My View | View Issues | Change Log | My Account|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0001845||TestLink||Database General||public||2008-11-08 04:47||2009-05-30 15:07|
|Fixed in Version|
|Summary||0001845: Orphan remains after test case create failure|
|Description||I 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.
|Tags||No tags attached.|
|QA Team - Task Workflow Status|
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?
|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|