Bug #64468 | Show Columns produces byte array, Describe does not. | ||
---|---|---|---|
Submitted: | 27 Feb 2012 13:57 | Modified: | 28 Feb 2012 14:51 |
Reporter: | Michael B | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | Connector / NET | Severity: | S3 (Non-critical) |
Version: | 6.2.5.0 | OS: | Windows |
Assigned to: | CPU Architecture: | Any |
[27 Feb 2012 13:57]
Michael B
[27 Feb 2012 14:28]
Valeriy Kravchuk
These are all ages old versions, and we do not fix bugs in old versions... We need to know if the problem is repeatable with server 5.0.91+ and Connector/Net 6.3.8+ at least. Let's first check if the problem is in server. Please, run mysql command line client with -T option, like this: macbook-pro:5.0 openxs$ bin/mysql -T -uroot test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.0.95-debug Source distribution Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> desc t1; Field 1: `Field` Catalog: `def` Database: `` Table: `COLUMNS` Org_table: `` Type: VAR_STRING Collation: latin1_swedish_ci (8) Length: 64 Max_length: 1 Decimals: 0 Flags: NOT_NULL Field 2: `Type` Catalog: `def` Database: `` Table: `COLUMNS` Org_table: `` Type: BLOB Collation: latin1_swedish_ci (8) Length: 196605 Max_length: 7 Decimals: 0 Flags: NOT_NULL BLOB Field 3: `Null` Catalog: `def` Database: `` Table: `COLUMNS` Org_table: `` Type: VAR_STRING Collation: latin1_swedish_ci (8) Length: 3 Max_length: 3 Decimals: 0 Flags: NOT_NULL Field 4: `Key` Catalog: `def` Database: `` Table: `COLUMNS` Org_table: `` Type: VAR_STRING Collation: latin1_swedish_ci (8) Length: 3 Max_length: 0 Decimals: 0 Flags: NOT_NULL Field 5: `Default` Catalog: `def` Database: `` Table: `COLUMNS` Org_table: `` Type: BLOB Collation: latin1_swedish_ci (8) Length: 196605 Max_length: 0 Decimals: 0 Flags: BLOB Field 6: `Extra` Catalog: `def` Database: `` Table: `COLUMNS` Org_table: `` Type: VAR_STRING Collation: latin1_swedish_ci (8) Length: 20 Max_length: 0 Decimals: 0 Flags: NOT_NULL +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | x | int(11) | YES | | NULL | | +-------+---------+------+-----+---------+-------+ 1 row in set (0.00 sec) mysql> show columns from t1; Field 1: `Field` Catalog: `def` Database: `` Table: `COLUMNS` Org_table: `` Type: VAR_STRING Collation: latin1_swedish_ci (8) Length: 64 Max_length: 1 Decimals: 0 Flags: NOT_NULL Field 2: `Type` Catalog: `def` Database: `` Table: `COLUMNS` Org_table: `` Type: BLOB Collation: latin1_swedish_ci (8) Length: 196605 Max_length: 7 Decimals: 0 Flags: NOT_NULL BLOB Field 3: `Null` Catalog: `def` Database: `` Table: `COLUMNS` Org_table: `` Type: VAR_STRING Collation: latin1_swedish_ci (8) Length: 3 Max_length: 3 Decimals: 0 Flags: NOT_NULL Field 4: `Key` Catalog: `def` Database: `` Table: `COLUMNS` Org_table: `` Type: VAR_STRING Collation: latin1_swedish_ci (8) Length: 3 Max_length: 0 Decimals: 0 Flags: NOT_NULL Field 5: `Default` Catalog: `def` Database: `` Table: `COLUMNS` Org_table: `` Type: BLOB Collation: latin1_swedish_ci (8) Length: 196605 Max_length: 0 Decimals: 0 Flags: BLOB Field 6: `Extra` Catalog: `def` Database: `` Table: `COLUMNS` Org_table: `` Type: VAR_STRING Collation: latin1_swedish_ci (8) Length: 20 Max_length: 0 Decimals: 0 Flags: NOT_NULL +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | x | int(11) | YES | | NULL | | +-------+---------+------+-----+---------+-------+ 1 row in set (0.01 sec) and check if you see any difference in column types for your table. If you do, this will be an indication of server problem.
[27 Feb 2012 15:26]
Michael B
Unfortunately we can't upgrade to Mysql 5.0 right now and are therefore dependent on connector 6.2.5 (last version to support 4.1). If this is not something that can't be fixed or explained in that specific version then we will have to do some experiments to see if all the rest is working so we can or cannot upgrade to 6.2.5. I was hoping there was still support since it seems to indicate in the manual (http://dev.mysql.com/doc/refman/5.6/en/connector-net-versions.html) however i completely understand your point. Thanks for the trouble. FYI: the requested queries on the command line for Mysql 4.1.13 both returned the expected result.
[27 Feb 2012 16:32]
Valeriy Kravchuk
OK, then we have a reason to suspect connector bug here.
[28 Feb 2012 14:51]
Michael B
This bug can be closed. After more research and reading more in the documentation we found the flag Respect Binary Flags. Setting this to false as reported in the following document seems to be exactly what we needed. http://dev.mysql.md/doc/refman/5.0/en/connector-net-programming-binary-issues.html My apologies and thanks for the fast response!