View Issue Details

IDProjectCategoryView StatusLast Update
0008322ADK-V4REVAPIpublic2018-07-25 06:43
ReporterScott RobertsAssigned ToIvan Smahin 
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version 
Target VersionFixed in Version8.3.x 
Summary0008322: COUNT_LINKED returns NULL value when used with SELECT INTO
DescriptionWhen a variable in a stored procedure is set to the COUNT_LINKED portion of a query, the value returned is NULL if SELECT INTO is used. If SET var = SELECT... is used, the value is correct.
Steps To Reproduce1. See the attached database.
2. Run the test_count_linked procedure.
3. The result is NULL for the SELECT INTO syntax and 2 for the SET var = SELECT syntax.
4. Both statements should return 2 (the number of linked records).
TagsNo tags attached.

Activities

Scott Roberts

Scott Roberts

2018-07-22 17:14

reporter  

Houses and Rooms.zip (12,299 bytes)

Issue History

Date Modified Username Field Change
2018-07-22 17:14 Scott Roberts New Issue
2018-07-22 17:14 Scott Roberts File Added: Houses and Rooms.zip
2018-07-25 06:43 Ivan Smahin Status new => resolved
2018-07-25 06:43 Ivan Smahin Fixed in Version => 8.3.x
2018-07-25 06:43 Ivan Smahin Resolution open => fixed
2018-07-25 06:43 Ivan Smahin Assigned To => Ivan Smahin