def temporary_views(self): """ MonetDB doesn't have temporary views, but does support views of temporary tables. TODO: disabled for now, but maybe we can enable this? """ return exclusions.closed()
def order_by_col_from_union(self): """target database supports ordering by a column from a SELECT inside of a UNION E.g. (SELECT id, ...) UNION (SELECT id, ...) ORDER BY id Fails on SQL Server This is also unsupported by MonetDB """ return exclusions.closed()
def bound_limit_offset(self): """target database can render LIMIT and/or OFFSET using a bound parameter open by default, but closed since raises: sqlalchemy.exc.CompileError: This SELECT structure does not use a simple integer value for offset """ return exclusions.closed()
def parens_in_union_contained_select_w_limit_offset(self): """Target database must support parenthesized SELECT in UNION when LIMIT/OFFSET is specifically present. E.g. (SELECT ...) UNION (SELECT ..) This is known to fail on SQLite. This is also unsupported by MonetDB https://www.monetdb.org/bugzilla/show_bug.cgi?id=6434 """ return exclusions.closed()
def parens_in_union_contained_select_wo_limit_offset(self): """Target database must support parenthesized SELECT in UNION when OFFSET/LIMIT is specifically not present. E.g. (SELECT ... LIMIT ..) UNION (SELECT .. OFFSET ..) This is known to fail on SQLite. It also fails on Oracle because without LIMIT/OFFSET, there is currently no step that creates an additional subquery. This is also unsupported by MonetDB https://www.monetdb.org/bugzilla/show_bug.cgi?id=6434 """ return exclusions.closed()
def foreign_key_constraint_option_reflection(self): """TODO: PostgreSQL, MonetDB and sqlite support this, so probably MoentDB also""" return exclusions.closed()
def broken_cx_oracle6_numerics(config): return exclusions.closed()
def precision_numerics_enotation_large(self): """We don't support Numeric > 18""" return exclusions.closed()
def datetime_microseconds(self): """monetdb doesn't support microsecond resolution""" return exclusions.closed()
def unique_constraint_reflection(self): """target dialect supports reflection of unique constraints""" return exclusions.closed()