- 05 8月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
it is now only mergejoin.
-
- 24 7月, 1998 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
Everyone using an [NOT] EXISTS subquery will have noticed that already. The bug is in "subselect.c" in the function "SS_process_sublinks()". Here the whole function as it *SHOULD BE*: Stephan
-
- 21 7月, 1998 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 19 7月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
now. Here some tested features, (examples included in the patch): 1.1) Subselects in the having clause 1.2) Double nested subselects 1.3) Subselects used in the where clause and in the having clause simultaneously 1.4) Union Selects using having 1.5) Indexes on the base relations are used correctly 1.6) Unallowed Queries are prevented (e.g. qualifications in the having clause that belong to the where clause) 1.7) Insert into as select 2) Queries using the having clause on view relations also work but there are some restrictions: 2.1) Create View as Select ... Having ...; using base tables in the select 2.1.1) The Query rewrite system: 2.1.2) Why are only simple queries allowed against a view from 2.1) ? 2.2) Select ... from testview1, testview2, ... having...; 3) Bug in ExecMergeJoin ?? Regards Stefan
-
- 18 7月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 15 7月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
members to be clearer. Fix cost computation for these.
-
- 16 6月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 15 4月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 14 4月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 06 4月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
Attached you'll find a (big) patch that fixes make dep and make depend in all Makefiles where I found it to be appropriate. It also removes the dependency in Makefile.global for NAMEDATALEN and OIDNAMELEN by making backend/catalog/genbki.sh and bin/initdb/initdb.sh a little smarter. This no longer requires initdb.sh that is turned into initdb with a sed script when installing Postgres, hence initdb.sh should be renamed to initdb (after the patch has been applied :-) ) This patch is against the 6.3 sources, as it took a while to complete. Please review and apply, Cheers, Jeroen van Vianen
-
- 01 4月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 31 3月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
sequential scans! (I think it will also work with hash, index, etc but I did not check it out! I made some High level changes which should work for all access methods, but maybe I'm wrong. Please let me know.) Now it is possible to make queries like: select s.sname, max(p.pid), min(p.pid) from part p, supplier s where s.sid=p.sid group by s.sname having max(pid)=6 and min(pid)=1 or avg(pid)=4; Having does not work yet for queries that contain a subselect statement in the Having clause, I'll try to fix this in the next days. If there are some bugs, please let me know, I'll start to read the mailinglists now! Now here is the patch against the original 6.3 version (no snapshot!!): Stefan
-
- 16 3月, 1998 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 26 2月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 13 2月, 1998 1 次提交
-
-
由 Vadim B. Mikheev 提交于
of some global variables to support subselects and calls union_planner(). Calls to SS_replace_correlation_vars() and SS_process_sublinks() in query_planner() before planning. Get rid of #ifdef INDEXSCAN_PATCH in createplan.c.
-
- 10 2月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 21 1月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 16 1月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
Pass List* of Aggregs into executor, and create needed array there. No longer need to double-processs Aggregs with second copy in Query. Fix crash when doing: select sum(x+1) from test where 1 > 0;
-
- 15 1月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 14 1月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 08 1月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 05 1月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 29 12月, 1997 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 27 12月, 1997 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 24 12月, 1997 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 22 12月, 1997 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 20 12月, 1997 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Marc G. Fournier 提交于
some of the ports...
-
- 19 12月, 1997 2 次提交
-
-
由 Marc G. Fournier 提交于
Makefile.global. End result, if all goes well, should allow for much easier porting, since there will no longer be a concept of a "port". Most, if not everything, *should* be determined by configure, or by the compiler itself. Still work to be done though :)
-
由 Bruce Momjian 提交于
-
- 18 12月, 1997 4 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 26 11月, 1997 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 22 11月, 1997 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 25 9月, 1997 1 次提交
-
-
由 Vadim B. Mikheev 提交于
-