summaryrefslogtreecommitdiff
path: root/src/test/regress
Commit message (Collapse)AuthorAgeFilesLines
* Communicate PGPORT and PGHOST via environment, not command linePeter Eisentraut2000-10-021-11/+25
|
* Honor $(SHELL) when invoking pg_regress.Tom Lane2000-10-021-3/+3
|
* Fix silly typo that prevented resultmap from being honored byTom Lane2000-10-021-2/+2
| | | | pg_regress.
* Fix quoting bugPeter Eisentraut2000-10-011-3/+3
|
* Fix test orderPeter Eisentraut2000-10-011-7/+11
|
* Please apply the following patch to fix problems with the AIX portBruce Momjian2000-09-291-0/+42
| | | | | | | | | | | | | | and the fmgr redesign. It makes the homebrewn dl*() functions for more recent Versions of AIX obsolete by using the system dl*() functions instead. It also fixes the expected file for the horology regression test. Please regenerate configure from configure.in, I don't have the environment/time. Andreas
* Subselects in FROM clause, per ISO syntax: FROM (SELECT ...) [AS] alias.Tom Lane2000-09-291-1/+1
| | | | | | | | | (Don't forget that an alias is required.) Views reimplemented as expanding to subselect-in-FROM. Grouping, aggregates, DISTINCT in views actually work now (he says optimistically). No UNION support in subselects/views yet, but I have some ideas about that. Rule-related permissions checking moved out of rewriter and into executor. INITDB REQUIRED!
* New unified regression test driver, test/regress makefile cleanup,Peter Eisentraut2000-09-2910-172/+811
| | | | | add "check" and "installcheck" targets, straighten out make variable naming of host_os, host_cpu, etc.
* Cygwin doesn't have DST before 1970 eitherPeter Eisentraut2000-09-281-0/+1
|
* Tweak resultmap so that geometry regress test selects the right comparisonTom Lane2000-09-241-1/+1
| | | | | file on LinuxPPC, which is identified by config.guess as powerpc-unknown-linux-gnu (not ...-gnulibc1).
* Add check of 'SET DateStyle TO DEFAULT'.Tom Lane2000-09-222-0/+3
|
* Implement differentiation between CURRENT_USER and SESSION_USER as per SQL.Peter Eisentraut2000-09-191-3/+3
| | | | | | There is still no effective difference but it will kick in once setuid functions exist (not included here). Make old getpgusername() alias for current_user.
* Variant horology resultfiles are inconsistent with the test, again.Tom Lane2000-09-151-14/+60
|
* Reimplement LIKE/ESCAPE as operators so that indexscan optimizationTom Lane2000-09-151-2/+2
| | | | | can still work, per recent discussion on pghackers. Correct some bugs in ILIKE implementation.
* Move a few specific tests to isolate homogenous type tests intoThomas G. Lockhart2000-09-1410-258/+257
| | | | | | | | | regression tests for specific types, and move a few others to the cross-type "horology" test. Rearrange the test order slightly, and move the abstime test to the "parallel safe" area. Hand-patch the results for "1947" and for "solaris", so those may not be exactly correct.
* First cut at full support for OUTER JOINs. There are still a few looseTom Lane2000-09-1215-498/+734
| | | | | ends to clean up (see my message of same date to pghackers), but mostly it works. INITDB REQUIRED!
* Update expected/horology-no-DST-before-1970.out for new horology test.Tom Lane2000-09-121-0/+42
| | | | There are still two out-of-date variants for horology; shame shame.
* Add regression tests for date, time, and time with time zone types.Thomas G. Lockhart2000-09-129-1/+512
| | | | | | Modify date->timestamp conversion to use mktime(). This should do better than before around Daylight Savings Time transitions.
* This patch implements a different "relkind"Bruce Momjian2000-09-122-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | for views. Views are now have a "relkind" of RELKIND_VIEW instead of RELKIND_RELATION. Also, views no longer have actual heap storage files. The following changes were made 1. CREATE VIEW sets the new relkind 2. The executor complains if a DELETE or INSERT references a view. 3. DROP RULE complains if an attempt is made to delete a view SELECT rule. 4. CREATE RULE "_RETmytable" AS ON SELECT TO mytable DO INSTEAD ... 1. checks to make sure mytable is empty. 2. sets the relkind to RELKIND_VIEW. 3. deletes the heap storage files. 5. LOCK myview is not allowed. :) 6. the regression test type_sanity was changed to account for the new relkind value. 7. CREATE INDEX ON myview ... is not allowed. 8. VACUUM myview is not allowed. VACUUM automatically skips views when do the entire database. 9. TRUNCATE myview is not allowed. THINGS LEFT TO THINK ABOUT o pg_views o pg_dump o pgsql (\d \dv) o Do we really want to be able to inherit from views? o Is 'DROP TABLE myview' OK? -- Mark Hollomon
* Irix fix:Bruce Momjian2000-09-121-0/+5
| | | | | | | | | | | | | The regression tests abstime, horology, int2, int4, and tinterval fail by default. They will pass if comparison is made to one of the variant expected/*.out files. (A related problem is that the geometry test fails. This seems to be just a matter of FP precision but more rigorous inspection is needed. No existing expected/geometry-*.out variant matches.) Pete Forman
* Fix relative path references so that make knowns which dependencies referPeter Eisentraut2000-08-313-12/+13
| | | | | to one another. Sort out builddir vs srcdir variable namings. Remove some now obsoleted make variables.
* This is mostly the same as an earlier patch IBruce Momjian2000-08-294-0/+33
| | | | | | | | | | | | | | | | | | | didn't hear anything about, but which would have broken with the function manager changes anyway. Well, this patch checks that a unique constraint of some form (unique or pk) is on the referenced columns of an FK constraint and that the columns in the referencing table exist at creation time. The former is to move closer to SQL compatibility and the latter is in answer to a bug report. I also added a basic check of this functionality to the alter table and foreign key regression tests. Stephan Szabo sszabo@bigpanda.com
* This file seems not to have been updated for the mostTom Lane2000-08-261-2/+2
| | | | recent change to geometry.sql.
* GetAttributeByName and GetAttributeByNum should be declared to returnTom Lane2000-08-241-3/+3
| | | | Datum, not char*, for portability's sake.
* First pass at integrating BIT and BIT VARYING code from Adriaan Joubert.Tom Lane2000-08-211-4/+6
| | | | | | | Update functions to new-style fmgr, make BIT and VARBIT be binary- equivalent, add entries to allow these types to be btree indexed, correct a few bugs. BIT/VARBIT are now toastable, too. NOTE: initdb forced due to catalog updates.
* Forgot to update the regression test output.Thomas G. Lockhart2000-08-071-16/+340
|
* Implement LIKE/ESCAPE. Change parser to use like()/notlike()Thomas G. Lockhart2000-08-061-8/+101
| | | | | | | | | | | | | | | | | | | | rather than the "~~" operator; this made it easy to add ESCAPE features. Implement ILIKE, NOT ILIKE, and the ESCAPE clause for them. afaict this is not MultiByte clean, but lots of other stuff isn't either. Fix up underlying support code for LIKE/NOT LIKE. Things should be faster and does not require internal string copying. Update regression test to add explicit checks for LIKE/NOT LIKE/ILIKE/NOT ILIKE. Remove colon and semi-colon operators as threatened in 7.0. Implement SQL99 COMMIT/AND NO CHAIN. Throw elog(ERROR) on COMMIT/AND CHAIN per spec since we don't yet support it. Implement SQL99 CREATE/DROP SCHEMA as equivalent to CREATE DATABASE. This is only a stopgap or demo since schemas will have another implementation soon. Remove a few unused production rules to get rid of warnings which crept in on the last commit. Fix up tabbing in some places by removing embedded spaces.
* Convert inet-related functions to new fmgr style. I have also taken itTom Lane2000-08-031-1/+1
| | | | | | | | on myself to do something about the non-self-consistency of the inet comparison functions. The results are probably still semantically wrong (inet and cidr should have different comparison semantics, I think) but at least the boolean operators now agree with each other and with the sort order of indexes on inet/cidr.
* Type lztext is toast.Tom Lane2000-07-301-2/+2
| | | | | | | (Sorry, couldn't help it...) Removed type filename as well, since it's unused and probably useless. INITDB FORCED, because pg_rewrite columns are now plain text again.
* Convert all remaining geometric operators to new fmgr style. ThisTom Lane2000-07-303-57/+61
| | | | | | | | allows fixing problems with operators that expected to be able to return a NULL, such as the '#' line-segment-intersection operator that tried to return NULL when the two segments don't intersect. (See, eg, bug report from 1-Nov-99 on pghackers.) Fix some other bugs in passing, such as backwards comparison in path_distance().
* PATH and POLYGON datatypes are now TOASTable. Associated functionsTom Lane2000-07-291-2/+3
| | | | | updated to new fmgr style. Deleted hoary old functions for compatibility with pre-6.1 representations of these datatypes.
* Add int2-vs-int8 comparison operators. These are now necessary becauseTom Lane2000-07-282-0/+33
| | | | | | | the planner may try to generate them as a result of transitivity of the existing int2-vs-int4 and int4-vs-int8 operators. In fact, it is now necessary that mergejoinable cross-datatype operators form closed sets. Add an opr_sanity regress test to detect missing operators.
* Unset locale variables before running regression tests. (All of them!)Peter Eisentraut2000-07-234-10/+16
| | | | Don't do config.status substitutions into the regression test makefile.
* Further cleanup of array behavior. Slice assignments to arrays withTom Lane2000-07-232-21/+45
| | | | | | | | | | | varlena elements work now. Allow assignment to previously-nonexistent subscript position to extend array, but only for 1-D arrays and only if adjacent to existing positions (could do more if we had a way to represent nulls in arrays, but I don't want to tackle that now). Arrange for assignment of NULL to an array element in UPDATE to be a no-op, rather than setting the entire array to NULL as it used to. (Throwing an error would be a reasonable alternative, but it's never done that...) Update regress test accordingly.
* Add an opr_sanity check for misdefined aggregates that have transitionTom Lane2000-07-182-0/+20
| | | | | | type different from input type but are expecting ExecAgg to insert the first non-null input as the starting transition value. This has always been verboten, but wasn't checked for until now...
* Revise aggregate functions per earlier discussions in pghackers.Tom Lane2000-07-1710-257/+124
| | | | | | | | | | | There's now only one transition value and transition function. NULL handling in aggregates is a lot cleaner. Also, use Numeric accumulators instead of integer accumulators for sum/avg on integer datatypes --- this avoids overflow at the cost of being a little slower. Implement VARIANCE() and STDDEV() aggregates in the standard backend. Also, enable new LIKE selectivity estimators by default. Unrelated change, but as long as I had to force initdb anyway...
* Hmm. I didn't expect a change since I hadn't added tests for the newBruce Momjian2000-07-161-1/+1
| | | | | | | stuff, but fixing the bug that existed in reporting the constraint name changes the error line. Patch to expected output enclosed. Stephan Szabo
* Implement nested block comments in the backend and in psql.Thomas G. Lockhart2000-07-142-1/+55
| | | | | | | | | | | | | | Include updates for the comment.sql regression test. Implement SET SESSION CHARACTERISTICS and SET DefaultXactIsoLevel. Implement SET SESSION CHARACTERISTICS TRANSACTION COMMIT and SET AutoCommit in the parser only. Need to add code to actually do something. Implement WITHOUT TIME ZONE type qualifier. Define SCHEMA keyword, along with stubbed-out grammar. Implement "[IN|INOUT|OUT] [varname] type" function arguments in parser only; INOUT and OUT throws an elog(ERROR). Add PATH as a type-specific token, since PATH is in SQL99 to support schema resource search and resolution.
* Fix typo, from Keith ParksPeter Eisentraut2000-07-131-2/+2
|
* Fix handling of pre-existing LD_LIBRARY_PATH, from Keith ParksPeter Eisentraut2000-07-091-2/+2
|
* Another round of those unportable config/build changes :-/Peter Eisentraut2000-07-091-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Add option to build with OpenSSL out of the box. Fix thusly exposed bit rot. Although it compiles now, getting this to do something useful is left as an exercise. * Fix Kerberos options to defer checking for required libraries until all the other libraries are checked for. * Change default odbcinst.ini and krb5.srvtab path to PREFIX/etc. * Install work around for Autoconf's install-sh relative path anomaly. Get rid of old INSTL_*_OPTS variables, now that we don't need them anymore. * Use `gunzip -c' instead of g?zcat. Reportedly broke on AIX. * Look for only one of readline.h or readline/readline.h, not both. * Make check for PS_STRINGS cacheable. Don't test for the header files separately. * Disable fcntl(F_SETLK) test on Linux. * Substitute the standard GCC warnings set into CFLAGS in configure, don't add it on in Makefile.global. * Sweep through contrib tree to teach makefiles standard semantics. ... and in completely unrelated news: * Make postmaster.opts arbitrary options-aware. I still think we need to save the environment as well.
* Backend makefile cleanup. make maintainer-clean is now completelyPeter Eisentraut2000-07-061-2/+2
| | | | | | | | | | | | | | | functional. Handle include file installation in src/include/Makefile genbki.sh improvements: Don't substitute anything by config.status, instead pass in AWK and CPP through environment. Change calling convention to support named output files, so we get to see error messages on stderr. Rename bootstrap template files and install them into PREFIX/share. Update initdb to that effect and other readability improvements in initdb.
* Update textin() and textout() to new fmgr style. This is just phaseTom Lane2000-07-051-2/+3
| | | | | one of updating the whole text datatype, but there are so dang many calls of these two routines that it seems worth a separate commit.
* Make the regression tests safe for TOAST.Tom Lane2000-07-054-8/+8
|
* New resultmap for Alpha, from Ryan KirkpatrickBruce Momjian2000-07-051-0/+1
|
* In the attache is new (correct) version. I add TZ (timezone) supportBruce Momjian2000-07-031-32/+32
| | | | | | | for to_char() too. Karel
* Attached is a new patch which addresses this problem. (oids inBruce Momjian2000-07-022-454/+454
| | | | | | regression tests). Chris Bitmead
* Back out Karels to_char changes.Bruce Momjian2000-07-011-32/+32
|
* In the attache is new to_date()/to_timestamp() version.Bruce Momjian2000-07-011-32/+32
| | | | | | | | | | | | Now the to_timestamp() support WW,W,J,SSSS,DDD conversion from strings and the am/pm bug is fixed, the to_char() use week-of-year (WW) full compatible with Oracle. This patch update relevant regress-tests and docs too. Karel ~ ~
* Cleaned up PL/pgSQL build. Fixed a couple of copyandpaste'os in thePeter Eisentraut2000-06-201-2/+2
| | | | | interfaces and interfaces/odbc make files. Adjusted regression test driver to start building and installing in the top level directory.
View Lorry Controller Status