[Firebird-checkins] SF.net SVN: firebird: [448] qa/trunk/testsuite

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Revision: 448
          http://firebird.svn.sourceforge.net/firebird/?rev=448&view=rev
Author:   makowski
Date:     2007-12-12 13:34:00 -0800 (Wed, 12 Dec 2007)

Log Message:
-----------
Clean up for Firebird 2.1

Modified Paths:
--------------
    qa/trunk/testsuite/bugs.qms/core_1076.qmt
    qa/trunk/testsuite/bugs.qms/core_1112.qmt
    qa/trunk/testsuite/bugs.qms/core_847.qmt
    qa/trunk/testsuite/bugs.qms/core_878.qmt
    qa/trunk/testsuite/functional.qms/arno.qms/indexes.qms/starting_with_01.qmt
    qa/trunk/testsuite/functional.qms/arno.qms/indexes.qms/starting_with_02.qmt
    qa/trunk/testsuite/functional.qms/arno.qms/indexes.qms/timestamps_01.qmt
    qa/trunk/testsuite/functional.qms/arno.qms/indexes.qms/upper_lower_bounds_02.qmt
    qa/trunk/testsuite/functional.qms/arno.qms/optimizer.qms/opt_left_join_08.qmt
    qa/trunk/testsuite/functional.qms/arno.qms/optimizer.qms/opt_sort_by_index_12.qmt
    qa/trunk/testsuite/functional.qms/basic.qms/db.qms/db_60.qmt
    qa/trunk/testsuite/functional.qms/basic.qms/db.qms/db_61.qmt
    qa/trunk/testsuite/functional.qms/basic.qms/db.qms/db_62.qmt
    qa/trunk/testsuite/functional.qms/basic.qms/db.qms/db_63.qmt
    qa/trunk/testsuite/functional.qms/basic.qms/db.qms/db_64.qmt
    qa/trunk/testsuite/functional.qms/basic.qms/db.qms/db_66.qmt
    qa/trunk/testsuite/functional.qms/basic.qms/db.qms/db_68.qmt
    qa/trunk/testsuite/functional.qms/basic.qms/isql.qms/isql_12.qmt
    qa/trunk/testsuite/functional.qms/basic.qms/isql.qms/isql_13.qmt
    qa/trunk/testsuite/functional.qms/database.qms/create.qms/create_database_38.qmt
    qa/trunk/testsuite/functional.qms/database.qms/create.qms/create_database_40.qmt
    qa/trunk/testsuite/functional.qms/database.qms/create.qms/create_database_41.qmt
    qa/trunk/testsuite/functional.qms/database.qms/create.qms/create_database_42.qmt
    qa/trunk/testsuite/functional.qms/database.qms/create.qms/create_database_43.qmt
    qa/trunk/testsuite/functional.qms/database.qms/create.qms/create_database_44.qmt
    qa/trunk/testsuite/functional.qms/domain.qms/alter.qms/alter_domain_10.qmt
    qa/trunk/testsuite/functional.qms/domain.qms/alter.qms/alter_domain_11.qmt
    qa/trunk/testsuite/functional.qms/shadow.qms/create.qms/create_shadow_09.qmt
    qa/trunk/testsuite/functional.qms/shadow.qms/create.qms/create_shadow_10.qmt

Added Paths:
-----------
    qa/trunk/testsuite/bugs.qms/core_1076-20.qmt
    qa/trunk/testsuite/bugs.qms/core_959-21.qmt
    qa/trunk/testsuite/functional.qms/database.qms/create.qms/create_database_45.qmt
    qa/trunk/testsuite/functional.qms/database.qms/create.qms/create_database_46.qmt
    qa/trunk/testsuite/functional.qms/database.qms/create.qms/create_database_47.qmt
    qa/trunk/testsuite/functional.qms/database.qms/create.qms/create_database_48.qmt
    qa/trunk/testsuite/functional.qms/database.qms/create.qms/create_database_49.qmt
    qa/trunk/testsuite/functional.qms/database.qms/create.qms/create_database_50.qmt
    qa/trunk/testsuite/functional.qms/database.qms/create.qms/create_database_51.qmt
    qa/trunk/testsuite/functional.qms/shadow.qms/create.qms/create_shadow_11.qmt
    qa/trunk/testsuite/functional.qms/shadow.qms/create.qms/create_shadow_12.qmt
    qa/trunk/testsuite/functional.qms/table.qms/create.qms/create_table_12.qmt
    qa/trunk/testsuite/functional.qms/table.qms/create.qms/create_table_13.qmt

Removed Paths:
-------------
    qa/trunk/testsuite/bugs.qms/core_932.qmt

Added: qa/trunk/testsuite/bugs.qms/core_1076-20.qmt
===================================================================

--- qa/trunk/testsuite/bugs.qms/core_1076-20.qmt	                        (rev 0)
+++ qa/trunk/testsuite/bugs.qms/core_1076-20.qmt	2007-12-12 21:34:00 UTC (rev 448)
@@ -0,0 +1,16 @@
+<?xml version="1.0" ?>
+<!DOCTYPE extension
+  PUBLIC '-//QM/2.3/Extension//EN'
+  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'>
+<extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>None</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>GSEC&gt; GSEC&gt;      user name                      uid   gid     full name
+------------------------------------------------------------------------------------------
+SYSDBA                              0     0      Sql Server Administrator
+TEST1076                            0     0      123456789012345678901234567890az 123456789012345678901234567890az 123456789012345678901234567890az
+GSEC&gt; GSEC&gt; </text></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>makowski</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>2.0</text></argument><argument name="description"><text>FB2.0 correctly saves First, Middle &amp; Last Name fields in the security database to the available length of 32 characters.
+FB1.5.3 and still now FB1.5.4RC1 truncates these field lengths to 17 chars.
+</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>None (manual)</enumeral></argument><argument name="bug_id"><text>CORE-1076</text></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>database_name</text></argument><argument name="isql_script"><text/></argument><argument name="source_code"><text>commands = &quot;&quot;&quot;add TEST1076 -pw PWD -fname 123456789012345678901234567890az -mname 123456789012345678901234567890az -lname 123456789012345678901234567890az
+display
+delete TEST1076
+quit
+&quot;&quot;&quot;
+runProgram('gsec',['-user',user_name,'-pas',user_password],commands)</text></argument><argument name="test_id"><text>core_1076</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>Python: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="title"><text>gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition</text></argument><argument name="drop_db"><enumeral>false</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file

Modified: qa/trunk/testsuite/bugs.qms/core_1076.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_1076.qmt	2007-12-12 09:55:59 UTC (rev 447)
+++ qa/trunk/testsuite/bugs.qms/core_1076.qmt	2007-12-12 21:34:00 UTC (rev 448)
@@ -2,13 +2,15 @@
 <!DOCTYPE extension
   PUBLIC '-//QM/2.3/Extension//EN'
   'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'>
-<extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>None</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text/></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>makowski</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text>     user name                      uid   gid     full name
+<extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>None</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text/></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>makowski</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text>GSEC&gt; GSEC&gt;      user name                      uid   gid     full name
 ------------------------------------------------------------------------------------------
 SYSDBA                              0     0        
-TEST                                0     0      123456789012345678901234567890az 123456789012345678901234567890az 123456789012345678901234567890az
-</text></argument><argument name="target_version"><text>1.5.5</text></argument><argument name="description"><text>FB2.0 correctly saves First, Middle &amp; Last Name fields in the security database to the available length of 32 characters.
+TEST1076                            0     0      123456789012345678901234567890az 123456789012345678901234567890az 123456789012345678901234567890az
+GSEC&gt; GSEC&gt; </text></argument><argument name="target_version"><text>1.5.5</text></argument><argument name="description"><text>FB2.0 correctly saves First, Middle &amp; Last Name fields in the security database to the available length of 32 characters.
 FB1.5.3 and still now FB1.5.4RC1 truncates these field lengths to 17 chars.
-</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>None (manual)</enumeral></argument><argument name="bug_id"><text>CORE-1076</text></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>database_name</text></argument><argument name="isql_script"><text/></argument><argument name="source_code"><text>runProgram('gsec',['-user',user_name,'-password',user_password,'-add','TEST','-pw','test','-fname','123456789012345678901234567890az','-mname','123456789012345678901234567890az','-lname','123456789012345678901234567890az'])
-runProgram('gsec',['-user',user_name,'-password',user_password,'-display'])
-runProgram('gsec',['-user',user_name,'-password',user_password,'-delete','TEST'])
-</text></argument><argument name="test_id"><text>core_1076</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>Python: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="title"><text>gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition</text></argument><argument name="drop_db"><enumeral>false</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file
+</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>None (manual)</enumeral></argument><argument name="bug_id"><text>CORE-1076</text></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>database_name</text></argument><argument name="isql_script"><text/></argument><argument name="source_code"><text>commands = &quot;&quot;&quot;add TEST1076 -pw PWD -fname 123456789012345678901234567890az -mname 123456789012345678901234567890az -lname 123456789012345678901234567890az
+display
+delete TEST1076
+quit
+&quot;&quot;&quot;
+runProgram('gsec',['-user',user_name,'-pas',user_password],commands)</text></argument><argument name="test_id"><text>core_1076</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>Python: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="title"><text>gsec truncate First.Middle.Last Name fields to 17 chars instead of 32 chars available in field definition</text></argument><argument name="drop_db"><enumeral>false</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file

Modified: qa/trunk/testsuite/bugs.qms/core_1112.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_1112.qmt	2007-12-12 09:55:59 UTC (rev 447)
+++ qa/trunk/testsuite/bugs.qms/core_1112.qmt	2007-12-12 21:34:00 UTC (rev 448)
@@ -1,4 +1,9 @@
-<?xml version="1.0" ?><!DOCTYPE extension  PUBLIC '-//QM/2.3/Extension//EN'  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'><extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text/></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>pcisar</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>2.1</text></argument><argument name="description"><text>This test may crash the server</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>None (manual)</enumeral></argument><argument name="bug_id"><text>CORE-1112</text></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>bug.fdb</text></argument><argument name="isql_script"><text/></argument><argument name="source_code"><text>c = db_conn.cursor()
+<?xml version="1.0" ?>
+<!DOCTYPE extension
+  PUBLIC '-//QM/2.3/Extension//EN'
+  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'>
+<extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>[('a',)]
+</text></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>pcisar</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>2.1</text></argument><argument name="description"><text>This test may crash the server</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>None (manual)</enumeral></argument><argument name="bug_id"><text>CORE-1112</text></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>core1112.fdb</text></argument><argument name="isql_script"><text/></argument><argument name="source_code"><text>c = db_conn.cursor()
 longstr = 'abc' * 10930
 try:
   c.execute(&quot;select * from rdb$database where '%s' = 'a'&quot; % longstr)
@@ -9,4 +14,5 @@
   c.execute(&quot;select * from rdb$database where '%s' containing 'a'&quot; % longstr)
 except:
   pass
-</text></argument><argument name="test_id"><text>core_1112</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>Python: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="title"><text>Crash when dealing with a string literal longer than 32K</text></argument><argument name="drop_db"><enumeral>true</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file
+c.execute(&quot;select 'a' from rdb$database&quot;)
+print c.fetchall()</text></argument><argument name="test_id"><text>core_1112</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>Python: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="title"><text>Crash when dealing with a string literal longer than 32K</text></argument><argument name="drop_db"><enumeral>true</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file

Modified: qa/trunk/testsuite/bugs.qms/core_847.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_847.qmt	2007-12-12 09:55:59 UTC (rev 447)
+++ qa/trunk/testsuite/bugs.qms/core_847.qmt	2007-12-12 21:34:00 UTC (rev 448)
@@ -1,10 +1,14 @@
-<?xml version="1.0" ?><!DOCTYPE extension  PUBLIC '-//QM/2.3/Extension//EN'  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'><extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>F1         F2         CF                      
+<?xml version="1.0" ?>
+<!DOCTYPE extension
+  PUBLIC '-//QM/2.3/Extension//EN'
+  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'>
+<extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>F1         F2         CF                      
 ========== ========== ======================= 
 0123456789 abcdefghij 0123456789 - abcdefghij 
 
 RDB$FIELD_NAME                                                                                RDB$QUERY_NAME                                                                                RDB$VALIDATION_BLR RDB$VALIDATION_SOURCE  RDB$COMPUTED_BLR RDB$COMPUTED_SOURCE RDB$DEFAULT_VALUE RDB$DEFAULT_SOURCE RDB$FIELD_LENGTH RDB$FIELD_SCALE RDB$FIELD_TYPE RDB$FIELD_SUB_TYPE RDB$MISSING_VALUE RDB$MISSING_SOURCE   RDB$DESCRIPTION RDB$SYSTEM_FLAG  RDB$QUERY_HEADER RDB$SEGMENT_LENGTH RDB$EDIT_STRING                                                                                                               RDB$EXTERNAL_LENGTH RDB$EXTERNAL_SCALE RDB$EXTERNAL_TYPE RDB$DIMENSIONS RDB$NULL_FLAG RDB$CHARACTER_LENGTH RDB$COLLATION_ID RDB$CHARACTER_SET_ID RDB$FIELD_PRECISION 
 =============================================================================== =============================================================================== ================== ===================== ================= =================== ================= ================== ================ =============== ============== ================== ================= ================== ================= =============== ================= ================== =============================================================================== =================== ================== ================= ============== ============= ==================== ================ ==================== =================== 
-RDB$3                                                                                         &lt;null&gt;                                                                                                    &lt;null&gt;                &lt;null&gt;             2:1f1             2:1f0            &lt;null&gt;             &lt;null&gt;               23               0             37                  0            &lt;null&gt;             &lt;null&gt;            &lt;null&gt;               0            &lt;null&gt;             &lt;null&gt; &lt;null&gt;                                                                                                                                     &lt;null&gt;             &lt;null&gt;            &lt;null&gt;         &lt;null&gt;        &lt;null&gt;                    0           &lt;null&gt;                    0              &lt;null&gt; 
+RDB$3                                                                                         &lt;null&gt;                                                                                                    &lt;null&gt;                &lt;null&gt;             2:1f4             2:1f3            &lt;null&gt;             &lt;null&gt;               23               0             37                  0            &lt;null&gt;             &lt;null&gt;            &lt;null&gt;               0            &lt;null&gt;             &lt;null&gt; &lt;null&gt;                                                                                                                                     &lt;null&gt;             &lt;null&gt;            &lt;null&gt;         &lt;null&gt;        &lt;null&gt;                    0           &lt;null&gt;                    0              &lt;null&gt; 
 
 F1         F2         CF                             
 ========== ========== ============================== 

Modified: qa/trunk/testsuite/bugs.qms/core_878.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_878.qmt	2007-12-12 09:55:59 UTC (rev 447)
+++ qa/trunk/testsuite/bugs.qms/core_878.qmt	2007-12-12 21:34:00 UTC (rev 448)
@@ -1,7 +1,11 @@
-<?xml version="1.0" ?><!DOCTYPE extension  PUBLIC '-//QM/2.3/Extension//EN'  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'><extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>I1                              INTEGER Not Null 
+<?xml version="1.0" ?>
+<!DOCTYPE extension
+  PUBLIC '-//QM/2.3/Extension//EN'
+  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'>
+<extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>I1                              INTEGER Not Null 
 I2                              INTEGER Nullable 
 CONSTRAINT INTEG_2:
-  Primary key (I1)
+  Primary key (I1) uses explicit ascending index RDB$PRIMARY1
 I1                              INTEGER Not Null 
 I2                              INTEGER Nullable 
 CONSTRAINT PK2_PK:
@@ -9,7 +13,7 @@
 I1                              INTEGER Not Null 
 I2                              INTEGER Nullable 
 CONSTRAINT INTEG_5:
-  Primary key (I1)
+  Primary key (I1) uses explicit ascending index RDB$PRIMARY2
 I2                              INTEGER Nullable 
 I2                              INTEGER Nullable 
 I2                              INTEGER Nullable 

Deleted: qa/trunk/testsuite/bugs.qms/core_932.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_932.qmt	2007-12-12 09:55:59 UTC (rev 447)
+++ qa/trunk/testsuite/bugs.qms/core_932.qmt	2007-12-12 21:34:00 UTC (rev 448)
@@ -1,19 +0,0 @@
-<?xml version="1.0" ?>
-<!DOCTYPE extension
-  PUBLIC '-//QM/2.3/Extension//EN'
-  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'>
-<extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>Owner: SYSDBA                         
-PAGE_SIZE 4096 
-Number of DB pages allocated = 164
-Sweep interval = 20000
-Forced Writes are ON 
-Transaction - oldest = 1 
-Transaction - oldest active = 2 
-Transaction - oldest snapshot = 2 
-Transaction - Next = 5 
-ODS = 11.1
-Default Character set: NONE                           
-</text></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>makowski</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>2.1</text></argument><argument name="description"><text>Accept comment in Create database</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>Using SQL Commands</enumeral></argument><argument name="bug_id"><text>CORE-932</text></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>database_name</text></argument><argument name="isql_script"><text/></argument><argument name="source_code"><text>commit;
-create database /* waw */ '$(DATABASE_LOCATION)trucks';
-show database;
-drop database;</text></argument><argument name="test_id"><text>core-932</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>SQL: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="title"><text>Comment in create database</text></argument><argument name="drop_db"><enumeral>true</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file

Added: qa/trunk/testsuite/bugs.qms/core_959-21.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_959-21.qmt	                        (rev 0)
+++ qa/trunk/testsuite/bugs.qms/core_959-21.qmt	2007-12-12 21:34:00 UTC (rev 448)
@@ -0,0 +1,36 @@
+<?xml version="1.0" ?>
+<!DOCTYPE extension
+  PUBLIC '-//QM/2.3/Extension//EN'
+  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'>
+<extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>
+Database &quot;c:\db\qa\bug.fdb&quot;
+Database header page information:
+	Flags			0
+	Checksum		12345
+	Generation		6
+	Page size		4096
+	ODS version		11.0
+	Oldest transaction	1
+	Oldest active		0
+	Oldest snapshot		0
+	Next transaction	1
+	Bumped transaction	1
+	Sequence number		0
+	Next attachment ID	0
+	Implementation ID	16
+	Shadow count		0
+	Page buffers		0
+	Next header page	0
+	Database dialect	3
+	Creation date		Jul 5, 2007 16:54:18
+	Attributes		force write
+
+    Variable header data:
+	*END*
+
+
+Database file sequence:
+File c:\db\qa\bug.fdb is the only file
+
+Analyzing database pages ...
+</text></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>pcisar</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set><tuple><text>^Database &quot;.*</text><text/></tuple><tuple><text>Page size.*</text><text/></tuple><tuple><text>ODS version.*</text><text/></tuple><tuple><text>Oldest.*</text><text/></tuple><tuple><text>Next.*</text><text/></tuple><tuple><text>Bumped.*</text><text/></tuple><tuple><text>Creation date.*</text><text/></tuple><tuple><text>Attributes.*</text><text/></tuple><tuple><text>File .*</text><text/></tuple><tuple><text>Implementation.*</text><text/></tuple></set></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>2.1</text></argument><argument name="description"><text/></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>None (manual)</enumeral></argument><argument name="bug_id"><text>CORE-959</text></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>bug.fdb</text></argument><argument name="isql_script"><text/></argument><argument name="source_code"><text>runProgram('gstat',['-a','-user',user_name,'-pa',user_password,dsn])</text></argument><argument name="test_id"><text>core_959</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>Python: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="title"><text>GSTAT does not work using the localhost connection string</text></argument><argument name="drop_db"><enumeral>true</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file

Modified: qa/trunk/testsuite/functional.qms/arno.qms/indexes.qms/starting_with_01.qmt
===================================================================
--- qa/trunk/testsuite/functional.qms/arno.qms/indexes.qms/starting_with_01.qmt	2007-12-12 09:55:59 UTC (rev 447)
+++ qa/trunk/testsuite/functional.qms/arno.qms/indexes.qms/starting_with_01.qmt	2007-12-12 21:34:00 UTC (rev 448)
@@ -1,60 +1,60 @@
-<?xml version="1.0" ?>
-<!DOCTYPE extension
-  PUBLIC '-//QM/2.2/Extension//EN'
-  'http://www.codesourcery.com/qm/dtds/2.2/-//qm/2.2/extension//en.dtd'>
-<extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>O_FIELD                               O_COUNT 
-================================ ============ 
-
-F1 - INDEXED ASC                            3 
-F2 - INDEXED DESC                           3 
-F3 - NOT INDEXED                            3 </text></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="title"><text>STARTING WITH charset NONE</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>1.5</text></argument><argument name="description"><text>STARTING WITH - Select from table with 2 entries
-
-Dependencies:
-CREATE DATABASE
-CREATE TABLE
-Basic SELECT</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>Using SQL Commands</enumeral></argument><argument name="bug_id"><text/></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>starting_with.fdb</text></argument><argument name="isql_script"><text>CREATE TABLE A_TEST (F1 VARCHAR(5), F2 VARCHAR(5), F3 VARCHAR(5));
-CREATE INDEX IDX_A_TEST_F1 ON A_TEST(F1);
-CREATE DESC INDEX IDX_A_TEST_F2 ON A_TEST(F2);
-COMMIT;
-INSERT INTO A_TEST (F1, F2, F3) VALUES('', '', '');
-INSERT INTO A_TEST (F1, F2, F3) VALUES(NULL, NULL, NULL);
-INSERT INTO A_TEST (F1, F2, F3) VALUES('a', 'a', 'a');
-INSERT INTO A_TEST (F1, F2, F3) VALUES('b', 'b', 'b');
-COMMIT;
-
-SET TERM ^;
-
-CREATE PROCEDURE PR_A_TEST_STARTING_WITH(I_START_VALUE VARCHAR(5))
-RETURNS(O_FIELD VARCHAR(32), O_COUNT integer)
-AS
-BEGIN
-  /* First retrieve results for indexed ASC field */
-  O_FIELD = 'F1 - INDEXED ASC';
-  SELECT COUNT(*) FROM A_TEST 
-  WHERE F1 STARTING WITH :I_START_VALUE
-  INTO :O_COUNT;
-
-  SUSPEND;
-
-  /* Second retrieve results for indexed DESC field */
-  O_FIELD = 'F2 - INDEXED DESC';
-  SELECT COUNT(*) FROM A_TEST 
-  WHERE F2 STARTING WITH :I_START_VALUE
-  INTO :O_COUNT;
-
-  SUSPEND;
-
-  /* Thirth for unindexed field */
-  O_FIELD = 'F3 - NOT INDEXED';
-  SELECT COUNT(*) FROM A_TEST 
-  WHERE F3 STARTING WITH :I_START_VALUE
-  INTO :O_COUNT;
-
-  SUSPEND;
-END^
-
-SET TERM ;^
-
-</text></argument><argument name="source_code"><text>SET PLAN OFF;
-SELECT O_FIELD, O_COUNT FROM PR_A_TEST_STARTING_WITH('');
-</text></argument><argument name="test_id"><text>starting_with_01</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>SQL: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="author"><text>arno.brinkman</text></argument><argument name="drop_db"><enumeral>true</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file
+<?xml version="1.0" ?>
+<!DOCTYPE extension
+  PUBLIC '-//QM/2.3/Extension//EN'
+  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'>
+<extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>O_FIELD                               O_COUNT 
+================================ ============ 
+
+F1 - INDEXED ASC                            3 
+F2 - INDEXED DESC                           3 
+F3 - NOT INDEXED                            3 </text></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>arno.brinkman</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>2.0</text></argument><argument name="description"><text>STARTING WITH - Select from table with 2 entries
+
+Dependencies:
+CREATE DATABASE
+CREATE TABLE
+Basic SELECT</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>Using SQL Commands</enumeral></argument><argument name="bug_id"><text/></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>starting_with.fdb</text></argument><argument name="isql_script"><text>CREATE TABLE A_TEST (F1 VARCHAR(5), F2 VARCHAR(5), F3 VARCHAR(5));
+CREATE INDEX IDX_A_TEST_F1 ON A_TEST(F1);
+CREATE DESC INDEX IDX_A_TEST_F2 ON A_TEST(F2);
+COMMIT;
+INSERT INTO A_TEST (F1, F2, F3) VALUES('', '', '');
+INSERT INTO A_TEST (F1, F2, F3) VALUES(NULL, NULL, NULL);
+INSERT INTO A_TEST (F1, F2, F3) VALUES('a', 'a', 'a');
+INSERT INTO A_TEST (F1, F2, F3) VALUES('b', 'b', 'b');
+COMMIT;
+
+SET TERM ^;
+
+CREATE PROCEDURE PR_A_TEST_STARTING_WITH(I_START_VALUE VARCHAR(5))
+RETURNS(O_FIELD VARCHAR(32), O_COUNT integer)
+AS
+BEGIN
+  /* First retrieve results for indexed ASC field */
+  O_FIELD = 'F1 - INDEXED ASC';
+  SELECT COUNT(*) FROM A_TEST 
+  WHERE F1 STARTING WITH :I_START_VALUE
+  INTO :O_COUNT;
+
+  SUSPEND;
+
+  /* Second retrieve results for indexed DESC field */
+  O_FIELD = 'F2 - INDEXED DESC';
+  SELECT COUNT(*) FROM A_TEST 
+  WHERE F2 STARTING WITH :I_START_VALUE
+  INTO :O_COUNT;
+
+  SUSPEND;
+
+  /* Thirth for unindexed field */
+  O_FIELD = 'F3 - NOT INDEXED';
+  SELECT COUNT(*) FROM A_TEST 
+  WHERE F3 STARTING WITH :I_START_VALUE
+  INTO :O_COUNT;
+
+  SUSPEND;
+END^
+
+SET TERM ;^
+
+</text></argument><argument name="source_code"><text>SET PLAN OFF;
+SELECT O_FIELD, O_COUNT FROM PR_A_TEST_STARTING_WITH('');
+</text></argument><argument name="test_id"><text>starting_with_01</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>SQL: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="title"><text>STARTING WITH charset NONE</text></argument><argument name="drop_db"><enumeral>true</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file

Modified: qa/trunk/testsuite/functional.qms/arno.qms/indexes.qms/starting_with_02.qmt
===================================================================
--- qa/trunk/testsuite/functional.qms/arno.qms/indexes.qms/starting_with_02.qmt	2007-12-12 09:55:59 UTC (rev 447)
+++ qa/trunk/testsuite/functional.qms/arno.qms/indexes.qms/starting_with_02.qmt	2007-12-12 21:34:00 UTC (rev 448)
@@ -1,60 +1,60 @@
-<?xml version="1.0" ?>
-<!DOCTYPE extension
-  PUBLIC '-//QM/2.2/Extension//EN'
-  'http://www.codesourcery.com/qm/dtds/2.2/-//qm/2.2/extension//en.dtd'>
-<extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>O_FIELD                               O_COUNT 
-================================ ============ 
-
-F1 - INDEXED ASC                            3 
-F2 - INDEXED DESC                           3 
-F3 - NOT INDEXED                            3 </text></argument><argument name="character_set"><enumeral>ISO8859_1</enumeral></argument><argument name="title"><text>STARTING WITH charset ISO8859_1</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>1.5</text></argument><argument name="description"><text>STARTING WITH - Select from table with 2 entries
-
-Dependencies:
-CREATE DATABASE
-CREATE TABLE
-Basic SELECT</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>Using SQL Commands</enumeral></argument><argument name="bug_id"><text/></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>starting_with.fdb</text></argument><argument name="isql_script"><text>CREATE TABLE A_TEST (F1 VARCHAR(5), F2 VARCHAR(5), F3 VARCHAR(5));
-CREATE INDEX IDX_A_TEST_F1 ON A_TEST(F1);
-CREATE DESC INDEX IDX_A_TEST_F2 ON A_TEST(F2);
-COMMIT;
-INSERT INTO A_TEST (F1, F2, F3) VALUES('', '', '');
-INSERT INTO A_TEST (F1, F2, F3) VALUES(NULL, NULL, NULL);
-INSERT INTO A_TEST (F1, F2, F3) VALUES('a', 'a', 'a');
-INSERT INTO A_TEST (F1, F2, F3) VALUES('b', 'b', 'b');
-COMMIT;
-
-SET TERM ^;
-
-CREATE PROCEDURE PR_A_TEST_STARTING_WITH(I_START_VALUE VARCHAR(5))
-RETURNS(O_FIELD VARCHAR(32), O_COUNT integer)
-AS
-BEGIN
-  /* First retrieve results for indexed ASC field */
-  O_FIELD = 'F1 - INDEXED ASC';
-  SELECT COUNT(*) FROM A_TEST 
-  WHERE F1 STARTING WITH :I_START_VALUE
-  INTO :O_COUNT;
-
-  SUSPEND;
-
-  /* Second retrieve results for indexed DESC field */
-  O_FIELD = 'F2 - INDEXED DESC';
-  SELECT COUNT(*) FROM A_TEST 
-  WHERE F2 STARTING WITH :I_START_VALUE
-  INTO :O_COUNT;
-
-  SUSPEND;
-
-  /* Thirth for unindexed field */
-  O_FIELD = 'F3 - NOT INDEXED';
-  SELECT COUNT(*) FROM A_TEST 
-  WHERE F3 STARTING WITH :I_START_VALUE
-  INTO :O_COUNT;
-
-  SUSPEND;
-END^
-
-SET TERM ;^
-
-</text></argument><argument name="source_code"><text>SET PLAN OFF;
-SELECT O_FIELD, O_COUNT FROM PR_A_TEST_STARTING_WITH('');
-</text></argument><argument name="test_id"><text>starting_with_02</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>SQL: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="author"><text>arno.brinkman</text></argument><argument name="drop_db"><enumeral>true</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file
+<?xml version="1.0" ?>
+<!DOCTYPE extension
+  PUBLIC '-//QM/2.3/Extension//EN'
+  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'>
+<extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>O_FIELD                               O_COUNT 
+================================ ============ 
+
+F1 - INDEXED ASC                            3 
+F2 - INDEXED DESC                           3 
+F3 - NOT INDEXED                            3 </text></argument><argument name="character_set"><enumeral>ISO8859_1</enumeral></argument><argument name="author"><text>arno.brinkman</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>2.0</text></argument><argument name="description"><text>STARTING WITH - Select from table with 2 entries
+
+Dependencies:
+CREATE DATABASE
+CREATE TABLE
+Basic SELECT</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>Using SQL Commands</enumeral></argument><argument name="bug_id"><text/></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>starting_with.fdb</text></argument><argument name="isql_script"><text>CREATE TABLE A_TEST (F1 VARCHAR(5), F2 VARCHAR(5), F3 VARCHAR(5));
+CREATE INDEX IDX_A_TEST_F1 ON A_TEST(F1);
+CREATE DESC INDEX IDX_A_TEST_F2 ON A_TEST(F2);
+COMMIT;
+INSERT INTO A_TEST (F1, F2, F3) VALUES('', '', '');
+INSERT INTO A_TEST (F1, F2, F3) VALUES(NULL, NULL, NULL);
+INSERT INTO A_TEST (F1, F2, F3) VALUES('a', 'a', 'a');
+INSERT INTO A_TEST (F1, F2, F3) VALUES('b', 'b', 'b');
+COMMIT;
+
+SET TERM ^;
+
+CREATE PROCEDURE PR_A_TEST_STARTING_WITH(I_START_VALUE VARCHAR(5))
+RETURNS(O_FIELD VARCHAR(32), O_COUNT integer)
+AS
+BEGIN
+  /* First retrieve results for indexed ASC field */
+  O_FIELD = 'F1 - INDEXED ASC';
+  SELECT COUNT(*) FROM A_TEST 
+  WHERE F1 STARTING WITH :I_START_VALUE
+  INTO :O_COUNT;
+
+  SUSPEND;
+
+  /* Second retrieve results for indexed DESC field */
+  O_FIELD = 'F2 - INDEXED DESC';
+  SELECT COUNT(*) FROM A_TEST 
+  WHERE F2 STARTING WITH :I_START_VALUE
+  INTO :O_COUNT;
+
+  SUSPEND;
+
+  /* Thirth for unindexed field */
+  O_FIELD = 'F3 - NOT INDEXED';
+  SELECT COUNT(*) FROM A_TEST 
+  WHERE F3 STARTING WITH :I_START_VALUE
+  INTO :O_COUNT;
+
+  SUSPEND;
+END^
+
+SET TERM ;^
+
+</text></argument><argument name="source_code"><text>SET PLAN OFF;
+SELECT O_FIELD, O_COUNT FROM PR_A_TEST_STARTING_WITH('');
+</text></argument><argument name="test_id"><text>starting_with_02</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>SQL: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="title"><text>STARTING WITH charset ISO8859_1</text></argument><argument name="drop_db"><enumeral>true</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file

Modified: qa/trunk/testsuite/functional.qms/arno.qms/indexes.qms/timestamps_01.qmt
===================================================================
--- qa/trunk/testsuite/functional.qms/arno.qms/indexes.qms/timestamps_01.qmt	2007-12-12 09:55:59 UTC (rev 447)
+++ qa/trunk/testsuite/functional.qms/arno.qms/indexes.qms/timestamps_01.qmt	2007-12-12 21:34:00 UTC (rev 448)
@@ -12,7 +12,7 @@
 1858-11-17 00:00:00.0000  1858-11-17 00:00:00.0000  
 1858-11-18 16:00:00.0000  1858-11-18 17:00:00.0000  
 2004-04-08 02:00:00.0000  2004-04-08 02:09:00.0000  
-</text></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>arno.brinkman</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>1.5</text></argument><argument name="description"><text>Datetime values below the julian date (firebird base date '1858-11-17') should be stored in correct order.</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>Using SQL Commands</enumeral></argument><argument name="bug_id"><text/></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>timestamps.fdb</text></argument><argument name="isql_script"><text>CREATE TABLE Era (
+</text></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>arno.brinkman</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>2.0</text></argument><argument name="description"><text>Datetime values below the julian date (firebird base date '1858-11-17') should be stored in correct order.</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>Using SQL Commands</enumeral></argument><argument name="bug_id"><text/></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>timestamps.fdb</text></argument><argument name="isql_script"><text>CREATE TABLE Era (
   BeginDateTime TIMESTAMP NOT NULL, 
   EndDateTime TIMESTAMP NOT NULL
 );

Modified: qa/trunk/testsuite/functional.qms/arno.qms/indexes.qms/upper_lower_bounds_02.qmt
===================================================================
--- qa/trunk/testsuite/functional.qms/arno.qms/indexes.qms/upper_lower_bounds_02.qmt	2007-12-12 09:55:59 UTC (rev 447)
+++ qa/trunk/testsuite/functional.qms/arno.qms/indexes.qms/upper_lower_bounds_02.qmt	2007-12-12 21:34:00 UTC (rev 448)
@@ -1,9 +1,13 @@
-<?xml version="1.0" ?><!DOCTYPE extension  PUBLIC '-//QM/2.3b/Extension//EN'  'http://www.codesourcery.com/qm/dtds/2.3b/-//qm/2.3b/extension//en.dtd'><extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>COUNT      
+<?xml version="1.0" ?>
+<!DOCTYPE extension
+  PUBLIC '-//QM/2.3/Extension//EN'
+  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'>
+<extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>COUNT      
 -----------
 201        
 sequential :  {}
 indexed    :  {128: 201}
-</text></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>arno.brinkman</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>1.5</text></argument><argument name="description"><text>&quot;Less or equal than&quot; should be prefered above &quot;less than&quot; and &quot;greater or equal than&quot; above &quot;greater than&quot;.
+</text></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>arno.brinkman</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>2.0</text></argument><argument name="description"><text>&quot;Less or equal than&quot; should be prefered above &quot;less than&quot; and &quot;greater or equal than&quot; above &quot;greater than&quot;.
 </text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>Using SQL Commands</enumeral></argument><argument name="bug_id"><text/></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>indexed.fdb</text></argument><argument name="isql_script"><text>CREATE TABLE Table_1000 (
   ID INTEGER NOT NULL
 );

Modified: qa/trunk/testsuite/functional.qms/arno.qms/optimizer.qms/opt_left_join_08.qmt
===================================================================
--- qa/trunk/testsuite/functional.qms/arno.qms/optimizer.qms/opt_left_join_08.qmt	2007-12-12 09:55:59 UTC (rev 447)
+++ qa/trunk/testsuite/functional.qms/arno.qms/optimizer.qms/opt_left_join_08.qmt	2007-12-12 21:34:00 UTC (rev 448)
@@ -50,4 +50,4 @@
     (c.ColorID &gt; 0)
 WHERE
   f.ColorID &gt;= 0;
-</text></argument><argument name="test_id"><text>opt_left_join_08</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>SQL: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="title"><text>LEFT OUTER JOIN with full match, but limited in ON and WHERE clause</text></argument><argument name="drop_db"><enumeral>true</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file
+</text></argument><argument name="test_id"><text>opt_left_join_08</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>SQL: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="title"><text>LEFT OUTER JOIN with full match, but limited in ON and WHERE clause</text></argument><argument name="drop_db"><enumeral>true</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>

Modified: qa/trunk/testsuite/functional.qms/arno.qms/optimizer.qms/opt_sort_by_index_12.qmt
===================================================================
--- qa/trunk/testsuite/functional.qms/arno.qms/optimizer.qms/opt_sort_by_index_12.qmt	2007-12-12 09:55:59 UTC (rev 447)
+++ qa/trunk/testsuite/functional.qms/arno.qms/optimizer.qms/opt_sort_by_index_12.qmt	2007-12-12 21:34:00 UTC (rev 448)
@@ -1,76 +1,77 @@
-<?xml version="1.0" ?>
-<!DOCTYPE extension
-  PUBLIC '-//QM/2.2/Extension//EN'
-  'http://www.codesourcery.com/qm/dtds/2.2/-//qm/2.2/extension//en.dtd'>
-<extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>PLAN SORT ((T53 INDEX (I_TABLE_53_ID1_ASC, I_TABLE_53_ID2_ASC)))
-
-         ID1          ID2 
-============ ============ 
-
-          10            5 
-          10            4 
-          10            3 
-          10            2 
-          10            1 
-          10            0 
-          20            5 
-          20            4 
-          20            3 
-          20            2 
-          20            1 
-          20            0 
-</text></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="title"><text>ORDER BY ASC, DESC using index (multi)</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>2.0</text></argument><argument name="description"><text>ORDER BY X ASC, Y DESC
-When more fields are given in ORDER BY clause try to use a compound index, but look out for mixed directions.</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>Using SQL Commands</enumeral></argument><argument name="bug_id"><text/></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>sort_by_index.fdb</text></argument><argument name="isql_script"><text>CREATE TABLE Table_53 (
-  ID1 INTEGER,
-  ID2 INTEGER
-);
-
-SET TERM ^^ ;
-CREATE PROCEDURE PR_FillTable_53
-AS
-DECLARE VARIABLE FillID INTEGER;
-DECLARE VARIABLE FillID1 INTEGER;
-BEGIN
-  FillID = 1;
-  WHILE (FillID &lt;= 50) DO
-  BEGIN
-    FillID1 = (FillID / 10) * 10;
-    INSERT INTO Table_53 
-      (ID1, ID2) 
-    VALUES 
-      (:FillID1, :FillID - :FillID1);
-    FillID = FillID + 1;
-  END
-  INSERT INTO Table_53 (ID1, ID2) VALUES (0, NULL);
-  INSERT INTO Table_53 (ID1, ID2) VALUES (NULL, 0);
-  INSERT INTO Table_53 (ID1, ID2) VALUES (NULL, NULL);
-END
-^^
-SET TERM ; ^^
-  
-COMMIT;
-
-EXECUTE PROCEDURE PR_FillTable_53;
-
-COMMIT;
-
-CREATE ASC INDEX I_Table_53_ID1_ASC ON Table_53 (ID1);
-CREATE DESC INDEX I_Table_53_ID1_DESC ON Table_53 (ID1);
-CREATE ASC INDEX I_Table_53_ID2_ASC ON Table_53 (ID2);
-CREATE DESC INDEX I_Table_53_ID2_DESC ON Table_53 (ID2);
-CREATE ASC INDEX I_Table_53_ID1_ID2_ASC ON Table_53 (ID1, ID2);
-CREATE DESC INDEX I_Table_53_ID1_ID2_DESC ON Table_53 (ID1, ID2);
-CREATE ASC INDEX I_Table_53_ID2_ID1_ASC ON Table_53 (ID2, ID1);
-CREATE DESC INDEX I_Table_53_ID2_ID1_DESC ON Table_53 (ID2, ID1);
-
-COMMIT;
-</text></argument><argument name="source_code"><text>SET PLAN ON;
-SELECT
-  t53.ID1, t53.ID2
-FROM
-  Table_53 t53
-WHERE
-  t53.ID1 BETWEEN 10 and 20 and 
-  t53.ID2 &lt;= 5
-ORDER BY
-  t53.ID1 ASC, t53.ID2 DESC;</text></argument><argument name="test_id"><text>opt_sort_by_index_12</text></argument><argument name="target_platform"><text>All</text></argument><argument name="insert_statement"><text/></argument><argument name="test_expr"><text/></argument><argument name="statement_type_and_result"><enumeral>SQL: String</enumeral></argument><argument name="prerequisites"><set/></argument><argument name="author"><text>arno.brinkman</text></argument><argument name="drop_db"><enumeral>true</enumeral></argument><argument name="db_path_property"><text>database_location</text></argument></extension>
\ No newline at end of file
+<?xml version="1.0" ?>
+<!DOCTYPE extension
+  PUBLIC '-//QM/2.3/Extension//EN'
+  'http://www.codesourcery.com/qm/dtds/2.3/-//qm/2.3/extension//en.dtd'>
+<extension class="fbqa.FirebirdTest" kind="test"><argument name="create_db_method"><enumeral>Create New</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>
+PLAN SORT ((T53 INDEX (I_TABLE_53_ID2_ASC, I_TABLE_53_ID1_ASC)))
+
+         ID1          ID2 
+============ ============ 
+          10            5 
+          10            4 
+          10            3 
+          10            2 
+          10            1 
+          10            0 
+          20            5 
+          20            4 
+          20            3 
+          20            2 
+          20            1 
+          20            0 
+
+</text></argument><argument name="character_set"><enumeral>NONE</enumeral></argument><argument name="author"><text>arno.brinkman</text></argument><argument name="page_size"><enumeral>Default</enumeral></argument><argument name="substitutions"><set/></argument><argument name="backup_file_path"><text/></argument><argument name="user_name"><text>SYSDBA</text></argument><argument name="resources"><set/></argument><argument name="expected_stderr"><text/></argument><argument name="target_version"><text>2.0</text></argument><argument name="description"><text>ORDER BY X ASC, Y DESC
+When more fields are given in ORDER BY clause try to use a compound index, but look out for mixed directions.</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>Using SQL Commands</enumeral></argument><argument name="bug_id"><text/></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>sort_by_index.fdb</text></argument><argument name="isql_script"><text>CREATE TABLE Table_53 (
+  ID1 INTEGER,
+  ID2 INTEGER
+);
+
+SET TERM ^^ ;
+CREATE PROCEDURE PR_FillTable_53
+AS
+DECLARE VARIABLE FillID INTEGER;
+DECLARE VARIABLE FillID1 INTEGER;
+BEGIN
+  FillID = 1;
+  WHILE (FillID &lt;= 50) DO
+  BEGIN
+    FillID1 = (FillID / 10) * 10;
+    INSERT INTO Table_53 
+      (ID1, ID2) 
+    VALUES 
+      (:FillID1, :FillID - :FillID1);
+    FillID = FillID + 1;
+  END
+  INSERT INTO Table_53 (ID1, ID2) VALUES (0, NULL);
+  INSERT INTO Table_53 (ID1, ID2) VALUES (NULL, 0);
+  INSERT INTO Table_53 (ID1, ID2) VALUES (NULL, NULL);
+END
+^^
+SET TERM ; ^^
+  
+COMMIT;
+
+EXECUTE PROCEDURE PR_FillTable_53;
+
+COMMIT;
+
+CREATE ASC INDEX I_Table_53_ID1_ASC ON Table_53 (ID1);
+CREATE DESC INDEX I_Table_53_ID1_DESC ON Table_53 (ID1);
+CREATE ASC INDEX I_Table_53_ID2_ASC ON Table_53 (ID2);
+CREATE DESC INDEX I_Table_53_ID2_DESC ON Table_53 (ID2);
+CREATE ASC INDEX I_Table_53_ID1_ID2_ASC ON Table_53 (ID1, ID2);
+CREATE DESC INDEX I_Table_53_ID1_ID2_DESC ON Table_53 (ID1, ID2);
+CREATE ASC INDEX I_Table_53_ID2_ID1_ASC ON Table_53 (ID2, ID1);
+CREATE DESC INDEX I_Table_53_ID2_ID1_DESC ON Table_53 (ID2, ID1);
+
+COMMIT;
+</text></argument><argument name="source_code"><text>SET PLAN ON;
+SELECT
+  t53.ID1, t53.ID2
+FROM
+  T...
 
[truncated message content]

[Firebird-checkins] SF.net SVN: firebird: [448] qa/trunk/testsuite

A powerful, cross platform, SQL database system

[Firebird-checkins] SF.net SVN: firebird: [448] qa/trunk/testsuite