orientechnologies / orientechnologies/orientdb
"insert expression" set field = "upsert expression" is legit?
Open
@luigidellaquila is already working on this.
Since Jan 11, 2021.
question
- Dominant language
- Java
- Stars
- 5k
- Forks
- 868
- Avg merge
- 15h 6m
- Merged PRs (30d)
- 18
Description
I want to do something like
insert into TTable1 set
field1 = "test",
field2 = field2 || (update TTable2 set name = "test" upsert return after @rid where name = "test")
returns syntax error, but
insert into TTable1 set
field1 = "test",
field2 = field2 || (select @rid from TTable2 where name = "test")
works fine.
Is it an issue or there are some limits in the engine?
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.