Bug #6401

dumpDatabase() and primary keys

Details

Submitted	2006-01-03 08:36 UTC
From	tvvcox at ossim dot net
Assigned	lsmith
Status	Closed
Package	MDB2_Schema
PHP Version	5.0.4
OS	Linux
Roadmaps	(Not assigned)

Comments

[2006-01-03 08:36 UTC] tvvcox at ossim dot net

Description:
------------
Dump and load fails on primary keys

Test script:
---------------
<?php
/*
CREATE TABLE foo (
id int NOT NULL auto_increment,
PRIMARY KEY (id)
);
*/
require_once 'MDB2/Schema.php';
$dsn = 'mysql://root@localhost/test';
$tmp_file = './test.xml';

$schema =& MDB2_Schema::factory($dsn);
$conf = array('output_mode' => 'file', 'output' => $tmp_file);
// write the xml schema
$schema->dumpDatabase($conf, MDB2_SCHEMA_DUMP_STRUCTURE);
// try to load the schema
$ret = $schema->parseDatabaseDefinitionFile($tmp_file);
if (PEAR::isError($ret)) die($ret->getUserInfo());
?>

Expected result:
----------------
Load the schema it has generated

Actual result:
--------------
Parser error: an index needs a name - No error - Byte: 410; Line: 28; Col: 9

The index dump:

<index>
<name>0</name>
<primary>true</primary>
<field>
<name>id</name>
<sorting>ascending</sorting>
</field>
</index>