[Firebird-checkins] SF.net SVN: firebird:[59734] qa/fbt-repository/trunk/tests

[<mak...@us...>]

Revision: 59734
          http://sourceforge.net/p/firebird/code/59734
Author:   makowski
Date:     2014-06-19 14:13:46 +0000 (Thu, 19 Jun 2014)
Log Message:
-----------
Fix for Firebird 2.1.6

Modified Paths:
--------------
    qa/fbt-repository/trunk/tests/bugs/core_0104.fbt
    qa/fbt-repository/trunk/tests/bugs/core_1018.fbt
    qa/fbt-repository/trunk/tests/bugs/core_4093.fbt
    qa/fbt-repository/trunk/tests/functional/domain/create_41.fbt
    qa/fbt-repository/trunk/tests/functional/exception/create_02.fbt
    qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_02.fbt
    qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_03.fbt
    qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_04.fbt
    qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_08.fbt
    qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_09.fbt
    qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_13.fbt
    qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_14.fbt
    qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_15.fbt
    qa/fbt-repository/trunk/tests/functional/fkey/primary/select_pk_02.fbt
    qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_02.fbt
    qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_03.fbt
    qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_04.fbt
    qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_07.fbt
    qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_08.fbt
    qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_09.fbt
    qa/fbt-repository/trunk/tests/functional/fkey/unique/select_uf_02.fbt
    qa/fbt-repository/trunk/tests/functional/generator/create_02.fbt
    qa/fbt-repository/trunk/tests/functional/index/create_10.fbt
    qa/fbt-repository/trunk/tests/functional/index/create_11.fbt
    qa/fbt-repository/trunk/tests/functional/table/create_06.fbt

Modified: qa/fbt-repository/trunk/tests/bugs/core_0104.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/bugs/core_0104.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/bugs/core_0104.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -1,9 +1,10 @@
 {
-'id': 'bugs.core_104',
+'id': 'bugs.core_0104',
 'qmid': 'bugs.core_104-250',
 'tracker_id': 'CORE-104',
 'title': 'Dropping and recreating a table in the same txn disables PK',
 'description': '',
+'min_versions': None,
 'versions': [
 {
  'firebird_version': '2.5.0',
@@ -49,6 +50,7 @@
 """,
  'expected_stderr': """Statement failed, SQLCODE = -803
 violation of PRIMARY or UNIQUE KEY constraint "INTEG_4" on table "TEST"
+-Problematic key value is ("ACOLUMN" = 1)
 """
 }
 ]

Modified: qa/fbt-repository/trunk/tests/bugs/core_1018.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/bugs/core_1018.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/bugs/core_1018.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -148,6 +148,20 @@
 3.0.0
 
 """
+},
+{
+ 'firebird_version': '2.1.6',
+ 'platform': 'All',
+ 'test_type': 'ISQL',
+ 'test_script': """select rdb$get_context('SYSTEM', 'ENGINE_VERSION') from rdb$database;
+""",
+ 'expected_stdout': """Database:  localhost:C:\Users\win7\Firebird_tests\fbt-repository\tmp\bugs.core_1018.fdb, User: SYSDBA
+SQL>
+RDB$GET_CONTEXT
+===============================================================================
+2.1.6
+
+SQL>"""
 }
 ]
 }

Modified: qa/fbt-repository/trunk/tests/bugs/core_4093.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/bugs/core_4093.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/bugs/core_4093.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -13,6 +13,19 @@
  'test_type': 'ISQL',
  'test_script': """SET HEADING OFF;
 select cast(cast(0 as numeric(18, 15)) * cast(0 as numeric(18, 15)) * cast(0 as numeric(18, 15)) as varchar (41)) from rdb$database;""",
+ 'expected_stderr': """Statement failed, SQLCODE = -413
+
+conversion error from string "0.000000000000000000000000000000000000000000000"
+
+"""
+},
+{
+ 'firebird_version': '2.5',
+ 'platform': 'All',
+ 'page_size': '4096',
+ 'test_type': 'ISQL',
+ 'test_script': """SET HEADING OFF;
+select cast(cast(0 as numeric(18, 15)) * cast(0 as numeric(18, 15)) * cast(0 as numeric(18, 15)) as varchar (41)) from rdb$database;""",
  'expected_stderr': """Statement failed, SQLSTATE = 22018
 
 conversion error from string "0.000000000000000000000000000000000000000000000"

Modified: qa/fbt-repository/trunk/tests/functional/domain/create_41.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/domain/create_41.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/domain/create_41.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -44,6 +44,19 @@
 -violation of PRIMARY or UNIQUE KEY constraint "RDB$INDEX_2" on table "RDB$FIELDS"
 
 """
+},
+{
+ 'firebird_version': '2.1',
+ 'platform': 'All',
+ 'init_script': 'CREATE DOMAIN test AS INTEGER;',
+ 'test_type': 'ISQL',
+ 'test_script': 'CREATE DOMAIN test AS VARCHAR(32);',
+ 'expected_stderr': """Statement failed, SQLCODE = -607
+unsuccessful metadata update
+-STORE RDB$FIELDS failed
+-attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_2"
+-Problematic key value is ("RDB$FIELD_NAME" = 'TEST')
+"""
 }
 ]
 }

Modified: qa/fbt-repository/trunk/tests/functional/exception/create_02.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/exception/create_02.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/exception/create_02.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -51,6 +51,20 @@
 -Exception TEST already exists
 
 """
+},
+{
+ 'firebird_version': '2.1',
+ 'platform': 'All',
+ 'init_script': """CREATE EXCEPTION test 'A1';
+commit;""",
+ 'test_type': 'ISQL',
+ 'test_script': "CREATE EXCEPTION test 'message to show';",
+ 'expected_stderr': """Statement failed, SQLCODE = -607
+unsuccessful metadata update
+-DEFINE EXCEPTION failed
+-attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_23"
+-Problematic key value is ("RDB$EXCEPTION_NAME" = 'TEST')
+"""
 }
 ]
 }

Modified: qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_02.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_02.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_02.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -58,10 +58,10 @@
   print (e[0])""",
  'expected_stdout': """Error while executing SQL statement:
 - SQLCODE: -901
-- Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
 - lock conflict on no wait transaction
 - violation of FOREIGN KEY constraint "FK_DETAIL_TABLE" on table "DETAIL_TABLE"
 - Foreign key reference target does not exist
+- Problematic key value is ("FKEY" = 1)
 """
 },
 {

Modified: qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_03.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_03.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_03.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -66,10 +66,10 @@
   print (e[0])""",
  'expected_stdout': """Error while executing SQL statement:
 - SQLCODE: -901
-- Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
 - lock conflict on no wait transaction
 - violation of FOREIGN KEY constraint "FK_DETAIL_TABLE" on table "DETAIL_TABLE"
 - Foreign key reference target does not exist
+- Problematic key value is ("FKEY" = 1)
 """
 },
 {

Modified: qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_04.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_04.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_04.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -66,10 +66,10 @@
   print (e[0])""",
  'expected_stdout': """Error while executing SQL statement:
 - SQLCODE: -901
-- Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
 - lock conflict on no wait transaction
 - violation of FOREIGN KEY constraint "FK_DETAIL_TABLE" on table "DETAIL_TABLE"
 - Foreign key reference target does not exist
+- Problematic key value is ("FKEY" = 1)
 """
 },
 {

Modified: qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_08.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_08.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_08.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -61,10 +61,10 @@
   print (e[0])""",
  'expected_stdout': """Error while executing SQL statement:
 - SQLCODE: -901
-- Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
 - lock conflict on no wait transaction
 - violation of FOREIGN KEY constraint "FK_DETAIL_TABLE" on table "DETAIL_TABLE"
 - Foreign key reference target does not exist
+- Problematic key value is ("FKEY_1" = 1, "FKEY_2" = 'one')
 """
 },
 {

Modified: qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_09.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_09.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_09.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -62,10 +62,10 @@
   print (e[0])""",
  'expected_stdout': """Error while executing SQL statement:
 - SQLCODE: -901
-- Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
 - lock conflict on no wait transaction
 - violation of FOREIGN KEY constraint "FK_DETAIL_TABLE" on table "DETAIL_TABLE"
 - Foreign key reference target does not exist
+- Problematic key value is ("FKEY_1" = 1, "FKEY_2" = 'one')
 """
 },
 {

Modified: qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_13.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_13.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_13.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -60,6 +60,7 @@
 - lock conflict on no wait transaction
 - violation of FOREIGN KEY constraint "FK_DETAIL_TABLE" on table "DETAIL_TABLE"
 - Foreign key reference target does not exist
+- Problematic key value is ("FKEY" = 1)
 """
 }
 ]

Modified: qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_14.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_14.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_14.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -60,6 +60,7 @@
 - SQLCODE: -530
 - violation of FOREIGN KEY constraint "FK_DETAIL_TABLE" on table "DETAIL_TABLE"
 - Foreign key reference target does not exist
+- Problematic key value is ("FKEY" = 1)
 """
 }
 ]

Modified: qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_15.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_15.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/fkey/primary/insert_pk_15.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -56,10 +56,10 @@
   print (e[0])""",
  'expected_stdout': """Error while executing SQL statement:
 - SQLCODE: -901
-- Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
 - lock conflict on no wait transaction
 - violation of FOREIGN KEY constraint "FK_DETAIL_TABLE" on table "DETAIL_TABLE"
 - Foreign key reference target does not exist
+- Problematic key value is ("FKEY" = 2)
 """
 },
 {

Modified: qa/fbt-repository/trunk/tests/functional/fkey/primary/select_pk_02.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/fkey/primary/select_pk_02.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/fkey/primary/select_pk_02.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -68,6 +68,7 @@
 - SQLCODE: -530
 - violation of FOREIGN KEY constraint "FK_DETAIL_TABLE" on table "DETAIL_TABLE"
 - Foreign key references are present for the record
+- Problematic key value is ("ID" = 1)
 """
 }
 ]

Modified: qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_02.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_02.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_02.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -59,10 +59,10 @@
   print (e[0])""",
  'expected_stdout': """Error while executing SQL statement:
 - SQLCODE: -901
-- Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
 - lock conflict on no wait transaction
 - violation of FOREIGN KEY constraint "FK_DETAIL_TABLE" on table "DETAIL_TABLE"
 - Foreign key reference target does not exist
+- Problematic key value is ("FKEY" = 2)
 """
 },
 {

Modified: qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_03.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_03.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_03.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -70,6 +70,7 @@
 - SQLCODE: -530
 - violation of FOREIGN KEY constraint "FK_DETAIL_TABLE" on table "DETAIL_TABLE"
 - Foreign key reference target does not exist
+- Problematic key value is ("FKEY" = 2)
 """
 }
 ]

Modified: qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_04.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_04.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_04.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -68,10 +68,10 @@
   print (e[0])""",
  'expected_stdout': """Error while executing SQL statement:
 - SQLCODE: -901
-- Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements
 - lock conflict on no wait transaction
 - violation of FOREIGN KEY constraint "FK_DETAIL_TABLE" on table "DETAIL_TABLE"
 - Foreign key reference target does not exist
+- Problematic key value is ("FKEY" = 2)
 """
 },
 {

Modified: qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_07.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_07.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_07.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -62,6 +62,7 @@
 - lock conflict on no wait transaction
 - violation of FOREIGN KEY constraint "FK_DETAIL_TABLE" on table "DETAIL_TABLE"
 - Foreign key reference target does not exist
+- Problematic key value is ("FKEY" = 1)
 """
 }
 ]

Modified: qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_08.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_08.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_08.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -62,6 +62,7 @@
 - SQLCODE: -530
 - violation of FOREIGN KEY constraint "FK_DETAIL_TABLE" on table "DETAIL_TABLE"
 - Foreign key reference target does not exist
+- Problematic key value is ("FKEY" = 1)
 """
 }
 ]

Modified: qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_09.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_09.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/fkey/unique/insert_09.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -60,6 +60,7 @@
 - lock conflict on no wait transaction
 - violation of FOREIGN KEY constraint "FK_DETAIL_TABLE" on table "DETAIL_TABLE"
 - Foreign key reference target does not exist
+- Problematic key value is ("FKEY" = 1)
 """
 }
 ]

Modified: qa/fbt-repository/trunk/tests/functional/fkey/unique/select_uf_02.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/fkey/unique/select_uf_02.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/fkey/unique/select_uf_02.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -68,6 +68,7 @@
 - SQLCODE: -530
 - violation of FOREIGN KEY constraint "FK_DETAIL_TABLE" on table "DETAIL_TABLE"
 - Foreign key references are present for the record
+- Problematic key value is ("UF" = 1)
 """
 }
 ]

Modified: qa/fbt-repository/trunk/tests/functional/generator/create_02.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/generator/create_02.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/generator/create_02.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -53,6 +53,21 @@
 -Sequence TEST already exists
 
 """
+},
+{
+ 'firebird_version': '2.1',
+ 'platform': 'All',
+ 'init_script': """CREATE GENERATOR test;
+commit;
+""",
+ 'test_type': 'ISQL',
+ 'test_script': 'CREATE GENERATOR test;',
+ 'expected_stderr': """Statement failed, SQLCODE = -607
+unsuccessful metadata update
+-DEFINE GENERATOR failed
+-attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_11"
+-Problematic key value is ("RDB$GENERATOR_NAME" = 'TEST')
+"""
 }
 ]
 }

Modified: qa/fbt-repository/trunk/tests/functional/index/create_10.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/index/create_10.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/index/create_10.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -58,6 +58,22 @@
 -Index TEST already exists
 
 """
+},
+{
+ 'firebird_version': '2.1',
+ 'platform': 'All',
+ 'init_script': """CREATE TABLE t( a INTEGER);
+CREATE INDEX test ON t(a);
+commit;
+""",
+ 'test_type': 'ISQL',
+ 'test_script': 'CREATE INDEX test ON t(a);',
+ 'expected_stderr': """Statement failed, SQLCODE = -607
+unsuccessful metadata update
+-STORE RDB$INDICES failed
+-attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_5"
+-Problematic key value is ("RDB$INDEX_NAME" = 'TEST')
+"""
 }
 ]
 }

Modified: qa/fbt-repository/trunk/tests/functional/index/create_11.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/index/create_11.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/index/create_11.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -1,5 +1,5 @@
 {
-'id': 'functional.index.create.11',
+'id': 'functional.index.create_11',
 'qmid': 'functional.index.create.create_index_11',
 'tracker_id': '',
 'title': 'CREATE UNIQUE INDEX - Non unique data in table',
@@ -10,6 +10,7 @@
 CREATE TABLE
 INSERT
 SHOW INDEX""",
+'min_versions': None,
 'versions': [
 {
  'firebird_version': '1.0',
@@ -50,6 +51,26 @@
 
 attempt to store duplicate value (visible to active transactions) in unique index "TEST"
 """
+},
+{
+ 'firebird_version': '2.1',
+ 'platform': 'All',
+ 'init_script': """CREATE TABLE t( a INTEGER);
+commit;
+INSERT INTO t VALUES(0);
+INSERT INTO t VALUES(0);
+INSERT INTO t VALUES(1);
+INSERT INTO t VALUES(2);
+INSERT INTO t VALUES(3);
+INSERT INTO t VALUES(4);
+COMMIT;
+""",
+ 'test_type': 'ISQL',
+ 'test_script': 'CREATE UNIQUE INDEX test ON t(a);',
+ 'expected_stderr': """Statement failed, SQLCODE = -803
+attempt to store duplicate value (visible to active transactions) in unique index "TEST"
+-Problematic key value is ("A" = 0)
+"""
 }
 ]
 }

Modified: qa/fbt-repository/trunk/tests/functional/table/create_06.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/table/create_06.fbt	2014-06-19 12:44:46 UTC (rev 59733)
+++ qa/fbt-repository/trunk/tests/functional/table/create_06.fbt	2014-06-19 14:13:46 UTC (rev 59734)
@@ -60,6 +60,23 @@
 -violation of PRIMARY or UNIQUE KEY constraint "RDB$INDEX_15" on table "RDB$RELATION_FIELDS"
 
 """
+},
+{
+ 'firebird_version': '2.1',
+ 'platform': 'All',
+ 'test_type': 'ISQL',
+ 'test_script': """CREATE TABLE test(
+ c1 SMALLINT,
+ c1 INTEGER
+);
+
+""",
+ 'expected_stderr': """Statement failed, SQLCODE = -607
+unsuccessful metadata update
+-STORE RDB$RELATION_FIELDS failed
+-attempt to store duplicate value (visible to active transactions) in unique index "RDB$INDEX_15"
+-Problematic key value is ("RDB$FIELD_NAME" = 'C1', "RDB$RELATION_NAME" = 'TEST')
+"""
 }
 ]
 }

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