Re: [DISCUSS] SQL system views content

2020-02-07 Thread Nikolay Izhikov
Ivan. My understanding of system views reflected in IEP-35: With the system views we should answer to the user question - «What objects are existing in my node?» > From a (unit) test I cannot figure out how a proxy index is different from an > underlying one from a user perspective. > Could

Re: [DISCUSS] SQL system views content

2020-02-07 Thread Ivan Pavlukhin
Nikolay, I have not filed any ticket yet. I would like to discuss first. > Yes, this was made intentionally. > I think we shouldn’t hide internal details from the user in the system views. Regarding proxy indices Cannot immediately agree here. My understanding is that the view in question should

Re: [DISCUSS] SQL system views content

2020-02-07 Thread Nikolay Izhikov
> 1. Columns related to a cache group information disappeared. Information about cache group can be gathered from SYS.CACHES and SYS.CACHE_GROUPS. > 2. "proxy" indexes info is now displayed in the view. Yes, this was made intentionally. I think we shouldn’t hide internal details from the user i

Re: [DISCUSS] SQL system views content

2020-02-07 Thread Nikolay Izhikov
Hello, Ivan. Please, clarify what columns are missed? Do you file a ticket to introduce those fields? > 7 февр. 2020 г., в 13:26, Ivan Pavlukhin написал(а): > > Nikolay, > > Recently I noticed some changes in SQL indexes view content introduced > in [1]. Among changes I noticed: > 1. Columns r

[DISCUSS] SQL system views content

2020-02-07 Thread Ivan Pavlukhin
Nikolay, Recently I noticed some changes in SQL indexes view content introduced in [1]. Among changes I noticed: 1. Columns related to a cache group information disappeared. 2. "proxy" indexes info is now displayed in the view. Was this changes made intentionally? Historically there were followin