- 05 Aug, 1999 2 commits
-
-
Tom Lane authored
constants, not only string constants, at parse time. Get rid of parser_typecast2(), which is bogus and redundant...
-
Bruce Momjian authored
-
- 03 Aug, 1999 1 commit
-
-
Tom Lane authored
use Autoconf-approved method of testing for predefined symbols, and move it down to where we know what compiler to run and how to run it.
-
- 02 Aug, 1999 5 commits
-
-
Tom Lane authored
in MVCC environment. I do not trust this until Vadim says it's OK...
-
Michael Meskes authored
-
Tom Lane authored
(it should just call the given operator, not look up an = operator). Fix intltsel() so that all numeric data types are converted to double before trying to estimate where the given comparison value is in the known range of column values. intltsel() still needs work, or replacement, for non-numeric data types ... but for nonintegral numeric types it should now be delivering reasonable estimates.
-
Marc G. Fournier authored
back out last...
-
Marc G. Fournier authored
testing somethign...
-
- 01 Aug, 1999 5 commits
-
-
Bruce Momjian authored
-
Bruce Momjian authored
configure.in to determine if a system is ELF or not. Note that some of the tests earlier may be redundant but I took the safest route. D'Arcy J.M. Cain
-
Bruce Momjian authored
-
Tom Lane authored
neqsel now behave as per my suggestions in pghackers a few days ago. selectivity for < > <= >= should work OK for integral types as well, but still need work for nonintegral types. Since these routines have never actually executed before :-(, this may result in some significant changes in the optimizer's choices of execution plans. Let me know if you see any serious misbehavior. CAUTION: THESE CHANGES REQUIRE INITDB. pg_statistic table has changed.
-
Tom Lane authored
every time I tweak the optimizer...
-
- 31 Jul, 1999 3 commits
- 30 Jul, 1999 11 commits
-
-
Tom Lane authored
-
Bruce Momjian authored
update temp tables with this setting.
-
Tom Lane authored
logic in indxpath.c, avoid generation of redundant indexscan paths for the same relation and index.
-
Marc G. Fournier authored
There is one section that changed, concernign startup...the rest is just changes for v6.5->v6.5.1, so relatively harmless
-
Marc G. Fournier authored
v6.6's HISTORY file should reflect changes that went into all previous releases, including v6.5.1 ...
-
Marc G. Fournier authored
just testing a script...
-
Bruce Momjian authored
-
Marc G. Fournier authored
Nothing changed, just testing cvslog ...
-
Bruce Momjian authored
-
Tom Lane authored
for example in the regression test database, try select * from tenk1 t1, tenk1 t2 where t1.unique1 = t2.unique2; 6.5 has this same bug ...
-
Tom Lane authored
-
- 29 Jul, 1999 3 commits
-
-
Bruce Momjian authored
-
Tom Lane authored
so that Case works in WHERE join clauses. Temporary patch --- this routine is one of many that ought to be changed to use centralized expression-tree- walking logic.
-
Tom Lane authored
detected this omission before. Miscellaneous other cleanups.
-
- 28 Jul, 1999 4 commits
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-
Tom Lane authored
IN and NOT IN operators. Rewrite grotty implementation of IN-list parsing ... look Ma, no global variable ...
-
Bruce Momjian authored
-
- 27 Jul, 1999 3 commits
-
-
Tom Lane authored
rels that the inner path needs to join to, but it was only checking for the first one. Failure could only have been observed with an OR-clause that mentions 3 or more tables, and then only if the bogus path was actually selected as cheapest ...
-
Tom Lane authored
be picked for one of the complex joins in rules test ... leading to a different output ordering ...
-
Tom Lane authored
optimizer rather than parser. This has many advantages, such as not getting fooled by chance uses of operator names ~ and ~~ (the operators are identified by OID now), and not creating useless comparison operations in contexts where the comparisons will not actually be used as indexquals. The new code also recognizes exact-match LIKE and regex patterns, and produces an = indexqual instead of >= and <=. This change does NOT fix the problem with non-ASCII locales: the code still doesn't know how to generate an upper bound indexqual for non-ASCII collation order. But it's no worse than before, just the same deficiency in a different place... Also, dike out loc_restrictinfo fields in Plan nodes. These were doing nothing useful in the absence of 'expensive functions' optimization, and they took a considerable amount of processing to fill in.
-
- 26 Jul, 1999 2 commits
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- 25 Jul, 1999 1 commit
-
-
Tom Lane authored
to index_selectivity so that it can be handed an indexqual clause list rather than a bunch of assorted derivative data.
-