Thanks to Jennie I understand that I can get the current schema with the query:

select current_schema from sys.var();

While I get the “right” response,   I get it as a series of duplicated lines (10 at the last count):

For example, after setting a schema as

set schema viewer;

I get the following 10 lines from the query:


Is it the right behaviour?

And if yes, do these lines have a specific significance?

Thanks

Enzo
enzo@smartinsightsfromdata.com