DB Alias and Sequence autoincrement

<cron-jbULQAKo4A5fyO9Q7EP/[email protected]> Thu, 27 Oct 2005 16:15:43 -0300
Newsgroups gmane.comp.php.pear.liveuser
Message-ID <[email protected]>
Hello,

I'm testing the examples from LiveUser_Admin/example1

Using MDB2 the example works correctly, but when using DB storage container
I get the error:

Couldn't create the query, reason: DB Error: no such field-UPDATE
liveuser_perm_users_seq SET id=LAST_INSERT_ID(id+1) [nativecode=1054 **
Unknown column 'id' in 'field list']

It appear not to respect the alias *id* to *sequence* when using the DB
storage container:

'tables' => array(
                        'users' => array(
                            'fields' => array(
                                'name' => false,
                                'email' => false,
        'id' => 'sequence',
                            ),
                        ),


After change the field name sequence to id on the database the example works
with out no problem.

I don't believe this is the expected behavior. Any advice on how to correct
this will be most welcome.

Another thing:

There is any way I can make LiveUser use the auto increment columns from
MYSQL?


Angelo