Comments (3)
I haven't tested it with Mariadb but since it's similar to MySQL there might be a reason for that - is the column unsigned? Also remember that the number indicates only how the value will be presented, the range remains the same.
from yii2-migration.
Yes the column is unsigned. Where I run into issues with it is creating foreign keys. Because if I have an ID with an Int(11) but one with Int(10). It will throw an error due to not matching types.
from yii2-migration.
This is expected behavior of the database. You cannot create foreign key out of not matching columns, either change all columns (primary and foreign keys) to unsigned ones or to signed ones. There is no bug here.
from yii2-migration.
Related Issues (20)
- Dependabot can't resolve your PHP dependency files
- [Bug] update after renameTable() HOT 1
- [Bug] Missing compatibility with MySQL 8
- [Bug] update of a migration does not work without Yii autoloader HOT 4
- [Bug] > SQLSTATE[08004] [1040] Too many connections HOT 1
- [Bug] Asterisk not working with migration/create HOT 5
- [Bug] Column data must be provided as an instance of yii\db\ColumnSchemaBuilder. HOT 10
- get all data from table HOT 1
- [Bug] Primary key not included as index in StructureBuilder::addHiddenIndexes() for MySQL dbs
- [Feature] Different timestamp for migration file names as Yii operates on time and breaks the migration processes HOT 3
- [Bug] Problem with parsing ENUMS in migrations
- [Q] Unable to get Migration Working Correctly HOT 2
- Unclear of the cause of migration/update causing: [23000]: Integrity constraint violation HOT 7
- Migration/Update drops column instead of using renameColumn command HOT 1
- migration/update produces: Column data must be provided as an instance of yii\db\ColumnSchemaBuilder HOT 1
- [Bug] Dropping table with foreign key on update
- [Bug] Setting default values using expressions fails HOT 11
- [Bug] Invalid path alias: @bizley/migration/views/migration.php HOT 4
- [Bug] Multiple definitions exist for class 'Migration' HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from yii2-migration.