Full Name of the airline or cut off at 30 characters as field type is varchar(30)
Observed Behaviour:
It seems like the airlinename field with type varchar(30) contains airlines names which was already cut off to maximum 20 characters. This means that the names data used was already limited to 20 characters and then inserted into the varchar(30) type airlinename field.
Logs:
mysql>select iata, airlinename from airline limit 3;
+------+----------------------+
| iata | airlinename |
+------+----------------------+
| AF | Afghanistan Airlines |
| AL | Albania Airlines |
| AM | American Samoa Airli |
+------+----------------------+
-- airline table description.
mysql> describe airline;
+--------------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+----------------+
| airline_id | smallint | NO | PRI | NULL | auto_increment |
| iata | char(2) | NO | UNI | NULL | |
| airlinename | varchar(30) | YES | | NULL | |
| base_airport | smallint | NO | MUL | NULL | |
+--------------+-------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)
Source:
flughafendb/tree/master/mysql-shell-dumps/flughafendb_small/
Expected Behaviour:
Full Name of the airline or cut off at 30 characters as field type is
varchar(30)
Observed Behaviour:
It seems like the
airlinename
field with typevarchar(30)
contains airlines names which was already cut off to maximum 20 characters. This means that the names data used was already limited to 20 characters and then inserted into thevarchar(30)
typeairlinename
field.Logs:
-- airline names and their lengths