| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.5.0b4 |
| Bug #18491 | MDB2_Driver_mssql - can not alterTable | ||
|---|---|---|---|
| Submitted: | 2011-04-29 17:21 UTC | ||
| From: | mjeffreyj | Assigned: | |
| Status: | Open | Package: | MDB2_Driver_mssql (version 1.5.0b3) |
| PHP Version: | 5.3.0 | OS: | windows 2008 R2 |
| Roadmaps: | (Not assigned) | ||
[2011-04-29 17:21 UTC] mjeffreyj
(Tomáš Kalous)
Description:
------------
when I´m using MDB2_Driver_mssql:
ERROR - MDB2 Error: can not alter
with MDB2_Driver_mysql:
OK - no problem
Could be problem in MS SQL CONSTRAINTs?
Test script:
---------------
$mdb2_manager = $mdb2->loadModule('Manager');
$definition = array( 'name' => 'TableName',
'add' => array( 'ColumnName' => array( 'type' => 'boolean',
'default' => 0
)
)
);
$mdb2_manager->alterTable('TableName', $definition, false);
Expected result:
----------------
script will add a new column into table
Actual result:
--------------
MDB2 Error: can not alter