Bug 84443 - Other: Access is denied: ROWNUM in statement
Summary: Other: Access is denied: ROWNUM in statement
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.2.5.2 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-09-29 01:11 UTC by Kamil Oztunc
Modified: 2014-09-29 21:33 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Kamil Oztunc 2014-09-29 01:11:19 UTC 
Problem description: 
When I try to use ROWNUM() function, I get this error:
"Access is denied: ROWNUM in statement"


Steps to reproduce:
1. Creating a table (something simple with auto-inc primary key field.
2. Making a SQL query on the table.
3. Using ROWNUM() function for a field in the query.

Current behavior:
I get an error.

Expected behavior:
ROWNUM() function returns the row number (an on-the-fly incremental number for each returned row.

Operating System: Windows 7
Version: 4.2.5.2 release
Comment 1 Terrence Enger 2014-09-29 15:08:19 UTC 
Kamil,

Thank you for taking the time to report your problem.

I wonder what database engine you are using?  Does the engine support the rownum() function?  LibreOffice is pretty much limited to the functionality provided by the database engine; if you have an embedded hsqldb database, you are using hsqldb version 1.8.0.10, and it does not support rownum().

When you respond, please set the status of this bug report back to UNCONFIRMED.

HTH,
Terry.
Comment 2 Kamil Oztunc 2014-09-29 20:26:03 UTC 
Thanks a lot! Sorry for the mistake. I am using hsqldb and I was not aware of this issue. I am switching to unconfirmed.
Comment 3 Terrence Enger 2014-09-29 21:33:21 UTC 
Further to comment 2, I am closing this NOTABUG.

Kamil,

Is it easy for you to work around the lack of ROWNUM()?  Or do you have a more capable database engine available?  <http://ask.libreoffice.org/en/questions/> may be able to give you some help.

Terry.