[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: [PATCH] wc-ng: use TEMPORARY tables ...

From: Bhuvaneswaran A <bhuvan_at_collab.net>
Date: Fri, 23 Oct 2009 00:13:50 +0530

Greg/Hyrum: ping?

On Wed, 2009-10-14 at 14:52 +0530, Bhuvaneswaran A wrote:
> Hello,
> As discussed in this email thread [1], please find attached the patch to
> use the TEMPORARY table when we want to remove columns from wc-ng
> related tables, and reduce number of SQLs by not creating the TEMPORARY
> tables explicitly.
>
> [[
> Use "CREATE TEMPORARY TABLE table_name AS SELECT" sql syntax to create
> temporary table, while dropping columns from the original table.
>
> * subversion/libsvn_wc/wc-metadata.sql
> (ACTUAL_NODE_BACKUP): Define as temporary table. Use "CREATE TEMPORARY
> TABLE table_name AS SELECT" syntax, instead of creating the table
> explicitly.
> (BASE_NODE_BACKUP): Use "CREATE TEMPORARY TABLE table_name AS SELECT"
> syntax, instead of creating the table explicitly.
> ]]
>
> [1]
> http://subversion.tigris.org/ds/viewMessage.do?dsForumId=462&dsMessageId=2405630
>
> --
> Bhuvaneswaran A
> CollabNet Software P Ltd. | www.collab.net
>
> ------------------------------------------------------
> http://subversion.tigris.org/ds/viewMessage.do?dsForumId=462&dsMessageId=2407463

-- 
Bhuvaneswaran A    
CollabNet Software P Ltd.  |  www.collab.net
------------------------------------------------------
http://subversion.tigris.org/ds/viewMessage.do?dsForumId=462&dsMessageId=2410355

Received on 2009-10-22 20:43:59 CEST

This is an archived mail posted to the Subversion Dev mailing list.