db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shreyas Kaushik (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-105) drop table statement shows wrong message after dropping table
Date Mon, 10 Jan 2005 12:42:13 GMT
     [ http://issues.apache.org/jira/browse/DERBY-105?page=comments#action_57463 ]
     
Shreyas Kaushik commented on DERBY-105:
---------------------------------------

One possible solution for this:

In the file JDBCDisplayUtil.java, the method 

static void DisplayUpdateCount(PrintWriter out, int count, int indentLevel ) is the place
where the messsages are displayed. Here we can replace the condition 

  if( count >= 0 ) 
     
    with
  
  if( count > 0 ) 

 This will cause the message "Statement executed" to be displayed. If there are any warning
messages those are displayed afetr this. This seems more meaningful as it says statement issued
was executed ( warnings if an y will be displayed ).

But doing this change will also require changes in all *.out files in the "master" directory
for tests which are written using the previous message.

Please comment.

> drop table statement shows wrong message after dropping table
> -------------------------------------------------------------
>
>          Key: DERBY-105
>          URL: http://issues.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://issues.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