Project

General

Profile

Actions

Bug #67288

closed

Field types don't get properly translated to MySQL types

Added by Morton Jonuschat over 9 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2015-06-03
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
7
PHP Version:
5.6
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

DBAL doesn't seem to properly convert the field types returned in admin_get_fields() to MySQL types.

When doing a database compare with DBAL enabled I get results like this:

ALTER TABLE be_sessions CHANGE ses_backuserid ses_backuserid int(11) NOT NULL default '0'; 
Current value: (8) default '0'
<pre>

Real field type is int8  / BIGINT which is often denoted as INT(8). The type information (INT) is being lost completly. The same is true for every other field type encountered

TYPO3 7.3-dev
PostgreSQL 9.4

Related issues 2 (0 open2 closed)

Related to TYPO3 Core - Epic #64459: Make TYPO3 run on PostgreSQLClosed2015-05-21

Actions
Related to TYPO3 Core - Task #67297: Move MySQL / DBMS field type translation into DBAL SpecificsClosed2015-06-04

Actions
Actions

Also available in: Atom PDF