On 08/08/2013 09:15 AM, Hannes Mühleisen wrote:
Hi Radovan,
On 08/08/2013 09:06 AM, Radovan Bičiště wrote:
Thank you for the prompt reply. Does DELETE FROM without WHERE truncate table storage ?
No it only marks them as deleted. sql>create table tmp(i int); operation successful (28.215ms) sql>insert into tmp values(1),(2); 2 affected rows (22.792ms) sql>delete from tmp; 2 affected rows (15.135ms) sql>select * from storage() where "table" ='tmp'; +--------+-------+--------+------+----------+-------+--------+--------+--------+---------+--------+ | schema | table | column | type | location | count | typewi | column | heapsi | indices | sorted | : : : : : : : dth : size : ze : : : +========+=======+========+======+==========+=======+========+========+========+=========+========+ | sys | tmp | i | int | 21/2112 | 0 | 4 | 0 | 0 | 0 | true | +--------+-------+--------+------+----------+-------+--------+--------+--------+---------+--------+ 1 tuple (4.572ms) And the file structure: [.......bat]$ ls 01 07 11 14 16 21 3.tail 4.head 4.theap HC 05 10 12 15 20 3.head 3.theap 4.tail BACKUP LEFTOVERS [........bat]$ ls 21 2100.tail 2102.tail 2104.tail 2113.tail 2115.tail 2121.tail 2124.tail So file seems gone