2 # Check if the MySQL Server have support for
3 # ALTER [ONLINE|OFFLINE] TABLE syntax
7 let $have_online_alter = 1;
8 CREATE
TABLE check_online_alter(a
int primary key);
9 --error 0,ER_PARSE_ERROR, ER_NOT_SUPPORTED_YET
10 ALTER ONLINE
TABLE check_online_alter ADD COLUMN b int;
11 if (`SELECT
'$mysql_errno' =
'1064'`)
13 let $have_online_alter= 0;
17 DROP
TABLE check_online_alter;
22 if (!$have_online_alter)
24 skip Need ALTER ONLINE syntax;