Storm needs to support INSERT INTO ... SELECT
Bug #613300 reported by
Steve Kowalik
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Storm |
Fix Released
|
Undecided
|
William Grant | ||
Bug Description
Storm currently doesn't support INSERT with a sub-SELECT, which would be a nice to have to Storm-ify a function used by InitialiseDistr
self._store.
INSERT INTO ComponentSelection (distroseries, component)
SELECT %s AS distroseries, cs.component AS component
FROM ComponentSelection AS cs WHERE cs.distroseries = %s
''' % sqlvalues(
self.distroseri
Revision history for this message
| James Henstridge (jamesh) wrote | #1 |
| Changed in storm: | |
| assignee: | nobody → William Grant (wgrant) |
| status: | New → Fix Committed |
| milestone: | none → 0.20 |
| Changed in storm: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
In the latest version of Storm, we can create a Select() expression from a ResultSet, which probably covers the first part of this. What I don't think we have is a way to compile the outer INSERT statement, or any higher level API for it.