- 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
-
- 29 5月, 1998 1 次提交
-
-
由 Thomas G. Lockhart 提交于
-
- 10 5月, 1998 1 次提交
-
-
由 Thomas G. Lockhart 提交于
-
- 01 4月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 31 3月, 1998 2 次提交
-
-
由 Bruce Momjian 提交于
yyerror ones from bison. It also includes a few 'enhancements' to the C programming style (which are, of course, personal). The other patch removes the compilation of backend/lib/qsort.c, as qsort() is a standard function in stdlib.h and can be used any where else (and it is). It was only used in backend/optimizer/geqo/geqo_pool.c, backend/optimizer/path/predmig.c, and backend/storage/page/bufpage.c > > Some or all of these changes might not be appropriate for v6.3, since we > > are in beta testing and since they do not affect the current functionality. > > For those cases, how about submitting patches based on the final v6.3 > > release? There's more to come. Please review these patches. I ran the regression tests and they only failed where this was expected (random, geo, etc). Cheers, Jeroen
-
由 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
-
- 26 2月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 10 2月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 07 2月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 21 1月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 20 1月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
Add lock to i386 asm.
-
- 19 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;
-
- 11 1月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 10 1月, 1998 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 05 1月, 1998 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 29 12月, 1997 3 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 27 12月, 1997 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 24 12月, 1997 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Thomas G. Lockhart 提交于
Add a few lines of test code playing with the unique flag for unions. Does not do much helpful yet.
-
- 16 12月, 1997 1 次提交
-
-
由 Thomas G. Lockhart 提交于
-
- 09 12月, 1997 1 次提交
-
-
由 Thomas G. Lockhart 提交于
Check for duplicate implicit index names and generate unique names.
-
- 05 12月, 1997 1 次提交
-
-
由 Thomas G. Lockhart 提交于
Implement PRIMARY KEY and UNIQUE clauses using indices.
-
- 26 11月, 1997 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 21 11月, 1997 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 31 10月, 1997 1 次提交
-
-
由 Thomas G. Lockhart 提交于
-
- 25 10月, 1997 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 16 10月, 1997 1 次提交
-
-
由 Vadim B. Mikheev 提交于
-
- 12 10月, 1997 1 次提交
-
-
由 Vadim B. Mikheev 提交于
-
- 19 9月, 1997 1 次提交
-
-
由 Bruce Momjian 提交于
-
- 18 9月, 1997 1 次提交
-
-
由 Vadim B. Mikheev 提交于
-
- 09 9月, 1997 2 次提交
-
-
由 Bruce Momjian 提交于
-
由 Bruce Momjian 提交于
-
- 08 9月, 1997 1 次提交
-
-
由 Bruce Momjian 提交于
Another PGINDENT run that changes variable indenting and case label indenting. Also static variable indenting.
-