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

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

From: Bhuvaneswaran A <bhuvan_at_collab.net>
Date: Wed, 14 Oct 2009 14:52:30 +0530

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

Received on 2009-10-14 11:22:46 CEST

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