superset
superset copied to clipboard
Generated queries contain `LIMIT` even though `allow_limit_clause = False` in dbEngineSpec.
A clear and concise description of what the bug is.
How to reproduce the bug
- Go to 'Sqllab'
- Click on 'SEE TABLE SCHEMA'
- Scroll down to any schema and click it to preview the table schema.
- Click the Copy select statement button near table name.
- In select query you can see LIMIT keyword.
Expected results
Generate query with TOP or anything other than LIMIT since allow_limit_clause is false.
Actual results
Query with LIMIT keyword.
Screenshots
Environment
(please complete the following information):
- browser type and version:
- superset version:
3.0.1
- python version:
3.10
- node.js version:
v18.12.1
Checklist
Make sure to follow these steps before submitting your issue - thank you!`
- [x] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [x] I have reproduced the issue with at least the latest released version of superset.
- [x] I have checked the issue tracker for the same issue and I haven't found one similar.
Additional context
Add any other context about the problem here.
@michael-s-molina @betodealmeida May I know in the code where it is adding limit 100 ?