Skip Menu |
 

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id: 77952
Status: resolved
Priority: 0/
Queue: DBD-mysql

People
Owner: Nobody in particular
Requestors: racke [...] linuxia.de
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: 4.020
Fixed in: (no value)



Subject: Curious behaviour with serial and primary_key method
First table definition: create table delivery_lists ( code serial, created datetime not null ); Second table definition: create table delivery_lists ( code serial, created datetime not null, primary key(code) ); MySQL shows in both cases: Show quoted text
mysql> describe delivery_lists;
+---------+---------------------+------+-----+---------+---------------- + | Field | Type | Null | Key | Default | Extra | +---------+---------------------+------+-----+---------+---------------- + | code | bigint(20) unsigned | NO | PRI | NULL | auto_increment | | created | datetime | NO | | NULL | | +---------+---------------------+------+-----+---------+---------------- + 2 rows in set (0.00 sec) primary_key method yields different results in these two cases: @keys = $self->{dbh}->primary_key(undef, undef, 'delivery_tables); First case: @keys = ('code'); Second case: @keys = (); That differs from what MySQL is showing. Please advise. Regards Racke


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.