README

application/octet-stream

Download

README for multibyte regression test.
CREATED BY Tatsuo Ishii 1998/7/22
CONTAINS: Set of tests for multibyte supporting extentions for PostgreSQL. 
LAST UPDATE BY Ayush Parashar 2005/July/7
ENHANCEMENTS 2005/July/7:
  1. - Include extensive multi-byte regression tests for copy command.
     - Uses following complete character sets and encoding types for testing: 
       "big5 gbk uhc gb18030 euc_cn latin8 iso_8859_6 iso_8859_7 euc_kr euc_jp" 
  2. Include help and usage for various tests.
  3. Include cleanup function, to remove the log files and database objects that 
     have been created.
REQUIREMENTS:
 - Installed PostgreSQL
 - The location of bin directory of PostgreSQL should be included in "PATH" variable.
TESTED ON:
 - 2.6.10-1.741_FC3.rootsmp GNU/Linux &
 - 5.10 Generic SunOS

USAGE:
./mbregress.sh --help
./mbregress.sh test
./mbregress.sh clean

MULTI-BYTE CHARACTER SET & CLIENT ENCODING TESTS FOR COPY COMMAND:
HIGHLIGHT:
- Uses complete character sets for: big5 gbk uhc gb18030 euc_cn latin8 
  iso_8859_6 iso_8859_7 euc_kr euc_jp
- Expected output produced using "iconv" command.

1. Creates tables in database with unicode encoding.
2. Sets client encoding to a particular type.
3. Uploads complete character sets to database using "copy from" command.
4. Sets client encoding to unicode.
5. Download complete character sets from database using "copy to" command.
6. Compares this result to expected output. 

HELP:
1. ./mbregress.sh test
  - Creates database and tables required for the tests.
      * Databases created: euc_cn, euc_jp, euc_kr, euc_tw, mule_internal, 
        unicode, unitest
      * Tables created: big5_ce_copy, euc_cn_ce_copy, euc_jp_ce_copy, 
        euc_kr_ce_copy, gb18030_ce_copy, gbk_ce_copy, iso_8859_6_ce_copy, 
        iso_8859_7_ce_copy, latin8_ce_copy, uhc_ce_copy [these tables created 
        in unitest database]
  - Uses scripts and data in ./sql directory, to produce output that is thrown 
    in ./results and compared with files in ./expected 
  - Differences are thrown in regression.diffs file
  - Logs related to database and table creation present in 
    file ./results/db_command.log
2. ./mbregress.sh clean
  - Cleans up the log files
  - Cleans up the database and tables created during the run 
    of "./mbregress.sh test"