> I think this case should fail with error like "only cache created tables
> can be removed with drop table. ", not with "scheme not found."
> SQL-engine is supposed to accept and understand values it returns itself.
Agree. Feel free to contribute a fix. My expectation here is that it
will not be
//Got a connectionConnection conn = ...;
//execute() - is just a helper function. Creates prepared statement, pass
params...
//Get all the tables
List> lst = execute(conn, "select SCHEMA_NAME, TABLE_NAME from
SYS.TABLES");
for( List row : lst ){
String schemaName = (String)row.get(0);
Vladimir,
I will try to shed a light on this.
1. Statically configured tables in caches (QueryEntity) by default
resides in a schema having the same name as a cache it belongs to
("default" is a cache and a schema name for a table Person in your
example).
2. As you might know SQL literals are case
Vladimir.
Please, provide a simple, self-contained reproducer to the issue you described.
> 29 янв. 2020 г., в 11:16, Vladimir Steshin написал(а):
>
> 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'
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 ther
