Menu ▾ ▴

#978 Not zeroing # of rows , after TRUNCATE

Upstream
nobody
None
Cosmetic
Defect
2009-02-12
2009-02-08
Anonymous
No

Originally created by: dak...@gmail.com

What exact steps will reproduce the problem?
1. select table with some rows
2. on tab "Query" execute "TRUNCATE table_name"
3. go to tab "Data" - it displays X rows total

What was the expected output?
"0 rows total"

What happened instead?
"X rows total", X = number of rows before truncating

Suggested fix (optional)?

Version used?
HeidiSQL revision: 2256
MySQL Server version: 5.0.45
Operating system: XP SP2

Discussion

  • Comment has been marked as spam. 
    Undo

    View and moderate all "tickets Discussion" comments posted by this user

    Mark all as spam, and block user from posting to "Tickets"

    Anonymous

    Anonymous - 2009-02-12

    Originally posted by: rosenfie...@gmail.com

    This is by design.  The data tab does not invalidate after executing a query.

    If the data tab invalidated, users would be unable to switch back and forth between
    a set of data and executing queries, which can be handy.

    Should probably be documented somewhere, but then again HeidiSQL doesn't have a
    manual ;-).

    Labels: Severity-Cosmetic
    Status: WontFix

     
  • Comment has been marked as spam. 
    Undo

    View and moderate all "tickets Discussion" comments posted by this user

    Mark all as spam, and block user from posting to "Tickets"

    Anonymous

    Anonymous - 2009-02-12

    Originally posted by: rosenfie...@gmail.com

    Actually, we could fix this if the MySQL Server told us what was modified by the
    last query executed.  A check could be made, and if the table touched is the table
    in the data view, it would be updated.  Marking bug as 'upstream' since that means
    waiting for something that'll never happen..

    (I suspect that some users would still complain, though.)

    Status: Upstream