On 04/26/2014 05:23 AM, Hinrichsen, John wrote:
Default non-NULL values copied from a column that was added using "ALTER
TABLE ... ADD COLUMN ... DEFAULT ..." are inserted into another table as
NULLs when copied using "INSERT INTO ... SELECT * FROM ..."
However, the same values are propagated co
Default non-NULL values copied from a column that was added using "ALTER
TABLE ... ADD COLUMN ... DEFAULT ..." are inserted into another table as
NULLs when copied using "INSERT INTO ... SELECT * FROM ..."
However, the same values are propagated correctly when "CREATE TABLE ... AS
SELECT * FROM ..
2 matches
Mail list logo