You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
FULLCAPTION Computed by: ((
with recursive
Hospitals_Recursive as (
Select H.HospitalID, H.HospitalParentID, H.Caption,
1 as ChildLevel
From Hospitals H
Where H.HospitalID = Hospitals.HospitalID
union all
Select H.HospitalID, H.HospitalParentID, H.Caption,
Hr.ChildLevel + 1 as ChildLevel
From Hospitals_Recursive HR inner join Hospitals H
on HR.HospitalParentID = H.HospitalID
),
Hospitals_List as (
Select Caption
From Hospitals_Recursive
Order by ChildLevel desc
)
Select list(Caption, ', ')
From Hospitals_List
))
is used in a query:
select HospitalID, FullCaption From Hospitals
Order by cast(FullCaption as varchar(32765));
Bug happened only when table, used in CTE, contained records with different formats. Record, stored in rpb on stack, becomes invalid when format changes. New actual record should be always used instead.
Submitted by: @AlexPeshkoff
When the following field
FULLCAPTION Computed by: ((
with recursive
Hospitals_Recursive as (
Select H.HospitalID, H.HospitalParentID, H.Caption,
1 as ChildLevel
From Hospitals H
Where H.HospitalID = Hospitals.HospitalID
union all
Select H.HospitalID, H.HospitalParentID, H.Caption,
Hr.ChildLevel + 1 as ChildLevel
From Hospitals_Recursive HR inner join Hospitals H
on HR.HospitalParentID = H.HospitalID
),
Hospitals_List as (
Select Caption
From Hospitals_Recursive
Order by ChildLevel desc
)
Select list(Caption, ', ')
From Hospitals_List
))
is used in a query:
select HospitalID, FullCaption From Hospitals
Order by cast(FullCaption as varchar(32765));
access violation happens.
Commits: 1b3d63e 75ea573 f0a837e FirebirdSQL/fbt-repository@43becf3
====== Test Details ======
Added data with diactitic marks.
The text was updated successfully, but these errors were encountered: