From: <pc...@us...> - 2007-06-20 16:00:31
|
Revision: 270 http://svn.sourceforge.net/firebird/?rev=270&view=rev Author: pcisar Date: 2007-06-20 09:00:32 -0700 (Wed, 20 Jun 2007) Log Message: ----------- QA-35 - Test for CORE-1063 Added Paths: ----------- qa/trunk/testsuite/bugs.qms/core_1063.qmt qa/trunk/testsuite/fbk/core1063.fbk Property Changed: ---------------- qa/trunk/testsuite/ Property changes on: qa/trunk/testsuite ___________________________________________________________________ Name: svn:ignore + qmedit.bat qmtest.bat *.bak context-win-2-0 Added: qa/trunk/testsuite/bugs.qms/core_1063.qmt =================================================================== --- qa/trunk/testsuite/bugs.qms/core_1063.qmt (rev 0) +++ qa/trunk/testsuite/bugs.qms/core_1063.qmt 2007-06-20 16:00:32 UTC (rev 270) @@ -0,0 +1,94 @@ +<?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>NAME +=============================================================================== +.menu +awards.htm +affiliate_program.htm +user_guide.htm +forms/feedback.htm +faq.htm +products.htm +zonetick_v2.7_plan.htm +fxstreet.htm +confirmed.htm +index.htm +mail/confirm +launch.htm +.menu +forms/why_uninstall.htm +modification_guidelines.htm +forms/feature_request.htm +addition_minneapolis.htm +cities.htm +index.htm + +NAME +=============================================================================== +index.meta +index.htm +database_format_discussion.htm +.menu +profiles.htm +modification_guidelines.htm +update.htm +oem.htm +content_providers.htm +addition_hamburg.htm +forms/confirm.htm +packs.htm +zonetick_v2.7_released.htm +quotes.htm +skins.htm +feedback.htm +addition_phoenix.htm +zonetick_v3.0_plan.htm +wrtimetracker_v0.4_released.htm +zonetick_v2.7_beta.htm + +NAME +=============================================================================== +jobs.htm +contact.htm +wrtimetracker/faq.htm +wrtimetracker/user_manual.htm +addition_salt_lake_city.htm +wrtimetracker/index.htm +wrtimetracker/license.htm +addition_singapore.htm +addition_lipetsk.htm +addition_miami.htm +addition_miami.htm +.menu_zonetick + +</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>core1063.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.0.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-1063</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>alter table cms_wiki +add u_name varchar(100) character set UTF8, +add u_title varchar(100) character set UTF8, +add u_description blob sub_type 1 character set UTF8, +add u_text blob sub_type 1 character set UTF8; + +commit; + +update cms_wiki set +u_name = name, u_title = title, u_text = text, u_description = description; + +commit; + +drop index uq_cms_wiki; + +alter table cms_wiki drop name, drop description, drop text, drop title; + +commit; + +alter table cms_wiki +alter u_name to name, +alter u_title to title, +alter u_description to description, +alter u_text to text; + +commit; + +CREATE UNIQUE INDEX UQ_CMS_WIKI ON CMS_WIKI (NAME, SITE_ID); + +commit; + +select name from CMS_WIKI; +</text></argument><argument name="test_id"><text>core_1063</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>Server hangs eating CPU and performs huge I/O copying different codepage fields</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/core1063.fbk =================================================================== (Binary files differ) Property changes on: qa/trunk/testsuite/fbk/core1063.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. |