[Firebird-checkins] SF.net SVN: firebird:[53064] qa/trunk/fbtest/tests/bugs/core_2426.fbt

[<pc...@us...>]

Revision: 53064
          http://firebird.svn.sourceforge.net/firebird/?rev=53064&view=rev
Author:   pcisar
Date:     2011-05-31 15:57:46 +0000 (Tue, 31 May 2011)

Log Message:
-----------
QA-398 for CORE-2426

Added Paths:
-----------
    qa/trunk/fbtest/tests/bugs/core_2426.fbt

Added: qa/trunk/fbtest/tests/bugs/core_2426.fbt
===================================================================
--- qa/trunk/fbtest/tests/bugs/core_2426.fbt	                        (rev 0)
+++ qa/trunk/fbtest/tests/bugs/core_2426.fbt	2011-05-31 15:57:46 UTC (rev 53064)
@@ -0,0 +1,32 @@
+{
+'id': 'bugs.core_2426',
+'qmid': None,
+'tracker_id': 'CORE-2426',
+'title': 'Alter table not respecting collation',
+'description': '',
+'min_versions': '',
+'versions': [
+{
+ 'firebird_version': '2.5',
+ 'platform': 'All',
+ 'page_size': '4096',
+ 'test_type': 'ISQL',
+ 'test_script': """-- create domain A_DOMAIN VARCHAR(14) CHARacter SET WIN1252 COLLATE WINPT_BR;
+create domain A_DOMAIN VARCHAR(14) CHARacter SET WIN1252;
+create domain B_DOMAIN VARCHAR(14) CHARacter SET ISO8859_1 COLLATE PT_BR;
+
+create table t (FIELD_A VARCHAR(14) CHARacter SET WIN1252 not null COLLATE WIN1252);
+alter table t alter field_a type b_domain;
+alter table t add primary key (FIELD_A);
+
+create table t2 (FK B_DOMAIN REFERENCES t(FIELD_A));
+show table t; -- colattion changes to de_de
+""",
+ 'expected_stdout': """FIELD_A                         (B_DOMAIN) VARCHAR(14) CHARACTER SET ISO8859_1 Not Null
+                                 COLLATE PT_BR
+CONSTRAINT INTEG_2:
+  Primary key (FIELD_A)
+"""
+}
+]
+}


Property changes on: qa/trunk/fbtest/tests/bugs/core_2426.fbt
___________________________________________________________________
Added: svn:mime-type
   + text/plain
Added: svn:eol-style
   + native


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