Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

OracleSqlUtil fails with "limit" and "foreach" options on newer Oracle DBs #4206

Closed
davidnich opened this issue Apr 11, 2021 · 0 comments
Closed

OracleSqlUtil fails with "limit" and "foreach" options on newer Oracle DBs #4206

davidnich opened this issue Apr 11, 2021 · 0 comments
Assignees
@davidnich
Labels
bug fixed not-c++
Projects
Qore Development
Milestone
0.9.14

Comments

@davidnich
Copy link
Contributor

the fetch x rows only clause cannot be used with for update, currval or nextval or in a fast refresh materialized view
@davidnich davidnich added this to the 0.9.14 milestone Apr 11, 2021
@davidnich davidnich self-assigned this Apr 11, 2021
@davidnich davidnich added this to To do in Qore Development via automation Apr 11, 2021
davidnich added a commit that referenced this issue Apr 12, 2021
@davidnich
refs #4206 added an exception when offset or limit are used with foru…
05a57df 
…pdate
davidnich added a commit that referenced this issue Apr 13, 2021
@davidnich
refs #4206 fixed SQL generation for queries with both limit and forup…
ba9687d 
…date options
davidnich added a commit that referenced this issue Apr 13, 2021
@davidnich
refs #4206 fixed a typo
93b263d
davidnich added a commit that referenced this issue Apr 13, 2021
@davidnich
refs #4206 fixed query generation for limit/offset options
d5db642
davidnich added a commit that referenced this issue Apr 13, 2021
@davidnich
refs #4206 fixed SQL generation; splice comments/hints into the strin…
2b6afa4 
…g last
davidnich added a commit that referenced this issue Apr 13, 2021
@davidnich
refs #4206 added comments about why the subquery is necessary with OR…
ab00007 
…DER BY and ROWNUM
tmandys added a commit that referenced this issue Apr 13, 2021
@tmandys
Merge pull request #4209 from qorelanguage/bugfix/4206_oracle_for_upd…
dbbd64f 
…ate_fix

refs #4206 added an exception when offset or limit are used with foru…
davidnich added a commit that referenced this issue Apr 14, 2021
@davidnich
refs #4206 fixed botched merge
47aca7a
davidnich added a commit that referenced this issue Apr 14, 2021
@davidnich
refs #4210 fixed a bug where pseudocolumn names were quoted in querie… (
437b920 
#4211)

* refs #4210 fixed a bug where pseudocolumn names were quoted in queries leading to errors

* refs #4206 fixed botched merge
Qore Development automation moved this from To do to Done Apr 14, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@davidnich davidnich

Labels
bug fixed not-c++
Projects
Qore Development
Done
Milestone
0.9.14
Development

No branches or pull requests
1 participant
@davidnich