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

[<ta...@us...>]

Revision: 61522
          http://sourceforge.net/p/firebird/code/61522
Author:   tabloid
Date:     2015-05-11 19:18:02 +0000 (Mon, 11 May 2015)
Log Message:
-----------
See added / modified .fbt file(s)

Modified Paths:
--------------
    qa/fbt-repository/trunk/tests/functional/database/create_02.fbt

Added Paths:
-----------
    qa/fbt-repository/trunk/tests/bugs/core_2289.fbt

Added: qa/fbt-repository/trunk/tests/bugs/core_2289.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/bugs/core_2289.fbt	                        (rev 0)
+++ qa/fbt-repository/trunk/tests/bugs/core_2289.fbt	2015-05-11 19:18:02 UTC (rev 61522)
@@ -0,0 +1,74 @@
+{
+'id': 'bugs.core_2289',
+'qmid': None,
+'tracker_id': 'CORE-2289',
+'title': "Wrong (primary) constraint name is reported for the foreign key violation during FK creation",
+'description': '',
+'min_versions': '2.1.7',
+'versions': [
+{
+ 'firebird_version': '2.1',
+ 'platform': 'All',
+ 'page_size': '4096',
+ 'test_type': 'ISQL',
+ 'init_script': 
+  """
+  """,
+ 'test_script': 
+  """
+    recreate table packet_detail(id int, packet_id int);
+    recreate table packet(id int, constraint packet_pk primary key(id) using index packet_idx);
+    commit;
+    insert into packet_detail(id, packet_id) values(1, 753);
+    commit;
+    
+    alter table packet_detail
+    add constraint packet_detail_fk
+    foreign key (packet_id)
+    references packet(id)
+    using index packet_detail_idx
+    ;
+    commit;
+  """,
+ 'expected_stderr':
+  """
+    Statement failed, SQLCODE = -530
+    violation of FOREIGN KEY constraint "PACKET_DETAIL_FK" on table "PACKET_DETAIL"
+    -Foreign key reference target does not exist
+    -Problematic key value is ("PACKET_ID" = 753)
+  """
+},
+{
+ 'firebird_version': '2.5',
+ 'platform': 'All',
+ 'page_size': '4096',
+ 'test_type': 'ISQL',
+ 'init_script': 
+  """
+  """,
+ 'test_script': 
+  """
+    recreate table packet_detail(id int, packet_id int);
+    recreate table packet(id int, constraint packet_pk primary key(id) using index packet_idx);
+    commit;
+    insert into packet_detail(id, packet_id) values(1, 753);
+    commit;
+    
+    alter table packet_detail
+    add constraint packet_detail_fk
+    foreign key (packet_id)
+    references packet(id)
+    using index packet_detail_idx
+    ;
+    commit;
+  """,
+ 'expected_stderr':
+  """
+    Statement failed, SQLSTATE = 23000
+    violation of FOREIGN KEY constraint "PACKET_DETAIL_FK" on table "PACKET_DETAIL"
+    -Foreign key reference target does not exist
+    -Problematic key value is ("PACKET_ID" = 753)
+  """
+}
+]
+}


Property changes on: qa/fbt-repository/trunk/tests/bugs/core_2289.fbt
___________________________________________________________________
Added: svn:mime-type
## -0,0 +1 ##
+text/plain
\ No newline at end of property
Added: svn:eol-style
## -0,0 +1 ##
+native
\ No newline at end of property
Modified: qa/fbt-repository/trunk/tests/functional/database/create_02.fbt
===================================================================
--- qa/fbt-repository/trunk/tests/functional/database/create_02.fbt	2015-05-11 15:48:35 UTC (rev 61521)
+++ qa/fbt-repository/trunk/tests/functional/database/create_02.fbt	2015-05-11 19:18:02 UTC (rev 61522)
@@ -133,6 +133,7 @@
  'platform': 'All',
  'user_name': 'test',
  'user_password': 'test',
+ 'init_script':'grant create database to test_user;',
  'test_type': 'ISQL',
  'test_script': 'SHOW DATABASE;',
  'expected_stdout': """        Owner: TEST

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