Home Dashboard Directory Help
Search

Indexed view no data? by Stefan Oude Vrielink


Status: 

Resolved
 as Not Reproducible Help for as Not Reproducible


1
0
Sign in
to vote
Type: Bug
ID: 784946
Opened: 4/17/2013 12:28:08 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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.
Details
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
Sign in to post a workaround.