#5696: PostgreSQL incorrect timestamp definition in CREATE TABLE when using
CakeTestFixture::$import
------------------------------------------------+---------------------------
Reporter: klevo | Owner: AD7six
Type: Bug | Status: closed
Priority: High | Milestone: 1.2.x.x
Component: PostgreSQL | Version: RC3
Severity: Normal | Resolution: worksforme
Keywords: postgres timestamp create table | Php_version: PHP 5
Cake_version: 1.2.0.7692 RC3 |
------------------------------------------------+---------------------------
Changes (by mark_story):
* status: reopened => closed
* resolution: => worksforme
Comment:
Your supplied tests fail which is good, however I'm not getting and SQL
errors generated by the SQL created and run against the database. I'm
using Postgres 8.3.5 as well. Furthermore, running the following SQL
doesn't cause errors.
{{{
#!sql
CREATE TABLE date_test (
body TEXT,
birthday DATE DEFAULT NULL
);
}}}
nor does the following schema class
{{{
#!php
<?php
class AppSchema extends CakeSchema {
var $name = 'App';
var $date_test = array(
'body' => array('type' => 'text'),
'birthday' => array('type' => 'date', 'default' => null,
'null' => true),
);
}
?>
}}}
The above schema class generates {{{birthday DATE DEFAULT NULL}}} which
does not cause syntax errors. If the issue is an SQL error issue please
provide code that raises such an issue.
--
Ticket URL: <https://trac.cakephp.org/ticket/5696#comment:4>
CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/>
Cake is a rapid development framework for PHP which uses commonly known design
patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC.
Our primary goal is to provide a structured framework that enables PHP users at
all levels to rapidly develop robust web applications, without any loss to
flexibility.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"tickets cakephp" group.
To post to this group, send email to tickets-cakephp@googlegroups.com
To unsubscribe from this group, send email to
tickets-cakephp+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/tickets-cakephp?hl=en
-~----------~----~----~----~------~----~------~--~---
