Re: [Postgres-xc-developers] Fix for test case copy2

[Abbas B. <abb...@en...>]

On Tue, Apr 30, 2013 at 4:19 PM, Ashutosh Bapat <
ash...@en...> wrote:

> Hi Abbas,
> copy2 has an alternate output file. So, if you change .sql file, you need
> to make corresponding changes in .out and _1.out. There is one missing
> change about not enforcing 2PC with temporary tables, which needs to be
> carried to .out file as well.
>

Done.


>
> Otherwise the change looks good. While adding the ORDER BY clause, hope
> you have made sure that the data that is output is same except for change
> in the ordering.
>

True.


>
> This testcase needs to be looked at by Amit for the trigger related
> changes. After that I think we should remove alt. output file.
>

The data in copy2.out and copy2_1.out is different because FOR EACH ROW
triggers are not fired on coordinators.
There is one other difference and that is
---
> "Jackson, Sam",\h
> "It is ""perfect"".",
214,215c214,215
< "Jackson, Sam","\h"
< "It is ""perfect"".","    "

Note quotes around \h in one case and no quotes in the other.

So we need to decide how to take care of these two changes in the data
before we remove the alternate expected output file.



>
>
> On Wed, Apr 24, 2013 at 10:58 PM, Abbas Butt <abb...@en...>wrote:
>
>> Hi,
>> Test was failing because of some order by issues in COPY TO statements.
>>
>> --
>> *Abbas*
>>  Architect
>>
>> Ph: 92.334.5100153
>>  Skype ID: gabbasb
>> www.enterprisedb.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/>
>> *
>> Follow us on Twitter*
>> @EnterpriseDB
>>
>> Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community>and more<http://www.enterprisedb.com/resources-community>
>>
>>
>> ------------------------------------------------------------------------------
>> Try New Relic Now & We'll Send You this Cool Shirt
>> New Relic is the only SaaS-based application performance monitoring
>> service
>> that delivers powerful full stack analytics. Optimize and monitor your
>> browser, app, & servers with just a few lines of code. Try New Relic
>> and get this awesome Nerd Life shirt!
>> http://p.sf.net/sfu/newrelic_d2d_apr
>> _______________________________________________
>> Postgres-xc-developers mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>>
>>
>
>
> --
> Best Wishes,
> Ashutosh Bapat
> EntepriseDB Corporation
> The Postgres Database Company
>



-- 
-- 
*Abbas*
 Architect

Ph: 92.334.5100153
 Skype ID: gabbasb
www.enterprisedb.co
<http://www.enterprisedb.com/>m<http://www.enterprisedb.com/>
*
Follow us on Twitter*
@EnterpriseDB

Visit EnterpriseDB for tutorials, webinars,
whitepapers<http://www.enterprisedb.com/resources-community>and
more<http://www.enterprisedb.com/resources-community>