search

timeseries / qstudio

qStudio - Free SQL Analysis Tool
https://www.timestored.com/qstudio/
Apache License 2.0
420 stars 18 forks source link

Oracle select top 100 broken #20

Closed ryanhamilton closed 4 months ago

ryanhamilton commented 6 months ago

I try qStudio with ojdbc8-19.19.0.0.jar (BTW the link to help install the Oracle plugin - shown in a popup - is broken, but I was quickly able to figure out where to move the jar file).

Server tree properly shows schemas and tables hierarchy.

Then when right clicking on a table then "Select top 100", I get the following error:

ORA-00933: SQL command not properly ended

When looking at the generated query, it seems that a space is missing after the table name, eg. of request :

SELECT * FROM PAIRS.EQUITIESFETCH FIRST 100 ROWS ONLY

When manually adding the space before "FETCH" it will work.

It looks like a bug to me, but happy to change a setting if needed ?

Thanks for your tool.

ryanhamilton commented 6 months ago

Great bug report. Thanks. I can see the problem in the code. This will be fixed in next release.

image

ryanhamilton commented 4 months ago

Released in 2.55