mirror of
https://github.com/MariaDB/server.git
synced 2026-02-22 02:28:39 +01:00
341 lines
6.8 KiB
Text
341 lines
6.8 KiB
Text
# This test tests for VP's bug fixes
|
|
--disable_warnings
|
|
--disable_query_log
|
|
--disable_result_log
|
|
--source test_init.inc
|
|
--enable_result_log
|
|
--enable_query_log
|
|
|
|
--echo
|
|
--echo drop and create databases
|
|
--connection master_1
|
|
DROP DATABASE IF EXISTS auto_test_local;
|
|
CREATE DATABASE auto_test_local;
|
|
USE auto_test_local;
|
|
if ($USE_CHILD_GROUP2)
|
|
{
|
|
--connection child2_1
|
|
DROP DATABASE IF EXISTS auto_test_remote;
|
|
CREATE DATABASE auto_test_remote;
|
|
USE auto_test_remote;
|
|
--connection child2_2
|
|
DROP DATABASE IF EXISTS auto_test_remote2;
|
|
CREATE DATABASE auto_test_remote2;
|
|
USE auto_test_remote2;
|
|
}
|
|
--enable_warnings
|
|
|
|
--echo
|
|
--echo test select 1
|
|
--connection master_1
|
|
SELECT 1;
|
|
if ($USE_CHILD_GROUP2)
|
|
{
|
|
if (!$OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--disable_query_log
|
|
--disable_result_log
|
|
}
|
|
--connection child2_1
|
|
SELECT 1;
|
|
--connection child2_2
|
|
SELECT 1;
|
|
if (!$OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--enable_query_log
|
|
--enable_result_log
|
|
}
|
|
}
|
|
|
|
--echo
|
|
--echo create table and insert
|
|
if ($USE_CHILD_GROUP2)
|
|
{
|
|
if (!$OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--disable_query_log
|
|
--disable_result_log
|
|
}
|
|
--connection child2_1
|
|
if ($OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--disable_query_log
|
|
echo CHILD2_1_DROP_TABLES;
|
|
echo CHILD2_1_CREATE_TABLES;
|
|
}
|
|
--disable_warnings
|
|
eval $CHILD2_1_DROP_TABLES;
|
|
--enable_warnings
|
|
eval $CHILD2_1_CREATE_TABLES;
|
|
if ($OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--enable_query_log
|
|
}
|
|
if ($USE_GENERAL_LOG)
|
|
{
|
|
TRUNCATE TABLE mysql.general_log;
|
|
}
|
|
if (!$OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--enable_query_log
|
|
--enable_result_log
|
|
}
|
|
}
|
|
--connection master_1
|
|
--disable_warnings
|
|
DROP TABLE IF EXISTS tb_l;
|
|
--enable_warnings
|
|
--disable_query_log
|
|
echo CREATE TABLE tb_l (
|
|
a INT,
|
|
b CHAR(1),
|
|
c DATETIME,
|
|
PRIMARY KEY(a)
|
|
) MASTER_1_ENGINE2 MASTER_1_CHARSET2;
|
|
eval CREATE TABLE tb_l (
|
|
a INT,
|
|
b CHAR(1),
|
|
c DATETIME,
|
|
PRIMARY KEY(a)
|
|
) $MASTER_1_ENGINE2 $MASTER_1_CHARSET2;
|
|
--enable_query_log
|
|
INSERT INTO tb_l (a, b, c) VALUES
|
|
(1, 'a', '2008-08-01 10:21:39'),
|
|
(2, 'b', '2000-01-01 00:00:00'),
|
|
(3, 'e', '2007-06-04 20:03:11'),
|
|
(4, 'd', '2003-11-30 05:01:03'),
|
|
(5, 'c', '2001-12-31 23:59:59');
|
|
--disable_warnings
|
|
DROP TABLE IF EXISTS ta_l;
|
|
--enable_warnings
|
|
--disable_query_log
|
|
echo CREATE TABLE ta_l (
|
|
PRIMARY KEY(a)
|
|
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1;
|
|
eval CREATE TABLE ta_l (
|
|
a INT,
|
|
b CHAR(1),
|
|
c DATETIME,
|
|
PRIMARY KEY(a)
|
|
) $MASTER_1_ENGINE $MASTER_1_CHARSET $MASTER_1_COMMENT_2_1;
|
|
--enable_query_log
|
|
--disable_ps_protocol
|
|
INSERT INTO ta_l SELECT a, b, c FROM tb_l;
|
|
--enable_ps_protocol
|
|
|
|
--echo
|
|
--echo 0.9
|
|
--echo create different primary key table
|
|
if ($USE_CHILD_GROUP2)
|
|
{
|
|
if (!$OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--disable_result_log
|
|
}
|
|
--disable_query_log
|
|
--connection child2_1
|
|
if ($OUTPUT_CHILD_GROUP2)
|
|
{
|
|
echo CHILD2_1_DROP_TABLES5;
|
|
echo CHILD2_1_CREATE_TABLES5;
|
|
}
|
|
--disable_warnings
|
|
eval $CHILD2_1_DROP_TABLES5;
|
|
--enable_warnings
|
|
eval $CHILD2_1_CREATE_TABLES5;
|
|
--enable_query_log
|
|
if (!$OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--enable_result_log
|
|
}
|
|
}
|
|
--connection master_1
|
|
--disable_query_log
|
|
echo CREATE TABLE ta_l_int (
|
|
a INT DEFAULT 10,
|
|
b INT AUTO_INCREMENT,
|
|
c INT DEFAULT 11,
|
|
PRIMARY KEY(b)
|
|
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT4_2_1;
|
|
eval CREATE TABLE ta_l_int (
|
|
a INT DEFAULT 10,
|
|
b INT AUTO_INCREMENT,
|
|
c INT DEFAULT 11,
|
|
PRIMARY KEY(b)
|
|
) $MASTER_1_ENGINE $MASTER_1_CHARSET $MASTER_1_COMMENT4_2_1;
|
|
--enable_query_log
|
|
if ($USE_CHILD_GROUP2)
|
|
{
|
|
if (!$OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--disable_query_log
|
|
--disable_result_log
|
|
}
|
|
--connection child2_1
|
|
if ($USE_GENERAL_LOG)
|
|
{
|
|
TRUNCATE TABLE mysql.general_log;
|
|
}
|
|
if (!$OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--enable_query_log
|
|
--enable_result_log
|
|
}
|
|
}
|
|
--connection master_1
|
|
--let $MASTER_1_IS_VP= `SELECT IF('$MASTER_1_ENGINE_TYPE' = 'VP', 1, 0)`
|
|
--disable_ps_protocol
|
|
if ($MASTER_1_IS_VP)
|
|
{
|
|
--error 14514
|
|
INSERT INTO ta_l_int (a, b, c) VALUES (2, NULL, 3);
|
|
}
|
|
if (!$MASTER_1_IS_VP)
|
|
{
|
|
INSERT INTO ta_l_int (a, b, c) VALUES (2, NULL, 3);
|
|
--disable_query_log
|
|
--disable_result_log
|
|
TRUNCATE TABLE ta_l_int;
|
|
--enable_query_log
|
|
--enable_result_log
|
|
}
|
|
if ($USE_CHILD_GROUP2)
|
|
{
|
|
if (!$OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--disable_query_log
|
|
--disable_result_log
|
|
}
|
|
--connection child2_1
|
|
if ($USE_GENERAL_LOG)
|
|
{
|
|
SELECT argument FROM mysql.general_log WHERE command_type != 'Execute' AND argument LIKE '%insert %';
|
|
}
|
|
eval $CHILD2_1_SELECT_TABLES5;
|
|
if (!$OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--enable_query_log
|
|
--enable_result_log
|
|
}
|
|
}
|
|
--enable_ps_protocol
|
|
|
|
--echo create un-correspond primary key table
|
|
--connection master_1
|
|
--disable_warnings
|
|
DROP TABLE IF EXISTS ta_l_int;
|
|
--enable_warnings
|
|
if ($USE_CHILD_GROUP2)
|
|
{
|
|
if (!$OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--disable_result_log
|
|
}
|
|
--disable_query_log
|
|
--connection child2_1
|
|
if ($OUTPUT_CHILD_GROUP2)
|
|
{
|
|
echo CHILD2_1_DROP_TABLES5;
|
|
echo CHILD2_1_CREATE_TABLES5;
|
|
}
|
|
--disable_warnings
|
|
eval $CHILD2_1_DROP_TABLES5;
|
|
--enable_warnings
|
|
eval $CHILD2_1_CREATE_TABLES5;
|
|
--enable_query_log
|
|
if (!$OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--enable_result_log
|
|
}
|
|
}
|
|
--connection master_1
|
|
--disable_query_log
|
|
echo CREATE TABLE ta_l_int (
|
|
a INT DEFAULT 10,
|
|
b INT DEFAULT 12,
|
|
c INT DEFAULT 11,
|
|
PRIMARY KEY(c)
|
|
) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT4_2_1;
|
|
eval CREATE TABLE ta_l_int (
|
|
a INT DEFAULT 10,
|
|
b INT DEFAULT 12,
|
|
c INT DEFAULT 11,
|
|
PRIMARY KEY(c)
|
|
) $MASTER_1_ENGINE $MASTER_1_CHARSET $MASTER_1_COMMENT4_2_1;
|
|
--enable_query_log
|
|
if ($USE_CHILD_GROUP2)
|
|
{
|
|
if (!$OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--disable_query_log
|
|
--disable_result_log
|
|
}
|
|
--connection child2_1
|
|
if ($USE_GENERAL_LOG)
|
|
{
|
|
TRUNCATE TABLE mysql.general_log;
|
|
}
|
|
eval $CHILD2_1_SELECT_TABLES;
|
|
if (!$OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--enable_query_log
|
|
--enable_result_log
|
|
}
|
|
}
|
|
--connection master_1
|
|
--disable_ps_protocol
|
|
if ($MASTER_1_IS_VP)
|
|
{
|
|
--error 14514
|
|
INSERT INTO ta_l_int (a, b, c) VALUES (2, NULL, 3);
|
|
}
|
|
if (!$MASTER_1_IS_VP)
|
|
{
|
|
INSERT INTO ta_l_int (a, b, c) VALUES (2, NULL, 3);
|
|
--disable_query_log
|
|
--disable_result_log
|
|
TRUNCATE TABLE ta_l_int;
|
|
--enable_query_log
|
|
--enable_result_log
|
|
}
|
|
if ($USE_CHILD_GROUP2)
|
|
{
|
|
if (!$OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--disable_query_log
|
|
--disable_result_log
|
|
}
|
|
--connection child2_1
|
|
if ($USE_GENERAL_LOG)
|
|
{
|
|
SELECT argument FROM mysql.general_log WHERE command_type != 'Execute' AND argument LIKE '%insert %';
|
|
}
|
|
eval $CHILD2_1_SELECT_TABLES5;
|
|
if (!$OUTPUT_CHILD_GROUP2)
|
|
{
|
|
--enable_query_log
|
|
--enable_result_log
|
|
}
|
|
}
|
|
--enable_ps_protocol
|
|
|
|
--echo
|
|
--echo deinit
|
|
--disable_warnings
|
|
--connection master_1
|
|
DROP DATABASE IF EXISTS auto_test_local;
|
|
if ($USE_CHILD_GROUP2)
|
|
{
|
|
--connection child2_1
|
|
DROP DATABASE IF EXISTS auto_test_remote;
|
|
--connection child2_2
|
|
DROP DATABASE IF EXISTS auto_test_remote2;
|
|
}
|
|
--disable_query_log
|
|
--disable_result_log
|
|
--source test_deinit.inc
|
|
--enable_result_log
|
|
--enable_query_log
|
|
--enable_warnings
|
|
--echo
|
|
--echo end of test
|