scripts/report-processing/config.yaml - master - githubmirror/postgres-compatibility-tests

scripts/report-processing/config.yaml
465 строк21 KB
Timofey Koolin
fixed KIKIMR-19006, insert without columns name
03 окт 2023, 14:53
03 окт 2023, 14:53f05b1a3
convert:
  change_error_to_failure: True

tickets:
  - name: KIKIMR-18122 # PG error codes and text
    tests:
      golang-lib-pq:
        - TestCopySyntaxError
        - TestParseErrorInExtendedQuery
        - TestErrorOnExec
      python-psycopg2:
        - tests.test_errors.ErrorsTests.test_exception_class
        - tests.test_errors.ErrorsTests.test_exception_class_fallback

  - name: KIKIMR-18049 # Pg Auth error
    tests:
      golang-lib-pq:
        - TestErrorDuringStartup

  - name: KIKIMR-18119 # LISTEN Queries, alternative is not implemented yet : 267
    tests:
      golang-lib-pq:
        - TestConnListen
        - TestConnUnlisten
        - TestConnUnlistenAll
        - TestListenerFailedQuery
        - TestListenerListen
        - TestListenerReconnect
        - TestListenerUnlisten
        - TestListenerUnlistenAll
        - TestNotifyExtra

  - name: KIKIMR-18060 # SSL support
    tests:
      golang-lib-pq:
        - TestConnectorWithNoticeHandler_Simple
        - TestConnectorWithNotificationHandler_Simple
        - TestNewConnector_Connect
        - TestNewConnector_Driver
        - TestNewConnector_WorksWithOpenDB

  - name: KIKIMR-18120 # implicit cast params (pg_sleep)
    tests:
      golang-lib-pq:
        - TestContextCancelBegin
        - TestContextCancelExec
        - TestContextCancelQuery
        - TestIssue1046
        - TestStmtExecContext
        - TestStmtExecContext/context.Background
        - TestStmtExecContext/context.WithTimeout_exceeded
        - TestStmtExecContext/context.WithTimeout
        - TestStmtQueryContext
        - TestStmtQueryContext/context.Background
        - TestStmtQueryContext/context.WithTimeout_exceeded
        - TestStmtQueryContext/context.WithTimeout

  - name: YQL-16300 # SELECT USER. alternative is not implemented yet : 142
    tests:
      golang-lib-pq:
        - TestPgpass

  - name: KIKIMR-18125 # SET LOCAL search_path
    tests:
      golang-lib-pq:
        - TestIssue282

  - name: KIKIMR-18174 # SET time zone
    tests:
      golang-lib-pq:
        - TestMultipleSimpleQuery
        - TestTimestampWithTimeZone

  - name: KIKIMR-18147 # Information schema
    tests:
      golang-lib-pq:
        - TestMultipleResult

  - name: KIKIMR-18180 # Cancel process request by client command
    tests:
      golang-lib-pq:
        - TestQueryCancelRace

  - name: KIKIMR-18181 # Select generators, alternative is not implemented yet : 304
    tests:
      golang-lib-pq:
        - TestQueryCancelledReused
      python-psycopg2:
        - tests.test_cursor.NamedCursorTests.test_iter_named_cursor_default_itersize
        - tests.test_cursor.NamedCursorTests.test_iter_named_cursor_efficient
        - tests.test_cursor.NamedCursorTests.test_iter_named_cursor_itersize
        - tests.test_cursor.NamedCursorTests.test_iter_named_cursor_rownumber
        - tests.test_cursor.NamedCursorTests.test_named_cursor_stealing
        - tests.test_cursor.NamedCursorTests.test_scroll
        - tests.test_cursor.NamedCursorTests.test_scroll_named
        - tests.test_cursor.NamedCursorTests.test_stolen_named_cursor_close

  - name: KIKIMR-17958  # Begin/Commit wire tags
    tests:
      golang-lib-pq:
        - TestQuickClose

  - name: KIKIMR-18186  # select current_setting
    tests:
      golang-lib-pq:
        - TestTxOptions

  - name: KIKIMR-18179  # Support rollback
    tests:
      golang-lib-pq:
        - TestPing

  - name: YQL-16313  # DateRange type
    tests:
      python-psycopg2:
        - tests.test_types_extras.RangeCasterTestCase.test_adapt_date_range
        - tests.test_types_extras.RangeCasterTestCase.test_adapt_number_range
        - tests.test_types_extras.RangeCasterTestCase.test_adapt_numeric_range
        - tests.test_types_extras.RangeCasterTestCase.test_cast_date
        - tests.test_types_extras.RangeCasterTestCase.test_cast_empty
        - tests.test_types_extras.RangeCasterTestCase.test_cast_inf
        - tests.test_types_extras.RangeCasterTestCase.test_cast_null
        - tests.test_types_extras.RangeCasterTestCase.test_cast_numbers
        - tests.test_types_extras.RangeCasterTestCase.test_cast_timestamp
        - tests.test_types_extras.RangeCasterTestCase.test_cast_timestamptz

  - name: KIKIMR-18191  # Cannot find table 'db.[/local/pg_namespace]'
    tests:
      python-psycopg2:
        - tests.test_types_extras.RangeCasterTestCase.test_rang_weird_name
        - tests.test_types_extras.AdaptTypeTestCase.test_composite_namespace
        - tests.test_types_extras.AdaptTypeTestCase.test_composite_namespace_path
        - tests.test_types_extras.AdaptTypeTestCase.test_composite_not_found
        - tests.test_types_extras.AdaptTypeTestCase.test_composite_weird_name

  - name: KIKIMR-18073  # Tables without primary key
    tests:
      golang-lib-pq:
        - TestIssue186
      python-psycopg2:
        - tests.test_psycopg2_dbapi20.Psycopg2Tests.test_None
        - tests.test_connection.SignalTestCase.test_bug_551_no_returning
        - tests.test_connection.SignalTestCase.test_bug_551_returning
        - tests.test_cursor.NamedCursorTests.test_invalid_name
        - tests.test_cursor.NamedCursorTests.test_not_scrollable
        - tests.test_cursor.NamedCursorTests.test_scrollable
        - tests.test_connection.ConnectionTwoPhaseTests.test_cancel_fails_prepared
        - tests.test_connection.ConnectionTwoPhaseTests.test_recovered_xids
        - tests.test_connection.ConnectionTwoPhaseTests.test_status_after_recover
        - tests.test_connection.ConnectionTwoPhaseTests.test_tpc_commit
        - tests.test_connection.ConnectionTwoPhaseTests.test_tpc_commit_one_phase
        - tests.test_connection.ConnectionTwoPhaseTests.test_tpc_commit_recovered
        - tests.test_connection.ConnectionTwoPhaseTests.test_tpc_recover_non_dbapi_connection
        - tests.test_connection.ConnectionTwoPhaseTests.test_tpc_rollback
        - tests.test_connection.ConnectionTwoPhaseTests.test_tpc_rollback_one_phase
        - tests.test_connection.ConnectionTwoPhaseTests.test_tpc_rollback_recovered
        - tests.test_connection.ConnectionTwoPhaseTests.test_unparsed_roundtrip
        - tests.test_connection.ConnectionTwoPhaseTests.test_xid_construction
        - tests.test_connection.ConnectionTwoPhaseTests.test_xid_encoding
        - tests.test_connection.ConnectionTwoPhaseTests.test_xid_from_string
        - tests.test_connection.ConnectionTwoPhaseTests.test_xid_roundtrip
        - tests.test_connection.ConnectionTwoPhaseTests.test_xid_to_string
        - tests.test_connection.ConnectionTwoPhaseTests.test_xid_unicode
        - tests.test_connection.ConnectionTwoPhaseTests.test_xid_unicode_unparsed
        - tests.test_cursor.NamedCursorTests.test_withhold
        - tests.test_cursor.NamedCursorTests.test_withhold_autocommit
        - tests.test_cursor.NamedCursorTests.test_withhold_no_begin


  - name: KIKIMR-18275  # VariableSetStmt, not supported name
    tests:
      golang-lib-pq:
        - TestByteaOutputFormats
      python-psycopg2:
        - tests.test_connection.TransactionControlTests.test_idempotence_check
        - tests.test_connection.TransactionControlTests.test_mixing_session_attribs
        - tests.test_quote.QuotingTestCase.test_bytes
        - tests.test_quote.QuotingTestCase.test_koi8
        - tests.test_quote.QuotingTestCase.test_latin1

  - name: KIKIMR-18276  # SHOW, unrecognized configuration parameter
    tests:
      python-psycopg2:
        - tests.test_psycopg2_dbapi20.Psycopg2TPCTests.test_commit_in_tpc_fails
        - tests.test_psycopg2_dbapi20.Psycopg2TPCTests.test_rollback_in_tpc_fails
        - tests.test_psycopg2_dbapi20.Psycopg2TPCTests.test_tpc_begin
        - tests.test_psycopg2_dbapi20.Psycopg2TPCTests.test_tpc_begin_in_tpc_transaction_fails
        - tests.test_psycopg2_dbapi20.Psycopg2TPCTests.test_tpc_begin_in_transaction_fails
        - tests.test_psycopg2_dbapi20.Psycopg2TPCTests.test_tpc_commit_with_prepare
        - tests.test_psycopg2_dbapi20.Psycopg2TPCTests.test_tpc_commit_without_prepare
        - tests.test_psycopg2_dbapi20.Psycopg2TPCTests.test_tpc_rollback_with_prepare
        - tests.test_psycopg2_dbapi20.Psycopg2TPCTests.test_tpc_rollback_without_prepare
        - tests.test_psycopg2_dbapi20.Psycopg2TPCTests.test_xid
        - tests.test_connection.TransactionControlTests.test_set_default
        - tests.test_connection.TransactionControlTests.test_set_deferrable
        - tests.test_connection.TransactionControlTests.test_set_isolation_level
        - tests.test_connection.TransactionControlTests.test_set_isolation_level_str
        - tests.test_connection.TransactionControlTests.test_set_read_only
        - tests.test_connection.TransactionControlTests.test_setattr_deferrable
        - tests.test_connection.TransactionControlTests.test_setattr_read_only
        - tests.test_connection.TestEncryptPassword.test_encrypt_server
        - tests.test_quote.QuotingTestCase.test_unicode

  - name: KIKIMR-18998 # Status idle after commit
    tests:
      golang-lib-pq:
        - TestQuickClose
      python-psycopg2:
        - tests.test_with.WithConnectionTestCase.test_with_autocommit
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.testDictCursorWithNamedCursorFetchAll
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.testDictCursorWithNamedCursorFetchMany
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.testDictCursorWithNamedCursorFetchManyNoarg
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.testDictCursorWithNamedCursorFetchOne
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.testDictCursorWithNamedCursorIter
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.testDictCursorWithNamedCursorIterRowNumber
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.testDictCursorWithNamedCursorNotGreedy
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.testDictCursorWithPlainCursorFetchAll
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.testDictCursorWithPlainCursorFetchMany
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.testDictCursorWithPlainCursorFetchManyNoarg
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.testDictCursorWithPlainCursorFetchOne
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.testDictCursorWithPlainCursorIter
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.testDictCursorWithPlainCursorIterRowNumber
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.testPickleDictRow
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.testUpdateRow
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.test_copy
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.test_iter_methods
        - tests.test_extras_dictcursor.ExtrasDictCursorTests.test_order

  - name: KIKIMR-18327 # Large objects
    tests:
      python-psycopg2:
        - tests.test_lobject.LargeObjectTruncateTests.test_truncate
        - tests.test_lobject.LargeObjectTruncateTests.test_truncate_after_close
        - tests.test_lobject.LargeObjectTruncateTests.test_truncate_after_commit

  - name: KIKIMR-18329  # pg_type table
    tests:
      python-psycopg:
        - tests.test_types_extras.HstoreTestCase.test_array_cast
        - tests.test_types_extras.HstoreTestCase.test_array_cast_oid
        - tests.test_types_extras.HstoreTestCase.test_array_cast_oid
        - tests.test_types_extras.HstoreTestCase.test_non_dbapi_connection
        - tests.test_types_extras.HstoreTestCase.test_oid
        - tests.test_types_extras.HstoreTestCase.test_register_conn
        - tests.test_types_extras.HstoreTestCase.test_register_curs
        - tests.test_types_extras.HstoreTestCase.test_register_globally
        - tests.test_types_extras.HstoreTestCase.test_roundtrip
        - tests.test_types_extras.HstoreTestCase.test_roundtrip_array
        - tests.test_types_extras.JsonTestCase.test_loads
        - tests.test_types_extras.JsonTestCase.test_no_conn_curs
        - tests.test_types_extras.JsonTestCase.test_null
        - tests.test_types_extras.JsonTestCase.test_register_globally
        - tests.test_types_extras.JsonTestCase.test_register_on_connection
        - tests.test_types_extras.JsonTestCase.test_register_on_cursor
        - tests.test_types_extras.JsonTestCase.test_type_not_available

  - name: KIKIMR-18332 # pg_catalog
    tests:
      python-psycopg2:
        - tests.test_cursor.NamedCursorTests.test_named_noop_close

  - name: KIKIMR-18333 # create type, alternative is not implemented yet : 316
    tests:
      python-psycopg2:
        - tests.test_types_extras.RangeCasterTestCase.test_range_escaping
        - tests.test_types_extras.RangeCasterTestCase.test_register_range_adapter

  - name: KIKIMR-18334 # pg_range
    tests:
      python-psycopg2:
        - tests.test_types_extras.RangeCasterTestCase.test_range_not_found

  - name: KIKIMR-18335  # create scheme rs, alternative is not implemented yet : 292
    tests:
      python-psycopg2:
        - tests.test_types_extras.RangeCasterTestCase.test_schema_range

  - name: KIKIMR-18336  # savepoint
    tests:
      python-psycopg2:
        - tests.test_types_extras.AdaptTypeTestCase.test_cast_composite
        - tests.test_types_extras.AdaptTypeTestCase.test_cast_nested
        - tests.test_types_extras.AdaptTypeTestCase.test_composite_array
        - tests.test_types_extras.AdaptTypeTestCase.test_empty_string
        - tests.test_types_extras.AdaptTypeTestCase.test_non_dbapi_connection
        - tests.test_types_extras.AdaptTypeTestCase.test_register_globally
        - tests.test_types_extras.AdaptTypeTestCase.test_register_on_connection
        - tests.test_types_extras.AdaptTypeTestCase.test_register_on_cursor
        - tests.test_types_extras.AdaptTypeTestCase.test_subclass
        - tests.test_types_extras.AdaptTypeTestCase.test_wrong_schema

  - name: KIKIMR-18336  # record, alternative is not implemented yet : 138 (curs.execute("SELECT %s;", [(42, None)]))
    tests:
      python-psycopg2:
        - tests.test_types_extras.AdaptTypeTestCase.test_none_in_record

  - name: KIKIMR-19007  # No need "Empty query"
    tests:
      python-psycopg2:
        - tests.test_cursor.CursorTests.test_description_attribs

  - name: KIKIMR-18408  # CREATE FUNCTION, alternative is not implemented yet : 261
    tests:
      golang-lib-pq:
        - TestCopyInRaiseStmtTrigger
      python-psycopg2:
        - tests.test_cursor.CursorTests.test_callproc_dict

  - name: YQL-16190 # Parse date and time
    tests:
      golang-lib-pq:
        - TestEncodeAndParseTs
        - TestFormatTsBackend
        - TestInfinityTimestamp

  - name: YQL-15730 # Implicit cast for operators
    tests:
      golang-lib-pq:
        - TestEncodeDecode
        - TestIssue196

  - name: KIKIMR-17960 # Error in param syntax
    tests:
      golang-lib-pq:
        - TestBindError
        - TestErrorOnQuery
        - TestErrorOnQueryRowSimpleQuery
        - TestExec

  - name: KIKIMR-18384 # COPY wire protocol
    tests:
      golang-lib-pq:
        - TestCopyFromError
        - TestCopyInBinaryError
        - TestCopyInMultipleValues
        - TestCopyInTypes
        - TestCopyInWrongType
        - TestCopyRespLoopConnectionError

  - name: YQL-16430 # COPY parser, RawStmt: alternative is not implemented yet : 253
    tests:
      golang-lib-pq:
        - TestCopyInStmtAffectedRows
        - TestIssue494

  - name: YQL-16174 # Implicit cast insert/update
    tests:
      golang-lib-pq:
        - TestQueryRowBugWorkaround
      python-psycopg2:
        - tests.test_with.WithConnectionTestCase.test_with_autocommit_pgerror
        - tests.test_with.WithConnectionTestCase.test_with_error_db

  - name: YQL-16630 # Default as column constraint
    tests:
      golang-lib-pq:
        - TestReturning

  - name: KIKIMR-19372 # CREATE TEMP tag
    tests:
      golang-lib-pq:
        - TestRowsResultTag

  - name: KIKIMR-19373 # Scheme operations inside transaction
    tests:
      python-psycopg2:
        - tests.test_transaction.TransactionTests.test_commit
        - tests.test_transaction.TransactionTests.test_failed_commit
        - tests.test_transaction.TransactionTests.test_rollback
        - tests.test_async.AsyncTests.test_async_after_async
        - tests.test_async.AsyncTests.test_async_callproc
        - tests.test_async.AsyncTests.test_async_connection_error_message
        - tests.test_async.AsyncTests.test_async_cursor_gone
        - tests.test_async.AsyncTests.test_async_dont_read_all
        - tests.test_async.AsyncTests.test_async_executemany
        - tests.test_async.AsyncTests.test_async_fetch_wrong_cursor
        - tests.test_async.AsyncTests.test_async_iter
        - tests.test_async.AsyncTests.test_async_named_cursor
        - tests.test_async.AsyncTests.test_async_scroll
        - tests.test_async.AsyncTests.test_async_select
        - tests.test_async.AsyncTests.test_async_subclass
        - tests.test_async.AsyncTests.test_close
        - tests.test_async.AsyncTests.test_close
        - tests.test_async.AsyncTests.test_connection_setup
        - tests.test_async.AsyncTests.test_copy_no_hang
        - tests.test_async.AsyncTests.test_copy_while_async
        - tests.test_async.AsyncTests.test_error
        - tests.test_async.AsyncTests.test_error_two_cursors
        - tests.test_async.AsyncTests.test_fetch_after_async
        - tests.test_async.AsyncTests.test_flush_on_write
        - tests.test_async.AsyncTests.test_lobject_while_async
        - tests.test_async.AsyncTests.test_non_block_after_notification
        - tests.test_async.AsyncTests.test_notices
        - tests.test_async.AsyncTests.test_notify
        - tests.test_async.AsyncTests.test_poll_conn_for_notification
        - tests.test_async.AsyncTests.test_poll_noop
        - tests.test_async.AsyncTests.test_reset_while_async
        - tests.test_async.AsyncTests.test_rollback_while_async
        - tests.test_async.AsyncTests.test_scroll
        - tests.test_async.AsyncTests.test_set_parameters_while_async
        - tests.test_async.AsyncTests.test_stop_on_first_error
        - tests.test_async.AsyncTests.test_sync_poll
        - tests.test_copy.CopyTests.test_copy_bytes
        - tests.test_copy.CopyTests.test_copy_expert_file_refcount
        - tests.test_copy.CopyTests.test_copy_expert_textiobase
        - tests.test_copy.CopyTests.test_copy_from
        - tests.test_copy.CopyTests.test_copy_from_cols
        - tests.test_copy.CopyTests.test_copy_from_cols_err
        - tests.test_copy.CopyTests.test_copy_from_insane_size
        - tests.test_copy.CopyTests.test_copy_from_propagate_error
        - tests.test_copy.CopyTests.test_copy_from_segfault
        - tests.test_copy.CopyTests.test_copy_funny_names
        - tests.test_copy.CopyTests.test_copy_no_column_limit
        - tests.test_copy.CopyTests.test_copy_query
        - tests.test_copy.CopyTests.test_copy_rowcount
        - tests.test_copy.CopyTests.test_copy_rowcount_error
        - tests.test_copy.CopyTests.test_copy_text
        - tests.test_copy.CopyTests.test_copy_to
        - tests.test_copy.CopyTests.test_copy_to_propagate_error
        - tests.test_copy.CopyTests.test_copy_to_segfault

  - name: YQL-16632 # ALTER table, RawStmt: alternative is not implemented yet : 244
    tests:
      python-psycopg2:
        - tests.test_types_extras.AdaptTypeTestCase.test_from_tables

  - name: KIKIMR-19392 # ydb crashed on test TestBinaryByteSlicetoUUID
    tests:
      golang-lib-pq:
        - TestByteSliceToText
        - TestCloseBadConn
        - TestCommitInFailedTransaction
        - TestCommitInFailedTransactionWithCancelContext
        - TestConnClose
        - TestConnExecDeadlock
        - TestConnPrepareContext
        - TestConnPrepareContext/context.Background
        - TestConnPrepareContext/context.WithTimeout
        - TestCopyOutsideOfTxnError
        - TestDecodeBool
        - TestDecodeUUIDBackend
        - TestEmptyResultSetColumns

  - name: KIKIMR-19548 # TEMP TABLE and Serial primary key
    tests:
      python-psycopg2:
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_cache
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_cursor_args
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_executemany
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_fetchall
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_fetchmany
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_fetchmany_noarg
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_fetchone
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_iter
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_max_cache
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_minimal_generation
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_named
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_named_fetchall
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_named_fetchmany
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_named_fetchone
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_named_rownumber
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_no_result_no_surprise
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_nonascii_name
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_not_greedy
        - tests.test_extras_dictcursor.NamedTupleCursorTest.test_record_updated