PostgreSQL 回归测试

   
   

    
    
 
     postgres@digoal-> ll -rt 
    
    
    
 
     total 1.2M 
    
    
    
 
     rwr-- 1 postgres postgres 579 Jun1003:29 standby_schedule  测试standby的调度配置, 其实就是调度sql里的文件名 
    
    
    
 
     2.3K serial_schedule  串行测试的调度配置 
    
    
    
 
     937 resultmap 不同的测试平台的结果映射文件，因为不同平台某些测试结果可能不相同，所以一个expected文件不能支持所有的平台。例如浮点数测试。 
    
    
    
 
     rwxrxrx 4.4K regressplans.sh 
    
    
    
 
     20K regressc 
    
    
    
 
     159 README 
    
    
    
 
     2.7K pg_regress_main1.6K pg_regressh 
    
    
    
 
     69K3.6K parallel_schedule 并行测试的调度配置 
    
    
    
 
     624Makefile 
    
    
    
 
     5.6KGNUmakefile 
    
    
    
 
     drwxrwxrwx24.0K38 output 
    
    
    
 
     drwxrwxrwx  input 
    
    
    
 
      data  一些测试数据 
    
   
   
   
   

    
    Sep71451 sql  测试用到的SQL
   
   
   
   

    
    drwxrwxr52 results  通过pg_regress调用目录中的脚本，得到的结果
   
   
   
   

    
     expected  执行目录中的文件对应的正确返回结果
   
   

   
   

    
    
 
     # ---------- 
    
    
    
 
     # src/test/regress/parallel_schedule 
    
    
    
 
     # 
    
    
    
 
     # By convention,we put no more than twenty tests in any one parallel group; 
    
    
    
 
     # this limits the number of connections needed to run the tests. 
    
    
    
 
     # ---------- 
    
   
   
   
   

    
    
 
     # run tablespace by itself,and first,because it forces a checkpoint; 
    
    
    
 
     # we'd prefer not to have checkpoints later in the tests because that 
    
    
    
 
     # interferes with crash-recovery testing. 
    
    
    
 
     test: tablespace 
    
    
    
 
       
    
    
    
 
     # The first group of parallel tests 
    
    
    
 
     test: boolean char name varchar text int2 int4 int8 oid float4 float8 bit numeric txid uuid enum money rangetypes pg_lsn regproc 
    
   
   

   
   

    
    # contrib/ltree/Makefile
   
   
   
   

    
     
   
   
   
   

    
    MODULE_big  ltree
   
   
   
   

    
    OBJS o ltree_opo lquery_opo _ltree_opo crc32o 
   
   
   
   

    
        ltxtquery_ioo ltxtquery_opo ltree_gisto _ltree_gisto
   
   
   
   

    
    PG_CPPFLAGS DLOWER_NODE
   
   
   
   

    
     
   
   
   
   

    
    EXTENSION DATA sql ltreesql
   
   
   
   

    
     
   
   
   
   

    
    REGRESS  ltree
   
   
   
   

    
     
   
   
   
   

    
    ifdef USE_PGXS
   
   
   
   

    
    PG_CONFIG  pg_config
   
   
   
   

    
    PGXS := $shell $PG_CONFIGpgxs)
   
   
   
   

    
    include $PGXSelse
   
   
   
   

    
    subdir ltree
   
   
   
   

    
    top_builddir ../..
   
   
   
   

    
    top_builddir)//Makefileglobal
   
   
   
   

    
    top_srcdircontrib-globalmk
   
   
   
   

    
    endif
   
   

   
   

    
    
 
     
 
      ) 
     
 
    
   
   
   
   

    
    或 
   
   

   
   

    
    global
   
   

   
   

    
    ifdef REGRESS
   
   
   
   

    
     
   
   
   
   

    
    # Select database to use for running the tests
   
   
   
   

    
    ifneq ($(USE_MODULE_DB),)
   
   
   
   

    
     REGRESS_OPTS += --dbname=$(CONTRIB_TESTDB_MODULE)
   
   
   
   

    
    else
   
   
   
   

    
     REGRESS_OPTS += --dbname=$(CONTRIB_TESTDB)
   
   
   
   

    
    endif
   
   
   
   

    
     
   
   
   
   

    
    # where to find psql for running the tests
   
   
   
   

    
    PSQLDIR = $(bindir)
   
   
   
   

    
     
   
   
   
   

    
    # When doing a VPATH build,must copy over the data files so that the
   
   
   
   

    
    # driver script can find them. We have to use an absolute path for
   
   
   
   

    
    # the targets,because otherwise make will try to locate the missing
   
   
   
   

    
    # files using VPATH,and will find them in $(srcdir),but the point
   
   
   
   

    
    # here is that we want to copy them from $(srcdir) to the build
   
   
   
   

    
    # directory.
   
   
   
   

    
     
   
   
   
   

    
    ifdef VPATH
   
   
   
   

    
    abs_builddirshell pwdtest_files_src wildcard $srcdirdata/*.data)
   
   
   
   

    
    test_files_build := $(patsubst $(srcdir)/%,$(abs_builddir)/%,$(test_files_src))
   
   
   
   

    
     
   
   
   
   

    
    all: $(test_files_build)
   
   
   
   

    
    $(test_files_build): $(abs_builddir)/%: $(srcdir)/%
   
   
   
   

    
        $(MKDIR_P) $(dir $@)
   
   
   
   

    
        ln -s $< $@
   
   
   
   

    
    endif # VPATH
   
   
   
   

    
     
   
   
   
   

    
    .PHONY: submake
   
   
   
   

    
    submake:
   
   
   
   

    
    ifndef PGXS
   
   
   
   

    
        $(MAKE) -C $(top_builddir)/src/test/regress pg_regress$(X)
   
   
   
   

    
    # against installed postmaster
   
   
   
   

    
    installcheck: submake $(REGRESS_PREP)
   
   
   
   

    
        $(pg_regress_installcheck) $(REGRESS_OPTS) $(REGRESS)
   
   
   
   

    
     
   
   
   
   

    
    ifdef PGXS
   
   
   
   

    
    check:
   
   
   
   

    
        @echo '"$(MAKE) check" is not supported.'
   
   
   
   

    
        @echo 'Do "$(MAKE) install",then "$(MAKE) installcheck" instead.'
   
   
   
   

    
    check: all submake $(REGRESS_PREP)
   
   
   
   

    
        $(pg_regress_check) --extra-install=$(subdir) $(REGRESS_OPTS) $(REGRESS)
   
   
   
   

    
    endif
   
   
   
   

    
    endif # REGRESS