121 lines
3.2 KiB
Plaintext
121 lines
3.2 KiB
Plaintext
EXPR_STR: select c1 from t3 where c1 like '|||%';
|
|
SELECTIVITY = 0.000100072
|
|
|
|
EXPR_STR: select c1 from t3 where c1 like '11';
|
|
SELECTIVITY = 0.0001
|
|
|
|
EXPR_STR: select c1 from t3 where c1 > '|||||||||||||||||||2';
|
|
SELECTIVITY = 0.0001
|
|
|
|
EXPR_STR: select c1 from t3 where c1 = '11';
|
|
SELECTIVITY = 0.0001
|
|
|
|
EXPR_STR: select c1 from t3 where c1 != '11';
|
|
SELECTIVITY = 0.9999
|
|
|
|
EXPR_STR: select c1 from t3 where c1 > '11';
|
|
SELECTIVITY = 0.986844
|
|
|
|
EXPR_STR: select c1 from t3 where c1 < '11';
|
|
SELECTIVITY = 0.0131557
|
|
|
|
EXPR_STR: select c1 from t3 where c1 < '|||||||||||||||||||2';
|
|
SELECTIVITY = 1
|
|
|
|
EXPR_STR: select c1 from t3 where c1 > '|||||||||||||||||||2';
|
|
SELECTIVITY = 0.0001
|
|
|
|
EXPR_STR: select c1 from t3 where c1 > '||||||||||||||||||||';
|
|
SELECTIVITY = 0.0001
|
|
|
|
EXPR_STR: select c1 from t3 where c1 > '20150305123445555';
|
|
SELECTIVITY = 0.974024
|
|
|
|
EXPR_STR: select c1 from t3 where c1 > '20150305123445555';
|
|
SELECTIVITY = 0.974024
|
|
|
|
EXPR_STR: select c1 from t3 where c1 like '11';
|
|
SELECTIVITY = 0.0001
|
|
|
|
EXPR_STR: select c1 from t3 where c1 like 'abc';
|
|
SELECTIVITY = 0.0001
|
|
|
|
EXPR_STR: select c1 from t3 where c1 like '|||%';
|
|
SELECTIVITY = 0.000100072
|
|
|
|
EXPR_STR: select c1 from t3 where c1 like 123;
|
|
SELECTIVITY = 0.333333
|
|
|
|
EXPR_STR: select c1 from t3 where c1 like 's%123' escape 's';
|
|
SELECTIVITY = 0.0001
|
|
|
|
EXPR_STR: select c1 from t3 where c1 like '123';
|
|
SELECTIVITY = 0.0001
|
|
|
|
EXPR_STR: select c1 from t3 where c1 like '%123';
|
|
SELECTIVITY = 0.333333
|
|
|
|
EXPR_STR: select c1 from t3 where c1 like '%%';
|
|
SELECTIVITY = 0.333333
|
|
|
|
EXPR_STR: select c1 from t3 where c1 like '%||||%';
|
|
SELECTIVITY = 0.333333
|
|
|
|
EXPR_STR: select c1 from t3 where c1 like '%|||';
|
|
SELECTIVITY = 0.333333
|
|
|
|
EXPR_STR: select c1 from t3 where c1 > '20150305123445555';
|
|
SELECTIVITY = 0.887209
|
|
|
|
EXPR_STR: select c1 from t3 where c1 < '20150305123445555';
|
|
SELECTIVITY = 0.112791
|
|
|
|
EXPR_STR: select c1 from t3 where c1 < '99991231235959999';
|
|
SELECTIVITY = 1
|
|
|
|
EXPR_STR: select c1 from t3 where c1 > '99991231235959999';
|
|
SELECTIVITY = 0.0001
|
|
|
|
EXPR_STR: select c1 from t3 where c1 < '10000101000000111';
|
|
SELECTIVITY = 0.0001
|
|
|
|
EXPR_STR: select c1 from t3 where c1 > '10000101000000111';
|
|
SELECTIVITY = 1
|
|
|
|
EXPR_STR: select c1 from t3 where c1 > '10000101000000111' and c1 < '99991231235959999';
|
|
SELECTIVITY = 0.9999
|
|
|
|
EXPR_STR: select c1 from t3 where c1 > '20150305123445555' and c1 < '10000101000000111';
|
|
SELECTIVITY = 0
|
|
|
|
EXPR_STR: select c1 from t3 where c1 < '20150305123445555' and c1 > '99991231235959999';
|
|
SELECTIVITY = 0
|
|
|
|
EXPR_STR: select c1 from t3 where c1 > '20150305123445555' and c1 < '50120805123445666';
|
|
SELECTIVITY = 0.332938
|
|
|
|
EXPR_STR: select c1 from t3 where c1 > '20150305123445555' and c1 < '20150305123446666';
|
|
SELECTIVITY = 0
|
|
|
|
EXPR_STR: select c1 from t3 where c1 = '20150305123445555';
|
|
SELECTIVITY = 0.0001
|
|
|
|
EXPR_STR: select c1 from t3 where c1 != '20150305123445555';
|
|
SELECTIVITY = 0.9999
|
|
|
|
EXPR_STR: select c1 from t3 where c1 like '20150305123445555';
|
|
SELECTIVITY = 0.0001
|
|
|
|
EXPR_STR: select c1 from t3 where c1 like '1000%';
|
|
SELECTIVITY = 0.000100007
|
|
|
|
EXPR_STR: select c1 from t3 where c1 like '9999%';
|
|
SELECTIVITY = 0.000100002
|
|
|
|
EXPR_STR: select c1 from t3 where c1 like '1%';
|
|
SELECTIVITY = 0.0994233
|
|
|
|
EXPR_STR: select c1 from t3 where c1 like '99%';
|
|
SELECTIVITY = 0.000223633
|
|
|