Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Zero rows returned for select statements against DUMMY

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

Former Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question