Cosette icon indicating copy to clipboard operation
Cosette copied to clipboard

Feature request: Avoid useless repetition in counter examples

Open beta-ziliani opened this issue 5 years ago • 0 comments

The following example (slightly modified from the one in the page) generates tables with lots of repetition, which could be easily avoided by truncation.

schema employee(eid:int, age:int, ??);
schema payroll(eid:int, salary:int, ??);        

table uw_emp(employee);
table uw_payroll(payroll);

query q1                
`select distinct e.eid as eid 
 from uw_emp e, uw_payroll p
 where e.eid = p.eid`;

query q2                
`select distinct e1.eid as eid 
 from uw_emp e1, uw_emp e2, uw_payroll p 
 where e1.eid = e2.eid and e1.eid = e2.eid`;

verify q1 q2;

Result:

Table uw_payroll

eid salary ??
1 0 0
1 0 0
1 0 0
1 0 0
1 0 0
1 0 0
1 0 0
1 0 0
1 0 0
1 0 0
1 0 0
1 0 0

Table uw_emp

eid age ??
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0

beta-ziliani avatar Jul 30 '19 18:07 beta-ziliani