]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Added vector datatype support in Oracle dialect 12321/head
authorsuraj <suraj.shaw@oracle.com>
Thu, 24 Apr 2025 22:51:24 +0000 (18:51 -0400)
committersuraj <suraj.shaw@oracle.com>
Sun, 4 May 2025 19:27:40 +0000 (00:57 +0530)
commita72a18a45c85ae7fa50a34e97ac642e16b463b54
tree9ffa7294fc8ab582636bd1dab2ba346da8062bb5
parentce3bbfcc4550e72a603640e533bc736715c5d76b
Added vector datatype support in Oracle dialect

Added new datatype :class:`_oracle.VECTOR` and accompanying DDL and DQL
support to fully support this type for Oracle Database. This change
includes the base :class:`_oracle.VECTOR` type that adds new type-specific
methods ``l2_distance``, ``cosine_distance``, ``inner_product`` as well as
new parameters ``oracle_vector`` for the :class:`.Index` construct,
allowing vector indexes to be configured, and ``oracle_fetch_approximate``
for the :meth:`.Select.fetch` clause.  Pull request courtesy Suraj Shaw.

Fixes: #12317
Fixes: #12341
Closes: #12321
Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/12321
Pull-request-sha: a0b3fa8fc993d2f70a089a649edb1cf18b12a84a

Change-Id: I6f3af4623ce439d0820c14582cd129df293f0ba8

Added vector datatype support in Oracle dialect #12321

Added vector datatype support in Oracle dialect#12321

Added vector datatype support in Oracle dialect#12321

updated to static link

some doc modification
12 files changed:
doc/build/changelog/unreleased_20/12317.rst [new file with mode: 0644]
doc/build/changelog/unreleased_21/10816.rst
doc/build/dialects/oracle.rst
doc/build/index.rst
lib/sqlalchemy/dialects/oracle/__init__.py
lib/sqlalchemy/dialects/oracle/base.py
lib/sqlalchemy/dialects/oracle/vector.py [new file with mode: 0644]
lib/sqlalchemy/sql/selectable.py
test/dialect/oracle/test_compiler.py
test/dialect/oracle/test_reflection.py
test/dialect/oracle/test_types.py
test/sql/test_compare.py