svn commit - mysqldoc@docsrva: r8660 - in trunk: . mysqltest

[paul]

Author: paul
Date: 2007-11-12 16:32:59 +0100 (Mon, 12 Nov 2007)
New Revision: 8660

Log:
 r26907@frost:  paul | 2007-11-12 09:32:39 -0600
 Update test cases in mysqltest manual to follow current lettercase
 guidelines.


Modified:
   trunk/mysqltest/command-reference.xml

Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:32620
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:26906
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:21581
   + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:32620
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:26907
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:21581


Modified: trunk/mysqltest/command-reference.xml
===================================================================
--- trunk/mysqltest/command-reference.xml	2007-11-12 15:32:50 UTC (rev 8659)
+++ trunk/mysqltest/command-reference.xml	2007-11-12 15:32:59 UTC (rev 8660)
Changed blocks: 17, Lines Added: 24, Lines Deleted: 24; 3426 bytes

@@ -182,9 +182,9 @@
     </para>
 
 <programlisting>
-echo issue a select statement
-select 1;
-echo done issuing the select statement
+echo issue a SELECT statement
+SELECT 1;
+echo done issuing the SELECT statement
 </programlisting>
 
     <para>

@@ -194,8 +194,8 @@
     </para>
 
 <programlisting>
-select 'hello'; # select a string value
-select 'hello'; -- echo that was a select statement
+SELECT 'hello'; # select a string value
+SELECT 'hello'; -- echo that was a SELECT statement
 </programlisting>
 
     <para>

@@ -1111,7 +1111,7 @@
 
 <programlisting>
 --error S42S02
-drop table t;
+DROP TABLE t;
 </programlisting>
 
             <para>

@@ -1140,7 +1140,7 @@
 
 <programlisting>
 --error S41S01,S42S02
-drop table t;
+DROP TABLE t;
 </programlisting>
 
             <para>

@@ -1211,9 +1211,9 @@
         </para>
 
 <programlisting>
-eval use $DB;
-eval change master to master_port=$SLAVE_MYPORT;
-eval prepare stmt1 from "$my_stmt";
+eval USE $DB;
+eval CHANGE MASTER TO MASTER_PORT=$SLAVE_MYPORT;
+eval PREPARE STMT1 FROM "$my_stmt";
 </programlisting>
       </listitem>
 

@@ -1399,7 +1399,7 @@
         </para>
 
 <programlisting>
-let $q = `select version()`;
+let $q = `SELECT VERSION()`;
 </programlisting>
 
         <remark role="todo">

@@ -1417,7 +1417,7 @@
         </para>
 
 <programlisting>
-CREATE TABLE t1(a int, b varchar(255), c datetime);
+CREATE TABLE t1(a INT, b VARCHAR(255), c DATETIME);
 SHOW COLUMNS FROM t1;
 let $value= query_get_value(SHOW COLUMNS FROM t1, Type, 1);
 echo $value;

@@ -1428,7 +1428,7 @@
         </para>
 
 <programlisting>
-CREATE TABLE t1(a int, b varchar(255), c datetime);
+CREATE TABLE t1(a INT, b VARCHAR(255), c DATETIME);
 SHOW COLUMNS FROM t1;
 +Field  Type  Null  Key Default Extra
 +a  int(11) YES   NULL  

@@ -1517,7 +1517,7 @@
         </para>
 
 <programlisting>
-query_horizontal select pi();
+query_horizontal SELECT PI();
 </programlisting>
       </listitem>
 

@@ -1532,7 +1532,7 @@
         </para>
 
 <programlisting>
-query_vertical select pi();
+query_vertical SELECT PI();
 </programlisting>
       </listitem>
 

@@ -1831,7 +1831,7 @@
         </para>
 
 <programlisting>
-send select 1;
+send SELECT 1;
 </programlisting>
 
         <para>

@@ -1840,7 +1840,7 @@
 
 <programlisting>
 send;
-select 1;
+SELECT 1;
 </programlisting>
       </listitem>
 

@@ -1929,13 +1929,13 @@
 
 <programlisting>
 sorted_result;
-SELECT 2 as "my_col" UNION SELECT 1;
-let $my_stmt=SELECT 2 as "my_col" UNION SELECT 1;
+SELECT 2 AS "my_col" UNION SELECT 1;
+let $my_stmt=SELECT 2 AS "my_col" UNION SELECT 1;
 --sorted_result
 eval $my_stmt;
 --sorted_result
 --replace_column 1 #
-SELECT '1' as "my_col1",2 as "my_col2"
+SELECT '1' AS "my_col1",2 AS "my_col2"
 UNION
 SELECT '2',1;
 </programlisting>

@@ -2070,7 +2070,7 @@
         </para>
 
 <programlisting>
-select 'I am a query';
+SELECT 'I am a query';
 </programlisting>
 
         <para>

@@ -2481,7 +2481,7 @@
         </para>
 
 <programlisting>
-select * from t;
+SELECT * FROM t;
 </programlisting>
       </listitem>
 

@@ -2493,7 +2493,7 @@
 
 <programlisting>
 --error 1
-select * from no_such_table;
+SELECT * FROM no_such_table;
 </programlisting>
       </listitem>
 

@@ -2504,7 +2504,7 @@
 
 <programlisting>
 --error 1
-select 'a string';
+SELECT 'a string';
 </programlisting>
       </listitem>