hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-08 23:07:39 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • b4def32439 Include some new code for outer joins. Disabled by default, but enable by including the following in your Makefile.custom: CFLAGS+= -DENABLE_OUTER_JOINS -DEXEC_MERGEJOINDEBUG Thomas G. Lockhart 1999-02-23 07:46:42 +00:00
  • 449020f782 Put in explicit checks for implicit index name lengths. Put in hooks for outer joins by passing a few parameters back and forth in function calls. May not be close to working yet. Thomas G. Lockhart 1999-02-23 07:44:44 +00:00
  • 03d5c070f0 Modify the outer join placeholder code with something closer to working code. Works here, but not completely implemented past this point. Thomas G. Lockhart 1999-02-23 07:42:41 +00:00
  • 8f0a76f012 Bring debugging print statement declarations up to date. Comment-out the #undef default declarations to allow the parameters to be set on the compiler command line. Thomas G. Lockhart 1999-02-23 07:39:40 +00:00
  • 889c1530c9 Add constants for outer join states in executor. Thomas G. Lockhart 1999-02-23 07:37:31 +00:00
  • 25cccc05aa Fix typos in comments. Thomas G. Lockhart 1999-02-23 07:36:31 +00:00
  • 6d73a8c0cb Add first code to help with outer joins. Enable by defining CFLAGS+= -DENABLE_OUTER_JOINS -DEXEC_MERGEJOINDEBUG in your Makefile.custom Thomas G. Lockhart 1999-02-23 07:35:09 +00:00
  • 97287e1d13 Fix typo in comment. Thomas G. Lockhart 1999-02-23 07:33:09 +00:00
  • e587f202e4 Update error messages with more consistant format. Thomas G. Lockhart 1999-02-23 07:31:02 +00:00
  • 4335a3779b Add many new test cases. Thomas G. Lockhart 1999-02-23 07:30:05 +00:00
  • dfdb2e5fb0 Remove non-portable queries by replacing getpgusername() with a constant string. Thomas G. Lockhart 1999-02-23 07:29:19 +00:00
  • 4aa0e645e2 First tests using JOIN syntax. Thomas G. Lockhart 1999-02-23 07:27:13 +00:00
  • 348ab94822 Rearrange order of subdirectory creation to help generate parse.h file early enough to use in nodes/. Try to be more complete for rules on generating parse.h, but it still does not work any better than before. Should be able to make correctly if parser/gram.y is updated even without a "make clean" but so far not there yet. Thomas G. Lockhart 1999-02-23 07:24:08 +00:00
  • 1e70c1fe5d comments cleanup. Bruce Momjian 1999-02-22 19:55:44 +00:00
  • 7fe29ecefc comment cleanup. Bruce Momjian 1999-02-22 19:40:10 +00:00
  • 01ec673cba ifdef out append(). Bruce Momjian 1999-02-22 17:29:57 +00:00
  • 9aa7e899dc Ok. I found an align problem in lobj that might not appear other than Solaris/sparc. Please apply included patches to src/backend/storage/large_object/inv_api.c and try again. (These are Bruce Momjian 1999-02-22 16:46:43 +00:00
  • bcfdc9df04 Repair some pretty serious problems in dynahash.c and shared memory space allocation. It's a wonder we have not seen bug reports traceable to this area ... it's quite clear that the routine dir_realloc() has never worked correctly, for example. Tom Lane 1999-02-22 06:16:57 +00:00
  • ceb233ed11 more cleanup Bruce Momjian 1999-02-22 06:08:48 +00:00
  • 1ed5cbbfd8 Final optimizer cleanups. Bruce Momjian 1999-02-22 05:26:58 +00:00
  • 47dd11bdd0 rename pgsql to postgres in regression. Bruce Momjian 1999-02-22 02:08:32 +00:00
  • e23623584f change pgsql to postgres Bruce Momjian 1999-02-22 02:06:38 +00:00
  • e73d417105 fix compile problem. Bruce Momjian 1999-02-22 01:57:50 +00:00
  • 8c3e8a8a0e From: Tatsuo Ishii <t-ishii@sra.co.jp> Marc G. Fournier 1999-02-21 03:49:55 +00:00
  • 1efa3f4228 Document postmaster's -N switch. Tom Lane 1999-02-21 03:17:31 +00:00
  • 13abdde2b9 Document configure's --with-maxbackends switch. Fix a few small typos. Tom Lane 1999-02-21 03:16:29 +00:00
  • ae4a40dc26 From: Michael Meskes <Michael_Meskes@topmail.de> Marc G. Fournier 1999-02-21 03:02:35 +00:00
  • 23c30246d7 pathkeys.c cleanup. Bruce Momjian 1999-02-21 01:55:03 +00:00
  • 9d197856dd Rearrange handling of MAXBACKENDS a little bit. The default setting of MAXBACKENDS is now 1024, since all it's costing is about 32 bytes of memory per array slot. configure's --with-maxbackends switch now controls DEF_MAXBACKENDS which is simply the default value of the postmaster's -N switch. Thus, the out-of-the-box configuration will still limit you to 64 backends, but you can go up to 1024 backends simply by restarting the postmaster with a different -N switch --- no rebuild required. Tom Lane 1999-02-21 01:41:55 +00:00
  • 75cccd0ad3 pathkeys fixes Bruce Momjian 1999-02-20 19:02:43 +00:00
  • 0ff2733355 Update pathkeys comparison function. Bruce Momjian 1999-02-20 18:01:02 +00:00
  • 148ec3b1d8 update pathkey description. Bruce Momjian 1999-02-20 16:32:35 +00:00
  • 9188aab758 add pathkeys description. Bruce Momjian 1999-02-20 16:28:20 +00:00
  • 67fd67f53a another rename of optimizer Bruce Momjian 1999-02-20 15:27:42 +00:00
  • bf6636baa6 From: Michael Meskes <Michael_Meskes@topmail.de> Marc G. Fournier 1999-02-20 07:01:08 +00:00
  • 3eb22085b5 OOPS ... Perl5 interface to PQsetdbLogin was actually calling PQsetdb ... Tom Lane 1999-02-19 23:27:17 +00:00
  • 4c31393135 Reorder startup ops so that if preallocation of semas fails, postmaster will release whatever it did get before dying. Tom Lane 1999-02-19 07:10:48 +00:00
  • e77b630cf0 Allow maximum number of backends to be set at configure time (--with-maxbackends). Add a postmaster switch (-N backends) that allows the limit to be reduced at postmaster start time. (You can't increase it, sorry to say, because there are still some fixed-size arrays.) Grab the number of semaphores indicated by min(MAXBACKENDS, -N) at postmaster startup, so that this particular form of bogus configuration is exposed immediately rather than under heavy load. Tom Lane 1999-02-19 06:06:39 +00:00
  • 612b8434e4 optimizer cleanup Bruce Momjian 1999-02-19 05:18:06 +00:00
  • 8ab72a38df optimizer cleanup Bruce Momjian 1999-02-19 02:05:20 +00:00
  • 61f40ac3f2 Fix parens typo reported by wmt@thi.com (Bill Tonkin). Thomas G. Lockhart 1999-02-19 01:58:52 +00:00
  • 1902e8d098 Fix SGML markup from last content changes. Thomas G. Lockhart 1999-02-19 01:57:08 +00:00
  • cd38f08598 rename optimizer file name Bruce Momjian 1999-02-18 19:58:53 +00:00
  • b4e7510e09 Enable bushy and right-hand queries by default. Bruce Momjian 1999-02-18 06:01:11 +00:00
  • 65ccd1039a Enable bushy plans by default. Bruce Momjian 1999-02-18 05:26:34 +00:00
  • e78662d879 optimizer cleanup Bruce Momjian 1999-02-18 04:55:54 +00:00
  • d977ff7b52 more optimizer cleanups Bruce Momjian 1999-02-18 04:45:36 +00:00
  • 63393bdf90 Produce a more specific error message when backend sees EOF on client connection. Tom Lane 1999-02-18 01:13:26 +00:00
  • 31cce21fb0 Fix bushy plans. Cleanup. Bruce Momjian 1999-02-18 00:49:48 +00:00
  • c82ca4c158 Re-enable bushy plans. Vadim want them. Bruce Momjian 1999-02-16 00:41:03 +00:00
  • cd550c7672 Update optimizer readme. Bruce Momjian 1999-02-15 22:19:01 +00:00
  • 390d5e9f14 regprocin should accept '-' signifying InvalidOid, for symmetry with regprocout. Tom Lane 1999-02-15 16:29:32 +00:00
  • e6bf7b4d93 rename Bruce Momjian 1999-02-15 05:56:07 +00:00
  • 56bb23a8fe optimizer rename Bruce Momjian 1999-02-15 05:50:02 +00:00
  • 50034a852d optimizer rename Bruce Momjian 1999-02-15 05:28:10 +00:00
  • c5449d5354 otherrels is now unjoined_rels Bruce Momjian 1999-02-15 05:21:12 +00:00
  • 82682ff31f optimizer rename Bruce Momjian 1999-02-15 03:59:28 +00:00
  • ba2883b264 Remove duplicate geqo functions, and more optimizer cleanup Bruce Momjian 1999-02-15 03:22:37 +00:00
  • 944d3c395e Replace non-idiomatic nconc(x, lcons(y, NIL)) with lappend(x, y). Tom Lane 1999-02-15 02:04:58 +00:00
  • dec354ca97 Fix a number of places that made faulty assumptions about what is_opclause will accept. Tom Lane 1999-02-15 01:06:59 +00:00
  • 5500039843 Fix optimizer coredump with unary-operator WHERE clauses. A test case is: create table linetab (x line); select * from linetab where ?| x; which coredumps in 6.4.2 and current sources. Tom Lane 1999-02-14 22:24:25 +00:00
  • d8b482be7c optimizer cleanup. Bruce Momjian 1999-02-14 05:27:12 +00:00
  • 808a6df065 optimizer rename. Bruce Momjian 1999-02-14 05:14:15 +00:00
  • 61aa825876 Optimizer rename. Bruce Momjian 1999-02-14 04:57:02 +00:00
  • 6724a50787 Change my-function-name-- to my_function_name, and optimizer renames. Bruce Momjian 1999-02-13 23:22:53 +00:00
  • c569f2a068 Remove equivalence between datetime and float8. Wasn't worth the trouble especially since datetime has too many reserved values to be a reasonable mapping. Thomas G. Lockhart 1999-02-13 06:00:52 +00:00
  • 2a6faa5368 This patch fixes some problems in date handling for atypical dates. Here is a summary: Be more careful to check input string lengths as well as values when deciding whether a field is a year field. Assume *anything* longer than 2 digits (if it isn't a special-case doy) is a valid year. This should fix the "Y1K" and "Y10K" problems pointed out by Massimo recently. Check usage of BC to require a positive-valued year; before just used it to flip the sign of the year without checking. This led to problems near year zero. Allow a 5 digit "concatenated date" of 2 digit year plus day of year. Do 2->4 digit year correction for 6 and 5 digit "concatenated dates". Somehow forgot this originally. Guess not many folks use it... Move common macros to dt.h. Thomas G. Lockhart 1999-02-13 05:59:34 +00:00
  • 8c3fff7337 Fix offset of one for date_part(timespan) when given arguments of decade, century, or millenium. Thomas G. Lockhart 1999-02-13 05:34:24 +00:00
  • ba71b81966 Remove equivalence between datetime and float8. Led to nothin' but trouble. Thomas G. Lockhart 1999-02-13 05:25:54 +00:00
  • a97683bc6c Change #if FALSE to #if NOT_USED to avoid port problems. Fix problem with date_part() for timespan (had an offset of one) when given decade, century, and millenium as arguments. Reported by Ricardo J.C.Coelho. Thomas G. Lockhart 1999-02-13 04:25:01 +00:00
  • 910fe5891e Add routines to convert between int8 and text/varchar types. Change #if FALSE to #if NOT_USED to avoid port problems. Fix up pg_indent weirdness with function argument declarations. Thomas G. Lockhart 1999-02-13 04:22:34 +00:00
  • 02e85e7e5f Add routines to convert between int8 and text/varchar types. Fix output type for int8out, but I don't think it matters. Thomas G. Lockhart 1999-02-13 04:19:54 +00:00
  • 7a724a0231 Include some Julian date declarations to share between various date/time modules. Used to be in dt.c I think. Thomas G. Lockhart 1999-02-13 04:15:33 +00:00
  • 0925e5f5f9 Re-enable arch-dev.sgml now that it has new information from Stefan's Master's Thesis. Thomas G. Lockhart 1999-02-13 03:54:51 +00:00
  • e4000add1b Require complete tagging in emacs hints at bottom of file. Thomas G. Lockhart 1999-02-13 03:54:00 +00:00
  • 478e5beef1 Include chapter on SQL language elements (keywords, etc). Should merge with or complement Stefan's Master's Thesis intro to SQL. Thomas G. Lockhart 1999-02-13 03:52:46 +00:00
  • af2a0dfd65 Describe the date/time parsing rules. Include specific information on the supported time zones. It's a really big table, so maybe it should go into an appendix instead. Thomas G. Lockhart 1999-02-13 03:42:10 +00:00
  • 0c30f18fbe Add Stefan Simkovics' Master's Thesis. Thomas G. Lockhart 1999-02-13 03:38:46 +00:00
  • ba8808b2a6 Substitute great info from Stefan Simkovics' Master's Thesis. Still need to add some acknowledgements at the top of the doc; already have full info in the bibliography but since the original is being spread across the existing docs we should also mention things locally. Thomas G. Lockhart 1999-02-13 03:37:54 +00:00
  • dcded41895 Minor markup changes for the recent TEMP TABLE info. Docs should build now... Thomas G. Lockhart 1999-02-13 03:33:50 +00:00
  • b106421473 More complete info from Oliver Elphick. Thomas G. Lockhart 1999-02-13 03:32:43 +00:00
  • ad4b27ac3f Optimizer cleanup. Bruce Momjian 1999-02-12 17:25:05 +00:00
  • c0d17c7aee JoinPath -> NestPath for nested loop. Bruce Momjian 1999-02-12 06:43:53 +00:00
  • 3fdb9bb9c7 Fix optimizer and make faster. Bruce Momjian 1999-02-12 05:57:08 +00:00
  • 55d0465009 optimizer update Bruce Momjian 1999-02-12 02:37:52 +00:00
  • 847da1a1ee Remove Perl module's unnecessary dependence on libpq-int.h. Tom Lane 1999-02-11 23:25:16 +00:00
  • 34ecb9d850 Optimizer cleanups. Bruce Momjian 1999-02-11 21:05:28 +00:00
  • c873fcdaf4 Optimizer cleanup. Bruce Momjian 1999-02-11 17:21:51 +00:00
  • 8dc2209f71 optimizer cleanup Bruce Momjian 1999-02-11 17:03:17 +00:00
  • 6de25f09b1 Optimizer cleanup. Bruce Momjian 1999-02-11 17:00:49 +00:00
  • 4ea3f728e9 More optimization. Bruce Momjian 1999-02-11 16:09:41 +00:00
  • d244df95db More optimizer speedups. Bruce Momjian 1999-02-11 14:59:09 +00:00
  • 129543e22d optimizer cleanup Bruce Momjian 1999-02-11 05:29:08 +00:00
  • dbd80c97f4 Optimizer fix for samekeys() and cost fixes for longer optimizer keys. Bruce Momjian 1999-02-11 04:08:44 +00:00
  • 403b3eff79 Include <varargs.h> on SunOS. (Does any other platform need it??) Tom Lane 1999-02-11 01:36:55 +00:00
  • 9dbb0efb0b Optmizer cleanup Bruce Momjian 1999-02-10 21:02:50 +00:00
  • d5a785cd5a Update find_typedefs for bsdi 4.0. Bruce Momjian 1999-02-10 17:14:32 +00:00
  • f859c81c18 Rename Path.keys to Path.pathkeys. Too many 'keys' used for other things. Bruce Momjian 1999-02-10 03:52:54 +00:00
  • 318e593f03 Rename Temp to Noname for noname tables. Bruce Momjian 1999-02-09 17:03:14 +00:00
  • 78511d8fe9 Optimizer fix for samekeys. Bruce Momjian 1999-02-09 06:30:45 +00:00