db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-105) drop table statement shows wrong message after dropping table
Date Mon, 30 Jul 2007 20:55:52 GMT

     [ https://issues.apache.org/jira/browse/DERBY-105?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kathey Marsden updated DERBY-105:
---------------------------------

    Issue Type: Improvement  (was: Bug)

I think this is an improvement, not a bug.


> drop table statement shows wrong message after dropping table
> -------------------------------------------------------------
>
>                 Key: DERBY-105
>                 URL: https://issues.apache.org/jira/browse/DERBY-105
>             Project: Derby
>          Issue Type: Improvement
>          Components: Tools
>    Affects 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.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message