Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 14207 invoked from network); 11 Jun 2007 18:33:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 11 Jun 2007 18:33:48 -0000 Received: (qmail 25111 invoked by uid 500); 11 Jun 2007 18:33:20 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 25084 invoked by uid 500); 11 Jun 2007 18:33:20 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 25019 invoked by uid 99); 11 Jun 2007 18:33:20 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Jun 2007 11:33:20 -0700 X-ASF-Spam-Status: No, hits=2.1 required=10.0 tests=RCVD_IN_WHOIS_INVALID,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of pandiri@students.iiit.ac.in designates 196.12.53.11 as permitted sender) Received: from [196.12.53.11] (HELO students.iiit.ac.in) (196.12.53.11) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Jun 2007 11:33:14 -0700 Received: from students.iiit.ac.in (localhost.localdomain [127.0.0.1]) by students.iiit.ac.in (8.13.8/8.13.0) with ESMTP id l5BIWgLi019285 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 12 Jun 2007 00:02:43 +0530 Received: from localhost (pandiri@localhost) by students.iiit.ac.in (8.13.8/8.12.8/Submit) with ESMTP id l5BIWgma019282 for ; Tue, 12 Jun 2007 00:02:42 +0530 Date: Tue, 12 Jun 2007 00:02:42 +0530 (IST) From: Ravinder Reddy To: derby-dev@db.apache.org Subject: Re: Regarding DERBY-2750 In-Reply-To: Message-ID: References: <56a83cd00706081436s47ad6e1fma2db1f1e7ff19701@mail.gmail.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-yoursite-MailScanner-Information: Please contact the IIIT Server Room for more information X-yoursite-MailScanner: Found to be clean X-yoursite-MailScanner-From: pandiri@students.iiit.ac.in X-Virus-Checked: Checked by ClamAV on apache.org X-Old-Spam-Status: No On Mon, 11 Jun 2007, Mamta Satoor wrote: > Ravinder, > > I haven't had time to look through all your mail but here is quick response > of 2 of the items. > > Test 1c) is covered in the GrantRevokeDDLTest.java and 1b) SYNONYM part is > getting tested in synonym.sql. > > It's great that you are not literally just converting the test but in fact > also trying to add missing test cases. That always helps with product > quality so please go ahead and add what seems to be missing. > > Mamta Thank U..!! > > On 6/8/07, Ravinder Reddy wrote: >> >> >> hi, >> I am Exploring lang/declareGlobalTempTableJava.java for >> converting into junit. >> >> I) I think It misses some tests >> >> a) If a Statement that performs an insert , update or delete to >> the temporary table >> encounter an error , all the rows of the table are deleted. >> "There is no test for this" >> b) CREATE TRIGGER and CREATE SYNONYM not allowed on SESSION schema >> tables. >> (including phisical tables). >> "There is no test for this" >> The tests relating to the TRIGGER are commented.what does >> it mean.? >> Does it mean that TRIGGERS are allowed on SESSION schema >> tables(now).? >> If not why they are commented.? >> >> c) Temporary Tables can't be specified in REVOKE and GRANT >> Statements. >> "There is no test for this" >> d)Importing into temporary tables and caching statements that >> reference SESSION schema >> tables also don't have tests. >> >> Should I include the tests in my fixture are just convert the old >> tests. >> >> II) There are some positive and negative tests for the DECLARE GLOBAL >> TEMPORARY TABLE >> statement.I think some of these are Sysnctic tests as opposed to >> behaviour tests >> (that we concern about). >> Can somebody justify the inclusion of these tests in >> testcases.? >> Eg: There is a test for >> "DECLARE GLOBAL TEMPORARY TABLE t1(c11 int) NOT LOGGED >> NOT LOGGED". >> I think this is slearly a syntax error and compiler will report it. >> >> III) In the process of converting this class to junit , As a first >> step, I listed all >> the tests that I planned to write.It turned out to be a huge >> number(50-60). >> Can a test fixture include these many(around 60) tests.Will we >> there be >> any performance degradations if all these tets are executed as one >> suite.? >> >> Thank U >> >> -- >> >> ****************************************************************************** >> >> Every problem that has been solved can be solved again in a better way >> >> - Ravinder Reddy >> >> >> ******************************************************************************* >> >> >> -- >> This message has been scanned for viruses and >> dangerous content by MailScanner, and is >> believed to be clean. >> >> > > -- ****************************************************************************** Every problem that has been solved can be solved again in a better way - Ravinder Reddy ******************************************************************************* -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.