Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

unexpected result COPY <table> INTO STDOUT #7028

Open
yzchang opened this issue Dec 15, 2020 · 1 comment
Open

unexpected result COPY <table> INTO STDOUT #7028

yzchang opened this issue Dec 15, 2020 · 1 comment
Labels
bug Something isn't working Design The issue involves a design choice documentation Improvements or additions to documentation low priority

Comments

@yzchang
Copy link
Member

yzchang commented Dec 15, 2020

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
Copy link
Member Author

yzchang commented Dec 15, 2020

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?

@njnes njnes added bug Something isn't working Design The issue involves a design choice documentation Improvements or additions to documentation low priority labels Dec 18, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working Design The issue involves a design choice documentation Improvements or additions to documentation low priority
Projects
None yet
Development

No branches or pull requests

2 participants