Vladimir. Please, provide a simple, self-contained reproducer to the issue you described.
> 29 янв. 2020 г., в 11:16, Vladimir Steshin <vlads...@gmail.com> написал(а): > > Hi ppl. Wanted to ask is issue a bug. Minor propably. > > Recently noticed that one simple query returns a value which can't be found > 'as is' in following query. I tried to find and drop all the tables I > created with "create table": > > select schema_name, table_name, cache_name from sys.tables > > And there are tables which were not created with 'create table...'. For > example, table 'default.Person' from the test/tutorial I was researching. > Ok. I tried to delete them too. Now I know this is prohibited. But why I > got error: scheme 'default' not found? I just received this schema name > from previous query. > > To avoid this I had to capitalize schema name taking it into "": > "default".Person. Then I got normal error like 'only cache created tables > can be removed with drop table.'. > > One select returns value which can't be found in second select > (delete/drop). Isn't it a bug from SQL's point of view?