on 08-02-2013 2:36 PM
Hello,
Why would 0 rows be returned for select statements against the DUMMY table for some users?
Are there special privileges required? The same select statements work for the "SYSTEM" user...
HANA 1.00.55.376513
C:\Program Files\sap\hdbclient>hdbsql -v
HDBSQL version 1.00.52 Build 0374886-1510, the SAP HANA Database interactive terminal.
C:\Program Files\sap\hdbclient>hdbsql -n sihana-5:30015 -u testuser -p testpassword
Welcome to the SAP HANA Database interactive terminal.
Type: \h for help with commands
\q to quit
hdbsql=> select * from DUMMY
MATERIAL,MAT_GRP
0 rows selected (overall time 260.978 msec; server time 131 usec)
hdbsql BC1=> SELECT CURRENT_CONNECTION FROM DUMMY
CURRENT_CONNECTION
0 rows selected (overall time 259.380 msec; server time 611 usec)
hdbsql BC1=>
Thanks,
Neal
Hi Neal,
easy
Either somebody deleted the row from SYS.DUMMY - in that case the table is just empty.
Or there is a table called DUMMY present already in your current schema.
And given your output
Neal Stack wrote:
hdbsql=> select * from DUMMY
MATERIAL,MAT_GRP
0 rows selected (overall time 260.978 msec; server time 131 usec)
I'd bet onto the second option.
Maybe the user created a DUMMY table with MATERIAL and MAT_GRP columns and forgot about it?
As the name resolution starts in the current schema and looks into the PUBLIC name space afterwards, the schema "local" table is chosen in this case.
- Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.