[ Avaa Bypassed ]

Upload:

Command:

hmhc3928@18.224.62.198: ~ $ 
#############################################################
# Author: Martin
# Date: 2007-07
# Purpose: basic online alter test
##############################################################
# Change Author: Jonathan
# Date 2006-08-28
# Purpose: Add more testing for online alter
##############################################################
--source include/ndb_have_online_alter.inc
--source include/have_multi_ndb.inc

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

# Create utiltity table used to hold the output from ndb_show_table
CREATE TEMPORARY TABLE IF NOT EXISTS ndb_show_tables_results (
  id INT,
  type VARCHAR(20),
  state VARCHAR(20),
  logging VARCHAR(20),
  _database VARCHAR(255),
  _schema VARCHAR(20),
  name VARCHAR(255)
);

######################################
# basic online alter tests
######################################
--echo *******************************
--echo * basic online alter tests
--echo *******************************

CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=DYNAMIC ENGINE NDB;
INSERT INTO t1 values (1,1);

--source ndb_show_tables_result.inc
set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%');

--echo *******************************
--echo * Alter Table online add column
--echo *******************************
--echo * Add column c as CHAR
--echo *******************************

ALTER TABLE t1 ADD c CHAR(19);

--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

INSERT INTO t1 values (2,1,"a");
SELECT * FROM t1 ORDER BY a;
UPDATE t1 SET c='b' where a = 2;
SELECT * FROM t1 ORDER BY a;
DROP TABLE t1;

--echo *******************************
--echo * Alter Table online add column
--echo *******************************
--echo * Add column c as nullable INT
--echo *******************************

CREATE TABLE t1 (a INT UNSIGNED KEY, b VARCHAR(19)) ENGINE NDB;
INSERT INTO t1 values (1,"a");

--source ndb_show_tables_result.inc
set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%');

ALTER TABLE t1 ADD c INT;

--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

INSERT INTO t1 values (2,"a",1);
SELECT * FROM t1 ORDER BY a;
UPDATE t1 SET c = 2 where a = 2;
SELECT * FROM t1 ORDER BY a;
DROP TABLE t1;

--echo *******************************
--echo * Alter Table online add column
--echo *******************************
--echo * Add column c as nullable INT
--echo *******************************

CREATE TABLE t1 (a INT UNSIGNED KEY, b INT COLUMN_FORMAT DYNAMIC) ENGINE NDB;
INSERT INTO t1 values (1,1);

--source ndb_show_tables_result.inc
set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%');

ALTER TABLE t1 ADD c INT;

--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

INSERT INTO t1 values (2,1,1);
SELECT * FROM t1 ORDER BY a;
UPDATE t1 SET c = 2 where a = 2;
SELECT * FROM t1 ORDER BY a;

--echo *******************************
--echo * Create online Index ci
--echo *******************************

CREATE ONLINE INDEX ci on t1(c);

--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

--echo *******************************
--echo * Create offline Index ci2
--echo *******************************
 
CREATE OFFLINE INDEX ci2 on t1(c);

--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';
set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%');

--echo *******************************
--echo * Drop online Index ci
--echo *******************************
 
DROP ONLINE INDEX ci on t1;

--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

--echo *******************************
--echo * Drop offline Index ci2
--echo *******************************

DROP OFFLINE INDEX ci2 on t1;

--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

DROP TABLE t1;

--echo *******************************
--echo * The following ALTER operations are not supported on-line
--echo *******************************
--echo * Not supported Test#1
--echo *******************************

CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=FIXED ENGINE NDB;
INSERT INTO t1 values (1,1);

--source ndb_show_tables_result.inc
set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%');

--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD c CHAR(19);
--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

ALTER TABLE t1 ADD c CHAR(19);

INSERT INTO t1 values (2,1,"a");
SELECT * FROM t1 ORDER BY a;
UPDATE t1 SET c = 'b' where a = 2;
SELECT * FROM t1 ORDER BY a;
DROP TABLE t1;

--echo *******************************
--echo * Not supported Test#2
--echo *******************************

CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=DYNAMIC ENGINE NDB;
INSERT INTO t1 values (1,1);

--source ndb_show_tables_result.inc
set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%');

--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD c CHAR(19) DEFAULT 17;
--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

ALTER TABLE t1 ADD c CHAR(19) DEFAULT 17;

INSERT INTO t1 values (2,1,"a");
SELECT * FROM t1 ORDER BY a;
UPDATE t1 SET c = 'b' where a = 2;
SELECT * FROM t1 ORDER BY a;
--echo *******************************
--echo * Not supported Test#3
--echo *******************************

--source ndb_show_tables_result.inc
set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%');

--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD d INT AFTER b;
--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

ALTER TABLE t1 ADD d INT AFTER b;
--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

INSERT INTO t1 VALUES(3,1,1,'b');
SELECT * FROM t1 ORDER BY a;
UPDATE t1 SET d = 2 where a = 3;
SELECT * FROM t1 ORDER BY a;

--echo *******************************
--echo * Not supported Test#4
--echo *******************************

--source ndb_show_tables_result.inc
set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%');

--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ENGINE MYISAM;
--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

DROP TABLE t1;

--echo *******************************
--echo * Not supported Test#5
--echo *******************************

CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=DYNAMIC ENGINE NDB;
INSERT INTO t1 values (1,1);

--source ndb_show_tables_result.inc
set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%');

--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD c TIMESTAMP;
--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

ALTER TABLE t1 ADD c TIMESTAMP;

INSERT INTO t1 values (2,2,'2007-09-19 18:46:02');
SELECT * FROM t1 ORDER BY a;
UPDATE t1 SET c = '2007-10-22 16:35:06' where a = 2;
SELECT * FROM t1 ORDER BY a;
DROP TABLE t1;

--echo *******************************
--echo * Not supported Test#6
--echo *******************************

CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=DYNAMIC ENGINE NDB;
INSERT INTO t1 values (1,1);

--source ndb_show_tables_result.inc
set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%');

--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD c CHAR(19) NOT NULL;
--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

ALTER TABLE t1 ADD c CHAR(19) NOT NULL;

INSERT INTO t1 values (2,1,"a");
SELECT * FROM t1 ORDER BY a;
UPDATE t1 SET c = 'b' where a = 2;
SELECT * FROM t1 ORDER BY a;
DROP TABLE t1;

--echo *******************************
--echo * Not supported Test#7
--echo *******************************

CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=DYNAMIC ENGINE NDB;
INSERT INTO t1 values (1,1);

--source ndb_show_tables_result.inc
set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%');

--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD c CHAR(19) COLUMN_FORMAT FIXED;
--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

ALTER TABLE t1 ADD c CHAR(19) COLUMN_FORMAT FIXED;

INSERT INTO t1 values (2,1,"a");
SELECT * FROM t1 ORDER BY a;
UPDATE t1 SET c = 'b' WHERE a = 2;
SELECT * FROM t1 ORDER BY a;
DROP TABLE t1;

--echo *******************************
--echo * Not supported Test#8
--echo * Ndb doesn't support renaming attributes on-line
--echo *******************************

CREATE TABLE t1 (
  auto int(5) unsigned NOT NULL auto_increment,
  string char(10),
  vstring varchar(10),
  bin binary(2),
  vbin varbinary(7),
  tiny tinyint(4) DEFAULT '0' NOT NULL ,
  short smallint(6) DEFAULT '1' NOT NULL ,
  medium mediumint(8) DEFAULT '0' NOT NULL,
  long_int int(11) DEFAULT '0' NOT NULL,
  longlong bigint(13) DEFAULT '0' NOT NULL,
  real_float float(13,1) DEFAULT 0.0 NOT NULL,
  real_double double(16,4),
  real_decimal decimal(16,4),
  utiny tinyint(3) unsigned DEFAULT '0' NOT NULL,
  ushort smallint(5) unsigned zerofill DEFAULT '00000' NOT NULL,
  umedium mediumint(8) unsigned DEFAULT '0' NOT NULL,
  ulong int(11) unsigned DEFAULT '0' NOT NULL,
  ulonglong bigint(13) unsigned DEFAULT '0' NOT NULL,
  bits bit(3),
  options enum('zero','one','two','three','four') not null,
  flags set('zero','one','two','three','four') not null,
  date_field date,
  year_field year,
  time_field time,
  date_time datetime,
  time_stamp timestamp,
  PRIMARY KEY (auto)
) engine=ndb;
                                                                                                   
--source ndb_show_tables_result.inc
set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%');

--error ER_NOT_SUPPORTED_YET
alter online table t1 change tiny new_tiny tinyint(4) DEFAULT '0' NOT NULL;
--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

alter table t1 change tiny new_tiny tinyint(4) DEFAULT '0' NOT NULL;

create index i1 on t1(medium);
alter table t1 add index i2(new_tiny);
drop index i1 on t1;

--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

DROP TABLE t1;

#####################################
# Adding dropping primary key
######################################
# Bug:31233
######################################
--echo ****************************************
--echo * Adding dropping primary key
--echo ****************************************
CREATE TABLE t1 (a INT UNSIGNED NOT NULL) ENGINE NDB;
--source show_primary_keys.inc
--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD PRIMARY KEY (a);
ALTER OFFLINE TABLE t1 ADD PRIMARY KEY (a);
--source show_primary_keys.inc
--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 DROP PRIMARY KEY;
ALTER OFFLINE TABLE t1 DROP PRIMARY KEY;
--source show_primary_keys.inc
--error ER_NOT_SUPPORTED_YET
CREATE ONLINE UNIQUE INDEX pk ON t1(a);
CREATE OFFLINE UNIQUE INDEX pk ON t1(a);
--source show_primary_keys.inc
--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 DROP INDEX PK;
ALTER OFFLINE TABLE t1 DROP INDEX PK;
--source show_primary_keys.inc
DROP TABLE t1;

CREATE TABLE t1 (a INT UNSIGNED) ENGINE NDB;
--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD b INT UNIQUE;
ALTER OFFLINE TABLE t1 ADD b INT UNIQUE;
--source show_primary_keys.inc
--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD c INT NOT NULL UNIQUE;
ALTER OFFLINE TABLE t1 ADD c INT NOT NULL UNIQUE;
--source show_primary_keys.inc
DROP TABLE t1;

######################################
# Alter dynmaic table, add TEXT column
######################################
# Bug:30205
######################################
--echo ****************************************
--echo * Add column c as nullable TEXT and BLOB
--echo ****************************************
CREATE TABLE t1 (a INT UNSIGNED  AUTO_INCREMENT KEY, b INT DEFAULT 2 COLUMN_FORMAT DYNAMIC) ENGINE NDB;
--source ndb_show_tables_result.inc
set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%');

let $v=5;
disable_query_log;
while ($v)
{
  INSERT INTO t1 VALUES(NULL, DEFAULT); 
  dec $v;
}
enable_query_log;
--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD c TEXT;
--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD d BLOB;
--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

DROP TABLE t1;

######################################
# Alter dynmaic table, add column
######################################

CREATE TABLE t1 (a INT UNSIGNED AUTO_INCREMENT KEY, b INT COLUMN_FORMAT DYNAMIC) ENGINE NDB;

let $v=5;
disable_query_log;
while ($v)
{
  --eval INSERT INTO t1 VALUES(NULL, $v); 
  dec $v;
}
enable_query_log;

--source ndb_show_tables_result.inc
set @t1_id = (select id from ndb_show_tables_results where name like '%t1%' and type like '%UserTable%');

--echo *******************************
--echo * Add column c as nullable FLOAT
--echo *******************************
ALTER ONLINE TABLE t1 ADD c FLOAT;

let $v=5;
disable_query_log;
while ($v)
{
  --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38); 
  dec $v;
}
enable_query_log;

--echo *******************************
--echo * Add column d as nullable DOUBLE
--echo *******************************
ALTER ONLINE TABLE t1 ADD d DOUBLE UNSIGNED;

let $v=5;
disable_query_log;
while ($v)
{
  --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38, 1.7976931348623E+308); 
  dec $v;
}
enable_query_log;

--echo *******************************
--echo * Add column e as nullable DECIMAL
--echo *******************************
ALTER ONLINE TABLE t1 ADD e DECIMAL(5,2);

let $v=5;
disable_query_log;
while ($v)
{
  --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38, 1.7976931348623E+308, 345.21); 
  dec $v;
}
enable_query_log;

--echo *******************************
--echo * Add column f as nullable DATETIME
--echo *******************************
ALTER ONLINE TABLE t1 ADD f DATETIME;

let $v=5;
disable_query_log;
while ($v)
{
  --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38, 1.7976931348623E+308, 345.21, '1000-01-01 00:00:00'); 
  dec $v;
}
enable_query_log;

--echo *******************************
--echo * Add column g as nullable BINARY
--echo *******************************
ALTER TABLE t1 ADD g BINARY(4);

let $v=5;
disable_query_log;
while ($v)
{
  --eval INSERT INTO t1 VALUES(NULL, $v, -3.402823466E+38, 1.7976931348623E+308, 345.21, '1000-01-01 00:00:00', '0101');
  dec $v;
}
enable_query_log;


--source ndb_show_tables_result.inc
select name from ndb_show_tables_results where id = @t1_id and name like '%t1%' and type like '%UserTable%';

SELECT COUNT(*) FROM t1 WHERE c IS NULL;
SELECT COUNT(*) FROM t1 WHERE d IS NULL;
SELECT COUNT(*) FROM t1 WHERE e IS NULL;
SELECT COUNT(*) FROM t1 WHERE f IS NULL;
SELECT COUNT(*) FROM t1 WHERE g IS NULL;

UPDATE t1 SET c = 3.402823466E+38, d = 1.2686868689898E+308, e = 666.66, f = '2007-10-23 23:23:23', g = '1111' WHERE a = 1;
SELECT * FROM t1 WHERE a = 1 or a = 10 or a = 20 or a = 30 ORDER BY a;

##############################
# Backup and restore section #
##############################
--echo *********************************
--echo * Backup and restore tables w/ new column
--echo *********************************

--source include/ndb_backup.inc

DROP TABLE t1;

--exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 1 -m -r --print --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT
--exec $NDB_RESTORE --no-defaults -b $the_backup_id -n 2 -r --print --print_meta $NDB_BACKUPS-$the_backup_id >> $NDB_TOOLS_OUTPUT

source show_varpart.inc;

DROP TABLE t1;

###################################
# Disk Data Error testing section #
###################################
--echo *********************************
--echo * Disk Data error testing
--echo *********************************

set default_storage_engine=ndb;

CREATE LOGFILE GROUP lg1
ADD UNDOFILE 'undofile.dat'
INITIAL_SIZE 16M
UNDO_BUFFER_SIZE = 1M;

CREATE TABLESPACE ts1
ADD DATAFILE 'datafile.dat'
USE LOGFILE GROUP lg1
INITIAL_SIZE 12M
ENGINE NDB;

CREATE TABLE t1
(pk1 INT NOT NULL PRIMARY KEY, b INT COLUMN_FORMAT DYNAMIC)
TABLESPACE ts1 STORAGE DISK
ENGINE=NDB;

--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 CHANGE b b_1 INT COLUMN_FORMAT DYNAMIC;
--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD COLUMN c INT COLUMN_FORMAT DYNAMIC;
--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD COLUMN d FLOAT COLUMN_FORMAT DYNAMIC;
--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD COLUMN  e DOUBLE COLUMN_FORMAT DYNAMIC;
--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD COLUMN f DATETIME COLUMN_FORMAT DYNAMIC;
--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD COLUMN g DECIMAL(5,2) COLUMN_FORMAT DYNAMIC;
--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD COLUMN h CHAR(20) COLUMN_FORMAT DYNAMIC;
--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD COLUMN h VARCHAR(20) COLUMN_FORMAT DYNAMIC;
--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD COLUMN h BINARY(20) COLUMN_FORMAT DYNAMIC;
--error ER_NOT_SUPPORTED_YET
ALTER ONLINE TABLE t1 ADD COLUMN h VARBINARY(20) COLUMN_FORMAT DYNAMIC;
DROP TABLE t1;

#
# bug#42549
#
create table t1 (a int primary key, b int) storage disk tablespace ts1 engine = ndb;
--error ER_NOT_SUPPORTED_YET
alter online table t1 add column c0 int null column_format DYNAMIC;
alter online table t1 add column c1 int null column_format DYNAMIC storage memory;
drop table t1;

create table t1 (a int primary key, b int storage disk) tablespace ts1 engine = ndb;
alter online table t1 add column c0 int null column_format DYNAMIC;
alter online table t1 add column c1 int null column_format DYNAMIC storage memory;
drop table t1;

ALTER TABLESPACE ts1
DROP DATAFILE 'datafile.dat'
ENGINE = NDB;

DROP TABLESPACE ts1
ENGINE = NDB;

DROP LOGFILE GROUP lg1
ENGINE =NDB; 

##############################
# ROW_FORMAT testing section #
##############################
--echo ********************
--echo * ROW_FORMAT testing
--echo ********************

# Bug:30276, should issue a warning 

CREATE TABLE t1
(pk1 INT NOT NULL PRIMARY KEY, b INT COLUMN_FORMAT DYNAMIC)ROW_FORMAT=FIXED
ENGINE=NDB;

source show_attributes.inc;

DROP TABLE t1;

CREATE TABLE t1
(pk1 INT NOT NULL COLUMN_FORMAT FIXED PRIMARY KEY, 
b INT COLUMN_FORMAT FIXED)ROW_FORMAT=DYNAMIC ENGINE=NDB;

source show_attributes.inc;

DROP TABLE t1;

--echo ********************
--echo * bug#44695 ALTER TABLE during START BACKUP crashes mysqld     
--echo ********************
# Testing failure of online alter during ongoing backup

CREATE TABLE t1(k INT NOT NULL PRIMARY KEY AUTO_INCREMENT) ROW_FORMAT=DYNAMIC ENGINE=NDB;
# create some data to slow down backup
INSERT INTO t1 VALUES (NULL);
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
INSERT INTO t1 SELECT NULL FROM t1;
SELECT COUNT(*) FROM t1;
--exec $NDB_MGM --no-defaults --ndb-connectstring="$NDB_CONNECTSTRING" -e "start backup nowait" >> $NDB_TOOLS_OUTPUT
--disable_warnings
--error 0,762,1296
ALTER ONLINE TABLE t1 ADD b INT;
# waut for backup to complete
--sleep 10

--enable_warnings

DROP TABLE t1, ndb_show_tables_results;

#
# test alter of table with many attributes
#
let $i=499;
let $separator=;
let $sql=create table t1 (;
while ($i)
{
  let $sql=$sql$separator c$i int;
  let $separator=,;
  dec $i;
}
let $sql=$sql, c501 varchar(10000);
let $sql=$sql, primary key using hash(c1)) engine=ndb;
eval $sql; # eval the sql and create the table

insert into t1 (c1) values (1), (2), (3);
alter offline table t1 modify c1 int auto_increment;
alter online table t1 add column c500 bit(1) column_format DYNAMIC;
--error ER_TOO_BIG_ROWSIZE
alter offline table t1 add column c502 varchar(2000);
--error ER_TOO_BIG_ROWSIZE
alter online table t1 add column c502 varchar(2000);
delete from t1;
drop table t1;

Filemanager

DIR : / usr/ share/ mysql-test/ suite/ ndb/ t/
Name Type Size Permission Actions
bug36547.test File 386 B 0644
clusterj.test File 1.8 KB 0644
clusterj_jpa.test File 2.46 KB 0644
disabled.def File 918 B 0644
have_ndb_dist_priv.inc File 857 B 0644
have_ndb_error_insert.inc File 931 B 0644
have_ndbinfo.inc File 821 B 0644
loaddata_autocom_ndb.test File 98 B 0644
ndb_add_partition.test File 6.78 KB 0644
ndb_addnode.cnf File 664 B 0644
ndb_addnode.test File 2.18 KB 0644
ndb_alter_table.test File 9.6 KB 0644
ndb_alter_table2.test File 1.31 KB 0644
ndb_alter_table3.test File 1.47 KB 0644
ndb_alter_table_backup.test File 1.53 KB 0644
ndb_alter_table_error.test File 953 B 0644
ndb_alter_table_online.test File 21.47 KB 0644
ndb_alter_table_online2.test File 4.82 KB 0644
ndb_alter_table_online_multi.test File 1.92 KB 0644
ndb_auto_increment.test File 11.59 KB 0644
ndb_autoinc.test File 642 B 0644
ndb_basic.test File 20.68 KB 0644
ndb_bitfield.test File 6.33 KB 0644
ndb_blob.test File 17.7 KB 0644
ndb_blob_big.cnf File 353 B 0644
ndb_blob_big.test File 1.62 KB 0644
ndb_blob_partition.test File 4.28 KB 0644
ndb_bug26793.test File 843 B 0644
ndb_bug31477.test File 2.13 KB 0644
ndb_bug31754.test File 206 B 0644
ndb_bulk_delete.test File 3.92 KB 0644
ndb_cache.test File 7.92 KB 0644
ndb_cache2.test File 11.05 KB 0644
ndb_cache_multi.test File 1.89 KB 0644
ndb_cache_multi2.test File 4.3 KB 0644
ndb_cache_trans.test File 4.64 KB 0644
ndb_charset.test File 6.41 KB 0644
ndb_column_properties.test File 4.48 KB 0644
ndb_condition_pushdown.test File 80.54 KB 0644
ndb_config.test File 3.53 KB 0644
ndb_config2.test File 346 B 0644
ndb_create_table.test File 795 B 0644
ndb_cursor.test File 918 B 0644
ndb_database.test File 2.99 KB 0644
ndb_dbug_lock.test File 1.94 KB 0644
ndb_dbug_tc_select.test File 3.81 KB 0644
ndb_dbug_tc_select_1.inc File 1.83 KB 0644
ndb_dbug_tc_select_2.inc File 1.91 KB 0644
ndb_dbug_tc_select_3.inc File 2.06 KB 0644
ndb_dd_alter.test File 7.87 KB 0644
ndb_dd_basic.test File 20.17 KB 0644
ndb_dd_bug12581213.cnf File 111 B 0644
ndb_dd_bug12581213.test File 370 B 0644
ndb_dd_ddl.test File 7.37 KB 0644
ndb_dd_disk2memory.test File 10.02 KB 0644
ndb_dd_dump.test File 10.58 KB 0644
ndb_dd_restore_compat.test File 949 B 0644
ndb_dd_sql_features.test File 16.14 KB 0644
ndb_ddl_open_trans.test File 2.54 KB 0644
ndb_disconnect_ddl.test File 1.31 KB 0644
ndb_discover_db-master.opt File 43 B 0644
ndb_discover_db.test File 1.88 KB 0644
ndb_dist_priv.test File 7.09 KB 0644
ndb_gis.test File 211 B 0644
ndb_global_schema_lock.test File 3.51 KB 0644
ndb_global_schema_lock_error.test File 1.53 KB 0644
ndb_grant.later File 10.98 KB 0644
ndb_hidden_pk.test File 2.55 KB 0644
ndb_index.test File 11.9 KB 0644
ndb_index_ordered.test File 15.46 KB 0644
ndb_index_stat.test File 9.91 KB 0644
ndb_index_stat_enable.inc File 1.18 KB 0644
ndb_index_unique.test File 14.63 KB 0644
ndb_init_schema_locks_count.inc File 226 B 0644
ndb_insert.test File 36.32 KB 0644
ndb_join_pushdown.test File 110.53 KB 0644
ndb_jtie.test File 990 B 0644
ndb_limit.test File 2.25 KB 0644
ndb_load.test File 2.12 KB 0644
ndb_loaddatalocal.test File 2.43 KB 0644
ndb_lock.test File 5.69 KB 0644
ndb_lock_table.test File 284 B 0644
ndb_mgm.inc File 130 B 0644
ndb_mgm.test File 3.38 KB 0644
ndb_minmax.test File 1.28 KB 0644
ndb_multi.test File 5.79 KB 0644
ndb_multi_row.test File 1.78 KB 0644
ndb_native_default_support.test File 25.47 KB 0644
ndb_optimize_table.test File 2.44 KB 0644
ndb_optimized_node_selection.test File 908 B 0644
ndb_partition_error.test File 1.83 KB 0644
ndb_partition_error2.test File 369 B 0644
ndb_partition_hash.test File 1.53 KB 0644
ndb_partition_key.test File 6.85 KB 0644
ndb_partition_list.test File 2.67 KB 0644
ndb_partition_range.test File 7.91 KB 0644
ndb_read_multi_range.test File 14.6 KB 0644
ndb_reconnect.test File 1.76 KB 0644
ndb_rename.test File 858 B 0644
ndb_replace.test File 3.95 KB 0644
ndb_restart_nostart.inc File 147 B 0644
ndb_restart_start.inc File 130 B 0644
ndb_restore_compat_compression-master.opt File 46 B 0644
ndb_restore_compat_compression.test File 589 B 0644
ndb_restore_compat_downward.test File 3.99 KB 0644
ndb_restore_compat_endianness.test File 6.68 KB 0644
ndb_restore_conv_lossy_charbinary.test File 16.86 KB 0644
ndb_restore_conv_lossy_integral.test File 22.53 KB 0644
ndb_restore_conv_padding.test File 9.09 KB 0644
ndb_restore_conv_promotion.test File 12.71 KB 0644
ndb_restore_discover.test File 1.72 KB 0644
ndb_restore_misc.test File 23.18 KB 0644
ndb_restore_print.test File 6.82 KB 0644
ndb_restore_schema_blobs.test File 4.26 KB 0644
ndb_restore_schema_partitions.test File 14.93 KB 0644
ndb_restore_schema_rewrites.test File 16.26 KB 0644
ndb_restore_schema_subsets.test File 10.97 KB 0644
ndb_restore_schema_tolerance.test File 6.55 KB 0644
ndb_restore_undolog.test File 16.53 KB 0644
ndb_row_count.test File 2.95 KB 0644
ndb_row_format.test File 1.89 KB 0644
ndb_schema_locks_count.inc File 209 B 0644
ndb_select_count.test File 364 B 0644
ndb_share.cnf File 652 B 0644
ndb_share.test File 9.38 KB 0644
ndb_short_sigs.cnf File 170 B 0644
ndb_short_sigs.test File 2.5 KB 0644
ndb_show_tables_result.inc File 563 B 0644
ndb_single_user-master.opt File 32 B 0644
ndb_single_user.test File 4.76 KB 0644
ndb_sp.test File 909 B 0644
ndb_sql_allow_batching.test File 1.12 KB 0644
ndb_statistics.inc File 3.33 KB 0644
ndb_statistics0.test File 232 B 0644
ndb_statistics1.test File 231 B 0644
ndb_subquery.test File 2.53 KB 0644
ndb_temporary.test File 1.08 KB 0644
ndb_tmp_table_and_DDL.test File 393 B 0644
ndb_transaction.test File 5.76 KB 0644
ndb_trigger.test File 8.77 KB 0644
ndb_truncate.test File 794 B 0644
ndb_types.test File 2.69 KB 0644
ndb_update.test File 2.74 KB 0644
ndb_update_no_read.test File 16.91 KB 0644
ndb_view.test File 607 B 0644
ndb_wait_nostart.inc File 103 B 0644
ndb_wait_started.inc File 84 B 0644
ndb_waiter.inc File 148 B 0644
ndbapi.test File 1.98 KB 0644
ndbinfo.test File 6.85 KB 0644
ndbinfo_cache.test File 794 B 0644
ndbinfo_create.inc File 387 B 0644
ndbinfo_drop.inc File 127 B 0644
ndbinfo_dump.test File 626 B 0644
ps_7ndb.test File 898 B 0644
show_attributes.inc File 664 B 0644
show_primary_keys.inc File 609 B 0644
show_varpart.inc File 762 B 0644
strict_autoinc_5ndb.test File 146 B 0644
test_mgmd.cnf File 232 B 0644
test_mgmd.test File 195 B 0644
test_ndbinfo.test File 229 B 0644