View Issue Details

IDProjectCategoryView StatusLast Update
0006987VCOMPONENT-VKERNELSQL Functionspublic2015-01-20 09:47
ReporterVladimir EsipovAssigned ToIvan Smahin 
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
PlatformINTELOSWindowsOS Version7
Product Version5.7 
Target Version5.7.1Fixed in Version5.7.1 
Summary0006987: Function list_nthitem (inList, inItemIndex, delimiter) returns NULL, if inItemIndex> 1.
DescriptionThe error occurs when the functions in the context of the cursor.
The bug had appeared after the change of function
http://www.valentina-db.com/bt/view.php?id=6514
Steps To ReproduceSELECT LGN, list_nthitem (LGN, 2, '') FROM tblUSR;

LGN1 WORD2 NULL
SOLIDWORD1 NULL
LGN2 WORD2 NULL
SOLIDWORD2 NULL

but

SELECT LGN, list_nthitem (LGN, 2, '') FROM tblUSR
  WHERE list_itemcount (LGN, '')> 1;

LGN1 WORD2 WORD2
LGN2 WORD2 WORD2
LGN3 WORD2 WORD2

SELECT list_nthitem ('WORD1 WORD2', 2 '') returns "WORD2"
TagsNo tags attached.

Activities

Vladimir Esipov

Vladimir Esipov

2015-01-12 08:15

reporter  

DB.zip (240,370 bytes)

Issue History

Date Modified Username Field Change
2015-01-12 08:15 Vladimir Esipov New Issue
2015-01-12 08:15 Vladimir Esipov File Added: DB.zip
2015-01-12 08:16 Ruslan Zasukhin Assigned To => Ivan Smahin
2015-01-12 08:16 Ruslan Zasukhin Status new => assigned
2015-01-12 13:28 Ivan Smahin Status assigned => resolved
2015-01-12 13:28 Ivan Smahin Fixed in Version => 5.7
2015-01-12 13:28 Ivan Smahin Resolution open => fixed
2015-01-20 09:02 Ruslan Zasukhin Target Version => 5.7.5
2015-01-20 09:47 Ruslan Zasukhin Fixed in Version 5.7 => 5.7.1
2015-01-20 09:47 Ruslan Zasukhin Target Version 5.7.5 => 5.7.1