← Back to team overview

drizzle-discuss team mailing list archive

CREATE TABLE LIKE

 

Hi!

In this case:

CREATE TEMPORARY TABLE t1 (
  id INT NOT NULL
, padding VARCHAR(200) NOT NULL
);

CREATE TABLE t2 LIKE t1;

Should t2 be a TEMPORARY table or not? What if the engine for t1 can't be TEMPORARY? Toss an error?

It seems like to me that either we should toss and error, or t2 should be identical to t1.

Thoughts? Opinions?

Cheers,
	-Brian



Follow ups