17 lines
535 B
Plaintext
17 lines
535 B
Plaintext
DROP TABLE IF EXISTS u1,u2;
|
|
CREATE TABLE u1 (id INT PRIMARY KEY, c1 VARCHAR(36) DEFAULT UUID());
|
|
CREATE TABLE u2 (id INT PRIMARY KEY, c1 VARBINARY(16) DEFAULT UUID_TO_BIN(UUID()));
|
|
|
|
--error 1674
|
|
ALTER TABLE u1 ADD COLUMN c2 VARCHAR(36) DEFAULT (UUID());
|
|
|
|
--error 1674
|
|
ALTER TABLE u2 ADD COLUMN c2 VARBINARY(16) DEFAULT UUID_TO_BIN(UUID(), 1);
|
|
|
|
INSERT INTO u1(id) VALUES (1),(2),(3);
|
|
INSERT INTO u2(id) VALUES (1),(2),(3);
|
|
SELECT IS_UUID(c1) FROM u1;
|
|
SELECT IS_UUID(BIN_TO_UUID(c1)) FROM u2;
|
|
SHOW CREATE TABLE u1;
|
|
SHOW CREATE TABLE u2;
|