I have a very simple question regarding using the keyword Limit:
This query: select * from myschema.mytable; works fine
This query: select * from myschema.mytable Limit 20; doesn't run
If I right click on the 2nd one and use the "execute the selected text" command, it works fine.
If run a sample data by right clicking on the table name, I do get a sample data back.
My question is: why can't I or what's the proper usage of the 'Limit' keyword?
The limit syntax you have is correct. Which client are you running this from? Can you copy and paste or type the exact error message when you run the query with a limit?
I am having this same issue! TD Studio 15.10 connected to Aster 6.2. Studio doesn't consider "Select * from tablename LIMIT 100" to be valid SQL and will not let me submit the query. However if I highlight it and submit, it works.