Project

General

Profile

Actions

Bug #17019

closed

SQL error with DBAL/PostgreSQL: quoting of varchar defaults

Added by Mathias Behrle over 17 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Should have
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2007-02-20
Due date:
% Done:

0%

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

Description

While importing extension tcdirectmail there occured errors, because DBAL removes the quotes from varchar defaults.

A definiton example is
servertype varchar(6) DEFAULT 'pop3' NOT NULL,

which gives as result in the final SQL:
"servertype" VARCHAR DEFAULT pop3 NOT NULL,

typo3-dev 4.1 (svn)
postgresql 8.1.4-6~bpo.1
apache2 2.0.54-5sarge1
php5 5.2.0-8~bpo.2
Firefox/Iceweasel/2.0.0.1
(issue imported from #M5044)


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #20470: Column's default value is not properly quoted in CREATE TABLEClosedXavier Perseguers2009-05-19

Actions
Actions

Also available in: Atom PDF