search

sitemule / noxDB

Not only XML. SQL,JSON and XML made easy for IBM i
MIT License
41 stars 20 forks source link

the ' OPTIMIZE FOR ' and ' FOR READ ONLY ' on SQL select fails #70

Open NielsLiisberg opened 2 years ago

NielsLiisberg commented 2 years ago

Using the:
OPTIMIZE FOR x ROWS and: FOR READ ONLY

causes the select statement to be invalid since the automatic LIMIT phrase is placed in a wrong position

The work around is to omit "OPTIMIZE FOR x ROWS" and "FOR READ ONLY" phrases