Indexed view no data? - by Stefan Oude Vrielink

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 784946 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 4/17/2013 12:28:08 PM
Access Restriction Public

Description

Today I encountered a serious bug in SQL Server 2012 Developer Edition SP1.
After deploying changes to some indexed views, another (non indexed) view on top of them did not return any data anymore!
After rebuilding the clustered indexes of the indexes views, results appeared!

After pinpointing the root cause of no data:
Following query returned data:
SELECT I.Value
FROM [IndexedView] as I
WHERE 1=1

Next query did not return data (while it should because of the left join):
SELECT I.Value
FROM [IndexedView] AS I
LEFT JOIN [OTHERVIEW] AS O ON I.Id = O.Id
WHERE 1=1

Because of time shortage I could not analyse further. I expect first query accessed based table, while second query accessed the indexed view, but I did not check execution plans.
Sign in to post a comment.
Posted by Microsoft on 7/17/2013 at 9:48 AM
Hi,

We weren't able to reproduce this issue in house. Absent the repro, query and plans I'm afraid I have to close this investigation.

Regards,
Richard Tkachuk
Program Manager, SQL Server
Posted by Microsoft on 5/13/2013 at 12:25 PM
Hello,

Thank you for submitting this feedback. Unfortunately the description and repro sections are not detailed enough, and we need more information from the customer. Is it possible to provide a repro, with actual query, data, and plans?

Thanks again for reporting the product issue and continued support in improving our product.
Gus Apostol, SQL Server Program Manager
Posted by Microsoft on 4/25/2013 at 2:26 PM
Hello,

Thank you for submitting this feedback. Unfortunately the description is not detailed enough, and we need more information from the customer. Resolving back to the customer for more details.

Thanks again for reporting the product issue and continued support in improving our product.
Gus Apostol, SQL Server Program Manager