Re: [Postgres-xc-developers] Query Planning bug ?

[Tomonari K. <kat...@po...>]

Hi,

I've tried regression test, but I could not
get right result.
Both patched and un-patched Postgres-XC get
same result, so I think my process is bad.

I run a gtm, a gtm_proxy, a coordinator, a datanode
in one server(CentOS6.4 x86_64 on VMWare),
and hit "make installcheck".

The configure option is [--enable-debug CFLAGS=""].
What is right way to run the regression test?

output is below.
---------------------------------------------------------
test tablespace ... ok
test boolean ... ok
test char ... ok
test name ... ok
test varchar ... ok
test text ... ok
test int2 ... ok
test int4 ... ok
test int8 ... ok
test oid ... ok
test float4 ... ok
test float8 ... ok
test bit ... ok
test numeric ... ok
test txid ... ok
test uuid ... ok
test enum ... FAILED
test money ... ok
test rangetypes ... ok
test strings ... ok
test numerology ... ok
test point ... ok
test lseg ... ok
test box ... ok
test path ... ok
test polygon ... ok
test circle ... ok
test date ... ok
test time ... ok
test timetz ... ok
test timestamp ... ok
test timestamptz ... ok
test interval ... ok
test abstime ... ok
test reltime ... ok
test tinterval ... ok
test inet ... ok
test macaddr ... ok
test tstypes ... ok
test comments ... ok
test geometry ... ok
test horology ... ok
test regex ... ok
test oidjoins ... ok
test type_sanity ... ok
test opr_sanity ... ok
test insert ... ok
test create_function_1 ... ok
test create_type ... ok
test create_table ... ok
test create_function_2 ... ok
test create_function_3 ... ok
test copy ... ok
test copyselect ... ok
test create_misc ... ok
test create_operator ... ok
test create_index ... FAILED
test create_view ... ok
test create_aggregate ... ok
test create_cast ... ok
test constraints ... FAILED
test triggers ... ok
test inherit ... FAILED
test create_table_like ... ok
test typed_table ... ok
test vacuum ... ok
test drop_if_exists ... ok
test sanity_check ... ok
test errors ... ok
test select ... ok
test select_into ... ok
test select_distinct ... ok
test select_distinct_on ... ok
test select_implicit ... ok
test select_having ... ok
test subselect ... ok
test union ... ok
test case ... ok
test join ... FAILED
test aggregates ... FAILED
test transactions ... ok
test random ... ok
test portals ... ok
test arrays ... FAILED
test btree_index ... ok
test hash_index ... ok
test update ... ok
test delete ... ok
test namespace ... ok
test prepared_xacts ... ok
test privileges ... FAILED
test security_label ... ok
test collate ... FAILED
test misc ... ok
test rules ... ok
test select_views ... ok
test portals_p2 ... ok
test foreign_key ... ok
test cluster ... ok
test dependency ... ok
test guc ... ok
test bitmapops ... ok
test combocid ... ok
test tsearch ... ok
test tsdicts ... ok
test foreign_data ... ok
test window ... ok
test xmlmap ... FAILED (test process exited with exit code 2)
test functional_deps ... FAILED (test process exited with exit code 2)
test advisory_lock ... FAILED (test process exited with exit code 2)
test json ... FAILED (test process exited with exit code 2)
test plancache ... FAILED (test process exited with exit code 2)
test limit ... FAILED (test process exited with exit code 2)
test plpgsql ... FAILED (test process exited with exit code 2)
test copy2 ... FAILED (test process exited with exit code 2)
test temp ... FAILED (test process exited with exit code 2)
test domain ... FAILED (test process exited with exit code 2)
test rangefuncs ... FAILED (test process exited with exit code 2)
test prepare ... FAILED (test process exited with exit code 2)
test without_oid ... FAILED (test process exited with exit code 2)
test conversion ... FAILED (test process exited with exit code 2)
test truncate ... FAILED (test process exited with exit code 2)
test alter_table ... FAILED (test process exited with exit code 2)
test sequence ... FAILED (test process exited with exit code 2)
test polymorphism ... FAILED (test process exited with exit code 2)
test rowtypes ... FAILED (test process exited with exit code 2)
test returning ... FAILED (test process exited with exit code 2)
test largeobject ... FAILED (test process exited with exit code 2)
test with ... FAILED (test process exited with exit code 2)
test xml ... FAILED (test process exited with exit code 2)
test stats ... FAILED (test process exited with exit code 2)
test xc_create_function ... FAILED (test process exited with exit code 2)
test xc_groupby ... FAILED (test process exited with exit code 2)
test xc_distkey ... FAILED (test process exited with exit code 2)
test xc_having ... FAILED (test process exited with exit code 2)
test xc_temp ... FAILED (test process exited with exit code 2)
test xc_remote ... FAILED (test process exited with exit code 2)
test xc_node ... FAILED (test process exited with exit code 2)
test xc_FQS ... FAILED (test process exited with exit code 2)
test xc_FQS_join ... FAILED (test process exited with exit code 2)
test xc_misc ... FAILED (test process exited with exit code 2)
test xc_triggers ... FAILED (test process exited with exit code 2)
test xc_trigship ... FAILED (test process exited with exit code 2)
test xc_constraints ... FAILED (test process exited with exit code 2)
test xc_copy ... FAILED (test process exited with exit code 2)
test xc_alter_table ... FAILED (test process exited with exit code 2)
test xc_sequence ... FAILED (test process exited with exit code 2)
test xc_prepared_xacts ... FAILED (test process exited with exit code 2)
test xc_notrans_block ... FAILED (test process exited with exit code 2)
test xc_limit ... FAILED (test process exited with exit code 2)
test xc_sort ... FAILED (test process exited with exit code 2)
test xc_returning ... FAILED (test process exited with exit code 2)
test xc_params ... FAILED (test process exited with exit code 2)
=========================
55 of 153 tests failed.
=========================