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