Cannot insert using select if using partial column selection

[gregsexton]

Given

CREATE TABLE pk_single_row_hist (
  id INTEGER PRIMARY KEY,
  t TEXT DEFAULT CURRENT_TIMESTAMP,
  client INTEGER,
  value INTEGER
);

When

INSERT INTO pk_single_row_hist (client, value) SELECT client, value FROM pk_single_row;

Then

Error: line 2, character 7:
Incompatible select size