sqlalchemy/sqlalchemy issues and pull requests

#12736 - deprecate "wrong" JSON operators (at least contains()) that are misleading since they overlap with JSONB; generalize to all types

Issue - State: closed - Opened by zzzeek 5 months ago - 3 comments
Labels: bug, datatypes, big job

#12690 - Revisit inherit_schema implementation

Issue - State: closed - Opened by CaselIT 6 months ago - 2 comments
Labels: schema, datatypes, code review in progress

#12317 - Add Support for Oracle VECTOR Datatype

Issue - State: closed - Opened by suraj-ora-2020 10 months ago - 2 comments
Labels: oracle, datatypes, use case

#12002 - TypeDecorator pickling error in 2.0, works fine in 1.4.54

Issue - State: closed - Opened by zzzeek about 1 year ago - 2 comments
Labels: bug, datatypes, regression, near-term release

#11978 - get _Binary to generic LargeBinary

Issue - State: closed - Opened by zzzeek about 1 year ago - 2 comments
Labels: datatypes, use case, near-term release

#11811 - Float, Numeric primary key column has autoincrement set to true

Issue - State: closed - Opened by CaselIT over 1 year ago - 7 comments
Labels: bug, schema, datatypes

#11633 - Support Oracle 23ai BOOLEAN datatype

Issue - State: open - Opened by CoxT9 over 1 year ago - 11 comments
Labels: oracle, datatypes, fairly easy, PRs (with tests!) welcome, use case

#11597 - sqltypes.Enum not generic enough

Issue - State: open - Opened by zzzeek over 1 year ago
Labels: bug, datatypes, typing

#11576 - the collate() binary expression should copy the internal type and reset its collation as well

Issue - State: closed - Opened by riwu over 1 year ago - 4 comments
Labels: bug, postgresql, sql, datatypes, near-term release

#11479 - mysql etc. percent escaping for literal enum

Issue - State: closed - Opened by zzzeek over 1 year ago - 2 comments
Labels: bug, mysql, datatypes, near-term release

#11176 - Some column types lose variants when inherited [SA 2.0 regression]

Issue - State: closed - Opened by ziima over 1 year ago - 3 comments
Labels: bug, datatypes, great mcve, near-term release, orm - annotated declarative

#11132 - MySQL DOUBLE accepts deprecated params that dont propagate from the base DOUBLE type, document this caveat

Issue - State: open - Opened by MacBath over 1 year ago - 3 comments
Labels: documentation, mysql, datatypes, PRs (with tests!) welcome

#10821 - Deprecate array any/all implementation specific implementations

Issue - State: closed - Opened by CaselIT almost 2 years ago - 2 comments
Labels: task, sql, datatypes, code review in progress

#10646 - Return object by default for python_type, types that have union types should just return it

Issue - State: closed - Opened by CaselIT about 2 years ago - 2 comments
Labels: datatypes, typing

#10604 - add "create_type" to sqltypes.Enum ?

Issue - State: closed - Opened by zzzeek about 2 years ago - 8 comments
Labels: postgresql, datatypes, code review in progress

#10594 - Change the default value of Enum.inherit_schema to True

Issue - State: closed - Opened by CaselIT about 2 years ago - 5 comments
Labels: task, datatypes, PRs (with tests!) welcome, use case

#10556 - create new string subclass for bit strings for PG drivers

Issue - State: closed - Opened by zzzeek about 2 years ago - 5 comments
Labels: bug, postgresql, datatypes, PRs (with tests!) welcome

#10375 - support Oracle JSON datatype

Issue - State: open - Opened by zzzeek about 2 years ago - 2 comments
Labels: oracle, datatypes, PRs (with tests!) welcome, use case

#10339 - Use the native UUID type on mariadb

Issue - State: closed - Opened by CaselIT about 2 years ago - 6 comments
Labels: datatypes, PRs (with tests!) welcome, mariadb

#10196 - Using default timestamp leads to error

Issue - State: closed - Opened by Krzmbrzl over 2 years ago - 5 comments
Labels: datatypes, expected behavior

#10096 - PostgreSQL CITEXT case-insensitive comparison not working in psycopg dialect due to ::VARCHAR cast

Issue - State: closed - Opened by jtbeach over 2 years ago - 4 comments
Labels: bug, postgresql, datatypes, great mcve, near-term release

#9945 - Unexpected/incorrect Python type returned for INET data type when used with psycopg driver

Issue - State: closed - Opened by jtbeach over 2 years ago - 9 comments
Labels: bug, postgresql, datatypes, use case

#9773 - [Postgresql] `ENUM` does not forward `create_type` when producing column copies for `declarative_base`

Issue - State: closed - Opened by ohaibbq over 2 years ago - 4 comments
Labels: bug, postgresql, datatypes, near-term release

#9704 - Use binary_float/double in Oracle when using the generic Float/Double.

Issue - State: closed - Opened by CaselIT over 2 years ago - 10 comments
Labels: oracle, datatypes

#9701 - Floats are rounded to whole numbers when inserted in batches

Issue - State: closed - Opened by rbuffat over 2 years ago - 14 comments
Labels: bug, postgresql, datatypes, regression, near-term release

#9693 - Text type columns using schema qualified collations compile a quoted DDL statement on Postgres

Issue - State: open - Opened by matt-mclaughlin-quantum-si over 2 years ago - 6 comments
Labels: postgresql, schema, datatypes, PRs welcome, use case

#9680 - Optimize bytes sqltype so that is does not create a processor for engines that return native bytes

Issue - State: closed - Opened by bdraco over 2 years ago - 2 comments
Labels: performance, datatypes, use case

#8661 - `Invalid precision value` when inserting long string on varchar column in SQLAlchemy 2.0.0b1

Issue - State: closed - Opened by harupy about 3 years ago - 8 comments
Labels: bug, SQL Server, datatypes, regression, great mcve

#8106 - LookupError when querying Table with enum column containing non defined values

Issue - State: closed - Opened by karolpawlowski over 3 years ago - 6 comments
Labels: sql, datatypes, expected behavior

#7223 - Interval type should not subclass from `TypeDecorator`

Issue - State: open - Opened by CaselIT about 4 years ago - 6 comments
Labels: sql, datatypes

#6511 - add support for reflection of collation in types

Issue - State: open - Opened by zzzeek over 4 years ago - 7 comments
Labels: reflection, datatypes, fairly easy, PRs (with tests!) welcome, use case

#5252 - Type Float inherits of type Numeric, even though doc indicates otherwise

Issue - State: closed - Opened by janfrederik over 5 years ago - 22 comments
Labels: bug, datatypes

#4733 - Give more details in LookupError message

Issue - State: closed - Opened by ghost over 6 years ago - 4 comments
Labels: bug, sql, datatypes

GitHub / sqlalchemy/sqlalchemy issues and pull requests