delta/python-packages/sqlalchemy.git/test/dialect, branch pr/43

- Fixed bug where Oracle table reflection using synonyms would fail

2013-10-25T23:11:53+00:00

if the synonym and the table were in different remote schemas.
Patch to fix courtesy Kyle Derr. [ticket:2853]

- move this test to PG test_reflection

2013-10-25T21:19:03+00:00

- don't use locals()

- Fix and test parsing of MySQL foreign key options within reflection;

2013-10-25T21:18:40+00:00

this complements the work in :ticket:`2183` where we begin to support
reflection of foreign key options such as ON UPDATE/ON DELETE
cascade. [ticket:2839]

Merge branch 'master' of github.com:ijl/sqlalchemy into merge_2183

2013-10-25T21:01:38+00:00

- Removed a 128-character truncation from the reflection of the

2013-10-18T23:00:05+00:00

server default for a column; this code was original from
PG system views which truncated the string for readability.
[ticket:2844]

- The change in :ticket:`2721`, which is that the ``deferrable`` keyword

2013-10-18T18:44:01+00:00

of :class:`.ForeignKeyConstraint` is silently ignored on the MySQL
backend, will be reverted as of 0.9; this keyword will now render again, raising
errors on MySQL as it is not understood - the same behavior will also
apply to the ``initially`` keyword.  In 0.8, the keywords will remain
ignored but a warning is emitted.   Additionally, the ``match`` keyword
now raises a :class:`.CompileError` on 0.9 and emits a warning on 0.8;
this keyword is not only silently ignored by MySQL but also breaks
the ON UPDATE/ON DELETE options.

To use a :class:`.ForeignKeyConstraint`
that does not render or renders differently on MySQL, use a custom
compilation option.  An example of this usage has been added to the
documentation, see :ref:`mysql_foreign_keys`.
[ticket:2721] [ticket:2839]

- Added support for rendering ``SMALLSERIAL`` when a :class:`.SmallInteger`

2013-10-15T23:06:21+00:00

type is used on a primary key autoincrement column, based on server
version detection of Postgresql version 9.2 or greater.
[ticket:2840]

The MySQL :class:`.mysql.SET` type now features the same auto-quoting

2013-10-14T20:12:54+00:00

behavior as that of :class:`.mysql.ENUM`.  Quotes are not required when
setting up the value, but quotes that are present will be auto-detected
along with a warning.  This also helps with Alembic where
the SET type doesn't render with quotes. [ticket:2817]

MySQL-connector dialect now allows options in the create_engine

2013-10-13T18:09:35+00:00

query string to override those defaults set up in the connect,
including "buffered" and "raise_on_warnings".
[ticket:2515]

Parenthesis will be applied to a compound SQL expression as

2013-10-13T00:21:18+00:00

rendered in the column list of a CREATE INDEX statement.
[ticket:2742]