I have just come up with another use case that jamesh suggested I add to this bug report.
I'm wanting to do an insert based on a select result.
INSERT INTO SomeTable (<some fields>) SELECT <some fields>, <some constants> FROM <some other tables>
I have just come up with another use case that jamesh suggested I add to this bug report.
I'm wanting to do an insert based on a select result.
INSERT INTO SomeTable (<some fields>)
SELECT <some fields>, <some constants>
FROM <some other tables>