dbptk-developer icon indicating copy to clipboard operation
dbptk-developer copied to clipboard

Review report phrasing

Open luis100 opened this issue 8 years ago • 1 comments

When a database from a DBMS is converted into SIARD, sometimes the report shows:

- Type conversion in import module: in `sakila.actor.actor_id` (format: schema.table.column) has original type `SMALLINT UNSIGNED` and was converted to the standard type `SMALLINT`

But types are not actually converted because both original type and inferred standard type are kept in SIARD. So, change phrasing to:

- Column `sakila.actor.actor_id` has type `SMALLINT UNSIGNED` which is not standard, the `SMALLINT` standard type was inferred 

luis100 avatar Nov 08 '16 18:11 luis100

The following column data types are not standard and a standard data type was inferred:
+---------------------------------------------------------------------------+
| Schema | Table | Column     | Original data type | Inferred standard type |
+---------------------------------------------------------------------------+
| sakila | actor | actor_id   | SMALLINT UNSIGNED  | SMALLINT               |
| sakila | actor | first_name | VARCHAR            | CHARACTER VARYING(45)  |
+---------------------------------------------------------------------------+

luis100 avatar Nov 08 '16 18:11 luis100