db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amit Handa (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-105) drop table statement shows wrong message after dropping table
Date Fri, 17 Dec 2004 11:21:12 GMT
drop table statement shows wrong message after dropping table
-------------------------------------------------------------

         Key: DERBY-105
         URL: http://nagoya.apache.org/jira/browse/DERBY-105
     Project: Derby
        Type: Bug
  Components: SQL  
    Versions: 10.0.2.2    
 Environment: generic
    Reporter: Amit Handa
    Priority: Minor


If we drop a table using the ij tool,
it returns a message that "0 rows inserted/updated/deleted"
giving an impression as if the table is still there and some update has been done
(as if executed a DML statement) to the table, whereas this is not the case.

Note that the same message appears while we execute a DML(insert/update/delete) query on the
table.
which further confuses the user as if a table hasn't been dropped and updations still happenning

on the table instead of dropping(and creating)

The same is the case when a table is created.

Rather it when a table is created

ij> create table temp(cv char(10));
0 rows inserted/updated/deleted       <-- Wrong message
ij> select * from temp;
CV        
----------

0 rows selected
ij> insert into temp values('a');
1 row inserted/updated/deleted
ij> drop table temp;
0 rows inserted/updated/deleted          <-- Wrong message
ij> 


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://nagoya.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


Mime
View raw message