View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0008322 | ADK-V4REV | API | public | 2018-07-22 17:14 | 2018-07-25 06:43 |
| Reporter | Scott Roberts | Assigned To | Ivan Smahin | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | |||||
| Target Version | Fixed in Version | 8.3.x | |||
| Summary | 0008322: COUNT_LINKED returns NULL value when used with SELECT INTO | ||||
| Description | When 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 Reproduce | 1. 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). | ||||
| Tags | No tags attached. | ||||
| 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 |
