Code to confirm a bug in DB Context Scaffold of Entity Framework Core

When I generated my DB Context from an existing PostgreSQL database by Entity Framework Core's scaffold and tried initializing the database in another PostgreSQL server, it failed. Errors happened for table creations which contain columns of serial type. The small code here is for testing such table creation by Entity Framework.

Dependencies

• .NET Core SDK 2.2.105
• Microsoft.EntityFrameworkCore 2.2.4
• Microsoft.EntityFrameworkCore.Design 2.2.4
• Npgsql 4.0.6
• Npgsql.EntityFrameworkCore.PostgreSQL 2.2.0
• bash
• psql
• tee
• Docker
• Docker Image postgres

Steps to reproduce

1. Start an empty PostgreSQL Server in docker
2. Create a database and a table with a column of "serial" type
3. Run DB Context Scaffold
4. Start another empty PostgreSQL Server in docker
5. Add a migration for the generated DB Context
6. Install the database by the DB Context
7. Test the installed database table

Test Run

Execute run_test_with_lib_released.sh for reproducing this issue. Execute run_test_with_lib_fixed.sh for testing a fixed Microsoft.EntityFrameworkCore.Design.dll. Replace the dll file in the lib directory before run the script.