aboutsummaryrefslogtreecommitdiff
path: root/src/backend/executor
Commit message (Collapse)AuthorAge
...
* Allow index use with OR clauses.Bruce Momjian1998-08-01
|
* Use Snapshot in heap access methods.Vadim B. Mikheev1998-07-27
|
* makeTargetEntry cleanup.Bruce Momjian1998-07-20
|
* Cleanup makeTargetEntry and remove internal.c.Bruce Momjian1998-07-20
|
* Cleanup Name usage.Bruce Momjian1998-07-20
|
* Remove un-needed psort close.Bruce Momjian1998-07-19
|
* 1) Queries using the having clause on base tables should work wellBruce Momjian1998-07-19
| | | | | | | | | | | | | | | | | | | | | | | | | 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
* Conditionally execute Junk filter only when ORDER BY of columnsBruce Momjian1998-07-19
| | | | not in target list.
* Fix for Group ReScan suggested by Vadim.Bruce Momjian1998-07-16
|
* Patch for ReScan of Group.Bruce Momjian1998-07-16
|
* Allow UNION/UNION ALL in subselects.Bruce Momjian1998-07-15
|
* Fix explain for union and inheritance. Rename Append structureBruce Momjian1998-07-15
| | | | members to be clearer. Fix cost computation for these.
* Remove un-needed braces around single statements.Bruce Momjian1998-06-15
|
* Fix macros that were not properly surrounded by parens or braces.Bruce Momjian1998-06-15
|
* Remove fork()/exec() and only do fork(). Small cleanups.Bruce Momjian1998-05-29
|
* Fix for drop database and junk filters.Bruce Momjian1998-05-26
|
* From: David Hartwig <daveh@insightdist.com>Marc G. Fournier1998-05-21
| | | | | Here is a patch to remove the requirement that ORDER/GROUP BY clause identifiers be included in the target list.
* Allow cancel from client of backend query. Change some int variablesBruce Momjian1998-05-19
| | | | to bool's.
* This patch...Bruce Momjian1998-04-27
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1. Removes the unnecessary "#define AbcRegProcedure 123"'s from pg_proc.h. 2. Changes those #defines to use the names already defined in fmgr.h. 3. Forces the make of fmgr.h in backend/Makefile instead of having it made as a dependency in access/common/Makefile *hack*hack*hack* 4. Rearranged the #includes to a less helter-skelter arrangement, also changing <file.h> to "file.h" to signify a non-system header. 5. Removed "pg_proc.h" from files where its only purpose was for the #defines removed in item #1. 6. Added "fmgr.h" to each file changed for completeness sake. Turns out that #6 was not necessary for some files because fmgr.h was being included in a roundabout way SIX levels deep by the first include. "access/genam.h" ->"access/relscan.h" ->"utils/rel.h" ->"access/strat.h" ->"access/skey.h" ->"fmgr.h" So adding fmgr.h really didn't add anything to the compile, hopefully just made it clearer to the programmer. S Darren.
* Re-apply Darren's char2-16 removal code.Bruce Momjian1998-04-26
|
* Inline some small functions called for every row.Bruce Momjian1998-04-24
|
* Cleanup up code.Bruce Momjian1998-04-13
|
* Back out char2-char16 removal. Add later.Bruce Momjian1998-04-07
|
* 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
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-29 06:40:07 +0000