Storm may generate SQL errors on ResultSets.set for otherwise-working ResultSets.
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Storm |
New
|
Undecided
|
Unassigned |
Bug Description
For a resultset with multiple tables, like:
Operations that rely on SELECT will work fine. set however does not:
[2010-11-12 10:00:36 EST] launchpad_
[2010-11-12 10:00:36 EST] launchpad_
Storm appears not to know that on Postgres, such a query requires a FROM clause mentioning PackageBuild (and BuildFarmJob).
On platforms where UPDATE does not accept a FROM clause, it should automatically use a subselect, IMHO. A ResultSet should support all methods, and should not emit SQL errors when the methods are used as intended.