Comments (2)
@raddevon The issue was with the []
, please explicitly type your empty arrays for now.
from edgedb.
I have found the following workaround for this issue. In order to either add Doc to the queue at position 2 or add position 2 to his positions if he is already in the queue (clone the Doc!), you can do this:
with
doc := assert_single((
select Person
filter .name = 'Doc'
)),
queue := (
select Queue {
id,
doc_position := (
select .people {
ps := (@position, Queue.id)
}
filter .id = doc.id
)
}
filter .id = <uuid>$queue_id
),
ps := assert_single(queue.doc_position.ps.0) ?? [],
result := (update queue
set {
people += (
select doc {
@position := ps ++ [2]
}
)
})
select assert_single(result)
I think it is rather noisy so if you have a better solution, please post!
Also I do not really understand why I get additional results from other Queues if I do not add the Queue.id
to the tuple (and later throw it away by only using .0
). If someone could explain this, that would also be great!
from edgedb.
Related Issues (20)
- `TransactionSerializationError` in `UPDATE` concurrent queries HOT 10
- Getting authenticated user's data from oauth provider HOT 4
- When adding a constraint to User.awards in cards db: InternalServerError: column old.id does not exist
- Branches with the GitHub and Vercel integrations failing when there's a forward slash HOT 1
- Unable to install HOT 5
- Email+password Provider with BuiltInUI doesn't handle non-existing accounts gracefully HOT 1
- apt repository does not have a Release file for Ubuntu 24.04 LTS HOT 2
- ISE: "subquery in FROM must have an alias" in PG < 16
- Magic Code Support
- Don't allow setting a global if it was declared with a computable expression HOT 1
- Auth improvements HOT 1
- Keycloak OAuth Provider HOT 1
- No index names in interactive migrations HOT 2
- Docs search shouldn't close on open in new tab
- Docs search should be improved
- Unclear error message for insert with mutation rewrite
- Overly strict error: INSERT does not support volatile properties with exclusive constraints
- `constraint expression on` causes InternalServerError: NotImplementedError HOT 2
- ISE when selecting link property in a complicated expression HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from edgedb.