Release notes
*Sourced from [sqlalchemy's releases](https://github.com/sqlalchemy/sqlalchemy/releases).*
>
> # 1.3.10
>
> Released: October 9, 2019
> - **[bug] [mssql]** Fixed bug in SQL Server dialect with new "max_identifier_length" feature
> where the mssql dialect already featured this flag, and the implementation
> did not accommodate for the new initialization hook correctly.
>
> References: [#4857](https://github.com/sqlalchemy/sqlalchemy/blob/HEAD/ticket:4857)
>
> - **[bug] [oracle]** Fixed regression in Oracle dialect that was inadvertently using max
> identifier length of 128 characters on Oracle server 12.2 and greater even
> though the stated contract for the remainder of the 1.3 series is that
> this value stays at 30 until version SQLAlchemy 1.4. Also repaired issues
> with the retrieval of the "compatibility" version, and removed the warning
> emitted when the "v$parameter" view was not accessible as this was causing
> user confusion.
>
> References: [#4857](https://github.com/sqlalchemy/sqlalchemy/blob/HEAD/ticket:4857), [#4898](https://github.com/sqlalchemy/sqlalchemy/blob/HEAD/ticket:4898)
>
>
> # 1.3.9
>
> Released: October 4, 2019
> - **[engine] [usecase]** Added new `create_engine()` parameter
> `create_engine.max_identifier_length`. This overrides the
> dialect-coded "max identifier length" in order to accommodate for databases
> that have recently changed this length and the SQLAlchemy dialect has
> not yet been adjusted to detect for that version. This parameter interacts
> with the existing `create_engine.label_length` parameter in that
> it establishes the maximum (and default) value for anonymously generated
> labels. Additionally, post-connection detection of max identifier lengths
> has been added to the dialect system. This feature is first being used
> by the Oracle dialect.
>
> References: [#4857](https://github.com/sqlalchemy/sqlalchemy/blob/HEAD/ticket:4857)
>
> - **[oracle] [usecase]** The Oracle dialect now emits a warning if Oracle version 12.2 or greater is
> used, and the `create_engine.max_identifier_length` parameter is
> not set. The version in this specific case defaults to that of the
> "compatibility" version set in the Oracle server configuration, not the
> actual server version. In version 1.4, the default max_identifier_length
> for 12.2 or greater will move to 128 characters. In order to maintain
> forwards compatibility, applications should set
> `create_engine.max_identifier_length` to 30 in order to maintain
> the same length behavior, or to 128 in order to test the upcoming behavior.
> This length determines among other things how generated constraint names
> are truncated for statements like `CREATE CONSTRAINT` and `DROP
> CONSTRAINT`, which means a the new length may produce a name-mismatch
> against a name that was generated with the old length, impacting database
> ... (truncated)
Commits
- See full diff in [compare view](https://github.com/sqlalchemy/sqlalchemy/commits)
Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.
Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR:
- `@dependabot rebase` will rebase this PR
- `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it
- `@dependabot merge` will merge this PR after your CI passes on it
- `@dependabot squash and merge` will squash and merge this PR after your CI passes on it
- `@dependabot cancel merge` will cancel a previously requested merge and block automerging
- `@dependabot reopen` will reopen this PR if it is closed
- `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
- `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
- `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
- `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
- `@dependabot use these labels` will set the current labels as the default for future PRs for this repo and language
- `@dependabot use these reviewers` will set the current reviewers as the default for future PRs for this repo and language
- `@dependabot use these assignees` will set the current assignees as the default for future PRs for this repo and language
- `@dependabot use this milestone` will set the current milestone as the default for future PRs for this repo and language
- `@dependabot badge me` will comment on this PR with code to add a "Dependabot enabled" badge to your readme
Additionally, you can set the following in your Dependabot [dashboard](https://app.dependabot.com):
- Update frequency (including time of day and day of week)
- Pull request limits (per update run and/or open at any time)
- Automerge options (never/patch/minor, and dev/runtime dependencies)
- Out-of-range updates (receive only lockfile updates, if desired)
- Security updates (receive only security updates, if desired)
Bumps sqlalchemy from 1.3.3 to 1.3.10.
Release notes
*Sourced from [sqlalchemy's releases](https://github.com/sqlalchemy/sqlalchemy/releases).* > > # 1.3.10 > > Released: October 9, 2019 > - **[bug] [mssql]** Fixed bug in SQL Server dialect with new "max_identifier_length" feature > where the mssql dialect already featured this flag, and the implementation > did not accommodate for the new initialization hook correctly. > > References: [#4857](https://github.com/sqlalchemy/sqlalchemy/blob/HEAD/ticket:4857) > > - **[bug] [oracle]** Fixed regression in Oracle dialect that was inadvertently using max > identifier length of 128 characters on Oracle server 12.2 and greater even > though the stated contract for the remainder of the 1.3 series is that > this value stays at 30 until version SQLAlchemy 1.4. Also repaired issues > with the retrieval of the "compatibility" version, and removed the warning > emitted when the "v$parameter" view was not accessible as this was causing > user confusion. > > References: [#4857](https://github.com/sqlalchemy/sqlalchemy/blob/HEAD/ticket:4857), [#4898](https://github.com/sqlalchemy/sqlalchemy/blob/HEAD/ticket:4898) > > > # 1.3.9 > > Released: October 4, 2019 > - **[engine] [usecase]** Added new `create_engine()` parameter > `create_engine.max_identifier_length`. This overrides the > dialect-coded "max identifier length" in order to accommodate for databases > that have recently changed this length and the SQLAlchemy dialect has > not yet been adjusted to detect for that version. This parameter interacts > with the existing `create_engine.label_length` parameter in that > it establishes the maximum (and default) value for anonymously generated > labels. Additionally, post-connection detection of max identifier lengths > has been added to the dialect system. This feature is first being used > by the Oracle dialect. > > References: [#4857](https://github.com/sqlalchemy/sqlalchemy/blob/HEAD/ticket:4857) > > - **[oracle] [usecase]** The Oracle dialect now emits a warning if Oracle version 12.2 or greater is > used, and the `create_engine.max_identifier_length` parameter is > not set. The version in this specific case defaults to that of the > "compatibility" version set in the Oracle server configuration, not the > actual server version. In version 1.4, the default max_identifier_length > for 12.2 or greater will move to 128 characters. In order to maintain > forwards compatibility, applications should set > `create_engine.max_identifier_length` to 30 in order to maintain > the same length behavior, or to 128 in order to test the upcoming behavior. > This length determines among other things how generated constraint names > are truncated for statements like `CREATE CONSTRAINT` and `DROP > CONSTRAINT`, which means a the new length may produce a name-mismatch > against a name that was generated with the old length, impacting database > ... (truncated)Commits
- See full diff in [compare view](https://github.com/sqlalchemy/sqlalchemy/commits)Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting
@dependabot rebase
.Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself) - `@dependabot use these labels` will set the current labels as the default for future PRs for this repo and language - `@dependabot use these reviewers` will set the current reviewers as the default for future PRs for this repo and language - `@dependabot use these assignees` will set the current assignees as the default for future PRs for this repo and language - `@dependabot use this milestone` will set the current milestone as the default for future PRs for this repo and language - `@dependabot badge me` will comment on this PR with code to add a "Dependabot enabled" badge to your readme Additionally, you can set the following in your Dependabot [dashboard](https://app.dependabot.com): - Update frequency (including time of day and day of week) - Pull request limits (per update run and/or open at any time) - Automerge options (never/patch/minor, and dev/runtime dependencies) - Out-of-range updates (receive only lockfile updates, if desired) - Security updates (receive only security updates, if desired)