unexpected result COPY <table> INTO STDOUT

[yzchang]

Describe the bug Not sure if this is a bug, but the result of this copy ... into stdout is a bit unexpected:

sql>create table t ( i int);
operation successful
sql>insert into t values (42);
1 affected row
sql>copy select * from t into stdout;
+------+
| i    |
+======+
+------+
1 tuple
1 affected row

Expected behavior I'd expect to see the value from the table, e.g.:

sql>copy select * from t into stdout;
+------+
| i    |
+======+
|   42 |
+------+
1 tuple
1 affected row

Software versions

• MonetDB version number [default]
• OS and version: [e.g. Ubuntu 20.04]
• Mercurial source

[yzchang]

Also, if I run the copy ... into stdout as a normal user without the COPY INTO privilege, I get the same empty result, instead of an error. That's a bug?