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

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

Revision: 306
          http://svn.sourceforge.net/firebird/?rev=306&view=rev
Author:   makowski
Date:     2007-07-02 07:45:44 -0700 (Mon, 02 Jul 2007)

Log Message:
-----------
testsuite/bugs.qms/core_1009.qmt
testsuite/bugs.qms/core_1162.qmt
testsuite/bugs.qms/core_1329.qmt
testsuite/bugs.qms/core_426.qmt
testsuite/bugs.qms/core_86.qmt
testsuite/bugs.qms/core_932.qmt
testsuite/fbk/core1009.fbk
testsuite/fbk/core86.fbk

Added Paths:
-----------
    qa/trunk/testsuite/bugs.qms/core_1009.qmt
    qa/trunk/testsuite/bugs.qms/core_1162.qmt
    qa/trunk/testsuite/bugs.qms/core_1329.qmt
    qa/trunk/testsuite/bugs.qms/core_426.qmt
    qa/trunk/testsuite/bugs.qms/core_86.qmt
    qa/trunk/testsuite/bugs.qms/core_932.qmt
    qa/trunk/testsuite/fbk/core1009.fbk
    qa/trunk/testsuite/fbk/core86.fbk

Added: qa/trunk/testsuite/bugs.qms/core_1009.qmt
===================================================================

--- qa/trunk/testsuite/bugs.qms/core_1009.qmt	                        (rev 0)
+++ qa/trunk/testsuite/bugs.qms/core_1009.qmt	2007-07-02 14:45:44 UTC (rev 306)
@@ -0,0 +1,10 @@
+<?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>Restore From Backup</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>RDB$FIELD_NAME                                                                                RDB$BASE_FIELD                                                                                
+=============================================================================== =============================================================================== 
+ID                                                                                            ID                                                                                            
+EXPR                                                                                          &lt;null&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>core1009.fbk</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>RDB$BASE_FIELD for expression have to be NULL</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>None (manual)</enumeral></argument><argument name="bug_id"><text>CORE-1009</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>select rdb$field_name, rdb$base_field from rdb$relation_fields where rdb$relation_name = 'TEST_VIEW';</text></argument><argument name="test_id"><text>core-1009</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>Restoring RDB$BASE_FIELD for expression</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_1162.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_1162.qmt	                        (rev 0)
+++ qa/trunk/testsuite/bugs.qms/core_1162.qmt	2007-07-02 14:45:44 UTC (rev 306)
@@ -0,0 +1,34 @@
+<?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 
+======= 
+  99.99 
+
+</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>Statement failed, SQLCODE = -607
+unsuccessful metadata update
+-New scale specified for column A must be at most 2.
+</text></argument><argument name="target_version"><text>2.1</text></argument><argument name="description"><text>create table tab ( a numeric(4,2) );
+
+insert into tab values (99.99);
+
+select * from tab;
+
+A
+=======
+  99.99
+
+alter table tab alter a type numeric(4,3);
+
+select * from tab;
+
+Statement failed, SQLCODE = -802
+arithmetic exception, numeric overflow, or string truncation
+
+Btw. the database is not &quot;corrupted&quot; too badly - you can revert the change back by alter table tab alter a type numeric(4,2);
+and the engine is clever enough to convert data from stored format to requested one directly, not through all intermediate format versions.</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>None (manual)</enumeral></argument><argument name="bug_id"><text>CORE-1162</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>create table tab ( a numeric(4,2) );
+insert into tab values (99.99);
+alter table tab alter a type numeric(4,3);
+select * from tab;
+</text></argument><argument name="test_id"><text>core-1162</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>Problem altering numeric field type</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_1329.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_1329.qmt	                        (rev 0)
+++ qa/trunk/testsuite/bugs.qms/core_1329.qmt	2007-07-02 14:45:44 UTC (rev 306)
@@ -0,0 +1,17 @@
+<?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>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.1</text></argument><argument name="description"><text>Bug with size of alias name in a table (but still minor that 31 characters)
+</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>None (manual)</enumeral></argument><argument name="bug_id"><text>CORE-1329</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>CREATE TABLE BIG_TABLE_1234567890123 (COD INTEGER NOT NULL PRIMARY KEY);
+COMMIT;
+SELECT
+BIG_TABLE_1234567890123.COD
+FROM
+BIG_TABLE_1234567890123
+JOIN (SELECT
+      BIG_TABLE_1234567890123.COD
+      FROM
+      BIG_TABLE_1234567890123) BIG_TABLE_1234567890123_ ON
+BIG_TABLE_1234567890123.COD = BIG_TABLE_1234567890123_.COD;
+</text></argument><argument name="test_id"><text>core-1329</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>size of alias name in a table</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_426.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_426.qmt	                        (rev 0)
+++ qa/trunk/testsuite/bugs.qms/core_426.qmt	2007-07-02 14:45:44 UTC (rev 306)
@@ -0,0 +1,119 @@
+<?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>ae     
+ao     
+be     
+bo     
+ce     
+cha    
+cho    
+co     
+de     
+do     
+ee     
+eo     
+fe     
+fe     
+fo     
+go     
+he     
+ho     
+ie     
+io     
+je     
+jo     
+ke     
+ko     
+le     
+lle    
+llo    
+lo     
+me     
+mo     
+ne     
+no     
+oe     
+oo     
+pe     
+po     
+qe     
+qo     
+re     
+ro     
+se     
+so     
+te     
+to     
+ue     
+uo     
+ve     
+vo     
+xe     
+xo     
+ye     
+yo     
+ze     
+zo     
+
+</text></argument><argument name="character_set"><enumeral>ISO8859_1</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>Check if sort order for collate ES_ES is the one of DRAE , the oficial organization for standarization of spanish
+</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-426</text></argument><argument name="data_tuple"><text/></argument><argument name="db_name"><text>database_name</text></argument><argument name="isql_script"><text>SET NAMES ISO8859_1;
+CREATE TABLE TAB (A CHAR(3) CHARACTER SET ISO8859_1);
+COMMIT;
+INSERT INTO TAB VALUES ('zo');
+INSERT INTO TAB VALUES ('ze');
+INSERT INTO TAB VALUES ('yo');
+INSERT INTO TAB VALUES ('ye');
+INSERT INTO TAB VALUES ('xo');
+INSERT INTO TAB VALUES ('xe');
+INSERT INTO TAB VALUES ('vo');
+INSERT INTO TAB VALUES ('ve');
+INSERT INTO TAB VALUES ('uo');
+INSERT INTO TAB VALUES ('ue');
+INSERT INTO TAB VALUES ('to');
+INSERT INTO TAB VALUES ('te');
+INSERT INTO TAB VALUES ('so');
+INSERT INTO TAB VALUES ('se');
+INSERT INTO TAB VALUES ('ro');
+INSERT INTO TAB VALUES ('re');
+INSERT INTO TAB VALUES ('qo');
+INSERT INTO TAB VALUES ('qe');
+INSERT INTO TAB VALUES ('po');
+INSERT INTO TAB VALUES ('pe');
+INSERT INTO TAB VALUES ('oo');
+INSERT INTO TAB VALUES ('oe');
+INSERT INTO TAB VALUES ('no');
+INSERT INTO TAB VALUES ('ne');
+INSERT INTO TAB VALUES ('mo');
+INSERT INTO TAB VALUES ('me');
+INSERT INTO TAB VALUES ('llo');
+INSERT INTO TAB VALUES ('lle');
+INSERT INTO TAB VALUES ('lo');
+INSERT INTO TAB VALUES ('le');
+INSERT INTO TAB VALUES ('ko');
+INSERT INTO TAB VALUES ('ke');
+INSERT INTO TAB VALUES ('jo');
+INSERT INTO TAB VALUES ('je');
+INSERT INTO TAB VALUES ('io');
+INSERT INTO TAB VALUES ('ie');
+INSERT INTO TAB VALUES ('ho');
+INSERT INTO TAB VALUES ('he');
+INSERT INTO TAB VALUES ('go');
+INSERT INTO TAB VALUES ('fe');
+INSERT INTO TAB VALUES ('fo');
+INSERT INTO TAB VALUES ('fe');
+INSERT INTO TAB VALUES ('eo');
+INSERT INTO TAB VALUES ('ee');
+INSERT INTO TAB VALUES ('do');
+INSERT INTO TAB VALUES ('de');
+INSERT INTO TAB VALUES ('cho');
+INSERT INTO TAB VALUES ('cha');
+INSERT INTO TAB VALUES ('co');
+INSERT INTO TAB VALUES ('ce');
+INSERT INTO TAB VALUES ('bo');
+INSERT INTO TAB VALUES ('be');
+INSERT INTO TAB VALUES ('ao');
+INSERT INTO TAB VALUES ('ae');</text></argument><argument name="source_code"><text>SET HEADING OFF;
+SELECT A FROM TAB ORDER BY A COLLATE ES_ES;
+</text></argument><argument name="test_id"><text>core-426</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>Wrong sort order when using es_ES collate</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_86.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_86.qmt	                        (rev 0)
+++ qa/trunk/testsuite/bugs.qms/core_86.qmt	2007-07-02 14:45:44 UTC (rev 306)
@@ -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>Restore From Backup</enumeral></argument><argument name="user_password"><text>masterkey</text></argument><argument name="sql_dialect"><enumeral>3</enumeral></argument><argument name="result_string"><text>ID_YLK PH                           HPBH CD                   JLDW   JZDW   CK               HW                              SH 
+============ ==================== ============ ==================== ====== ====== ================ ============ ===================== 
+         110 0021                          492 MG                   JIAN   DUN    8K               1.8                        1.81000 
+
+</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>core86.fbk</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>Can not fetch the data when Index is use</text></argument><argument name="target_group"><text>.*</text></argument><argument name="populate_method"><enumeral>None (manual)</enumeral></argument><argument name="bug_id"><text>CORE-86</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>Select * from YLK A where PH = '0021'
+and HPBH = '492'
+and CD = 'MG'
+and JLDW = 'JIAN'
+and JZDW = 'DUN'
+and CK = '8K'
+and HW = '1.8'
+and SH='1.81'; </text></argument><argument name="test_id"><text>core-86</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>Index bug</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_932.qmt
===================================================================
--- qa/trunk/testsuite/bugs.qms/core_932.qmt	                        (rev 0)
+++ qa/trunk/testsuite/bugs.qms/core_932.qmt	2007-07-02 14:45:44 UTC (rev 306)
@@ -0,0 +1,19 @@
+<?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/fbk/core1009.fbk
===================================================================
(Binary files differ)


Property changes on: qa/trunk/testsuite/fbk/core1009.fbk
___________________________________________________________________
Name: svn:mime-type
   + application/octet-stream

Added: qa/trunk/testsuite/fbk/core86.fbk
===================================================================
(Binary files differ)


Property changes on: qa/trunk/testsuite/fbk/core86.fbk
___________________________________________________________________
Name: svn:mime-type
   + application/octet-stream


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.




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

A powerful, cross platform, SQL database system

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