aboutsummaryrefslogtreecommitdiff
path: root/src/backend/executor
Commit message (Collapse)AuthorAge
...
* Hi,Bruce Momjian1998-04-06
| | | | | | | | | | | | | | | | | | | | | | 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
* The following uuencoded, gzip'd file will ...Bruce Momjian1998-03-30
| | | | | | | | | | | 1. Remove the char2, char4, char8 and char16 types from postgresql 2. Change references of char16 to name in the regression tests. 3. Rename the char16.sql regression test to name.sql. 4. Modify the regression test scripts and outputs to match up. Might require new regression.{SYSTEM} files... Darren King
* There's a patch attached to fix gcc 2.8.x warnings, except for theBruce Momjian1998-03-30
| | | | | | | | | | | | | | | | | | | | | | | | 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
* I started adding the Having Clause and it works quite fine forBruce Momjian1998-03-30
| | | | | | | | | | | | | | | | | | | | | | | | 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
* ExecReScan for MergeJoin.Vadim B. Mikheev1998-02-27
| | | | | Marked inner tuple now is copied into mergestate->mj_MarkedTupleSlot - no more tricks arround ttc_shouldfree.
* Check SELECT permissions in subqueries.Vadim B. Mikheev1998-02-27
|
* execScan.c: in the end of scan projInfo->pi_slot must beVadim B. Mikheev1998-02-26
| | | | | | | | return, not a slot returned from access method (they have different TupleDesc and MergeJoin node was broken). nodeIndexscan.c: index_markpos()/index_restrpos() call index-specific mark/restr funcs and are in use now (instead of IndexScanMarkPosition()/ExecIndexRestrPos()).
* pgindent run before 6.3 release, with Thomas' requested changes.Bruce Momjian1998-02-26
|
* ExecReScan for Unique & Sort nodes.Vadim B. Mikheev1998-02-23
|
* First step done,Marc G. Fournier1998-02-21
| | | | | | | | | | | | | | | | | | | below is the patch to have views to override the permission checks for the accessed tables. Now we can do the following: CREATE VIEW db_user AS SELECT usename, usesysid, usecreatedb, usetrace, usecatupd, '**********'::text as passwd, valuntil FROM pg_user; REVOKE ALL ON pg_user FROM public; REVOKE ALL ON db_user FROM public; GRANT SELECT ON db_user TO public;
* Fix for InitPlan-s: have to copy subselect' result tuple.Vadim B. Mikheev1998-02-19
|
* New nodeGroup.c code uses own copy of first tuple in a group.Vadim B. Mikheev1998-02-18
| | | | Free memory after comparison in nodeUnique.c
* Fix from Vadim for simple-minded case SELECT 1 WHERE 1 IN (SELECT 1)Thomas G. Lockhart1998-02-18
| | | | used in regression tests. No longer core dumps.
* Support for subselects.Vadim B. Mikheev1998-02-13
| | | | | | | ExecReScan for nodeAgg, nodeHash, nodeHashjoin, nodeNestloop and nodeResult. Fixed ExecReScan for nodeMaterial. Get rid of #ifdef INDEXSCAN_PATCH. Get rid of ExecMarkPos and ExecRestrPos in nodeNestloop.
* Goodbye register keyword. Compiler knows better.Bruce Momjian1998-02-11
|
* Pass around typmod as int16.Bruce Momjian1998-02-10
|
* Pass attypmod through to executor by adding to Var and Resdom.Bruce Momjian1998-02-10
|
* atttypmod now -1.Bruce Momjian1998-02-07
|
* Inline fastgetattr and others so data access does not use functionBruce Momjian1998-01-31
| | | | calls.
* Reversed out group by patch.Bruce Momjian1998-01-27
|
* From: Darren King <darrenk@insightdist.com>Marc G. Fournier1998-01-26
| | | | | | | | | I have always been under the impression that NULL is not equal to NULL and that NULL is not equal to anything else either. If this is the case, then this patch is correct. If NULL _is_ equal to NULL, then I think there are other problems in the Group By logic.
* getpid/pid cleanupBruce Momjian1998-01-25
|
* Parser cleanup.Bruce Momjian1998-01-20
| | | | Add lock to i386 asm.
* Fix for SELECT INTO TABLE for varchar().Bruce Momjian1998-01-19
|
* New pg_attribute.atttypmod for type-specific information likeBruce Momjian1998-01-16
| | | | | | | | | | | varchar length. Cleans up code so attlen is always length. Removed varchar() hack added earlier. Will fix bug in selecting varchar() fields, and varchar() can be variable length.
* Temporary varchar patch.Bruce Momjian1998-01-16
|
* Fix for aggreg problem and fmgr.c compile problems.Bruce Momjian1998-01-15
|
* Fix:Marc G. Fournier1998-01-15
| | | | | | | | | | nodeAgg.c: WARN -> NOTICE for elog parse_oper.c: was created after patch for fmgr_info, so function call wrong scan.c: regenerated for i386_solaris using flex 2.5.4 gethostname.c: required prototype for gethostname() function config.h.in: create prototype for isinfo() function isinf.c: "fake" isinf() under i386_solaris using fpclass() call...
* Thank god for searchable mail archives.PostgreSQL Daemon1998-01-15
| | | | | | | | | Patch by: wieck@sapserv.debis.de (Jan Wieck) One of the design rules of PostgreSQL is extensibility. And to follow this rule means (at least for me) that there should not only be a builtin PL. Instead I would prefer a defined interface for PL implemetations.
* Remove Query->qry_aggs and qry_numaggs and replace with Query->hasAggs.Bruce Momjian1998-01-15
| | | | | | | | | 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;
* Cleanup of prototypes. FIx for PQtrace start/stop several times.Bruce Momjian1998-01-14
|
* Some *very* major changes by darrenk@insightdist.com (Darren King)Marc G. Fournier1998-01-13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | ========================================== What follows is a set of diffs that cleans up the usage of BLCKSZ. As a side effect, the person compiling the code can change the value of BLCKSZ _at_their_own_risk_. By that, I mean that I've tried it here at 4096 and 16384 with no ill-effects. A value of 4096 _shouldn't_ affect much as far as the kernel/file system goes, but making it bigger than 8192 can have severe consequences if you don't know what you're doing. 16394 worked for me, _BUT_ when I went to 32768 and did an initdb, the SCSI driver broke and the partition that I was running under went to hell in a hand basket. Had to reboot and do a good bit of fsck'ing to fix things up. The patch can be safely applied though. Just leave BLCKSZ = 8192 and everything is as before. It basically only cleans up all of the references to BLCKSZ in the code. If this patch is applied, a comment in the config.h file though above the BLCKSZ define with warning about monkeying around with it would be a good idea. Darren darrenk@insightdist.com (Also cleans up some of the #includes in files referencing BLCKSZ.) ==========================================
* Goodbye ABORT. Hello ERROR for all errors.Bruce Momjian1998-01-07
|
* Change elog(WARN) to elog(ERROR) and elog(ABORT).Bruce Momjian1998-01-05
|
* Fix for count(*), aggs with views and multiple tables and sum(3).Bruce Momjian1998-01-04
|
* Change some mallocs to palloc.Bruce Momjian1997-12-29
|
* UNION work for UNION ALL and other union stuff.Bruce Momjian1997-12-27
|
* Fix for select 1=1 or 2=2, select 1=1 and 2=2, and select sum(2+2).Bruce Momjian1997-12-22
|
* Major cleanout of PORTNAME variables from Makefiles...bound to screw upMarc G. Fournier1997-12-20
| | | | some of the ports...
* Remove Existential, and ifdef out generate_fjoin. Neither did anything.Bruce Momjian1997-12-18
|
* First pass through, of many to come, towards making the whole sourceMarc G. Fournier1997-12-17
| | | | | | tree "non-PORTNAME" dependent. Technically, anything that is PORTNAME dependent should be able to be derived at compile time, through configure or through gcc
* Rename pg_plan and pg_eval to be more meaningful.Bruce Momjian1997-12-11
|
* Rename heap_destroyr to heap_destroy, heap_destroy to heap_destroy_with_catalog.Bruce Momjian1997-11-28
|
* Rename heap_create to heap_create_and_catatlog, rename heap_creatr to ↵Bruce Momjian1997-11-28
| | | | heap_create().
* Cleaups of comments.Bruce Momjian1997-11-27
|
* Make parser functions static where possible.Bruce Momjian1997-11-26
|
* Cleanup up include files.Bruce Momjian1997-11-26
|
* Break parser functions into smaller files, group together.Bruce Momjian1997-11-25
|
* Remove tqual.h includes not needed.Bruce Momjian1997-11-24
|
* Remove unused files.Bruce Momjian1997-11-21
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-20 19:36:02 +0000