|View Issue Details [ Jump to Notes ] ||[ Issue History ] [ Print ] |
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0003729||TestLink||Database General||public||2010-08-30 19:49||2010-08-31 20:26|
|Assigned To||fman|| |
|Platform||Firefox 3.6.8||OS||Ubuntu||OS Version||10.04|
|Product Version|| |
|Fixed in Version||1.9 Beta 6|| |
|Summary||0003729: testcase::get_by_name fails to get test cases with titles longer than 100 characters|
|Description||Test cases with titles longer than 100 characters can be added through the API (GUI limits entries to 100 characters), however the title gets truncated to 100 characters since the table entry in nodes_hierarchy is defined as a varchar(100).|
If calling the get_by_name method (note that this applies to all entries in nodes_hierarchy, not just test cases) with the same test case name, it will return an empty record set.
What I did to fix this locally is to use the 'substr' function to limit the length of the title used to search the database.
|Steps To Reproduce||1- Create a test case with a title longer than 100 characters through the API (createTestCase).|
2- Call the testcase::get_by_name method with the title used above.
|Tags||No tags attached.|
|Database (MySQL,Postgres,etc)||mysql Ver 14.14 Distrib 5.1.41|
|QA Team - Task Workflow Status|