ProviderMetaPartialUpdate1PostgreSQL and ProviderMetaPartialUpdate2PostgreSQL - FAIL
I use the latest Docker image for PostgreSQL: postgresql:11. The listed tests fail. Below information from ProviderMetaPartialUpdate1PostgreSQL is listed. For the second test, it is identical.
============= Provider Meta Partial 1 Update now testing: PostgreSQL =============
============= prov_test_common_setup() =============
Open connection string: HOST=localhost;PASSWORD=test1;USERNAME=test;DB_NAME=test
Connection now set up (database created)
Implementation missing: create_table_object() in ../libgda/gda-meta-struct-io.c line 399
Implementation missing: gda_meta_struct_load_from_xml_file() in ../libgda/gda-meta-struct-io.c line 110
Database object: testbigint
Database object: datetest
Database object: tstest
Database object: dummy
Database object: language
Database object: actor
Database object: film
depend on language
depend on language
Database object: film_actor
depend on actor
depend on film
Graph written to 'graph.dot'
Renderer SQL for PostgreSQL: CREATE TABLE testbigint (thebigint bigint NOT NULL) WITH OIDS
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _attributes (att_name string NOT NULL PRIMARY KEY, att_value string NOT NULL)
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _information_schema_catalog_name (catalog_name string NOT NULL PRIMARY KEY)
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _builtin_data_types (short_type_name string NOT NULL, full_type_name string NOT NULL PRIMARY KEY, gtype string, comments text, synonyms string, internal boolean NOT NULL)
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _element_types (specific_name string NOT NULL PRIMARY KEY, object_catalog string NOT NULL, object_schema string NOT NULL, object_name string NOT NULL, object_type string NOT NULL, data_type string, array_spec string, min_cardinality int, max_cardinality int)
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS __declared_fk (constraint_name string NOT NULL, table_catalog string NOT NULL, table_schema string NOT NULL, table_name string NOT NULL, column_name string NOT NULL, ref_table_catalog string NOT NULL, ref_table_schema string NOT NULL, ref_table_name string NOT NULL, ref_column_name string NOT NULL, ts timestamp, descr string, PRIMARY KEY (constraint_name, table_catalog, table_schema, table_name, column_name, ref_table_catalog, ref_table_schema, ref_table_name, ref_column_name))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _schemata (catalog_name string NOT NULL, schema_name string NOT NULL, schema_owner string, schema_internal boolean NOT NULL, schema_default boolean, PRIMARY KEY (catalog_name, schema_name))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _udt (udt_catalog string NOT NULL, udt_schema string NOT NULL, udt_name string NOT NULL, udt_gtype string, udt_comments text, udt_short_name string NOT NULL, udt_full_name string NOT NULL, udt_internal boolean NOT NULL, udt_owner string, PRIMARY KEY (udt_catalog, udt_schema, udt_name))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _domains (domain_catalog string NOT NULL, domain_schema string NOT NULL, domain_name string NOT NULL, data_type string, array_spec string, domain_gtype string NOT NULL, character_maximum_length int, character_octet_length int, collation_catalog string, collation_schema string, collation_name string, character_set_catalog string, character_set_schema string, character_set_name string, numeric_precision int, numeric_scale int, domain_default string, domain_comments text, domain_short_name string NOT NULL, domain_full_name string NOT NULL, domain_internal boolean NOT NULL, domain_owner string, PRIMARY KEY (domain_catalog, domain_schema, domain_name))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _tables (table_catalog string NOT NULL, table_schema string NOT NULL, table_name string NOT NULL, table_type string NOT NULL, is_insertable_into boolean, table_comments text, table_short_name string NOT NULL, table_full_name text NOT NULL, table_owner string, PRIMARY KEY (table_catalog, table_schema, table_name))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _collations (collation_catalog string NOT NULL, collation_schema string NOT NULL, collation_name string NOT NULL, collation_comments text, collation_short_name string NOT NULL, collation_full_name string NOT NULL, PRIMARY KEY (collation_catalog, collation_schema, collation_name))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _routines (specific_catalog string NOT NULL, specific_schema string NOT NULL, specific_name string NOT NULL, routine_catalog string, routine_schema string, routine_name string NOT NULL, routine_type string, return_type string, returns_set boolean NOT NULL, nb_args int NOT NULL, routine_body text, routine_definition text, external_name string, external_language string, parameter_style string, is_deterministic boolean, sql_data_access string, is_null_call boolean, routine_comments text, routine_short_name text NOT NULL, routine_full_name text NOT NULL, routine_owner string, PRIMARY KEY (specific_catalog, specific_schema, specific_name))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _udt_columns (udt_catalog string NOT NULL, udt_schema string NOT NULL, udt_name string NOT NULL, udt_column string NOT NULL, ordinal_position int NOT NULL, data_type string, array_spec string, character_maximum_length int, character_octet_length int, numeric_precision int, numeric_scale int, datetime_precision int, character_set_catalog string, character_set_schema string, character_set_name string, collation_catalog string, collation_schema string, collation_name string, PRIMARY KEY (udt_catalog, udt_schema, udt_name, udt_column))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _enums (udt_catalog string NOT NULL, udt_schema string NOT NULL, udt_name string NOT NULL, label string NOT NULL, ordinal_position int NOT NULL, PRIMARY KEY (udt_catalog, udt_schema, udt_name, label))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _views (table_catalog string NOT NULL, table_schema string NOT NULL, table_name string NOT NULL, view_definition text, check_option string, is_updatable boolean, PRIMARY KEY (table_catalog, table_schema, table_name))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _character_sets (character_set_catalog string NOT NULL, character_set_schema string NOT NULL, character_set_name string NOT NULL, default_collate_catalog string, default_collate_schema string, default_collate_name string, character_set_comments text, character_set_short_name string NOT NULL, character_set_full_name string NOT NULL, PRIMARY KEY (character_set_catalog, character_set_schema, character_set_name))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _triggers (trigger_catalog string NOT NULL, trigger_schema string NOT NULL, trigger_name string NOT NULL, event_manipulation string NOT NULL, event_object_catalog string NOT NULL, event_object_schema string NOT NULL, event_object_table string NOT NULL, action_statement text, action_orientation string NOT NULL, condition_timing string NOT NULL, trigger_comments text, trigger_short_name string NOT NULL, trigger_full_name string NOT NULL, PRIMARY KEY (trigger_catalog, trigger_schema, trigger_name, event_manipulation, event_object_catalog, event_object_schema, event_object_table))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _table_constraints (constraint_catalog string, constraint_schema string, constraint_name string NOT NULL, table_catalog string NOT NULL, table_schema string NOT NULL, table_name string NOT NULL, constraint_type string NOT NULL, check_clause text, is_deferrable boolean, initially_deferred boolean, PRIMARY KEY (constraint_name, table_catalog, table_schema, table_name))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _domain_constraints (constraint_catalog string, constraint_schema string, constraint_name string NOT NULL, domain_catalog string NOT NULL, domain_schema string NOT NULL, domain_name string NOT NULL, check_clause string, is_deferrable boolean, initially_deferred boolean, PRIMARY KEY (constraint_name, domain_catalog, domain_schema, domain_name))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _parameters (specific_catalog string NOT NULL, specific_schema string NOT NULL, specific_name string NOT NULL, ordinal_position int NOT NULL, parameter_mode string NOT NULL, parameter_name string, data_type string, array_spec string, PRIMARY KEY (specific_catalog, specific_schema, specific_name, ordinal_position))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _routine_columns (specific_catalog string NOT NULL, specific_schema string NOT NULL, specific_name string NOT NULL, column_name string NOT NULL, ordinal_position int, data_type string, array_spec string, PRIMARY KEY (specific_catalog, specific_schema, specific_name, column_name, ordinal_position))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _table_indexes (index_catalog string, index_schema string, index_name string NOT NULL, table_catalog string NOT NULL, table_schema string NOT NULL, table_name string NOT NULL, is_unique boolean, index_def string, index_type string, extra string, index_owner string, index_comments text, PRIMARY KEY (index_name, table_catalog, table_schema, table_name))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _columns (table_catalog string NOT NULL, table_schema string NOT NULL, table_name string NOT NULL, column_name string NOT NULL, ordinal_position int NOT NULL, column_default string, is_nullable boolean NOT NULL, data_type string, array_spec string, gtype string NOT NULL, character_maximum_length int, character_octet_length int, numeric_precision int, numeric_scale int, datetime_precision int, character_set_catalog string, character_set_schema string, character_set_name string, collation_catalog string, collation_schema string, collation_name string, extra string, is_updatable boolean, column_comments text, PRIMARY KEY (table_catalog, table_schema, table_name, column_name))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _referential_constraints (table_catalog string NOT NULL, table_schema string NOT NULL, table_name string NOT NULL, constraint_name string NOT NULL, ref_table_catalog string NOT NULL, ref_table_schema string NOT NULL, ref_table_name string NOT NULL, ref_constraint_name string NOT NULL, match_option string, update_rule string, delete_rule string, PRIMARY KEY (table_catalog, table_schema, table_name, constraint_name))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _index_column_usage (index_catalog string, index_schema string, index_name string NOT NULL, table_catalog string NOT NULL, table_schema string NOT NULL, table_name string NOT NULL, column_name string, column_expr string, ordinal_position int NOT NULL, PRIMARY KEY (index_name, table_catalog, table_schema, table_name, column_name, column_expr))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _key_column_usage (table_catalog string NOT NULL, table_schema string NOT NULL, table_name string NOT NULL, constraint_name string NOT NULL, column_name string NOT NULL, ordinal_position int NOT NULL, PRIMARY KEY (table_catalog, table_schema, table_name, constraint_name, column_name, ordinal_position))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _check_column_usage (table_catalog string NOT NULL, table_schema string NOT NULL, table_name string NOT NULL, constraint_name string NOT NULL, column_name string NOT NULL, PRIMARY KEY (table_catalog, table_schema, table_name, constraint_name, column_name))
Renderer SQL for SQLite: CREATE TABLE IF NOT EXISTS _view_column_usage (view_catalog string NOT NULL, view_schema string NOT NULL, view_name string NOT NULL, table_catalog string NOT NULL, table_schema string NOT NULL, table_name string NOT NULL, column_name string NOT NULL, PRIMARY KEY (view_catalog, view_schema, view_name, table_catalog, table_schema, table_name, column_name))
Updating the complete meta store...
Updating the meta store for table '_tables'
============= prov_test_common_clean() =============
Waiting a bit for the server to register the disconnection...
Test failed
--- stderr ---
** Message: 21:48:45.313: Creating database - step
** Message: 21:48:47.074: Opening connection
** Message: 21:48:47.075: Connection string: HOST=localhost;PASSWORD=test1;USERNAME=test;DB_NAME=test
** Message: 21:48:47.075: Auth string: USERNAME=test;PASSWORD=test1;
** (process:27724): WARNING **: 21:48:47.130: Could not setup database structure: relation "testbigint" already exists
-------
Edited by Pavlo Solntsev