19 lines
598 B
Plaintext
19 lines
598 B
Plaintext
--source include/have_ndb.inc
|
|
|
|
--disable_warnings
|
|
DROP TABLE IF EXISTS t1;
|
|
--enable_warnings
|
|
|
|
--echo #
|
|
--echo # For now expressions are not allowed to be set as DEFAULT using NDB
|
|
--echo #
|
|
--error ER_UNSUPPORTED_ACTION_ON_DEFAULT_VAL_GENERATED
|
|
CREATE TABLE t1 (i INT, j DOUBLE DEFAULT (i*i)) ENGINE = ndbcluster ;
|
|
CREATE TABLE t1 (i INT) ENGINE = ndbcluster ;
|
|
--error ER_UNSUPPORTED_ACTION_ON_DEFAULT_VAL_GENERATED
|
|
ALTER TABLE t1 ALTER COLUMN i SET DEFAULT (i*i);
|
|
--error ER_UNSUPPORTED_ACTION_ON_DEFAULT_VAL_GENERATED
|
|
alter table t1 add column k double DEFAULT (SQRT(z));
|
|
|
|
DROP TABLE IF EXISTS t1;
|