delta/python-packages/sqlalchemy.git/lib/sqlalchemy/dialects/sqlite, branch pr/250

- happy new year

2016-01-29T16:20:22+00:00

- The workaround for right-nested joins on SQLite, where they are rewritten

2016-01-26T21:09:23+00:00

as subqueries in order to work around SQLite's lack of support for this
syntax, is lifted when SQLite version 3.7.16 or greater is detected.
fixes #3634
- The workaround for SQLite's unexpected delivery of column names as
``tablename.columnname`` for some kinds of queries is now disabled
when SQLite version 3.10.0 or greater is detected.
fixes #3633

- documenation updates to clarify specific SQLite versions

2016-01-21T20:21:33+00:00

that have problems with right-nested joins and UNION column keys;
references #3633 references #3634.   backport from 1.1 to 0.9
announcing 1.1 as where these behaviors will be retired based
on version-specific checks
- fix test_resultset so that it passes when SQLite 3.10.0 is
present, references #3633

- for DB's w/o a real "autoincrement", reflection should be returning

2015-10-08T03:41:24+00:00

"auto", doesn't matter if there's a default here

- The system by which a :class:`.Column` considers itself to be an

2015-10-07T14:02:45+00:00

"auto increment" column has been changed, such that autoincrement
is no longer implicitly enabled for a :class:`.Table` that has a
composite primary key.  In order to accommodate being able to enable
autoincrement for a composite PK member column while at the same time
maintaining SQLAlchemy's long standing behavior of enabling
implicit autoincrement for a single integer primary key, a third
state has been added to the :paramref:`.Column.autoincrement` parameter
``"auto"``, which is now the default. fixes #3216
- The MySQL dialect no longer generates an extra "KEY" directive when
generating CREATE TABLE DDL for a table using InnoDB with a
composite primary key with AUTO_INCREMENT on a column that isn't the
first column;  to overcome InnoDB's limitation here, the PRIMARY KEY
constraint is now generated with the AUTO_INCREMENT column placed
first in the list of columns.

- limit the search for schemas to not include "temp", which is sort of an implicit schema

2015-09-28T21:48:55+00:00

- repair the CREATE INDEX ddl for schemas
- update provisioning to include support for setting up ATTACH DATABASE up front
for the test_schema; enable "schemas" testing for SQLite
- changelog / migration notes for new SQLite schema support
- include the "schema" as the "remote_schema" when we reflect SQLite FKs

Support get_schema_names for SQLite

2015-09-09T21:03:14+00:00

- Fixed bug in SQLite dialect where reflection of UNIQUE constraints

2015-07-21T16:33:35+00:00

that included non-alphabetic characters in the names, like dots or
spaces, would not be reflected with their name.
fixes #3495

- document SQlite dotted name issue, fixes #3441

2015-06-05T20:11:13+00:00

- document fully how to use autoincrement w/ SQLite including

2015-05-22T17:27:09+00:00

non-Integer column types, fixes #2075