Project

General

Profile

Actions
Copy link

Bug #17019

closed

SQL error with DBAL/PostgreSQL: quoting of varchar defaults

Added by Mathias Behrle over 17 years ago. Updated almost 15 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Karsten Dambekalns
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 open — 1 closed)

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

Actions
Actions
Copy link
 #1

Updated by Karsten Dambekalns over 17 years ago

Please try this:

  • Change class.ux_t3lib_sqlengine.php to put a comment sign in front of line 276:
    #$cfg .= ' NOQUOTE';
  • Try again to create the table in question
  • Watch for anything that has a default value and check if it works

Thanks!

Actions
Copy link
 #2

Updated by Xavier Perseguers almost 15 years ago

See bug #11142

Actions
Copy link

Also available in: Atom PDF