Skip Menu |
 

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

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

People
Owner: Nobody in particular
Requestors: warp [...] spin.de
Cc:
AdminCc:

Bug Information
Severity: Wishlist
Broken in: 4.043
Fixed in: (no value)



Subject: More meta information from MYSQL_FIELD helpful
Download (untitled) / with headers
text/plain 1020b
For a current project, it would be nice to have more information from MYSQL_FIELD->flags and available in Perl to gain more information about column types. What I'm currently missing is: - ENUM_FLAG and SET_FLAG from MYSQLD_FIELD->flags to be able to detect ENUMs and SETs (which otherwise present themselves as "char") - UNSIGNED_FLAG for unsigned detection I could even live some kind of extension for dbd_st_FETCH_internal which simple returns MYSQLD_FIELD->flags as is, and then check the bits myself. - MYSQL_FIELD->org_name and MYSQL_FIELD->org_table would be helpful to access original table and column names (bypassing AS aliases) I unfortunately, due to circumstances, cannot use accesses INFORMATION_SCHEMA or SHOW COLUMNS here to query the actual column types as the queries I have to analyze are basically free form and often heavily aliased, so I cannot sensible find out the affected columns of the tables without parsing the query myself, as org_name and org_table are also not available from Perl.


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.