Icon View Incident Report

Serious Serious
Reported By: Norman Knott
Reported On: 5/7/2021
For: Version 2.34 Build 3
# 4832 Queries that Reference Views Can Experience AVs During Unprepare

We have a constellation of multiple databases per session.
A master-DB and one DB for each project.

A query with a join of a view in the master results in an AV while repeating the execution.

I was able to reproduce it on EDB-Manager with a sample.
Please look at the DBs in the attachment.

1. prepare both queries

2. unprepare one of them

3. repeat the prepare/execution and you will see an AV.
Access violation at address 007127C5 in module 'edbmgr.exe'. Read of address 000000B0

Query 1:

SELECT member.*, A.name
FROM c1.member M
LEFT OUTER JOIN md.vw_adr A ON A.id = M.fid

Query 2:

SELECT member.*, A.name
FROM c2.member M
LEFT OUTER JOIN md.vw_adr A ON A.id = M.fid

Resolution Resolution
Fixed Problem on 5/10/2021 in version 2.35 build 1

Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial