Skip to content

Instantly share code, notes, and snippets.

@sheilatron
Created August 13, 2015 10:02
Show Gist options
  • Save sheilatron/d9801bfeff26015b8a6a to your computer and use it in GitHub Desktop.
Save sheilatron/d9801bfeff26015b8a6a to your computer and use it in GitHub Desktop.
SQLAlchemy tests (master branch 8/12/2015), mxODBC 3.3.4, unixODBC 2.3.3, Microsoft ODBC for Linux on Fedora21
(testmx334d2)[sallen@localhost sqlalchemy]$ py.test --db=msodbc
=============================================================================================== test session starts ===============================================================================================
platform linux2 -- Python 2.7.10 -- py-1.4.30 -- pytest-2.7.2 -- /home/sallen/env/testmx334d2/bin/python
rootdir: /home/sallen/env/testmx334d2/sqlalchemy, inifile: setup.cfg
collected 7224 items
test/aaa_profiling/test_compiler.py::CompileTest_mssql_mxodbc::test_insert <- lib/sqlalchemy/testing/profiling.py SKIPPED
test/aaa_profiling/test_compiler.py::CompileTest_mssql_mxodbc::test_select SKIPPED
test/aaa_profiling/test_compiler.py::CompileTest_mssql_mxodbc::test_select_labels SKIPPED
test/aaa_profiling/test_compiler.py::CompileTest_mssql_mxodbc::test_update <- lib/sqlalchemy/testing/profiling.py SKIPPED
test/aaa_profiling/test_compiler.py::CompileTest_mssql_mxodbc::test_update_whereclause SKIPPED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_DecimalResultProcessor_init SKIPPED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_DecimalResultProcessor_process SKIPPED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_UnicodeResultProcessor_init SKIPPED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_ad_hoc_types PASSED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_alias_pathing PASSED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_fixture PASSED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_join_cache PASSED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_key_fallback_result PASSED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_many_discarded_relationships PASSED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_many_updates PASSED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_mapper_reset PASSED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_orm_many_engines PASSED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_path_registry PASSED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_session PASSED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_sessionmaker PASSED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_type_compile PASSED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_unicode_warnings PASSED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_warnings_util PASSED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_with_inheritance PASSED
test/aaa_profiling/test_memusage.py::MemUsageTest_mssql_mxodbc::test_with_manytomany PASSED
test/aaa_profiling/test_orm.py::AttributeOverheadTest::test_attribute_set SKIPPED
test/aaa_profiling/test_orm.py::AttributeOverheadTest::test_collection_append_remove SKIPPED
test/aaa_profiling/test_orm.py::DeferOptionsTest::test_baseline <- lib/sqlalchemy/testing/profiling.py SKIPPED
test/aaa_profiling/test_orm.py::DeferOptionsTest::test_defer_many_cols <- lib/sqlalchemy/testing/profiling.py SKIPPED
test/aaa_profiling/test_orm.py::LoadManyToOneFromIdentityTest::test_many_to_one_load_identity SKIPPED
test/aaa_profiling/test_orm.py::LoadManyToOneFromIdentityTest::test_many_to_one_load_no_identity SKIPPED
test/aaa_profiling/test_orm.py::MergeBackrefsTest::test_merge_pending_with_all_pks <- lib/sqlalchemy/testing/profiling.py SKIPPED
test/aaa_profiling/test_orm.py::MergeTest::test_merge_load SKIPPED
test/aaa_profiling/test_orm.py::MergeTest::test_merge_no_load SKIPPED
test/aaa_profiling/test_orm.py::QueryTest::test_query_cols SKIPPED
test/aaa_profiling/test_orm.py::SessionTest::test_expire_lots SKIPPED
test/aaa_profiling/test_pool.py::QueuePoolTest::test_first_connect <- lib/sqlalchemy/testing/profiling.py SKIPPED
test/aaa_profiling/test_pool.py::QueuePoolTest::test_second_connect SKIPPED
test/aaa_profiling/test_pool.py::QueuePoolTest::test_second_samethread_connect SKIPPED
test/aaa_profiling/test_resultset.py::ExecutionTest_mssql_mxodbc::test_minimal_connection_execute SKIPPED
test/aaa_profiling/test_resultset.py::ExecutionTest_mssql_mxodbc::test_minimal_engine_execute SKIPPED
test/aaa_profiling/test_resultset.py::ResultSetTest_mssql_mxodbc::test_contains_doesnt_compile SKIPPED
test/aaa_profiling/test_resultset.py::ResultSetTest_mssql_mxodbc::test_string <- lib/sqlalchemy/testing/profiling.py SKIPPED
test/aaa_profiling/test_resultset.py::ResultSetTest_mssql_mxodbc::test_unicode <- lib/sqlalchemy/testing/profiling.py SKIPPED
test/aaa_profiling/test_resultset.py::RowProxyTest_mssql_mxodbc::test_value_refcounts_custom_seq PASSED
test/aaa_profiling/test_resultset.py::RowProxyTest_mssql_mxodbc::test_value_refcounts_pure_tuple PASSED
test/aaa_profiling/test_zoomark.py::ZooMarkTest::test_invocation <- lib/sqlalchemy/testing/replay_fixture.py SKIPPED
test/aaa_profiling/test_zoomark_orm.py::ZooMarkTest::test_invocation <- lib/sqlalchemy/testing/replay_fixture.py SKIPPED
test/base/test_dependency.py::DependencySortTest::test_find_cycle_one PASSED
test/base/test_dependency.py::DependencySortTest::test_find_multiple_cycles_four PASSED
test/base/test_dependency.py::DependencySortTest::test_find_multiple_cycles_one PASSED
test/base/test_dependency.py::DependencySortTest::test_find_multiple_cycles_three PASSED
test/base/test_dependency.py::DependencySortTest::test_find_multiple_cycles_two PASSED
test/base/test_dependency.py::DependencySortTest::test_large_sort PASSED
test/base/test_dependency.py::DependencySortTest::test_raise_on_cycle_one PASSED
test/base/test_dependency.py::DependencySortTest::test_raise_on_cycle_three PASSED
test/base/test_dependency.py::DependencySortTest::test_raise_on_cycle_two PASSED
test/base/test_dependency.py::DependencySortTest::test_sort_deterministic_one PASSED
test/base/test_dependency.py::DependencySortTest::test_sort_deterministic_two PASSED
test/base/test_dependency.py::DependencySortTest::test_sort_one PASSED
test/base/test_dependency.py::DependencySortTest::test_sort_three PASSED
test/base/test_dependency.py::DependencySortTest::test_sort_two PASSED
test/base/test_dependency.py::DependencySortTest::test_ticket_1380 PASSED
test/base/test_events.py::AcceptTargetsTest::test_target_accept PASSED
test/base/test_events.py::ClsLevelListenTest::test_lis_multisub_lis PASSED
test/base/test_events.py::ClsLevelListenTest::test_lis_subcalss_lis PASSED
test/base/test_events.py::ClsLevelListenTest::test_two_sub_lis PASSED
test/base/test_events.py::CustomTargetsTest::test_indirect PASSED
test/base/test_events.py::EventsTest::test_append_vs_insert_cls PASSED
test/base/test_events.py::EventsTest::test_append_vs_insert_instance PASSED
test/base/test_events.py::EventsTest::test_bool_clslevel PASSED
test/base/test_events.py::EventsTest::test_decorator PASSED
test/base/test_events.py::EventsTest::test_immutable_methods PASSED
test/base/test_events.py::EventsTest::test_no_instance_level_collections PASSED
test/base/test_events.py::EventsTest::test_register_class PASSED
test/base/test_events.py::EventsTest::test_register_class_instance PASSED
test/base/test_events.py::EventsTest::test_register_instance PASSED
test/base/test_events.py::JoinTest::test_kw_ok PASSED
test/base/test_events.py::JoinTest::test_neither PASSED
test/base/test_events.py::JoinTest::test_parent_class_child_class PASSED
test/base/test_events.py::JoinTest::test_parent_class_child_instance_apply_after PASSED
test/base/test_events.py::JoinTest::test_parent_class_child_instance_apply_before PASSED
test/base/test_events.py::JoinTest::test_parent_class_only PASSED
test/base/test_events.py::JoinTest::test_parent_events_child_no_events PASSED
test/base/test_events.py::JoinTest::test_parent_instance_child_class_apply_after PASSED
test/base/test_events.py::JoinTest::test_parent_instance_child_class_apply_before PASSED
test/base/test_events.py::JoinTest::test_parent_instance_child_instance_apply_before PASSED
test/base/test_events.py::LegacySignatureTest::test_complex_legacy_accept PASSED
test/base/test_events.py::LegacySignatureTest::test_kw_accept_has_legacies PASSED
test/base/test_events.py::LegacySignatureTest::test_kw_accept_plus_kw_has_legacies PASSED
test/base/test_events.py::LegacySignatureTest::test_legacy_accept PASSED
test/base/test_events.py::LegacySignatureTest::test_legacy_accept_from_method PASSED
test/base/test_events.py::LegacySignatureTest::test_legacy_accept_kw_cls PASSED
test/base/test_events.py::LegacySignatureTest::test_legacy_accept_kw_instance PASSED
test/base/test_events.py::LegacySignatureTest::test_legacy_accept_partial PASSED
test/base/test_events.py::LegacySignatureTest::test_standard_accept_has_legacies PASSED
test/base/test_events.py::ListenOverrideTest::test_listen_override PASSED
test/base/test_events.py::ListenOverrideTest::test_remove_clslevel PASSED
test/base/test_events.py::ListenOverrideTest::test_remove_instancelevel PASSED
test/base/test_events.py::NamedCallTest::test_kw_accept PASSED
test/base/test_events.py::NamedCallTest::test_kw_accept_plus_kw PASSED
test/base/test_events.py::NamedCallTest::test_kw_accept_wrapped PASSED
test/base/test_events.py::NamedCallTest::test_partial_kw_accept PASSED
test/base/test_events.py::NamedCallTest::test_partial_kw_accept_wrapped PASSED
test/base/test_events.py::PropagateTest::test_propagate PASSED
test/base/test_events.py::RemovalTest::test_clslevel PASSED
test/base/test_events.py::RemovalTest::test_clslevel_subclass PASSED
test/base/test_events.py::RemovalTest::test_double_event_nonwrapped PASSED
test/base/test_events.py::RemovalTest::test_double_event_wrapped PASSED
test/base/test_events.py::RemovalTest::test_instance PASSED
test/base/test_events.py::RemovalTest::test_listener_collection_removed_cleanup PASSED
test/base/test_events.py::RemovalTest::test_no_add_in_event PASSED
test/base/test_events.py::RemovalTest::test_no_remove_in_event PASSED
test/base/test_events.py::RemovalTest::test_once PASSED
test/base/test_events.py::RemovalTest::test_propagate PASSED
test/base/test_events.py::RemovalTest::test_remove_not_listened PASSED
test/base/test_events.py::RemovalTest::test_remove_plain_named PASSED
test/base/test_events.py::RemovalTest::test_remove_wrapped_named PASSED
test/base/test_events.py::SubclassGrowthTest::test_subclass PASSED
test/base/test_except.py::WrapTest::test_db_error_busted_dbapi PASSED
test/base/test_except.py::WrapTest::test_db_error_dbapi_uses_wrong_names PASSED
test/base/test_except.py::WrapTest::test_db_error_keyboard_interrupt PASSED
test/base/test_except.py::WrapTest::test_db_error_noncompliant_dbapi PASSED
test/base/test_except.py::WrapTest::test_db_error_normal PASSED
test/base/test_except.py::WrapTest::test_db_error_system_exit PASSED
test/base/test_except.py::WrapTest::test_tostring PASSED
test/base/test_except.py::WrapTest::test_tostring_large_dict PASSED
test/base/test_except.py::WrapTest::test_tostring_large_executemany PASSED
test/base/test_except.py::WrapTest::test_tostring_large_list PASSED
test/base/test_inspect.py::TestInspection::test_class_insp PASSED
test/base/test_inspect.py::TestInspection::test_def_insp PASSED
test/base/test_inspect.py::TestInspection::test_hierarchy_insp PASSED
test/base/test_inspect.py::TestInspection::test_no_inspect PASSED
test/base/test_utils.py::ArgInspectionTest::test_callable_argspec_call PASSED
test/base/test_utils.py::ArgInspectionTest::test_callable_argspec_call_no_self PASSED
test/base/test_utils.py::ArgInspectionTest::test_callable_argspec_fn PASSED
test/base/test_utils.py::ArgInspectionTest::test_callable_argspec_fn_no_self PASSED
test/base/test_utils.py::ArgInspectionTest::test_callable_argspec_fn_no_self_but_self PASSED
test/base/test_utils.py::ArgInspectionTest::test_callable_argspec_init PASSED
test/base/test_utils.py::ArgInspectionTest::test_callable_argspec_init_no_self PASSED
test/base/test_utils.py::ArgInspectionTest::test_callable_argspec_instance_method_no_self PASSED
test/base/test_utils.py::ArgInspectionTest::test_callable_argspec_method PASSED
test/base/test_utils.py::ArgInspectionTest::test_callable_argspec_obj_init PASSED
test/base/test_utils.py::ArgInspectionTest::test_callable_argspec_partial PASSED
test/base/test_utils.py::ArgInspectionTest::test_callable_argspec_py_builtin PASSED
test/base/test_utils.py::ArgInspectionTest::test_callable_argspec_unbound_method_no_self PASSED
test/base/test_utils.py::ArgInspectionTest::test_get_cls_kwargs PASSED
test/base/test_utils.py::ArgInspectionTest::test_get_func_kwargs PASSED
test/base/test_utils.py::AsInterfaceTest::test_dict PASSED
test/base/test_utils.py::AsInterfaceTest::test_instance PASSED
test/base/test_utils.py::ColumnCollectionTest::test_compare PASSED
test/base/test_utils.py::ColumnCollectionTest::test_dupes_add PASSED
test/base/test_utils.py::ColumnCollectionTest::test_dupes_extend PASSED
test/base/test_utils.py::ColumnCollectionTest::test_dupes_update PASSED
test/base/test_utils.py::ColumnCollectionTest::test_extend_existing PASSED
test/base/test_utils.py::ColumnCollectionTest::test_in PASSED
test/base/test_utils.py::ColumnCollectionTest::test_replace PASSED
test/base/test_utils.py::ColumnCollectionTest::test_replace_key_matches PASSED
test/base/test_utils.py::ColumnCollectionTest::test_replace_name_matches PASSED
test/base/test_utils.py::ColumnCollectionTest::test_replace_no_match PASSED
test/base/test_utils.py::ColumnCollectionTest::test_update_existing PASSED
test/base/test_utils.py::DictlikeIteritemsTest::test_UserDict PASSED
test/base/test_utils.py::DictlikeIteritemsTest::test_dict PASSED
test/base/test_utils.py::DictlikeIteritemsTest::test_duck_1 PASSED
test/base/test_utils.py::DictlikeIteritemsTest::test_duck_2 PASSED
test/base/test_utils.py::DictlikeIteritemsTest::test_duck_3 PASSED
test/base/test_utils.py::DictlikeIteritemsTest::test_duck_4 PASSED
test/base/test_utils.py::DictlikeIteritemsTest::test_duck_5 PASSED
test/base/test_utils.py::DictlikeIteritemsTest::test_duck_6 PASSED
test/base/test_utils.py::DictlikeIteritemsTest::test_object PASSED
test/base/test_utils.py::DictlikeIteritemsTest::test_subdict PASSED
test/base/test_utils.py::DuckTypeCollectionTest::test_sets PASSED
test/base/test_utils.py::FlattenIteratorTest::test_flatten PASSED
test/base/test_utils.py::FlattenIteratorTest::test_str_with_iter PASSED
test/base/test_utils.py::FrozenDictTest::test_serialize PASSED
test/base/test_utils.py::GenericReprTest::test_all_positional PASSED
test/base/test_utils.py::GenericReprTest::test_discard_vargs PASSED
test/base/test_utils.py::GenericReprTest::test_discard_vargs_kwargs PASSED
test/base/test_utils.py::GenericReprTest::test_kw_defaults PASSED
test/base/test_utils.py::GenericReprTest::test_multi_kw PASSED
test/base/test_utils.py::GenericReprTest::test_multi_kw_repeated PASSED
test/base/test_utils.py::GenericReprTest::test_no_args PASSED
test/base/test_utils.py::GenericReprTest::test_no_init PASSED
test/base/test_utils.py::GenericReprTest::test_positional_plus_kw PASSED
test/base/test_utils.py::GenericReprTest::test_significant_vargs PASSED
test/base/test_utils.py::IdentitySetTest::test_add PASSED
test/base/test_utils.py::IdentitySetTest::test_basic_sanity PASSED
test/base/test_utils.py::IdentitySetTest::test_difference PASSED
test/base/test_utils.py::IdentitySetTest::test_difference_update PASSED
test/base/test_utils.py::IdentitySetTest::test_dunder_and PASSED
test/base/test_utils.py::IdentitySetTest::test_dunder_eq PASSED
test/base/test_utils.py::IdentitySetTest::test_dunder_ge PASSED
test/base/test_utils.py::IdentitySetTest::test_dunder_gt PASSED
test/base/test_utils.py::IdentitySetTest::test_dunder_iand PASSED
test/base/test_utils.py::IdentitySetTest::test_dunder_ior PASSED
test/base/test_utils.py::IdentitySetTest::test_dunder_isub PASSED
test/base/test_utils.py::IdentitySetTest::test_dunder_le PASSED
test/base/test_utils.py::IdentitySetTest::test_dunder_lt PASSED
test/base/test_utils.py::IdentitySetTest::test_dunder_ne PASSED
test/base/test_utils.py::IdentitySetTest::test_dunder_or PASSED
test/base/test_utils.py::IdentitySetTest::test_dunder_sub PASSED
test/base/test_utils.py::IdentitySetTest::test_dunder_sub2 PASSED
test/base/test_utils.py::IdentitySetTest::test_dunder_xor PASSED
test/base/test_utils.py::IdentitySetTest::test_init PASSED
test/base/test_utils.py::IdentitySetTest::test_intersection PASSED
test/base/test_utils.py::IdentitySetTest::test_intersection_update PASSED
test/base/test_utils.py::IdentitySetTest::test_issubset PASSED
test/base/test_utils.py::IdentitySetTest::test_issuperset PASSED
test/base/test_utils.py::IdentitySetTest::test_symmetric_difference PASSED
test/base/test_utils.py::IdentitySetTest::test_symmetric_difference_update PASSED
test/base/test_utils.py::IdentitySetTest::test_union PASSED
test/base/test_utils.py::IdentitySetTest::test_update PASSED
test/base/test_utils.py::KeyedTupleTest::test_basic_attribute_access PASSED
test/base/test_utils.py::KeyedTupleTest::test_basic_creation PASSED
test/base/test_utils.py::KeyedTupleTest::test_basic_index_access PASSED
test/base/test_utils.py::KeyedTupleTest::test_duplicate_labels PASSED
test/base/test_utils.py::KeyedTupleTest::test_empty PASSED
test/base/test_utils.py::KeyedTupleTest::test_immutable PASSED
test/base/test_utils.py::KeyedTupleTest::test_none_label PASSED
test/base/test_utils.py::KeyedTupleTest::test_serialize PASSED
test/base/test_utils.py::KeyedTupleTest::test_values_but_no_labels PASSED
test/base/test_utils.py::LRUTest::test_lru PASSED
test/base/test_utils.py::LWKeyedTupleTest::test_basic_attribute_access PASSED
test/base/test_utils.py::LWKeyedTupleTest::test_basic_creation PASSED
test/base/test_utils.py::LWKeyedTupleTest::test_basic_index_access PASSED
test/base/test_utils.py::LWKeyedTupleTest::test_duplicate_labels PASSED
test/base/test_utils.py::LWKeyedTupleTest::test_empty PASSED
test/base/test_utils.py::LWKeyedTupleTest::test_immutable PASSED
test/base/test_utils.py::LWKeyedTupleTest::test_none_label PASSED
test/base/test_utils.py::LWKeyedTupleTest::test_serialize PASSED
test/base/test_utils.py::LWKeyedTupleTest::test_values_but_no_labels PASSED
test/base/test_utils.py::MemoizedAttrTest::test_memoized_instancemethod PASSED
test/base/test_utils.py::MemoizedAttrTest::test_memoized_property PASSED
test/base/test_utils.py::MemoizedAttrTest::test_memoized_slots PASSED
test/base/test_utils.py::OrderedDictTest::test_odict PASSED
test/base/test_utils.py::OrderedDictTest::test_odict_constructor PASSED
test/base/test_utils.py::OrderedDictTest::test_odict_copy PASSED
test/base/test_utils.py::OrderedIdentitySetTest::test_add PASSED
test/base/test_utils.py::OrderedIdentitySetTest::test_intersection PASSED
test/base/test_utils.py::OrderedSetTest::test_mutators_against_iter PASSED
test/base/test_utils.py::PublicFactoryTest::test_classmethod PASSED
test/base/test_utils.py::PublicFactoryTest::test_constructor PASSED
test/base/test_utils.py::SymbolTest::test_basic PASSED
test/base/test_utils.py::SymbolTest::test_bitflags PASSED
test/base/test_utils.py::SymbolTest::test_composites PASSED
test/base/test_utils.py::SymbolTest::test_pickle PASSED
test/base/test_utils.py::TestClassHierarchy::test_object PASSED
test/base/test_utils.py::TestClassHierarchy::test_oldstyle_mixin PASSED
test/base/test_utils.py::TestClassHierarchy::test_single PASSED
test/base/test_utils.py::TestClassProperty::test_simple PASSED
test/base/test_utils.py::TestFormatArgspec::test_init_bare PASSED
test/base/test_utils.py::TestFormatArgspec::test_init_grouped PASSED
test/base/test_utils.py::TestFormatArgspec::test_specs PASSED
test/base/test_utils.py::ToListTest::test_from_dict PASSED
test/base/test_utils.py::ToListTest::test_from_set PASSED
test/base/test_utils.py::ToListTest::test_from_string PASSED
test/base/test_utils.py::ToListTest::test_from_tuple PASSED
test/base/test_utils.py::WeakSequenceTest::test_cleanout_appended PASSED
test/base/test_utils.py::WeakSequenceTest::test_cleanout_elements PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_count PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_create_index_expr PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_delete_exclude_hint PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_delete_hint PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_delete_returning PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_delete_schema PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_delete_schema_multipart PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_delete_schema_multipart_both_need_quoting PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_delete_schema_multipart_needs_quoting PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_drop_index_w_schema PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_extract PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_function PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_function_overrides PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_in_with_subqueries PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_index_clustering PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_index_extra_include_1 PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_index_extra_include_2 PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_index_ordering PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_insert PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_insert_hint PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_insert_returning PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_join_with_hint PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_limit_offset_using_window PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_limit_offset_with_correlated_order_by PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_limit_using_top PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_limit_zero_offset_using_window PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_limit_zero_using_top PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_noorderby_insubquery PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_offset_using_window PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_select PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_select_with_nolock PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_select_with_nolock_schema PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_sequence_ignore_nullability PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_sequence_non_primary_key PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_sequence_start_0 PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_strict_binds PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_table_pkc_clustering PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_table_uc_clustering PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_true_false PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_union PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_update PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_update_exclude_hint PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_update_from_hint PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_update_hint PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_update_returning PASSED
test/dialect/mssql/test_compiler.py::CompileTest::test_update_to_select_schema PASSED
test/dialect/mssql/test_compiler.py::SchemaTest::test_that_mssql_default_nullability_emits_null PASSED
test/dialect/mssql/test_compiler.py::SchemaTest::test_that_mssql_none_nullability_does_not_emit_nullability PASSED
test/dialect/mssql/test_compiler.py::SchemaTest::test_that_mssql_specified_not_nullable_emits_not_null PASSED
test/dialect/mssql/test_compiler.py::SchemaTest::test_that_mssql_specified_nullable_emits_null PASSED
test/dialect/mssql/test_engine.py::EngineFromConfigTest::test_legacy_schema_flag PASSED
test/dialect/mssql/test_engine.py::ParseConnectTest::test_bad_freetds_warning SKIPPED
test/dialect/mssql/test_engine.py::ParseConnectTest::test_pymssql_disconnect PASSED
test/dialect/mssql/test_engine.py::ParseConnectTest::test_pymssql_port_setting PASSED
test/dialect/mssql/test_engine.py::ParseConnectTest::test_pyodbc_connect_comma_port PASSED
test/dialect/mssql/test_engine.py::ParseConnectTest::test_pyodbc_connect_config_port PASSED
test/dialect/mssql/test_engine.py::ParseConnectTest::test_pyodbc_connect_dsn_extra PASSED
test/dialect/mssql/test_engine.py::ParseConnectTest::test_pyodbc_connect_dsn_non_trusted PASSED
test/dialect/mssql/test_engine.py::ParseConnectTest::test_pyodbc_connect_dsn_trusted PASSED
test/dialect/mssql/test_engine.py::ParseConnectTest::test_pyodbc_connect_old_style_dsn_trusted PASSED
test/dialect/mssql/test_engine.py::ParseConnectTest::test_pyodbc_extra_connect PASSED
test/dialect/mssql/test_engine.py::ParseConnectTest::test_pyodbc_host_no_driver PASSED
test/dialect/mssql/test_engine.py::ParseConnectTest::test_pyodbc_hostname PASSED
test/dialect/mssql/test_engine.py::ParseConnectTest::test_pyodbc_odbc_connect PASSED
test/dialect/mssql/test_engine.py::ParseConnectTest::test_pyodbc_odbc_connect_ignores_other_values PASSED
test/dialect/mssql/test_engine.py::ParseConnectTest::test_pyodbc_odbc_connect_with_dsn PASSED
test/dialect/mssql/test_engine.py::VersionDetectionTest::test_pymssql_version PASSED
test/dialect/mssql/test_query.py::IdentityInsertTest::test_compiled PASSED
test/dialect/mssql/test_query.py::IdentityInsertTest::test_execute PASSED
test/dialect/mssql/test_query.py::IdentityInsertTest::test_executemany PASSED
test/dialect/mssql/test_query.py::LegacySchemaAliasingTest::test_column_subquery_to_alias PASSED
test/dialect/mssql/test_query.py::LegacySchemaAliasingTest::test_join_to_schema PASSED
test/dialect/mssql/test_query.py::LegacySchemaAliasingTest::test_result_map PASSED
test/dialect/mssql/test_query.py::LegacySchemaAliasingTest::test_result_map_use_labels PASSED
test/dialect/mssql/test_query.py::LegacySchemaAliasingTest::test_straight_select PASSED
test/dialect/mssql/test_query.py::LegacySchemaAliasingTest::test_straight_select_use_labels PASSED
test/dialect/mssql/test_query.py::LegacySchemaAliasingTest::test_union_schema_to_non PASSED
test/dialect/mssql/test_query.py::MatchTest::test_and_match SKIPPED
test/dialect/mssql/test_query.py::MatchTest::test_expression SKIPPED
test/dialect/mssql/test_query.py::MatchTest::test_match_across_joins SKIPPED
test/dialect/mssql/test_query.py::MatchTest::test_or_match SKIPPED
test/dialect/mssql/test_query.py::MatchTest::test_simple_inflectional_match SKIPPED
test/dialect/mssql/test_query.py::MatchTest::test_simple_match SKIPPED
test/dialect/mssql/test_query.py::MatchTest::test_simple_match_with_apostrophe SKIPPED
test/dialect/mssql/test_query.py::MatchTest::test_simple_prefix_match SKIPPED
test/dialect/mssql/test_query.py::QueryTest::test_delete_schema PASSED
test/dialect/mssql/test_query.py::QueryTest::test_delete_schema_legacy PASSED
test/dialect/mssql/test_query.py::QueryTest::test_disable_scope_identity PASSED
test/dialect/mssql/test_query.py::QueryTest::test_embedded_scope_identity SKIPPED
test/dialect/mssql/test_query.py::QueryTest::test_enable_scope_identity PASSED
test/dialect/mssql/test_query.py::QueryTest::test_fetchid_trigger PASSED
test/dialect/mssql/test_query.py::QueryTest::test_insertid_reserved PASSED
test/dialect/mssql/test_query.py::QueryTest::test_insertid_schema PASSED
test/dialect/mssql/test_query.py::QueryTest::test_insertid_schema_legacy PASSED
test/dialect/mssql/test_query.py::QueryTest::test_returning_no_autoinc PASSED
test/dialect/mssql/test_query.py::QueryUnicodeTest::test_convert_unicode PASSED
test/dialect/mssql/test_reflection.py::InfoCoerceUnicodeTest::test_info_unicode_cast PASSED
test/dialect/mssql/test_reflection.py::InfoCoerceUnicodeTest::test_info_unicode_cast_no_2000 PASSED
test/dialect/mssql/test_reflection.py::InfoCoerceUnicodeTest::test_info_unicode_coercion PASSED
test/dialect/mssql/test_reflection.py::ReflectHugeViewTest::test_inspect_view_definition PASSED
test/dialect/mssql/test_reflection.py::ReflectionTest::test_basic_reflection PASSED
test/dialect/mssql/test_reflection.py::ReflectionTest::test_db_qualified_items FAILED
test/dialect/mssql/test_reflection.py::ReflectionTest::test_identity PASSED
test/dialect/mssql/test_reflection.py::ReflectionTest::test_indexes_cols PASSED
test/dialect/mssql/test_reflection.py::ReflectionTest::test_indexes_cols_with_commas PASSED
test/dialect/mssql/test_reflection.py::ReflectionTest::test_indexes_cols_with_spaces PASSED
test/dialect/mssql/test_reflection.py::ReflectionTest::test_max_ident_in_varchar_not_present PASSED
test/dialect/mssql/test_reflection.py::ReflectionTest::test_skip_types PASSED
test/dialect/mssql/test_types.py::BinaryTest::test_binary_legacy_types PASSED
test/dialect/mssql/test_types.py::BinaryTest::test_binary_none_legacy_types PASSED
test/dialect/mssql/test_types.py::BinaryTest::test_binary_none_updated_types PASSED
test/dialect/mssql/test_types.py::BinaryTest::test_binary_updated_types PASSED
test/dialect/mssql/test_types.py::MonkeyPatchedBinaryTest::test_bytes SKIPPED
test/dialect/mssql/test_types.py::MonkeyPatchedBinaryTest::test_unicode SKIPPED
test/dialect/mssql/test_types.py::TimeTypeTest::test_result_processor_no_microseconds PASSED
test/dialect/mssql/test_types.py::TimeTypeTest::test_result_processor_too_many_microseconds PASSED
test/dialect/mssql/test_types.py::TypeDDLTest::test_binary PASSED
test/dialect/mssql/test_types.py::TypeDDLTest::test_boolean PASSED
test/dialect/mssql/test_types.py::TypeDDLTest::test_char PASSED
test/dialect/mssql/test_types.py::TypeDDLTest::test_large_type_deprecation PASSED
test/dialect/mssql/test_types.py::TypeDDLTest::test_money PASSED
test/dialect/mssql/test_types.py::TypeDDLTest::test_numeric PASSED
test/dialect/mssql/test_types.py::TypeDDLTest::test_timestamp PASSED
test/dialect/mssql/test_types.py::TypeRoundTripTest::test_autoincrement PASSED
test/dialect/mssql/test_types.py::TypeRoundTripTest::test_binary_reflection_legacy_large_types PASSED
test/dialect/mssql/test_types.py::TypeRoundTripTest::test_binary_reflection_sql2012_large_types PASSED
test/dialect/mssql/test_types.py::TypeRoundTripTest::test_date_roundtrip PASSED
test/dialect/mssql/test_types.py::TypeRoundTripTest::test_dates PASSED
test/dialect/mssql/test_types.py::TypeRoundTripTest::test_decimal_notation PASSED
test/dialect/mssql/test_types.py::TypeRoundTripTest::test_float PASSED
test/dialect/mysql/test_compiler.py::CompileTest::test_create_composite_index_with_length PASSED
test/dialect/mysql/test_compiler.py::CompileTest::test_create_composite_index_with_length_quoted PASSED
test/dialect/mysql/test_compiler.py::CompileTest::test_create_composite_index_with_length_quoted_3085_workaround PASSED
test/dialect/mysql/test_compiler.py::CompileTest::test_create_index_expr PASSED
test/dialect/mysql/test_compiler.py::CompileTest::test_create_index_simple PASSED
test/dialect/mysql/test_compiler.py::CompileTest::test_create_index_with_length PASSED
test/dialect/mysql/test_compiler.py::CompileTest::test_create_index_with_length_quoted PASSED
test/dialect/mysql/test_compiler.py::CompileTest::test_create_index_with_using PASSED
test/dialect/mysql/test_compiler.py::CompileTest::test_create_pk_plain PASSED
test/dialect/mysql/test_compiler.py::CompileTest::test_create_pk_with_using PASSED
test/dialect/mysql/test_compiler.py::CompileTest::test_deferrable_initially_kw_not_ignored PASSED
test/dialect/mysql/test_compiler.py::CompileTest::test_for_update PASSED
test/dialect/mysql/test_compiler.py::CompileTest::test_match_kw_raises PASSED
test/dialect/mysql/test_compiler.py::CompileTest::test_reserved_words PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_backslash_escaping PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_cast PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_cast_grouped_expression_non_castable PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_cast_grouped_expression_pre_4 PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_cast_type_decorator PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_create_table_with_partition PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_create_table_with_partition_hash PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_extract PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_innodb_autoincrement PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_innodb_autoincrement_reserved_word_column_name PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_limit PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_no_cast_pre_4 PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_precolumns PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_sysdate PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_too_long_index PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_unsupported_casts PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_update_limit PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_utc_timestamp PASSED
test/dialect/mysql/test_compiler.py::SQLTest::test_varchar_raise PASSED
test/dialect/mysql/test_dialect.py::DialectTest_mssql_mxodbc::test_mysqlconnector_buffered_arg PASSED
test/dialect/mysql/test_dialect.py::DialectTest_mssql_mxodbc::test_mysqlconnector_raise_on_warnings_arg PASSED
test/dialect/mysql/test_dialect.py::DialectTest_mssql_mxodbc::test_random_arg SKIPPED
test/dialect/mysql/test_dialect.py::DialectTest_mssql_mxodbc::test_special_encodings SKIPPED
test/dialect/mysql/test_dialect.py::DialectTest_mssql_mxodbc::test_ssl_arguments_mysqldb PASSED
test/dialect/mysql/test_dialect.py::DialectTest_mssql_mxodbc::test_ssl_arguments_oursql PASSED
test/dialect/mysql/test_dialect.py::ExecutionTest::test_charset_caching SKIPPED
test/dialect/mysql/test_dialect.py::ExecutionTest::test_sysdate SKIPPED
test/dialect/mysql/test_dialect.py::SQLModeDetectionTest::test_ansi_quotes SKIPPED
test/dialect/mysql/test_dialect.py::SQLModeDetectionTest::test_backslash_escapes SKIPPED
test/dialect/mysql/test_dialect.py::SQLModeDetectionTest::test_combination SKIPPED
test/dialect/mysql/test_query.py::IdiosyncrasyTest::test_is_boolean_symbols_despite_no_native SKIPPED
test/dialect/mysql/test_query.py::MatchTest::test_and_match SKIPPED
test/dialect/mysql/test_query.py::MatchTest::test_expression_format SKIPPED
test/dialect/mysql/test_query.py::MatchTest::test_expression_pyformat SKIPPED
test/dialect/mysql/test_query.py::MatchTest::test_match_across_joins SKIPPED
test/dialect/mysql/test_query.py::MatchTest::test_not_match SKIPPED
test/dialect/mysql/test_query.py::MatchTest::test_or_match SKIPPED
test/dialect/mysql/test_query.py::MatchTest::test_return_value SKIPPED
test/dialect/mysql/test_query.py::MatchTest::test_simple_match SKIPPED
test/dialect/mysql/test_query.py::MatchTest::test_simple_match_with_apostrophe SKIPPED
test/dialect/mysql/test_reflection.py::RawReflectionTest::test_fk_reflection PASSED
test/dialect/mysql/test_reflection.py::RawReflectionTest::test_key_reflection PASSED
test/dialect/mysql/test_reflection.py::ReflectionTest::test_autoincrement SKIPPED
test/dialect/mysql/test_reflection.py::ReflectionTest::test_default_reflection SKIPPED
test/dialect/mysql/test_reflection.py::ReflectionTest::test_nullable_reflection SKIPPED
test/dialect/mysql/test_reflection.py::ReflectionTest::test_reflection_on_include_columns SKIPPED
test/dialect/mysql/test_reflection.py::ReflectionTest::test_reflection_with_table_options SKIPPED
test/dialect/mysql/test_reflection.py::ReflectionTest::test_reflection_with_unique_constraint SKIPPED
test/dialect/mysql/test_reflection.py::ReflectionTest::test_system_views SKIPPED
test/dialect/mysql/test_reflection.py::ReflectionTest::test_type_reflection SKIPPED
test/dialect/mysql/test_types.py::EnumSetTest::test_bitwise_required_for_empty SKIPPED
test/dialect/mysql/test_types.py::EnumSetTest::test_empty_set_empty_string SKIPPED
test/dialect/mysql/test_types.py::EnumSetTest::test_empty_set_no_empty_string SKIPPED
test/dialect/mysql/test_types.py::EnumSetTest::test_enum SKIPPED
test/dialect/mysql/test_types.py::EnumSetTest::test_enum_compile SKIPPED
test/dialect/mysql/test_types.py::EnumSetTest::test_enum_parse SKIPPED
test/dialect/mysql/test_types.py::EnumSetTest::test_int_roundtrip SKIPPED
test/dialect/mysql/test_types.py::EnumSetTest::test_no_null SKIPPED
test/dialect/mysql/test_types.py::EnumSetTest::test_oursql_error_one SKIPPED
test/dialect/mysql/test_types.py::EnumSetTest::test_set_colspec SKIPPED
test/dialect/mysql/test_types.py::EnumSetTest::test_set_parse SKIPPED
test/dialect/mysql/test_types.py::EnumSetTest::test_set_roundtrip_plus_reflection SKIPPED
test/dialect/mysql/test_types.py::EnumSetTest::test_string_roundtrip SKIPPED
test/dialect/mysql/test_types.py::EnumSetTest::test_unicode_enum SKIPPED
test/dialect/mysql/test_types.py::EnumSetTest::test_unicode_roundtrip SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_bit_50 SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_bit_50_roundtrip SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_boolean SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_boolean_roundtrip SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_charset SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_charset_collate_table SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_datetime_fsp SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_datetime_generic SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_numeric SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_precision_float_roundtrip SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_time_fsp SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_time_generic SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_time_result_processor SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_time_roundtrip SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_timestamp_defaults SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_timestamp_fsp SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_timestamp_nullable SKIPPED
test/dialect/mysql/test_types.py::TypesTest::test_year SKIPPED
test/dialect/postgresql/test_compiler.py::CompileTest::test_array PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_array_literal PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_array_literal_compare PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_array_literal_insert PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_array_literal_type PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_array_zero_indexes_false PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_array_zero_indexes_true PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_drop_enum PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_index_concurrently PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_index_expr_gets_parens PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_index_literals PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_index_with_ops PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_index_with_text_or_composite PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_index_with_using PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_index_with_with PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_partial_index PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_table_inherits PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_table_inherits_quoting PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_table_inherits_tuple PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_table_with_multiple_options PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_table_with_oids PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_table_with_oncommit_option PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_table_with_tablespace PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_create_table_with_tablespace_quoted PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_exclude_constraint_cast PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_exclude_constraint_cast_quote PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_exclude_constraint_copy PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_exclude_constraint_full PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_exclude_constraint_min PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_exclude_constraint_text PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_for_update PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_from_only PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_generic_enum PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_insert_returning PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_reserved_words PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_substring PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_update_array_element PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_update_array_slice PASSED
test/dialect/postgresql/test_compiler.py::CompileTest::test_update_returning PASSED
test/dialect/postgresql/test_compiler.py::DistinctOnTest::test_distinct_on_subquery_anon PASSED
test/dialect/postgresql/test_compiler.py::DistinctOnTest::test_distinct_on_subquery_named PASSED
test/dialect/postgresql/test_compiler.py::DistinctOnTest::test_on_columns_generative PASSED
test/dialect/postgresql/test_compiler.py::DistinctOnTest::test_on_columns_generative_multi_call PASSED
test/dialect/postgresql/test_compiler.py::DistinctOnTest::test_on_columns_inline_list PASSED
test/dialect/postgresql/test_compiler.py::DistinctOnTest::test_on_columns_inline_scalar PASSED
test/dialect/postgresql/test_compiler.py::DistinctOnTest::test_plain_generative PASSED
test/dialect/postgresql/test_compiler.py::DistinctOnTest::test_plain_inline PASSED
test/dialect/postgresql/test_compiler.py::DistinctOnTest::test_query_distinct_on_aliased PASSED
test/dialect/postgresql/test_compiler.py::DistinctOnTest::test_query_on_columns PASSED
test/dialect/postgresql/test_compiler.py::DistinctOnTest::test_query_on_columns_multi_call PASSED
test/dialect/postgresql/test_compiler.py::DistinctOnTest::test_query_on_columns_subquery PASSED
test/dialect/postgresql/test_compiler.py::DistinctOnTest::test_query_plain PASSED
test/dialect/postgresql/test_compiler.py::FullTextSearchTest::test_match_basic PASSED
test/dialect/postgresql/test_compiler.py::FullTextSearchTest::test_match_regconfig PASSED
test/dialect/postgresql/test_compiler.py::FullTextSearchTest::test_match_tsvector PASSED
test/dialect/postgresql/test_compiler.py::FullTextSearchTest::test_match_tsvectorconfig PASSED
test/dialect/postgresql/test_compiler.py::FullTextSearchTest::test_match_tsvectorconfig_regconfig PASSED
test/dialect/postgresql/test_compiler.py::SequenceTest::test_format PASSED
test/dialect/postgresql/test_compiler.py::SequenceTest::test_reverse_eng_name SKIPPED
test/dialect/postgresql/test_dialect.py::MiscTest::test_autocommit_isolation_level SKIPPED
test/dialect/postgresql/test_dialect.py::MiscTest::test_checksfor_sequence SKIPPED
test/dialect/postgresql/test_dialect.py::MiscTest::test_client_encoding SKIPPED
test/dialect/postgresql/test_dialect.py::MiscTest::test_date_reflection SKIPPED
test/dialect/postgresql/test_dialect.py::MiscTest::test_extract SKIPPED
test/dialect/postgresql/test_dialect.py::MiscTest::test_numeric_raise SKIPPED
test/dialect/postgresql/test_dialect.py::MiscTest::test_pg_dialect_use_native_unicode_from_config SKIPPED
test/dialect/postgresql/test_dialect.py::MiscTest::test_preexecute_passivedefault SKIPPED
test/dialect/postgresql/test_dialect.py::MiscTest::test_psycopg2_non_standard_err SKIPPED
test/dialect/postgresql/test_dialect.py::MiscTest::test_psycopg2_version SKIPPED
test/dialect/postgresql/test_dialect.py::MiscTest::test_schema_roundtrips SKIPPED
test/dialect/postgresql/test_dialect.py::MiscTest::test_serial_integer SKIPPED
test/dialect/postgresql/test_dialect.py::MiscTest::test_version_parsing SKIPPED
test/dialect/postgresql/test_query.py::ExtractTest::test_eight SKIPPED
test/dialect/postgresql/test_query.py::ExtractTest::test_eleven SKIPPED
test/dialect/postgresql/test_query.py::ExtractTest::test_fifteen SKIPPED
test/dialect/postgresql/test_query.py::ExtractTest::test_five SKIPPED
test/dialect/postgresql/test_query.py::ExtractTest::test_four SKIPPED
test/dialect/postgresql/test_query.py::ExtractTest::test_fourteen SKIPPED
test/dialect/postgresql/test_query.py::ExtractTest::test_nine SKIPPED
test/dialect/postgresql/test_query.py::ExtractTest::test_one SKIPPED
test/dialect/postgresql/test_query.py::ExtractTest::test_seven SKIPPED
test/dialect/postgresql/test_query.py::ExtractTest::test_six SKIPPED
test/dialect/postgresql/test_query.py::ExtractTest::test_ten SKIPPED
test/dialect/postgresql/test_query.py::ExtractTest::test_thirteen SKIPPED
test/dialect/postgresql/test_query.py::ExtractTest::test_three SKIPPED
test/dialect/postgresql/test_query.py::ExtractTest::test_twelve SKIPPED
test/dialect/postgresql/test_query.py::ExtractTest::test_two SKIPPED
test/dialect/postgresql/test_query.py::InsertTest::test_autoincrement_insert SKIPPED
test/dialect/postgresql/test_query.py::InsertTest::test_autoincrement_returning_insert SKIPPED
test/dialect/postgresql/test_query.py::InsertTest::test_compiled_insert SKIPPED
test/dialect/postgresql/test_query.py::InsertTest::test_foreignkey_missing_insert SKIPPED
test/dialect/postgresql/test_query.py::InsertTest::test_noautoincrement_insert SKIPPED
test/dialect/postgresql/test_query.py::InsertTest::test_opt_sequence_insert SKIPPED
test/dialect/postgresql/test_query.py::InsertTest::test_opt_sequence_returning_insert SKIPPED
test/dialect/postgresql/test_query.py::InsertTest::test_sequence_insert SKIPPED
test/dialect/postgresql/test_query.py::InsertTest::test_sequence_returning_insert SKIPPED
test/dialect/postgresql/test_query.py::MatchTest::test_and_match SKIPPED
test/dialect/postgresql/test_query.py::MatchTest::test_expression_positional SKIPPED
test/dialect/postgresql/test_query.py::MatchTest::test_expression_pyformat SKIPPED
test/dialect/postgresql/test_query.py::MatchTest::test_match_across_joins SKIPPED
test/dialect/postgresql/test_query.py::MatchTest::test_not_match SKIPPED
test/dialect/postgresql/test_query.py::MatchTest::test_or_match SKIPPED
test/dialect/postgresql/test_query.py::MatchTest::test_simple_derivative_match SKIPPED
test/dialect/postgresql/test_query.py::MatchTest::test_simple_match SKIPPED
test/dialect/postgresql/test_query.py::MatchTest::test_simple_match_with_apostrophe SKIPPED
test/dialect/postgresql/test_query.py::ServerSideCursorsTest::test_aliases_and_ss SKIPPED
test/dialect/postgresql/test_query.py::ServerSideCursorsTest::test_conn_option SKIPPED
test/dialect/postgresql/test_query.py::ServerSideCursorsTest::test_for_update_expr SKIPPED
test/dialect/postgresql/test_query.py::ServerSideCursorsTest::test_for_update_string SKIPPED
test/dialect/postgresql/test_query.py::ServerSideCursorsTest::test_global_expr SKIPPED
test/dialect/postgresql/test_query.py::ServerSideCursorsTest::test_global_off_explicit SKIPPED
test/dialect/postgresql/test_query.py::ServerSideCursorsTest::test_global_string SKIPPED
test/dialect/postgresql/test_query.py::ServerSideCursorsTest::test_global_text SKIPPED
test/dialect/postgresql/test_query.py::ServerSideCursorsTest::test_roundtrip SKIPPED
test/dialect/postgresql/test_query.py::ServerSideCursorsTest::test_stmt_enabled_conn_option_disabled SKIPPED
test/dialect/postgresql/test_query.py::ServerSideCursorsTest::test_stmt_option SKIPPED
test/dialect/postgresql/test_query.py::ServerSideCursorsTest::test_stmt_option_disabled SKIPPED
test/dialect/postgresql/test_query.py::ServerSideCursorsTest::test_text_no_ss SKIPPED
test/dialect/postgresql/test_query.py::ServerSideCursorsTest::test_text_ss_option SKIPPED
test/dialect/postgresql/test_query.py::TupleTest::test_tuple_containment SKIPPED
test/dialect/postgresql/test_reflection.py::CustomTypeReflectionTest::test_clslevel PASSED
test/dialect/postgresql/test_reflection.py::CustomTypeReflectionTest::test_instancelevel PASSED
test/dialect/postgresql/test_reflection.py::DomainReflectionTest::test_crosschema_domain_is_reflected SKIPPED
test/dialect/postgresql/test_reflection.py::DomainReflectionTest::test_domain_is_reflected SKIPPED
test/dialect/postgresql/test_reflection.py::DomainReflectionTest::test_enum_domain_is_reflected SKIPPED
test/dialect/postgresql/test_reflection.py::DomainReflectionTest::test_schema_domain_is_reflected SKIPPED
test/dialect/postgresql/test_reflection.py::DomainReflectionTest::test_table_is_reflected SKIPPED
test/dialect/postgresql/test_reflection.py::DomainReflectionTest::test_table_is_reflected_test_schema SKIPPED
test/dialect/postgresql/test_reflection.py::DomainReflectionTest::test_unknown_types SKIPPED
test/dialect/postgresql/test_reflection.py::ForeignTableReflectionTest::test_foreign_table_is_reflected SKIPPED
test/dialect/postgresql/test_reflection.py::ForeignTableReflectionTest::test_get_foreign_table_names SKIPPED
test/dialect/postgresql/test_reflection.py::ForeignTableReflectionTest::test_get_table_names_no_foreign SKIPPED
test/dialect/postgresql/test_reflection.py::MaterializedViewReflectionTest::test_get_view_names SKIPPED
test/dialect/postgresql/test_reflection.py::MaterializedViewReflectionTest::test_mview_is_reflected SKIPPED
test/dialect/postgresql/test_reflection.py::MaterializedViewReflectionTest::test_mview_select SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_cross_schema_reflection_five SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_cross_schema_reflection_four SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_cross_schema_reflection_one SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_cross_schema_reflection_seven SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_cross_schema_reflection_six SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_cross_schema_reflection_three SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_cross_schema_reflection_two SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_foreign_key_option_inspection SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_has_temporary_table SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_index_reflection SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_index_reflection_modified SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_index_reflection_with_access_method SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_index_reflection_with_storage_options SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_inspect_enums SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_inspect_enums_schema SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_inspect_enums_star SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_pg_weirdchar_reflection SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_reflect_default_over_128_chars SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_reflect_unique_index SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_reflected_primary_key_order SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_reflection_with_unique_constraint SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_renamed_pk_reflection SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_renamed_sequence_reflection SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_uppercase_lowercase_sequence SKIPPED
test/dialect/postgresql/test_reflection.py::ReflectionTest::test_uppercase_lowercase_table SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_array_all_exec SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_array_any_exec SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_array_comparison SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_array_concat SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_array_contained_by_exec SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_array_getitem_single_exec SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_array_getitem_single_type SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_array_getitem_slice_exec SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_array_getitem_slice_type SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_array_literal SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_array_literal_compare SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_array_overlap_exec SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_array_subtype_resultprocessor SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_array_where SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_dim_array_contains_generator_exec SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_dim_array_contains_list_exec SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_dim_array_contains_set_exec SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_dimension SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_insert_array SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_reflect_array_column SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_tuple_flag SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_undim_array_contains_generator_exec SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_undim_array_contains_list_exec SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_undim_array_contains_set_exec SKIPPED
test/dialect/postgresql/test_types.py::ArrayTest::test_undim_array_empty SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_actual_type SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_adjacent_to SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_contained_by SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_contains SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_difference_result SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_different SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_insert_obj SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_insert_text SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_intersection SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_intersection_result SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_not_extend_left_of SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_not_extend_right_of SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_overlaps SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_reflect SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_strictly_left_of SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_strictly_right_of SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_union SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_union_result SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_where_equal SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_where_greater_than SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_where_greater_than_or_equal SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_where_less_than SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_where_less_than_or_equal SKIPPED
test/dialect/postgresql/test_types.py::DateRangeTests::test_where_not_equal SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_actual_type SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_adjacent_to SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_contained_by SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_contains SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_difference_result SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_different SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_insert_obj SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_insert_text SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_intersection SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_intersection_result SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_not_extend_left_of SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_not_extend_right_of SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_overlaps SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_reflect SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_strictly_left_of SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_strictly_right_of SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_union SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_union_result SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_where_equal SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_where_greater_than SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_where_greater_than_or_equal SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_where_less_than SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_where_less_than_or_equal SKIPPED
test/dialect/postgresql/test_types.py::DateTimeRangeTests::test_where_not_equal SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_actual_type SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_adjacent_to SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_contained_by SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_contains SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_difference_result SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_different SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_insert_obj SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_insert_text SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_intersection SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_intersection_result SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_not_extend_left_of SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_not_extend_right_of SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_overlaps SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_reflect SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_strictly_left_of SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_strictly_right_of SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_union SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_union_result SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_where_equal SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_where_greater_than SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_where_greater_than_or_equal SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_where_less_than SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_where_less_than_or_equal SKIPPED
test/dialect/postgresql/test_types.py::DateTimeTZRangeTests::test_where_not_equal SKIPPED
test/dialect/postgresql/test_types.py::EnumTest::test_create_table SKIPPED
test/dialect/postgresql/test_types.py::EnumTest::test_disable_create SKIPPED
test/dialect/postgresql/test_types.py::EnumTest::test_drops_on_table SKIPPED
test/dialect/postgresql/test_types.py::EnumTest::test_generate_alone_on_metadata SKIPPED
test/dialect/postgresql/test_types.py::EnumTest::test_generate_multiple SKIPPED
test/dialect/postgresql/test_types.py::EnumTest::test_generate_multiple_on_metadata SKIPPED
test/dialect/postgresql/test_types.py::EnumTest::test_name_required SKIPPED
test/dialect/postgresql/test_types.py::EnumTest::test_no_support SKIPPED
test/dialect/postgresql/test_types.py::EnumTest::test_non_native_dialect SKIPPED
test/dialect/postgresql/test_types.py::EnumTest::test_non_native_enum SKIPPED
test/dialect/postgresql/test_types.py::EnumTest::test_non_native_enum_w_unicode SKIPPED
test/dialect/postgresql/test_types.py::EnumTest::test_reflection SKIPPED
test/dialect/postgresql/test_types.py::EnumTest::test_remain_on_table_metadata_wide SKIPPED
test/dialect/postgresql/test_types.py::EnumTest::test_schema_reflection SKIPPED
test/dialect/postgresql/test_types.py::EnumTest::test_standalone_enum SKIPPED
test/dialect/postgresql/test_types.py::EnumTest::test_unicode_labels SKIPPED
test/dialect/postgresql/test_types.py::FloatCoercionTest::test_arrays SKIPPED
test/dialect/postgresql/test_types.py::FloatCoercionTest::test_float_coercion SKIPPED
test/dialect/postgresql/test_types.py::HStoreRoundTripTest::test_criterion_native SKIPPED
test/dialect/postgresql/test_types.py::HStoreRoundTripTest::test_criterion_python SKIPPED
test/dialect/postgresql/test_types.py::HStoreRoundTripTest::test_escaped_quotes_round_trip_native SKIPPED
test/dialect/postgresql/test_types.py::HStoreRoundTripTest::test_escaped_quotes_round_trip_python SKIPPED
test/dialect/postgresql/test_types.py::HStoreRoundTripTest::test_fixed_round_trip_native SKIPPED
test/dialect/postgresql/test_types.py::HStoreRoundTripTest::test_fixed_round_trip_python SKIPPED
test/dialect/postgresql/test_types.py::HStoreRoundTripTest::test_insert_native SKIPPED
test/dialect/postgresql/test_types.py::HStoreRoundTripTest::test_insert_python SKIPPED
test/dialect/postgresql/test_types.py::HStoreRoundTripTest::test_orm_round_trip SKIPPED
test/dialect/postgresql/test_types.py::HStoreRoundTripTest::test_reflect SKIPPED
test/dialect/postgresql/test_types.py::HStoreRoundTripTest::test_unicode_round_trip_native SKIPPED
test/dialect/postgresql/test_types.py::HStoreRoundTripTest::test_unicode_round_trip_python SKIPPED
test/dialect/postgresql/test_types.py::HStoreTest::test_bind_serialize_default PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_bind_serialize_psycopg2 PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_bind_serialize_with_slashes_and_quotes PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_cols_array PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_cols_concat PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_cols_concat_get PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_cols_concat_op PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_cols_delete_array_of_keys PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_cols_delete_matching_pairs PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_cols_delete_single_key PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_cols_get PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_cols_hstore_pair_array PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_cols_hstore_pair_text PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_cols_hstore_single_array PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_cols_keys PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_cols_matrix PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_cols_slice PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_cols_vals PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_parse_error PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_result_deserialize_default PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_result_deserialize_psycopg2 PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_result_deserialize_with_slashes_and_quotes PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_where_contained_by PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_where_contains PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_where_defined PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_where_getitem PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_where_has_all PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_where_has_any PASSED
test/dialect/postgresql/test_types.py::HStoreTest::test_where_has_key PASSED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_actual_type SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_adjacent_to SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_contained_by SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_contains SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_difference_result SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_different SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_insert_obj SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_insert_text SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_intersection SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_intersection_result SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_not_extend_left_of SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_not_extend_right_of SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_overlaps SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_reflect SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_strictly_left_of SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_strictly_right_of SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_union SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_union_result SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_where_equal SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_where_greater_than SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_where_greater_than_or_equal SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_where_less_than SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_where_less_than_or_equal SKIPPED
test/dialect/postgresql/test_types.py::Int4RangeTests::test_where_not_equal SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_actual_type SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_adjacent_to SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_contained_by SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_contains SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_difference_result SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_different SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_insert_obj SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_insert_text SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_intersection SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_intersection_result SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_not_extend_left_of SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_not_extend_right_of SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_overlaps SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_reflect SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_strictly_left_of SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_strictly_right_of SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_union SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_union_result SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_where_equal SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_where_greater_than SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_where_greater_than_or_equal SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_where_less_than SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_where_less_than_or_equal SKIPPED
test/dialect/postgresql/test_types.py::Int8RangeTests::test_where_not_equal SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_criterion_native SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_criterion_python SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_custom_native SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_custom_python SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_fixed_round_trip_native SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_fixed_round_trip_python SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_insert_native SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_insert_native_none_as_null SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_insert_native_nulls SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_insert_python SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_insert_python_none_as_null SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_insert_python_nulls SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_path_query SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_query_returned_as_int SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_query_returned_as_text SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_reflect SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_unicode_round_trip_native SKIPPED
test/dialect/postgresql/test_types.py::JSONBRoundTripTest::test_unicode_round_trip_python SKIPPED
test/dialect/postgresql/test_types.py::JSONBTest::test_bind_serialize_None PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_bind_serialize_default PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_bind_serialize_none_as_null PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_bind_serialize_null PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_cols_get PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_result_deserialize_None PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_result_deserialize_default PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_result_deserialize_null PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_where_contained_by PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_where_contains PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_where_getitem PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_where_getitem_as_cast PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_where_getitem_as_text PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_where_has_all PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_where_has_any PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_where_has_key PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_where_path PASSED
test/dialect/postgresql/test_types.py::JSONBTest::test_where_path_as_text PASSED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_criterion_native SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_criterion_python SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_custom_native SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_custom_python SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_fixed_round_trip_native SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_fixed_round_trip_python SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_insert_native SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_insert_native_none_as_null SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_insert_native_nulls SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_insert_python SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_insert_python_none_as_null SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_insert_python_nulls SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_path_query SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_query_returned_as_int SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_query_returned_as_text SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_reflect SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_unicode_round_trip_native SKIPPED
test/dialect/postgresql/test_types.py::JSONRoundTripTest::test_unicode_round_trip_python SKIPPED
test/dialect/postgresql/test_types.py::JSONTest::test_bind_serialize_None PASSED
test/dialect/postgresql/test_types.py::JSONTest::test_bind_serialize_default PASSED
test/dialect/postgresql/test_types.py::JSONTest::test_bind_serialize_none_as_null PASSED
test/dialect/postgresql/test_types.py::JSONTest::test_bind_serialize_null PASSED
test/dialect/postgresql/test_types.py::JSONTest::test_cols_get PASSED
test/dialect/postgresql/test_types.py::JSONTest::test_result_deserialize_None PASSED
test/dialect/postgresql/test_types.py::JSONTest::test_result_deserialize_default PASSED
test/dialect/postgresql/test_types.py::JSONTest::test_result_deserialize_null PASSED
test/dialect/postgresql/test_types.py::JSONTest::test_where_getitem PASSED
test/dialect/postgresql/test_types.py::JSONTest::test_where_getitem_as_cast PASSED
test/dialect/postgresql/test_types.py::JSONTest::test_where_getitem_as_text PASSED
test/dialect/postgresql/test_types.py::JSONTest::test_where_path PASSED
test/dialect/postgresql/test_types.py::JSONTest::test_where_path_as_text PASSED
test/dialect/postgresql/test_types.py::NumRangeTests::test_actual_type SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_adjacent_to SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_contained_by SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_contains SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_difference_result SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_different SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_insert_obj SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_insert_text SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_intersection SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_intersection_result SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_not_extend_left_of SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_not_extend_right_of SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_overlaps SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_reflect SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_strictly_left_of SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_strictly_right_of SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_union SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_union_result SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_where_equal SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_where_greater_than SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_where_greater_than_or_equal SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_where_less_than SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_where_less_than_or_equal SKIPPED
test/dialect/postgresql/test_types.py::NumRangeTests::test_where_not_equal SKIPPED
test/dialect/postgresql/test_types.py::NumericInterpretationTest::test_numeric_codes SKIPPED
test/dialect/postgresql/test_types.py::NumericInterpretationTest::test_numeric_default SKIPPED
test/dialect/postgresql/test_types.py::OIDTest::test_reflection SKIPPED
test/dialect/postgresql/test_types.py::SpecialTypesTest::test_bit_compile SKIPPED
test/dialect/postgresql/test_types.py::SpecialTypesTest::test_bit_reflection SKIPPED
test/dialect/postgresql/test_types.py::SpecialTypesTest::test_reflection SKIPPED
test/dialect/postgresql/test_types.py::SpecialTypesTest::test_tsvector_round_trip SKIPPED
test/dialect/postgresql/test_types.py::TimePrecisionTest_mssql_mxodbc::test_compile PASSED
test/dialect/postgresql/test_types.py::TimePrecisionTest_mssql_mxodbc::test_reflection SKIPPED
test/dialect/postgresql/test_types.py::TimestampTest::test_timestamp SKIPPED
test/dialect/postgresql/test_types.py::TimezoneTest::test_with_timezone SKIPPED
test/dialect/postgresql/test_types.py::TimezoneTest::test_without_timezone SKIPPED
test/dialect/postgresql/test_types.py::UUIDTest::test_no_uuid_available SKIPPED
test/dialect/postgresql/test_types.py::UUIDTest::test_uuid_array SKIPPED
test/dialect/postgresql/test_types.py::UUIDTest::test_uuid_string SKIPPED
test/dialect/postgresql/test_types.py::UUIDTest::test_uuid_string_array SKIPPED
test/dialect/postgresql/test_types.py::UUIDTest::test_uuid_uuid SKIPPED
test/dialect/test_firebird.py::ArgumentTest::test_retaining_flag_default_fdb PASSED
test/dialect/test_firebird.py::ArgumentTest::test_retaining_flag_default_kinterbasdb PASSED
test/dialect/test_firebird.py::ArgumentTest::test_retaining_flag_false_fdb PASSED
test/dialect/test_firebird.py::ArgumentTest::test_retaining_flag_false_kinterbasdb PASSED
test/dialect/test_firebird.py::ArgumentTest::test_retaining_flag_true_fdb PASSED
test/dialect/test_firebird.py::ArgumentTest::test_retaining_flag_true_kinterbasdb PASSED
test/dialect/test_firebird.py::BuggyDomainReflectionTest::test_intermixed_comment SKIPPED
test/dialect/test_firebird.py::BuggyDomainReflectionTest::test_lowercase_default_name SKIPPED
test/dialect/test_firebird.py::BuggyDomainReflectionTest::test_tables_are_reflected_same_way SKIPPED
test/dialect/test_firebird.py::CompileTest::test_alias PASSED
test/dialect/test_firebird.py::CompileTest::test_charset PASSED
test/dialect/test_firebird.py::CompileTest::test_function PASSED
test/dialect/test_firebird.py::CompileTest::test_insert_returning PASSED
test/dialect/test_firebird.py::CompileTest::test_quoting_initial_chars PASSED
test/dialect/test_firebird.py::CompileTest::test_substring PASSED
test/dialect/test_firebird.py::CompileTest::test_update_returning PASSED
test/dialect/test_firebird.py::CompileTest::test_varchar_raise PASSED
test/dialect/test_firebird.py::DomainReflectionTest::test_table_is_reflected SKIPPED
test/dialect/test_firebird.py::MiscTest::test_percents_in_text SKIPPED
test/dialect/test_firebird.py::MiscTest::test_rowcount_flag SKIPPED
test/dialect/test_firebird.py::MiscTest::test_strlen SKIPPED
test/dialect/test_firebird.py::MiscTest::test_version_parsing SKIPPED
test/dialect/test_firebird.py::TypesTest::test_infinite_float SKIPPED
test/dialect/test_mxodbc.py::MxODBCTest::test_native_odbc_execute PASSED
test/dialect/test_oracle.py::BufferedColumnTest::test_fetch SKIPPED
test/dialect/test_oracle.py::BufferedColumnTest::test_fetch_single_arraysize SKIPPED
test/dialect/test_oracle.py::CXOracleArgsTest::test_autosetinputsizes SKIPPED
test/dialect/test_oracle.py::CXOracleArgsTest::test_exclude_inputsizes_custom SKIPPED
test/dialect/test_oracle.py::CXOracleArgsTest::test_exclude_inputsizes_none SKIPPED
test/dialect/test_oracle.py::CompatFlagsTest::test_default_flags PASSED
test/dialect/test_oracle.py::CompatFlagsTest::test_ora10_flags PASSED
test/dialect/test_oracle.py::CompatFlagsTest::test_ora8_flags PASSED
test/dialect/test_oracle.py::CompileTest::test_alias_outer_join PASSED
test/dialect/test_oracle.py::CompileTest::test_bindparam_quote PASSED
test/dialect/test_oracle.py::CompileTest::test_compound PASSED
test/dialect/test_oracle.py::CompileTest::test_create_index_alt_schema PASSED
test/dialect/test_oracle.py::CompileTest::test_create_index_bitmap_compress PASSED
test/dialect/test_oracle.py::CompileTest::test_create_index_expr PASSED
test/dialect/test_oracle.py::CompileTest::test_create_table_compress PASSED
test/dialect/test_oracle.py::CompileTest::test_cte PASSED
test/dialect/test_oracle.py::CompileTest::test_for_update PASSED
test/dialect/test_oracle.py::CompileTest::test_limit PASSED
test/dialect/test_oracle.py::CompileTest::test_limit_preserves_typing_information PASSED
test/dialect/test_oracle.py::CompileTest::test_long_labels PASSED
test/dialect/test_oracle.py::CompileTest::test_no_paren_fns PASSED
test/dialect/test_oracle.py::CompileTest::test_nonansi_nested_right_join PASSED
test/dialect/test_oracle.py::CompileTest::test_outer_join PASSED
test/dialect/test_oracle.py::CompileTest::test_owner PASSED
test/dialect/test_oracle.py::CompileTest::test_returning_insert PASSED
test/dialect/test_oracle.py::CompileTest::test_returning_insert_functional PASSED
test/dialect/test_oracle.py::CompileTest::test_returning_insert_labeled PASSED
test/dialect/test_oracle.py::CompileTest::test_subquery PASSED
test/dialect/test_oracle.py::CompileTest::test_table_options PASSED
test/dialect/test_oracle.py::CompileTest::test_true_false PASSED
test/dialect/test_oracle.py::CompileTest::test_use_binds_for_limits_disabled PASSED
test/dialect/test_oracle.py::CompileTest::test_use_binds_for_limits_enabled PASSED
test/dialect/test_oracle.py::ConstraintTest::test_oracle_has_no_on_update_cascade SKIPPED
test/dialect/test_oracle.py::DBLinkReflectionTest::test_hello_world SKIPPED
test/dialect/test_oracle.py::DBLinkReflectionTest::test_reflection SKIPPED
test/dialect/test_oracle.py::DialectTypesTest::test_char_length PASSED
test/dialect/test_oracle.py::DialectTypesTest::test_interval PASSED
test/dialect/test_oracle.py::DialectTypesTest::test_long PASSED
test/dialect/test_oracle.py::DialectTypesTest::test_no_clobs_for_string_params PASSED
test/dialect/test_oracle.py::DialectTypesTest::test_raw_compile PASSED
test/dialect/test_oracle.py::DialectTypesTest::test_type_adapt PASSED
test/dialect/test_oracle.py::DialectTypesTest::test_varchar_types PASSED
test/dialect/test_oracle.py::DontReflectIOTTest::test_reflect_all SKIPPED
test/dialect/test_oracle.py::EuroNumericTest::test_output_type_handler SKIPPED
test/dialect/test_oracle.py::ExecuteTest::test_basic SKIPPED
test/dialect/test_oracle.py::ExecuteTest::test_limit_offset_for_update SKIPPED
test/dialect/test_oracle.py::ExecuteTest::test_sequences_are_integers SKIPPED
test/dialect/test_oracle.py::MultiSchemaTest::test_create_same_names_explicit_schema SKIPPED
test/dialect/test_oracle.py::MultiSchemaTest::test_create_same_names_implicit_schema SKIPPED
test/dialect/test_oracle.py::MultiSchemaTest::test_reflect_alt_owner_explicit SKIPPED
test/dialect/test_oracle.py::MultiSchemaTest::test_reflect_alt_owner_implicit SKIPPED
test/dialect/test_oracle.py::MultiSchemaTest::test_reflect_alt_owner_synonyms SKIPPED
test/dialect/test_oracle.py::MultiSchemaTest::test_reflect_alt_synonym_owner_local_table SKIPPED
test/dialect/test_oracle.py::MultiSchemaTest::test_reflect_alt_table_owner_local_synonym SKIPPED
test/dialect/test_oracle.py::MultiSchemaTest::test_reflect_local_to_remote SKIPPED
test/dialect/test_oracle.py::MultiSchemaTest::test_reflect_remote_synonyms SKIPPED
test/dialect/test_oracle.py::OutParamTest::test_out_params SKIPPED
test/dialect/test_oracle.py::QuotedBindRoundTripTest::test_numeric_bind_in_crud SKIPPED
test/dialect/test_oracle.py::QuotedBindRoundTripTest::test_numeric_bind_round_trip SKIPPED
test/dialect/test_oracle.py::QuotedBindRoundTripTest::test_table_round_trip SKIPPED
test/dialect/test_oracle.py::RoundTripIndexTest::test_basic SKIPPED
test/dialect/test_oracle.py::SequenceTest::test_basic PASSED
test/dialect/test_oracle.py::ServiceNameTest::test_cx_oracle_service_name SKIPPED
test/dialect/test_oracle.py::ServiceNameTest::test_cx_oracle_service_name_bad SKIPPED
test/dialect/test_oracle.py::TableReflectionTest::test_reflect_basic_compression SKIPPED
test/dialect/test_oracle.py::TableReflectionTest::test_reflect_oltp_compression SKIPPED
test/dialect/test_oracle.py::TwoPhaseTest::test_not_prepared SKIPPED
test/dialect/test_oracle.py::TwoPhaseTest::test_twophase_prepare_false SKIPPED
test/dialect/test_oracle.py::TwoPhaseTest::test_twophase_prepare_true SKIPPED
test/dialect/test_oracle.py::TwoPhaseTest::test_twophase_rollback SKIPPED
test/dialect/test_oracle.py::TypesTest::test_char_length SKIPPED
test/dialect/test_oracle.py::TypesTest::test_coerce_to_unicode SKIPPED
test/dialect/test_oracle.py::TypesTest::test_fixed_char SKIPPED
test/dialect/test_oracle.py::TypesTest::test_int_not_float SKIPPED
test/dialect/test_oracle.py::TypesTest::test_interval SKIPPED
test/dialect/test_oracle.py::TypesTest::test_lobs_without_convert SKIPPED
test/dialect/test_oracle.py::TypesTest::test_long_type SKIPPED
test/dialect/test_oracle.py::TypesTest::test_longstring SKIPPED
test/dialect/test_oracle.py::TypesTest::test_numeric_no_decimal_mode SKIPPED
test/dialect/test_oracle.py::TypesTest::test_numerics SKIPPED
test/dialect/test_oracle.py::TypesTest::test_numerics_broken_inspection SKIPPED
test/dialect/test_oracle.py::TypesTest::test_raw_roundtrip SKIPPED
test/dialect/test_oracle.py::TypesTest::test_reflect_all_types_schema SKIPPED
test/dialect/test_oracle.py::TypesTest::test_reflect_dates SKIPPED
test/dialect/test_oracle.py::TypesTest::test_reflect_nvarchar SKIPPED
test/dialect/test_oracle.py::TypesTest::test_rowid SKIPPED
test/dialect/test_oracle.py::UnicodeSchemaTest::test_quoted_column_non_unicode SKIPPED
test/dialect/test_oracle.py::UnicodeSchemaTest::test_quoted_column_unicode SKIPPED
test/dialect/test_oracle.py::UnsupportedIndexReflectTest::test_reflect_functional_index SKIPPED
test/dialect/test_pyodbc.py::PyODBCTest::test_pyodbc_version PASSED
test/dialect/test_sqlite.py::AttachedFileDBTest::test_col_targeting SKIPPED
test/dialect/test_sqlite.py::AttachedFileDBTest::test_col_targeting_union SKIPPED
test/dialect/test_sqlite.py::AttachedFileDBTest::test_crud SKIPPED
test/dialect/test_sqlite.py::AttachedFileDBTest::test_no_tables SKIPPED
test/dialect/test_sqlite.py::AttachedFileDBTest::test_reflect_system_table SKIPPED
test/dialect/test_sqlite.py::AttachedFileDBTest::test_reflect_user_table SKIPPED
test/dialect/test_sqlite.py::AttachedFileDBTest::test_table_names_present SKIPPED
test/dialect/test_sqlite.py::AttachedFileDBTest::test_table_names_system SKIPPED
test/dialect/test_sqlite.py::AttachedMemoryDBTest::test_col_targeting SKIPPED
test/dialect/test_sqlite.py::AttachedMemoryDBTest::test_col_targeting_union SKIPPED
test/dialect/test_sqlite.py::AttachedMemoryDBTest::test_crud SKIPPED
test/dialect/test_sqlite.py::AttachedMemoryDBTest::test_no_tables SKIPPED
test/dialect/test_sqlite.py::AttachedMemoryDBTest::test_reflect_system_table SKIPPED
test/dialect/test_sqlite.py::AttachedMemoryDBTest::test_reflect_user_table SKIPPED
test/dialect/test_sqlite.py::AttachedMemoryDBTest::test_table_names_present SKIPPED
test/dialect/test_sqlite.py::AttachedMemoryDBTest::test_table_names_system SKIPPED
test/dialect/test_sqlite.py::AutoIncrementTest::test_sqlite_autoincrement PASSED
test/dialect/test_sqlite.py::AutoIncrementTest::test_sqlite_autoincrement_constraint PASSED
test/dialect/test_sqlite.py::AutoIncrementTest::test_sqlite_autoincrement_int_affinity PASSED
test/dialect/test_sqlite.py::AutoIncrementTest::test_sqlite_no_autoincrement PASSED
test/dialect/test_sqlite.py::ConstraintReflectionTest::test_create_index_with_schema SKIPPED
test/dialect/test_sqlite.py::ConstraintReflectionTest::test_dont_reflect_autoindex SKIPPED
test/dialect/test_sqlite.py::ConstraintReflectionTest::test_foreign_key_composite_broken_casing SKIPPED
test/dialect/test_sqlite.py::ConstraintReflectionTest::test_foreign_key_name_is_none SKIPPED
test/dialect/test_sqlite.py::ConstraintReflectionTest::test_foreign_key_name_is_not_none SKIPPED
test/dialect/test_sqlite.py::ConstraintReflectionTest::test_legacy_quoted_identifiers_unit SKIPPED
test/dialect/test_sqlite.py::ConstraintReflectionTest::test_unique_constraint_named SKIPPED
test/dialect/test_sqlite.py::ConstraintReflectionTest::test_unique_constraint_named_broken_casing SKIPPED
test/dialect/test_sqlite.py::ConstraintReflectionTest::test_unique_constraint_named_broken_temp SKIPPED
test/dialect/test_sqlite.py::ConstraintReflectionTest::test_unique_constraint_unnamed_inline SKIPPED
test/dialect/test_sqlite.py::ConstraintReflectionTest::test_unique_constraint_unnamed_inline_quoted SKIPPED
test/dialect/test_sqlite.py::ConstraintReflectionTest::test_unique_constraint_unnamed_normal SKIPPED
test/dialect/test_sqlite.py::ConstraintReflectionTest::test_unique_constraint_unnamed_normal_temporary SKIPPED
test/dialect/test_sqlite.py::ConstraintReflectionTest::test_unnamed_inline_foreign_key SKIPPED
test/dialect/test_sqlite.py::ConstraintReflectionTest::test_unnamed_inline_foreign_key_quoted SKIPPED
test/dialect/test_sqlite.py::DateTest::test_custom_format PASSED
test/dialect/test_sqlite.py::DateTest::test_default PASSED
test/dialect/test_sqlite.py::DateTimeTest::test_custom_format_compact PASSED
test/dialect/test_sqlite.py::DateTimeTest::test_time_microseconds PASSED
test/dialect/test_sqlite.py::DateTimeTest::test_truncate_microseconds PASSED
test/dialect/test_sqlite.py::DefaultsTest::test_boolean_default SKIPPED
test/dialect/test_sqlite.py::DefaultsTest::test_default_reflection SKIPPED
test/dialect/test_sqlite.py::DefaultsTest::test_default_reflection_2 SKIPPED
test/dialect/test_sqlite.py::DefaultsTest::test_default_reflection_3 SKIPPED
test/dialect/test_sqlite.py::DefaultsTest::test_old_style_default SKIPPED
test/dialect/test_sqlite.py::DialectTest::test_description_encoding SKIPPED
test/dialect/test_sqlite.py::DialectTest::test_extra_reserved_words SKIPPED
test/dialect/test_sqlite.py::DialectTest::test_file_path_is_absolute SKIPPED
test/dialect/test_sqlite.py::DialectTest::test_pool_class SKIPPED
test/dialect/test_sqlite.py::DialectTest::test_quoted_identifiers_functional_one SKIPPED
test/dialect/test_sqlite.py::DialectTest::test_quoted_identifiers_functional_two SKIPPED
test/dialect/test_sqlite.py::InsertTest::test_empty_insert_nopk1 SKIPPED
test/dialect/test_sqlite.py::InsertTest::test_empty_insert_nopk2 SKIPPED
test/dialect/test_sqlite.py::InsertTest::test_empty_insert_pk1 SKIPPED
test/dialect/test_sqlite.py::InsertTest::test_empty_insert_pk2 SKIPPED
test/dialect/test_sqlite.py::InsertTest::test_empty_insert_pk3 SKIPPED
test/dialect/test_sqlite.py::InsertTest::test_empty_insert_pk4 SKIPPED
test/dialect/test_sqlite.py::InsertTest::test_inserts_with_spaces SKIPPED
test/dialect/test_sqlite.py::MatchTest::test_and_match SKIPPED
test/dialect/test_sqlite.py::MatchTest::test_expression SKIPPED
test/dialect/test_sqlite.py::MatchTest::test_match_across_joins SKIPPED
test/dialect/test_sqlite.py::MatchTest::test_or_match SKIPPED
test/dialect/test_sqlite.py::MatchTest::test_simple_match SKIPPED
test/dialect/test_sqlite.py::MatchTest::test_simple_prefix_match SKIPPED
test/dialect/test_sqlite.py::ReflectHeadlessFKsTest::test_reflect_tables_fk_no_colref SKIPPED
test/dialect/test_sqlite.py::SQLTest::test_constraints_with_schemas PASSED
test/dialect/test_sqlite.py::SQLTest::test_create_partial_index PASSED
test/dialect/test_sqlite.py::SQLTest::test_extract PASSED
test/dialect/test_sqlite.py::SQLTest::test_localtime PASSED
test/dialect/test_sqlite.py::SQLTest::test_true_false PASSED
test/dialect/test_sqlite.py::SavepointTest::test_nested_subtransaction_commit SKIPPED
test/dialect/test_sqlite.py::SavepointTest::test_nested_subtransaction_rollback SKIPPED
test/dialect/test_sqlite.py::SavepointTest::test_rollback_to_subtransaction SKIPPED
test/dialect/test_sqlite.py::TestTypes::test_boolean SKIPPED
test/dialect/test_sqlite.py::TestTypes::test_cant_parse_datetime_message SKIPPED
test/dialect/test_sqlite.py::TestTypes::test_custom_date SKIPPED
test/dialect/test_sqlite.py::TestTypes::test_custom_date_text_affinity SKIPPED
test/dialect/test_sqlite.py::TestTypes::test_custom_datetime SKIPPED
test/dialect/test_sqlite.py::TestTypes::test_custom_datetime_text_affinity SKIPPED
test/dialect/test_sqlite.py::TestTypes::test_native_datetime SKIPPED
test/dialect/test_sqlite.py::TestTypes::test_no_convert_unicode SKIPPED
test/dialect/test_sqlite.py::TestTypes::test_string_dates_passed_raise SKIPPED
test/dialect/test_sqlite.py::TimeTest::test_custom_format PASSED
test/dialect/test_sqlite.py::TimeTest::test_default PASSED
test/dialect/test_sqlite.py::TimeTest::test_truncate_microseconds PASSED
test/dialect/test_sqlite.py::TypeReflectionTest::test_lookup_direct_lookup SKIPPED
test/dialect/test_sqlite.py::TypeReflectionTest::test_lookup_direct_type_affinity SKIPPED
test/dialect/test_sqlite.py::TypeReflectionTest::test_lookup_direct_unsupported_args SKIPPED
test/dialect/test_sqlite.py::TypeReflectionTest::test_round_trip_direct_lookup SKIPPED
test/dialect/test_sqlite.py::TypeReflectionTest::test_round_trip_direct_type_affinity SKIPPED
test/dialect/test_sqlite.py::TypeReflectionTest::test_round_trip_direct_unsupported_args SKIPPED
test/dialect/test_suite.py::BooleanTest_mssql_mxodbc::test_null <- lib/sqlalchemy/testing/suite/test_types.py PASSED
test/dialect/test_suite.py::BooleanTest_mssql_mxodbc::test_render_literal_bool <- lib/sqlalchemy/testing/suite/test_types.py PASSED
test/dialect/test_suite.py::BooleanTest_mssql_mxodbc::test_round_trip <- lib/sqlalchemy/testing/suite/test_types.py PASSED
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_autoincrement_col <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_deprecated_get_primary_keys <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_dialect_initialize <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_columns <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_columns_with_schema <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_default_schema_name <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_foreign_keys <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_foreign_keys_with_schema <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_indexes <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_indexes_with_schema <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_pk_constraint <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_pk_constraint_with_schema <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_schema_names <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_table_names <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_table_names_fks <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_table_names_with_schema <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_table_oid <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_table_oid_with_schema <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_tables_and_views <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_temp_table_columns <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_temp_table_indexes <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_temp_table_names <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_temp_table_unique_constraints <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
test/dialect/test_suite.py::ComponentReflectionTest_mssql_mxodbc::test_get_temp_view_columns <- lib/sqlalchemy/testing/suite/test_reflection.py ERROR
===================================================================================================== ERRORS ======================================================================================================
__________________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_autoincrement_col __________________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
_____________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_deprecated_get_primary_keys _____________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
_________________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_dialect_initialize __________________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
_____________________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_columns _____________________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
_______________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_columns_with_schema _______________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
_______________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_default_schema_name _______________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
__________________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_foreign_keys ___________________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
____________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_foreign_keys_with_schema _____________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
_____________________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_indexes _____________________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
_______________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_indexes_with_schema _______________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
__________________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_pk_constraint __________________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
____________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_pk_constraint_with_schema ____________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
__________________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_schema_names ___________________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
___________________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_table_names ___________________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
_________________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_table_names_fks _________________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
_____________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_table_names_with_schema _____________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
____________________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_table_oid ____________________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
______________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_table_oid_with_schema ______________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
________________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_tables_and_views _________________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
_______________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_temp_table_columns ________________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
_______________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_temp_table_indexes ________________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
________________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_temp_table_names _________________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
__________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_temp_table_unique_constraints __________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
________________________________________________________________ ERROR at setup of ComponentReflectionTest_mssql_mxodbc.test_get_temp_view_columns ________________________________________________________________
Traceback (most recent call last):
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 83, in setup_class
cls._setup_once_tables()
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/fixtures.py", line 112, in _setup_once_tables
cls.metadata.create_all(cls.bind)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/schema.py", line 3687, in create_all
tables=tables)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1856, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1481, in _run_visitor
**kwargs).traverse_single(element)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 730, in visit_metadata
_is_metadata_operation=True)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/visitors.py", line 121, in traverse_single
return meth(obj, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 764, in visit_table
include_foreign_key_constraints=include_foreign_key_constraints
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 968, in _execute_ddl
compiled
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/util/compat.py", line 199, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 150, in do_execute
cursor.execute(statement, parameters, direct=self._get_direct(context))
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py", line 86, in error_handler
raise errorclass(errorvalue)
ProgrammingError: (mx.ODBC.Error.ProgrammingError) ('42000', 1770, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Foreign key 'FK__email_add__remot__22A269FA' references invalid column 'user_id' in referenced table 'users'.", 11245) [SQL: u'\nCREATE TABLE email_addresses (\n\taddress_id INTEGER NOT NULL IDENTITY(1,1), \n\tremote_user_id INTEGER NULL, \n\temail_address VARCHAR(20) NULL, \n\tCONSTRAINT email_ad_pk PRIMARY KEY (address_id), \n\tFOREIGN KEY(remote_user_id) REFERENCES users (user_id)\n)\n\n']
==================================================================================================== FAILURES =====================================================================================================
_____________________________________________________________________________________ ReflectionTest.test_db_qualified_items ______________________________________________________________________________________
Traceback (most recent call last):
File "<string>", line 2, in test_db_qualified_items
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/util.py", line 196, in provide_metadata
return fn(*args, **kw)
File "/home/sallen/env/testmx334d2/sqlalchemy/test/dialect/mssql/test_reflection.py", line 111, in test_db_qualified_items
'constrained_columns': ['foo_id']}]
File "/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/testing/assertions.py", line 209, in eq_
assert a == b, msg or "%r != %r" % (a, b)
AssertionError: [{'referred_table': u'foo', 'referred_columns': [u'id'], 'referred_schema': u'test_sqlalchemy.jiva_user', 'name': u'fkfoo', 'constrained_columns': [u'foo_id']}] != [{'referred_table': 'foo', 'constrained_columns': ['foo_id'], 'referred_schema': 'test.dbo', 'name': 'fkfoo', 'referred_columns': ['id']}]
---------------------------------------------------------------------------------------------- Captured stderr call -----------------------------------------------------------------------------------------------
/home/sallen/env/testmx334d2/sqlalchemy/test/../lib/sqlalchemy/connectors/mxodbc.py:150: Warning: ('01000', 5701, "[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Changed database context to 'test_sqlalchemy'.", 11245)
cursor.execute(statement, parameters, direct=self._get_direct(context))
============================================================================================= short test summary info =============================================================================================
FAIL test/dialect/mssql/test_reflection.py::ReflectionTest::()::test_db_qualified_items
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Interrupted: stopping after 25 failures !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
========================================================================== 1 failed, 578 passed, 587 skipped, 24 error in 458.74 seconds ==========================================================================
Segmentation fault (core dumped)
@sheilatron
Copy link
Author

Looks like the segfault is reproducible with pyodbc, on both Windows & Linux using Microsoft Native SQL Server driver.

(testmx334d2)[sallen@localhost sqlalchemy]$ py.test --db pmssql test/dialect/mssql/test_types.py
=============================================================================================== test session starts ===============================================================================================
platform linux2 -- Python 2.7.10 -- py-1.4.30 -- pytest-2.7.2 -- /home/sallen/env/testmx334d2/bin/python
rootdir: /home/sallen/env/testmx334d2/sqlalchemy, inifile: setup.cfg
collected 22 items

test/dialect/mssql/test_types.py::BinaryTest::test_binary_legacy_types PASSED
test/dialect/mssql/test_types.py::BinaryTest::test_binary_none_legacy_types PASSED
test/dialect/mssql/test_types.py::BinaryTest::test_binary_none_updated_types PASSED
test/dialect/mssql/test_types.py::BinaryTest::test_binary_updated_types PASSED
test/dialect/mssql/test_types.py::MonkeyPatchedBinaryTest::test_bytes SKIPPED
test/dialect/mssql/test_types.py::MonkeyPatchedBinaryTest::test_unicode SKIPPED
test/dialect/mssql/test_types.py::TimeTypeTest::test_result_processor_no_microseconds PASSED
test/dialect/mssql/test_types.py::TimeTypeTest::test_result_processor_too_many_microseconds PASSED
test/dialect/mssql/test_types.py::TypeDDLTest::test_binary PASSED
test/dialect/mssql/test_types.py::TypeDDLTest::test_boolean PASSED
test/dialect/mssql/test_types.py::TypeDDLTest::test_char PASSED
test/dialect/mssql/test_types.py::TypeDDLTest::test_large_type_deprecation PASSED
test/dialect/mssql/test_types.py::TypeDDLTest::test_money PASSED
test/dialect/mssql/test_types.py::TypeDDLTest::test_numeric PASSED
test/dialect/mssql/test_types.py::TypeDDLTest::test_timestamp PASSED
test/dialect/mssql/test_types.py::TypeRoundTripTest::test_autoincrement PASSED
test/dialect/mssql/test_types.py::TypeRoundTripTest::test_binary_reflection_legacy_large_types PASSED
test/dialect/mssql/test_types.py::TypeRoundTripTest::test_binary_reflection_sql2012_large_types PASSED
test/dialect/mssql/test_types.py::TypeRoundTripTest::test_date_roundtrip PASSED
test/dialect/mssql/test_types.py::TypeRoundTripTest::test_dates PASSED
test/dialect/mssql/test_types.py::TypeRoundTripTest::test_decimal_notation PASSED
test/dialect/mssql/test_types.py::TypeRoundTripTest::test_float PASSED

====================================================================================== 20 passed, 2 skipped in 32.81 seconds ======================================================================================
Segmentation fault (core dumped)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment