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

wc-ng: using backup tables ...

From: Bhuvaneswaran A <bhuvan_at_collab.net>
Date: Sat, 10 Oct 2009 00:04:26 +0530

I've 2 queries related to wc-ng related sqls defined in wc-metadata.sql
file:

1) We create backup tables explicitly to store records from original
tables. We use the sqls in following style:
  create table foo_temp (col1 int);
     insert into foo_temp select col1 from foo;
  drop table foo;
  create table foo (col1 int);
     insert into foo select col1 from foo_temp;
  drop table foo_temp;

Instead, why shouldn't use the following style:
  create table foo_temp as select col1 from foo;
  drop table foo;
  create table foo (col1 int);
     insert into foo select col1 from foo_temp;
  drop table foo_temp;

2) We use 2 backup tables, BASE_NODE_BACKUP and ACTUAL_NODE_BACKUP. The
former is defined as a TEMPORARY table, while the latter is defined as
normal table. Any specific reason for doing so? Why can't they maintain
same standard, perhaps being a TEMPORARY table?

If you agree with the proposals, I shall come with a patch. Thanks!

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

Received on 2009-10-09 20:34:47 CEST

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