Menu

#318 [PHP] Create table failed when using default timestamp '2038-01-19 12:14:07'

open
nobody
None
5
2012-10-14
2012-10-14
Jira Trac
No

[PHP] Create table failed when using default timestamp '2038-01-19 12:14:07'

Case Path: php/_04_field_flags/flags_01.phpt

Test verion:
{noformat}
Cubrid: CUBRID 9.0 (9.0.0.0478)
PHP Driver:
http://svn.cubrid.org/cubridapis/php/branches/RB-9.0.0 Revision: 917
{noformat}

codes:
{noformat}
cubrid_execute($conn,CREATE TABLE flag1_tb(c1 string primary key , c2 char(20) not null , c3 int unique key auto_increment, c4 double default 22.22, c5 time default TIME '
23:59:59', c6 date, c7 TIMESTAMP default TIMESTAMP '2038-01-19 12:14:07',c8 bit, c9 numeric(13,4)););
{noformat}

result:
{noformat}
Warning: Error: DBMS, -494, Semantic: before ' ,c8 bit, c9 numeric(13,4));'
Invalid utime: '2038-01-19 12:14:07'. in /home/php/phptestcases/php/php/_04_field_flags/flags_01.php on line 6
{noformat}

Discussion

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.