diff options
author | unknown <mleich@five.local.lan> | 2008-05-15 18:01:13 +0200 |
---|---|---|
committer | unknown <mleich@five.local.lan> | 2008-05-15 18:01:13 +0200 |
commit | 7ab1c8dc936c757746f966ea14ab0a17f0713126 (patch) | |
tree | 20dcafa228d996ca9540a3cf5055a43f9005cb20 /mysql-test/suite/jp/r/jp_join_sjis.result | |
parent | 19e550ba771aad6fcd2fe2658906e7e6b0883bb8 (diff) | |
download | mariadb-git-7ab1c8dc936c757746f966ea14ab0a17f0713126.tar.gz |
Fix for
Bug#28563 Test suite "jp" fails completely
- The main goal of this fix is to make the "jp" suite runnable in general
and to make it more robust for use in pushbuild under build team conditions.
- It was decided to fix the remaining heavy issues within the
architecture of this test later
(-> WL 4327 Redesign the 'jp' testsuite for build team testing conditions)
Only the test jp_trim_sjis got some significant improvements of its
architecture (Just as proof of concept for the other tests).
- Tests suffering from
Bug 36597 Testsuite "jp": Suspicious results for some tests
(unexpected result sets)
were disabled
- *.opt files were used to avoid differences on OS (Windows) because of
case sensitive tablenames within the tests
mysql-test/suite/jp/r/jp_alter_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_alter_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_alter_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_alter_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_charlength_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_charlength_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_charlength_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_charlength_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_charset_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_charset_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_charset_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_charset_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_convert_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_convert_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_convert_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_convert_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_create_db_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_create_db_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_create_db_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_create_db_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_create_tbl_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_create_tbl_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_create_tbl_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_create_tbl_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_enum_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_enum_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_enum_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_enum_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_insert_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_insert_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_insert_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_insert_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_instr_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_instr_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_instr_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_instr_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_join_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_join_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_join_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_join_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_left_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_left_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_left_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_left_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_length_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_length_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_length_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_length_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_like_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_like_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_like_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_like_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_locate_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_locate_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_locate_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_locate_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_lpad_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_lpad_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_lpad_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_lpad_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_ltrim_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_ltrim_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_ltrim_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_ltrim_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_ps_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_ps_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_replace_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_replace_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_replace_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_replace_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_reverse_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_reverse_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_reverse_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_reverse_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_right_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_right_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_right_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_right_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_rpad_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_rpad_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_rpad_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_rpad_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_rtrim_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_rtrim_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_rtrim_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_rtrim_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_select_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_select_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_select_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_select_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_subquery_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_subquery_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_subquery_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_subquery_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_substring_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_substring_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_substring_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_substring_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_trim_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_trim_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_trim_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_trim_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_union_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_update_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_update_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_update_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_update_utf8.result:
Updated results
mysql-test/suite/jp/r/jp_where_sjis.result:
Updated results
mysql-test/suite/jp/r/jp_where_ucs2.result:
Updated results
mysql-test/suite/jp/r/jp_where_ujis.result:
Updated results
mysql-test/suite/jp/r/jp_where_utf8.result:
Updated results
mysql-test/suite/jp/t/jp_alter_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_alter_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_alter_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_alter_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_charlength_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_charlength_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_charlength_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_charlength_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_charset_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_charset_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_charset_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_charset_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_convert_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_convert_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_convert_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_convert_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_create_db_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_create_db_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_create_tbl_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_create_tbl_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_create_tbl_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_create_tbl_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_enum_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_enum_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_enum_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_enum_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_insert_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_insert_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_insert_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_insert_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_instr_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_instr_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_instr_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_instr_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_join_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_join_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_join_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_join_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_left_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_left_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_left_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_left_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_length_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_length_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_length_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_length_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_like_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_like_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_like_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_like_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_locate_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_locate_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_locate_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_locate_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_lpad_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_lpad_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_lpad_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_lpad_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_ltrim_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_ltrim_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_ltrim_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_ltrim_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_ps_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_ps_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_replace_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_replace_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_replace_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_replace_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_reverse_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_reverse_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_reverse_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_reverse_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_right_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_right_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_right_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_right_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_rpad_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_rpad_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_rpad_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_rpad_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_rtrim_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_rtrim_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_rtrim_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_rtrim_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_select_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_select_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_select_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_select_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_subquery_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_subquery_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_subquery_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_subquery_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_substring_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_substring_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_substring_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_substring_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_trim_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_trim_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_trim_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_trim_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_union_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_update_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_update_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_update_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_update_utf8.test:
Updated results
mysql-test/suite/jp/t/jp_where_sjis.test:
Updated results
mysql-test/suite/jp/t/jp_where_ucs2.test:
Updated results
mysql-test/suite/jp/t/jp_where_ujis.test:
Updated results
mysql-test/suite/jp/t/jp_where_utf8.test:
Updated results
mysql-test/suite/jp/include/trim_sjis.inc:
Auxiliary script
mysql-test/suite/jp/t/disabled.def:
Disable tests which suffer to an unacceptable extend
from bug 36597 Testsuite "jp": Suspicious results for some tests
Diffstat (limited to 'mysql-test/suite/jp/r/jp_join_sjis.result')
-rw-r--r-- | mysql-test/suite/jp/r/jp_join_sjis.result | 399 |
1 files changed, 132 insertions, 267 deletions
diff --git a/mysql-test/suite/jp/r/jp_join_sjis.result b/mysql-test/suite/jp/r/jp_join_sjis.result index a5ccc58ae4c..5e7e51e0925 100644 --- a/mysql-test/suite/jp/r/jp_join_sjis.result +++ b/mysql-test/suite/jp/r/jp_join_sjis.result @@ -1,15 +1,21 @@ -drop table if exists `sP`; -drop table if exists `sQ`; -drop table if exists `sR`; -drop table if exists `sS`; -drop table if exists `sT`; -drop table if exists `sU`; -drop table if exists `sV`; -drop table if exists `sW`; -drop table if exists `sX`; -drop table if exists `sPO`; -drop table if exists `sPP`; -drop table if exists `sPQ`; +DROP TABLE IF EXISTS `sPa`; +DROP TABLE IF EXISTS `sPb`; +DROP TABLE IF EXISTS `sQa`; +DROP TABLE IF EXISTS `sQb`; +DROP TABLE IF EXISTS `sRa`; +DROP TABLE IF EXISTS `sRb`; +DROP TABLE IF EXISTS `sSa`; +DROP TABLE IF EXISTS `sSb`; +DROP TABLE IF EXISTS `sTa`; +DROP TABLE IF EXISTS `sTb`; +DROP TABLE IF EXISTS `sUa`; +DROP TABLE IF EXISTS `sUb`; +DROP TABLE IF EXISTS `sVa`; +DROP TABLE IF EXISTS `sVb`; +DROP TABLE IF EXISTS `sWa`; +DROP TABLE IF EXISTS `sWb`; +DROP TABLE IF EXISTS `sXa`; +DROP TABLE IF EXISTS `sXb`; SET NAMES sjis; SET character_set_database = sjis; CREATE TABLE `sPa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = innodb; @@ -24,18 +30,12 @@ CREATE TABLE `sTa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine CREATE TABLE `sTb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sUa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; CREATE TABLE `sUb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = myisam; -CREATE TABLE `sVa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sVb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sWa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sWb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sXa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sXb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sPOa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sPOb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sPPa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sPPb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sPQa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; -CREATE TABLE `sPQb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = heap; +CREATE TABLE `sVa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; +CREATE TABLE `sVb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; +CREATE TABLE `sWa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; +CREATE TABLE `sWb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; +CREATE TABLE `sXa` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; +CREATE TABLE `sXb` (`bP` char(1) PRIMARY KEY) DEFAULT CHARSET = sjis engine = MEMORY; INSERT INTO `sPa` VALUES (''),(''),(''); INSERT INTO `sPb` VALUES (''); INSERT INTO `sQa` VALUES (''),(''),(''); @@ -54,12 +54,6 @@ INSERT INTO `sWa` VALUES (''),(''),(''); INSERT INTO `sWb` VALUES (''); INSERT INTO `sXa` VALUES ('\'),('\'),('\'); INSERT INTO `sXb` VALUES ('\'); -INSERT INTO `sPOa` VALUES (''),(''),(''); -INSERT INTO `sPOb` VALUES (''); -INSERT INTO `sPPa` VALUES (''),(''),(''); -INSERT INTO `sPPb` VALUES (''); -INSERT INTO `sPQa` VALUES ('\'),('\'),('\'); -INSERT INTO `sPQb` VALUES ('\'); SELECT * FROM `sPa` JOIN `sPb`; bP bP @@ -71,31 +65,31 @@ SELECT * FROM `sPa` INNER JOIN `sPb`; SELECT * FROM `sPa` JOIN `sPb` USING (`bP`); -bP bP - +bP + SELECT * FROM `sPa` INNER JOIN `sPb` USING (`bP`); -bP bP - +bP + SELECT * FROM `sPa` CROSS JOIN `sPb`; bP bP SELECT * FROM `sPa` LEFT JOIN `sPb` USING (`bP`); -bP bP - - NULL - NULL +bP + + + SELECT * FROM `sPa` LEFT JOIN `sPb` ON (`sPa`.`bP` = `sPb`.`bP`); bP bP NULL NULL SELECT * FROM `sPb` RIGHT JOIN `sPa` USING (`bP`); -bP bP - -NULL -NULL +bP + + + SELECT * FROM `sPb` RIGHT JOIN `sPa` ON (`sPa`.`bP` = `sPb`.`bP`); bP bP @@ -112,31 +106,31 @@ SELECT * FROM `sQa` INNER JOIN `sQb`; SELECT * FROM `sQa` JOIN `sQb` USING (`bP`); -bP bP - +bP + SELECT * FROM `sQa` INNER JOIN `sQb` USING (`bP`); -bP bP - +bP + SELECT * FROM `sQa` CROSS JOIN `sQb`; bP bP SELECT * FROM `sQa` LEFT JOIN `sQb` USING (`bP`); -bP bP - - NULL - NULL +bP + + + SELECT * FROM `sQa` LEFT JOIN `sQb` ON (`sQa`.`bP` = `sQb`.`bP`); bP bP NULL NULL SELECT * FROM `sQb` RIGHT JOIN `sQa` USING (`bP`); -bP bP - -NULL -NULL +bP + + + SELECT * FROM `sQb` RIGHT JOIN `sQa` ON (`sQa`.`bP` = `sQb`.`bP`); bP bP @@ -153,31 +147,31 @@ SELECT * FROM `sRa` INNER JOIN `sRb`; \ \ \ \ SELECT * FROM `sRa` JOIN `sRb` USING (`bP`); -bP bP -\ \ +bP +\ SELECT * FROM `sRa` INNER JOIN `sRb` USING (`bP`); -bP bP -\ \ +bP +\ SELECT * FROM `sRa` CROSS JOIN `sRb`; bP bP \ \ \ \ \ \ SELECT * FROM `sRa` LEFT JOIN `sRb` USING (`bP`); -bP bP -\ \ -\ NULL -\ NULL +bP +\ +\ +\ SELECT * FROM `sRa` LEFT JOIN `sRb` ON (`sRa`.`bP` = `sRb`.`bP`); bP bP \ \ \ NULL \ NULL SELECT * FROM `sRb` RIGHT JOIN `sRa` USING (`bP`); -bP bP -\ \ -NULL \ -NULL \ +bP +\ +\ +\ SELECT * FROM `sRb` RIGHT JOIN `sRa` ON (`sRa`.`bP` = `sRb`.`bP`); bP bP \ \ @@ -194,31 +188,31 @@ SELECT * FROM `sSa` INNER JOIN `sSb`; SELECT * FROM `sSa` JOIN `sSb` USING (`bP`); -bP bP - +bP + SELECT * FROM `sSa` INNER JOIN `sSb` USING (`bP`); -bP bP - +bP + SELECT * FROM `sSa` CROSS JOIN `sSb`; bP bP SELECT * FROM `sSa` LEFT JOIN `sSb` USING (`bP`); -bP bP - - NULL - NULL +bP + + + SELECT * FROM `sSa` LEFT JOIN `sSb` ON (`sSa`.`bP` = `sSb`.`bP`); bP bP NULL NULL SELECT * FROM `sSb` RIGHT JOIN `sSa` USING (`bP`); -bP bP - -NULL -NULL +bP + + + SELECT * FROM `sSb` RIGHT JOIN `sSa` ON (`sSa`.`bP` = `sSb`.`bP`); bP bP @@ -235,31 +229,31 @@ SELECT * FROM `sTa` INNER JOIN `sTb`; SELECT * FROM `sTa` JOIN `sTb` USING (`bP`); -bP bP - +bP + SELECT * FROM `sTa` INNER JOIN `sTb` USING (`bP`); -bP bP - +bP + SELECT * FROM `sTa` CROSS JOIN `sTb`; bP bP SELECT * FROM `sTa` LEFT JOIN `sTb` USING (`bP`); -bP bP - - NULL - NULL +bP + + + SELECT * FROM `sTa` LEFT JOIN `sTb` ON (`sTa`.`bP` = `sTb`.`bP`); bP bP NULL NULL SELECT * FROM `sTb` RIGHT JOIN `sTa` USING (`bP`); -bP bP - -NULL -NULL +bP + + + SELECT * FROM `sTb` RIGHT JOIN `sTa` ON (`sTa`.`bP` = `sTb`.`bP`); bP bP @@ -276,31 +270,31 @@ SELECT * FROM `sUa` INNER JOIN `sUb`; \ \ \ \ SELECT * FROM `sUa` JOIN `sUb` USING (`bP`); -bP bP -\ \ +bP +\ SELECT * FROM `sUa` INNER JOIN `sUb` USING (`bP`); -bP bP -\ \ +bP +\ SELECT * FROM `sUa` CROSS JOIN `sUb`; bP bP \ \ \ \ \ \ SELECT * FROM `sUa` LEFT JOIN `sUb` USING (`bP`); -bP bP -\ \ -\ NULL -\ NULL +bP +\ +\ +\ SELECT * FROM `sUa` LEFT JOIN `sUb` ON (`sUa`.`bP` = `sUb`.`bP`); bP bP \ \ \ NULL \ NULL SELECT * FROM `sUb` RIGHT JOIN `sUa` USING (`bP`); -bP bP -\ \ -NULL \ -NULL \ +bP +\ +\ +\ SELECT * FROM `sUb` RIGHT JOIN `sUa` ON (`sUa`.`bP` = `sUb`.`bP`); bP bP \ \ @@ -317,31 +311,31 @@ SELECT * FROM `sVa` INNER JOIN `sVb`; SELECT * FROM `sVa` JOIN `sVb` USING (`bP`); -bP bP - +bP + SELECT * FROM `sVa` INNER JOIN `sVb` USING (`bP`); -bP bP - +bP + SELECT * FROM `sVa` CROSS JOIN `sVb`; bP bP SELECT * FROM `sVa` LEFT JOIN `sVb` USING (`bP`); -bP bP - - NULL - NULL +bP + + + SELECT * FROM `sVa` LEFT JOIN `sVb` ON (`sVa`.`bP` = `sVb`.`bP`); bP bP NULL NULL SELECT * FROM `sVb` RIGHT JOIN `sVa` USING (`bP`); -bP bP - -NULL -NULL +bP + + + SELECT * FROM `sVb` RIGHT JOIN `sVa` ON (`sVa`.`bP` = `sVb`.`bP`); bP bP @@ -358,31 +352,31 @@ SELECT * FROM `sWa` INNER JOIN `sWb`; SELECT * FROM `sWa` JOIN `sWb` USING (`bP`); -bP bP - +bP + SELECT * FROM `sWa` INNER JOIN `sWb` USING (`bP`); -bP bP - +bP + SELECT * FROM `sWa` CROSS JOIN `sWb`; bP bP SELECT * FROM `sWa` LEFT JOIN `sWb` USING (`bP`); -bP bP - - NULL - NULL +bP + + + SELECT * FROM `sWa` LEFT JOIN `sWb` ON (`sWa`.`bP` = `sWb`.`bP`); bP bP NULL NULL SELECT * FROM `sWb` RIGHT JOIN `sWa` USING (`bP`); -bP bP - -NULL -NULL +bP + + + SELECT * FROM `sWb` RIGHT JOIN `sWa` ON (`sWa`.`bP` = `sWb`.`bP`); bP bP @@ -399,159 +393,36 @@ SELECT * FROM `sXa` INNER JOIN `sXb`; \ \ \ \ SELECT * FROM `sXa` JOIN `sXb` USING (`bP`); -bP bP -\ \ +bP +\ SELECT * FROM `sXa` INNER JOIN `sXb` USING (`bP`); -bP bP -\ \ +bP +\ SELECT * FROM `sXa` CROSS JOIN `sXb`; bP bP \ \ \ \ \ \ SELECT * FROM `sXa` LEFT JOIN `sXb` USING (`bP`); -bP bP -\ \ -\ NULL -\ NULL +bP +\ +\ +\ SELECT * FROM `sXa` LEFT JOIN `sXb` ON (`sXa`.`bP` = `sXb`.`bP`); bP bP \ \ \ NULL \ NULL SELECT * FROM `sXb` RIGHT JOIN `sXa` USING (`bP`); -bP bP -\ \ -NULL \ -NULL \ +bP +\ +\ +\ SELECT * FROM `sXb` RIGHT JOIN `sXa` ON (`sXa`.`bP` = `sXb`.`bP`); bP bP \ \ NULL \ NULL \ -SELECT * FROM `sPOa` JOIN `sPOb`; -bP bP - - - -SELECT * FROM `sPOa` INNER JOIN `sPOb`; -bP bP - - - -SELECT * FROM `sPOa` JOIN `sPOb` USING (`bP`); -bP bP - -SELECT * FROM `sPOa` INNER JOIN `sPOb` USING (`bP`); -bP bP - -SELECT * FROM `sPOa` CROSS JOIN `sPOb`; -bP bP - - - -SELECT * FROM `sPOa` LEFT JOIN `sPOb` USING (`bP`); -bP bP - - NULL - NULL -SELECT * FROM `sPOa` LEFT JOIN `sPOb` ON (`sPOa`.`bP` = `sPOb`.`bP`); -bP bP - - NULL - NULL -SELECT * FROM `sPOb` RIGHT JOIN `sPOa` USING (`bP`); -bP bP - -NULL -NULL -SELECT * FROM `sPOb` RIGHT JOIN `sPOa` ON (`sPOa`.`bP` = `sPOb`.`bP`); -bP bP - -NULL -NULL -SELECT * FROM `sPPa` JOIN `sPPb`; -bP bP - - - -SELECT * FROM `sPPa` INNER JOIN `sPPb`; -bP bP - - - -SELECT * FROM `sPPa` JOIN `sPPb` USING (`bP`); -bP bP - -SELECT * FROM `sPPa` INNER JOIN `sPPb` USING (`bP`); -bP bP - -SELECT * FROM `sPPa` CROSS JOIN `sPPb`; -bP bP - - - -SELECT * FROM `sPPa` LEFT JOIN `sPPb` USING (`bP`); -bP bP - - NULL - NULL -SELECT * FROM `sPPa` LEFT JOIN `sPPb` ON (`sPPa`.`bP` = `sPPb`.`bP`); -bP bP - - NULL - NULL -SELECT * FROM `sPPb` RIGHT JOIN `sPPa` USING (`bP`); -bP bP - -NULL -NULL -SELECT * FROM `sPPb` RIGHT JOIN `sPPa` ON (`sPPa`.`bP` = `sPPb`.`bP`); -bP bP - -NULL -NULL -SELECT * FROM `sPQa` JOIN `sPQb`; -bP bP -\ \ -\ \ -\ \ -SELECT * FROM `sPQa` INNER JOIN `sPQb`; -bP bP -\ \ -\ \ -\ \ -SELECT * FROM `sPQa` JOIN `sPQb` USING (`bP`); -bP bP -\ \ -SELECT * FROM `sPQa` INNER JOIN `sPQb` USING (`bP`); -bP bP -\ \ -SELECT * FROM `sPQa` CROSS JOIN `sPQb`; -bP bP -\ \ -\ \ -\ \ -SELECT * FROM `sPQa` LEFT JOIN `sPQb` USING (`bP`); -bP bP -\ \ -\ NULL -\ NULL -SELECT * FROM `sPQa` LEFT JOIN `sPQb` ON (`sPQa`.`bP` = `sPQb`.`bP`); -bP bP -\ \ -\ NULL -\ NULL -SELECT * FROM `sPQb` RIGHT JOIN `sPQa` USING (`bP`); -bP bP -\ \ -NULL \ -NULL \ -SELECT * FROM `sPQb` RIGHT JOIN `sPQa` ON (`sPQa`.`bP` = `sPQb`.`bP`); -bP bP -\ \ -NULL \ -NULL \ DROP TABLE `sPa`; DROP TABLE `sPb`; DROP TABLE `sQa`; @@ -570,9 +441,3 @@ DROP TABLE `sWa`; DROP TABLE `sWb`; DROP TABLE `sXa`; DROP TABLE `sXb`; -DROP TABLE `sPOa`; -DROP TABLE `sPOb`; -DROP TABLE `sPPa`; -DROP TABLE `sPPb`; -DROP TABLE `sPQa`; -DROP TABLE `sPQb`; |