Debian Codegraph @

mysql-test/suite/ndb/t/ndb_default_as_expr.test

raw
1 --source include/have_ndb.inc
2
3 --disable_warnings
4 DROP TABLE IF EXISTS t1;
5 --enable_warnings
6
7 --echo #
8 --echo # For now expressions are not allowed to be set as DEFAULT using NDB
9 --echo #
10 --error ER_UNSUPPORTED_ACTION_ON_DEFAULT_VAL_GENERATED
11 CREATE TABLE t1 (i INT, j DOUBLE DEFAULT (i*i)) ENGINE = ndbcluster ;
12 CREATE TABLE t1 (i INT) ENGINE = ndbcluster ;
13 --error ER_UNSUPPORTED_ACTION_ON_DEFAULT_VAL_GENERATED
14 ALTER TABLE t1 ALTER COLUMN i SET DEFAULT (i*i);
15 --error ER_UNSUPPORTED_ACTION_ON_DEFAULT_VAL_GENERATED
16 alter table t1 add column k double DEFAULT (SQRT(z));
17
18 DROP TABLE IF EXISTS t1;