[Info-ingres] Compression weighs heavy on my defaults.

[Paul White]

--repeat at intervals.
That was pretty clever Geraint.

I tried it on a larger table...
create table digits (v varchar(1));
insert into digits values ('0'), ('1'), ('2'), ('3'), ('4'), ('5'), ('6'),
('7'), ('8'), ('9');
create table millions as select a.v + b.v + c.v + d.v + e.v + f.v
from digits a, digits b, digits  c, digits  d, digits e, digits f;
alter table millions add column b ingresdate not null default 'now';
select count(*) from millions where b = date('now'); 
select count(*) from millions where b = date('now'); 
select * from millions where v1 like '%00000';


-----Original Message-----
From: info-ingres-bounces at lists.planetingres.org
[mailto:info-ingres-bounces at lists.planetingres.org] On Behalf Of
geraint.jones at ndph.ox.ac.uk
Sent: Tuesday, 17 October 2017 8:12 PM
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Compression weighs heavy on my defaults.

On Tuesday, October 17, 2017 at 10:58:14 AM UTC+1, Roy Hann wrote:
> Surprises during testing are acceptable
> (to me). Every day is a school day.


Here's another interesting feature discovered after adding a column. It
certainly surprised me for a while...

create table my_table(a integer);
insert into my_table values(1),(2),(3);
alter table my_table add column b ingresdate not null default 'now';
select * from my_table; --repeat at intervals.
_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
http://lists.planetingres.org/mailman/listinfo/info-ingres