[Bug 1989507] [NEW] [FFE] alembic 1.8.1

[Corey Bryant]

Public bug reported:

When building the latest version of designate, nearly all of the unit
tests fail with 1.7.6. They are all successful with 1.8.1.

I would like to bump alembic in kinetic from 1.7.6 to 1.8.1. It has
several useful fixes and is mostly used by openstack packages (which
have a standing FFE exception for).

This will also align with the version that upstream is testing with in
their upper-constraints.

Further testing will be performed with the openstack regression testing.

Here is the delta of commits:

~/pkg/zed/upstream/alembic$ git-pretty rel_1_7_6..rel_1_8_1
 - [a968c9d] - 1.8.1
 - [baed628] build fixes
 - [8033c78] implement SQLite RENAME TABLE w schema syntax
 - [4fbf99a] add FUNDING
 - [03e4f51] ignore typing issue
 - [cabccf6] fail gracefully for batch_alter_table() called in --sql mode
 - [852bea0] fix typo in setup.cfg
 - [720e509] use license_files instead of the deprecated license_file
 - [bff2ce3] Make alembic compatible with comments on constraints
 - [cd91da9] docs(cookbook): add note on including info object on declarative tables (#1051)
 - [0ef8bea] Remove redundant wheel dep from pyproject.toml (#1047)
 - [e28ee4e] Annotate batch_alter_table
 - [0dd2cc8] chore: Set permissions for GitHub actions (#1035)
 - [67a7b94] Version 1.8.1 placeholder
 - [ee83ff6] - 1.8.0
 - [f734560] Trigger events before and after drop table statements
 - [2cd9e1a] remove pylons template
 - [11839b7] this will be 1.8.0
 - [188dd8b] implement full copy for indexes in batch
 - [e125829] Use pep517 to install alembic.
 - [0adcc74] Add epoch as an option for file_template
 - [7172022] Alembic 1.8 now supports Python 3.7 and above
 - [1684d0e] Fix downgrade with effective head
 - [cfe92fa] Various typing related updates
 - [e539704] Use `-> None` in script templates by default
 - [d770c1e] document argparse limitation
 - [537448c] Document config for migration files timestamp prefixed
 - [d741367] bump black to 22.3.0
 - [8fc58ea] adapt for column collection being "immutable" or "readonly"
 - [e533927] add covering index tests; generalize autogen index tests
 - [a9e6f90] Version 1.7.8 placeholder
 - [7b55158] - 1.7.7
 - [d8b6af3] changelog updates
 - [0f61c47] add sphinx_copybutton
 - [ce6144e] Fix duplicated constraints when using expressions
 - [721b28c] fix failing test on windows after sqlite switched to queuepool by default
 - [349e661] desensitize Oracle to FLOAT/DOUBLE/DOUBLE_PRECISION differences
 - [b231d15] more links to pypi, add 3.10 to classifiers
 - [05c56c3] add GitHub URL for PyPi (#994)
 - [1846ddd] illustrate connection sharing + asyncio
 - [4db8f8f] repair sharing example
 - [d477aa6] fix connection handling in consumption test
 - [cacce36] add conditional for fileConfig()
 - [fb8d450] Prevent alter_column() from changing nullability
 - [7b94270] clarify default configuration behavior
 - [32dc8a4] fix pep484 issue
 - [76553d0] Version 1.7.7 placeholder

** Affects: alembic (Ubuntu)
     Importance: Undecided
         Status: New

** Also affects: alembic (Ubuntu)
   Importance: Undecided
       Status: New

** No longer affects: ubuntu

** Description changed:

  I would like to bump alembic in kinetic from 1.7.6 to 1.8.1. It has
  several useful fixes and is mostly used by openstack packages (which
  have a standing FFE exception).
  
  This will also align with the version that upstream is testing with in
  their upper-constraints.
  
- It would found while building the latest version of designate that
- nearly all of the unit tests fail with 1.7.6. They are successful with
- 1.8.1.
+ When building the latest version of designate, nearly all of the unit
+ tests fail with 1.7.6. They are all successful with 1.8.1.
  
  Here is the delta of commits:
  
  ~/pkg/zed/upstream/alembic$ git-pretty rel_1_7_6..rel_1_8_1
-  - [a968c9d] - 1.8.1
-  - [baed628] build fixes
-  - [8033c78] implement SQLite RENAME TABLE w schema syntax
-  - [4fbf99a] add FUNDING
-  - [03e4f51] ignore typing issue
-  - [cabccf6] fail gracefully for batch_alter_table() called in --sql mode
-  - [852bea0] fix typo in setup.cfg
-  - [720e509] use license_files instead of the deprecated license_file
-  - [bff2ce3] Make alembic compatible with comments on constraints
-  - [cd91da9] docs(cookbook): add note on including info object on declarative tables (#1051)
-  - [0ef8bea] Remove redundant wheel dep from pyproject.toml (#1047)
-  - [e28ee4e] Annotate batch_alter_table
-  - [0dd2cc8] chore: Set permissions for GitHub actions (#1035)
-  - [67a7b94] Version 1.8.1 placeholder
-  - [ee83ff6] - 1.8.0
-  - [f734560] Trigger events before and after drop table statements
-  - [2cd9e1a] remove pylons template
-  - [11839b7] this will be 1.8.0
-  - [188dd8b] implement full copy for indexes in batch
-  - [e125829] Use pep517 to install alembic.
-  - [0adcc74] Add epoch as an option for file_template
-  - [7172022] Alembic 1.8 now supports Python 3.7 and above
-  - [1684d0e] Fix downgrade with effective head
-  - [cfe92fa] Various typing related updates
-  - [e539704] Use `-> None` in script templates by default
-  - [d770c1e] document argparse limitation
-  - [537448c] Document config for migration files timestamp prefixed
-  - [d741367] bump black to 22.3.0
-  - [8fc58ea] adapt for column collection being "immutable" or "readonly"
-  - [e533927] add covering index tests; generalize autogen index tests
-  - [a9e6f90] Version 1.7.8 placeholder
-  - [7b55158] - 1.7.7
-  - [d8b6af3] changelog updates
-  - [0f61c47] add sphinx_copybutton
-  - [ce6144e] Fix duplicated constraints when using expressions
-  - [721b28c] fix failing test on windows after sqlite switched to queuepool by default
-  - [349e661] desensitize Oracle to FLOAT/DOUBLE/DOUBLE_PRECISION differences
-  - [b231d15] more links to pypi, add 3.10 to classifiers
-  - [05c56c3] add GitHub URL for PyPi (#994)
-  - [1846ddd] illustrate connection sharing + asyncio
-  - [4db8f8f] repair sharing example
-  - [d477aa6] fix connection handling in consumption test
-  - [cacce36] add conditional for fileConfig()
-  - [fb8d450] Prevent alter_column() from changing nullability
-  - [7b94270] clarify default configuration behavior
-  - [32dc8a4] fix pep484 issue
-  - [76553d0] Version 1.7.7 placeholder
+  - [a968c9d] - 1.8.1
+  - [baed628] build fixes
+  - [8033c78] implement SQLite RENAME TABLE w schema syntax
+  - [4fbf99a] add FUNDING
+  - [03e4f51] ignore typing issue
+  - [cabccf6] fail gracefully for batch_alter_table() called in --sql mode
+  - [852bea0] fix typo in setup.cfg
+  - [720e509] use license_files instead of the deprecated license_file
+  - [bff2ce3] Make alembic compatible with comments on constraints
+  - [cd91da9] docs(cookbook): add note on including info object on declarative tables (#1051)
+  - [0ef8bea] Remove redundant wheel dep from pyproject.toml (#1047)
+  - [e28ee4e] Annotate batch_alter_table
+  - [0dd2cc8] chore: Set permissions for GitHub actions (#1035)
+  - [67a7b94] Version 1.8.1 placeholder
+  - [ee83ff6] - 1.8.0
+  - [f734560] Trigger events before and after drop table statements
+  - [2cd9e1a] remove pylons template
+  - [11839b7] this will be 1.8.0
+  - [188dd8b] implement full copy for indexes in batch
+  - [e125829] Use pep517 to install alembic.
+  - [0adcc74] Add epoch as an option for file_template
+  - [7172022] Alembic 1.8 now supports Python 3.7 and above
+  - [1684d0e] Fix downgrade with effective head
+  - [cfe92fa] Various typing related updates
+  - [e539704] Use `-> None` in script templates by default
+  - [d770c1e] document argparse limitation
+  - [537448c] Document config for migration files timestamp prefixed
+  - [d741367] bump black to 22.3.0
+  - [8fc58ea] adapt for column collection being "immutable" or "readonly"
+  - [e533927] add covering index tests; generalize autogen index tests
+  - [a9e6f90] Version 1.7.8 placeholder
+  - [7b55158] - 1.7.7
+  - [d8b6af3] changelog updates
+  - [0f61c47] add sphinx_copybutton
+  - [ce6144e] Fix duplicated constraints when using expressions
+  - [721b28c] fix failing test on windows after sqlite switched to queuepool by default
+  - [349e661] desensitize Oracle to FLOAT/DOUBLE/DOUBLE_PRECISION differences
+  - [b231d15] more links to pypi, add 3.10 to classifiers
+  - [05c56c3] add GitHub URL for PyPi (#994)
+  - [1846ddd] illustrate connection sharing + asyncio
+  - [4db8f8f] repair sharing example
+  - [d477aa6] fix connection handling in consumption test
+  - [cacce36] add conditional for fileConfig()
+  - [fb8d450] Prevent alter_column() from changing nullability
+  - [7b94270] clarify default configuration behavior
+  - [32dc8a4] fix pep484 issue
+  - [76553d0] Version 1.7.7 placeholder

** Description changed:

  I would like to bump alembic in kinetic from 1.7.6 to 1.8.1. It has
  several useful fixes and is mostly used by openstack packages (which
- have a standing FFE exception).
+ have a standing FFE exception for).
  
  This will also align with the version that upstream is testing with in
  their upper-constraints.
  
  When building the latest version of designate, nearly all of the unit
  tests fail with 1.7.6. They are all successful with 1.8.1.
  
  Here is the delta of commits:
  
  ~/pkg/zed/upstream/alembic$ git-pretty rel_1_7_6..rel_1_8_1
   - [a968c9d] - 1.8.1
   - [baed628] build fixes
   - [8033c78] implement SQLite RENAME TABLE w schema syntax
   - [4fbf99a] add FUNDING
   - [03e4f51] ignore typing issue
   - [cabccf6] fail gracefully for batch_alter_table() called in --sql mode
   - [852bea0] fix typo in setup.cfg
   - [720e509] use license_files instead of the deprecated license_file
   - [bff2ce3] Make alembic compatible with comments on constraints
   - [cd91da9] docs(cookbook): add note on including info object on declarative tables (#1051)
   - [0ef8bea] Remove redundant wheel dep from pyproject.toml (#1047)
   - [e28ee4e] Annotate batch_alter_table
   - [0dd2cc8] chore: Set permissions for GitHub actions (#1035)
   - [67a7b94] Version 1.8.1 placeholder
   - [ee83ff6] - 1.8.0
   - [f734560] Trigger events before and after drop table statements
   - [2cd9e1a] remove pylons template
   - [11839b7] this will be 1.8.0
   - [188dd8b] implement full copy for indexes in batch
   - [e125829] Use pep517 to install alembic.
   - [0adcc74] Add epoch as an option for file_template
   - [7172022] Alembic 1.8 now supports Python 3.7 and above
   - [1684d0e] Fix downgrade with effective head
   - [cfe92fa] Various typing related updates
   - [e539704] Use `-> None` in script templates by default
   - [d770c1e] document argparse limitation
   - [537448c] Document config for migration files timestamp prefixed
   - [d741367] bump black to 22.3.0
   - [8fc58ea] adapt for column collection being "immutable" or "readonly"
   - [e533927] add covering index tests; generalize autogen index tests
   - [a9e6f90] Version 1.7.8 placeholder
   - [7b55158] - 1.7.7
   - [d8b6af3] changelog updates
   - [0f61c47] add sphinx_copybutton
   - [ce6144e] Fix duplicated constraints when using expressions
   - [721b28c] fix failing test on windows after sqlite switched to queuepool by default
   - [349e661] desensitize Oracle to FLOAT/DOUBLE/DOUBLE_PRECISION differences
   - [b231d15] more links to pypi, add 3.10 to classifiers
   - [05c56c3] add GitHub URL for PyPi (#994)
   - [1846ddd] illustrate connection sharing + asyncio
   - [4db8f8f] repair sharing example
   - [d477aa6] fix connection handling in consumption test
   - [cacce36] add conditional for fileConfig()
   - [fb8d450] Prevent alter_column() from changing nullability
   - [7b94270] clarify default configuration behavior
   - [32dc8a4] fix pep484 issue
   - [76553d0] Version 1.7.7 placeholder

** Description changed:

+ When building the latest version of designate, nearly all of the unit
+ tests fail with 1.7.6. They are all successful with 1.8.1.
+ 
  I would like to bump alembic in kinetic from 1.7.6 to 1.8.1. It has
  several useful fixes and is mostly used by openstack packages (which
  have a standing FFE exception for).
  
  This will also align with the version that upstream is testing with in
  their upper-constraints.
  
- When building the latest version of designate, nearly all of the unit
- tests fail with 1.7.6. They are all successful with 1.8.1.
+ Further testing will be performed with the openstack regression testing.
  
  Here is the delta of commits:
  
  ~/pkg/zed/upstream/alembic$ git-pretty rel_1_7_6..rel_1_8_1
   - [a968c9d] - 1.8.1
   - [baed628] build fixes
   - [8033c78] implement SQLite RENAME TABLE w schema syntax
   - [4fbf99a] add FUNDING
   - [03e4f51] ignore typing issue
   - [cabccf6] fail gracefully for batch_alter_table() called in --sql mode
   - [852bea0] fix typo in setup.cfg
   - [720e509] use license_files instead of the deprecated license_file
   - [bff2ce3] Make alembic compatible with comments on constraints
   - [cd91da9] docs(cookbook): add note on including info object on declarative tables (#1051)
   - [0ef8bea] Remove redundant wheel dep from pyproject.toml (#1047)
   - [e28ee4e] Annotate batch_alter_table
   - [0dd2cc8] chore: Set permissions for GitHub actions (#1035)
   - [67a7b94] Version 1.8.1 placeholder
   - [ee83ff6] - 1.8.0
   - [f734560] Trigger events before and after drop table statements
   - [2cd9e1a] remove pylons template
   - [11839b7] this will be 1.8.0
   - [188dd8b] implement full copy for indexes in batch
   - [e125829] Use pep517 to install alembic.
   - [0adcc74] Add epoch as an option for file_template
   - [7172022] Alembic 1.8 now supports Python 3.7 and above
   - [1684d0e] Fix downgrade with effective head
   - [cfe92fa] Various typing related updates
   - [e539704] Use `-> None` in script templates by default
   - [d770c1e] document argparse limitation
   - [537448c] Document config for migration files timestamp prefixed
   - [d741367] bump black to 22.3.0
   - [8fc58ea] adapt for column collection being "immutable" or "readonly"
   - [e533927] add covering index tests; generalize autogen index tests
   - [a9e6f90] Version 1.7.8 placeholder
   - [7b55158] - 1.7.7
   - [d8b6af3] changelog updates
   - [0f61c47] add sphinx_copybutton
   - [ce6144e] Fix duplicated constraints when using expressions
   - [721b28c] fix failing test on windows after sqlite switched to queuepool by default
   - [349e661] desensitize Oracle to FLOAT/DOUBLE/DOUBLE_PRECISION differences
   - [b231d15] more links to pypi, add 3.10 to classifiers
   - [05c56c3] add GitHub URL for PyPi (#994)
   - [1846ddd] illustrate connection sharing + asyncio
   - [4db8f8f] repair sharing example
   - [d477aa6] fix connection handling in consumption test
   - [cacce36] add conditional for fileConfig()
   - [fb8d450] Prevent alter_column() from changing nullability
   - [7b94270] clarify default configuration behavior
   - [32dc8a4] fix pep484 issue
   - [76553d0] Version 1.7.7 placeholder

-- 
You received this bug notification because you are a member of Ubuntu
OpenStack, which is subscribed to alembic in Ubuntu.
https://bugs.launchpad.net/bugs/1989507

Title:
  [FFE] alembic 1.8.1

Status in alembic package in Ubuntu:
  New

Bug description:
  When building the latest version of designate, nearly all of the unit
  tests fail with 1.7.6. They are all successful with 1.8.1.

  I would like to bump alembic in kinetic from 1.7.6 to 1.8.1. It has
  several useful fixes and is mostly used by openstack packages (which
  have a standing FFE exception for).

  This will also align with the version that upstream is testing with in
  their upper-constraints.

  Further testing will be performed with the openstack regression
  testing.

  Here is the delta of commits:

  ~/pkg/zed/upstream/alembic$ git-pretty rel_1_7_6..rel_1_8_1
   - [a968c9d] - 1.8.1
   - [baed628] build fixes
   - [8033c78] implement SQLite RENAME TABLE w schema syntax
   - [4fbf99a] add FUNDING
   - [03e4f51] ignore typing issue
   - [cabccf6] fail gracefully for batch_alter_table() called in --sql mode
   - [852bea0] fix typo in setup.cfg
   - [720e509] use license_files instead of the deprecated license_file
   - [bff2ce3] Make alembic compatible with comments on constraints
   - [cd91da9] docs(cookbook): add note on including info object on declarative tables (#1051)
   - [0ef8bea] Remove redundant wheel dep from pyproject.toml (#1047)
   - [e28ee4e] Annotate batch_alter_table
   - [0dd2cc8] chore: Set permissions for GitHub actions (#1035)
   - [67a7b94] Version 1.8.1 placeholder
   - [ee83ff6] - 1.8.0
   - [f734560] Trigger events before and after drop table statements
   - [2cd9e1a] remove pylons template
   - [11839b7] this will be 1.8.0
   - [188dd8b] implement full copy for indexes in batch
   - [e125829] Use pep517 to install alembic.
   - [0adcc74] Add epoch as an option for file_template
   - [7172022] Alembic 1.8 now supports Python 3.7 and above
   - [1684d0e] Fix downgrade with effective head
   - [cfe92fa] Various typing related updates
   - [e539704] Use `-> None` in script templates by default
   - [d770c1e] document argparse limitation
   - [537448c] Document config for migration files timestamp prefixed
   - [d741367] bump black to 22.3.0
   - [8fc58ea] adapt for column collection being "immutable" or "readonly"
   - [e533927] add covering index tests; generalize autogen index tests
   - [a9e6f90] Version 1.7.8 placeholder
   - [7b55158] - 1.7.7
   - [d8b6af3] changelog updates
   - [0f61c47] add sphinx_copybutton
   - [ce6144e] Fix duplicated constraints when using expressions
   - [721b28c] fix failing test on windows after sqlite switched to queuepool by default
   - [349e661] desensitize Oracle to FLOAT/DOUBLE/DOUBLE_PRECISION differences
   - [b231d15] more links to pypi, add 3.10 to classifiers
   - [05c56c3] add GitHub URL for PyPi (#994)
   - [1846ddd] illustrate connection sharing + asyncio
   - [4db8f8f] repair sharing example
   - [d477aa6] fix connection handling in consumption test
   - [cacce36] add conditional for fileConfig()
   - [fb8d450] Prevent alter_column() from changing nullability
   - [7b94270] clarify default configuration behavior
   - [32dc8a4] fix pep484 issue
   - [76553d0] Version 1.7.7 placeholder

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/alembic/+bug/1989507/+subscriptions