OQGRAPH

TRUNCATE TABLE chucks an error if table not empty

Bug #481145 reported by Arjen Lentz
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OQGRAPH
Confirmed
High
Antony T Curtis

Bug Description

mysql> create table foo like graph_template;
OK

mysql> truncate table foo;
OK

mysql> insert into foo ...
OK

mysql> truncate table foo;
ERROR 1005 (HY000): Can't create table ./test/foo' (errno: 145)

So it only happens when the table is not already empty.
DELETE FROM foo (without WHERE clause) works fine.

Revision history for this message
Andrew McDonnell (andymc73) wrote :

This doesn't make sense for oqgraphv3, because all modifying operations on a graph are prevented (read-only) - assume this is v2?

Revision history for this message
Arjen Lentz (arjen-lentz) wrote : Re: [Bug 481145] Re: TRUNCATE TABLE chucks an error if table not empty

On 30/09/13 21:24, Andrew McDonnell wrote:
> This doesn't make sense for oqgraphv3, because all modifying operations
> on a graph are prevented (read-only) - assume this is v2?

Yes v2 - you could mark it as such and even mark it as "won't fix" with
a note that it's been dealt with in v3.

--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Australian peace of mind for your MySQL/MariaDB infrastructure.

Follow us at http://openquery.com/blog/ & http://twitter.com/openquery

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.