MySQL Bugs: #11262: CRASH IN SELECT

Bug #11262	CRASH IN SELECT
Submitted:	11 Jun 2005 17:25	Modified:	28 Jul 2005 8:41
Reporter:	kmesen kmesen	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	3.51.11.0	OS:	WXP SP2
Assigned to:		CPU Architecture:	Any

Description:
CONNECTOR chash with Power builder any version when retrieve :

<?xml version="1.0" encoding="UTF-16"?>
<DATABASE>
<EXE NAME="pb90.exe" FILTER="GRABMI_FILTER_PRIVACY">
    <MATCHING_FILE NAME="pb90.exe" SIZE="33280" CHECKSUM="0x84644415" BIN_FILE_VERSION="9.0.0.5507" BIN_PRODUCT_VERSION="9.0.0.0" FILE_DESCRIPTION="Sybase PowerBuilder" COMPANY_NAME="Sybase Inc." PRODUCT_NAME="PowerBuilder/InfoMaker" FILE_VERSION="9.0.0.5507" INTERNAL_NAME="PB 9.0" LEGAL_COPYRIGHT="Copyright Sybase Inc. 2002" VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x10001" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="9.0.0.5507" UPTO_BIN_PRODUCT_VERSION="9.0.0.0" LINK_DATE="02/18/2003 05:55:40" UPTO_LINK_DATE="02/18/2003 05:55:40" VER_LANGUAGE="Inglés (Estados Unidos) [0x409]" />
    <MATCHING_FILE NAME="SDK\PBNI\pbsig90.exe" SIZE="73728" CHECKSUM="0x962F4E4" BIN_FILE_VERSION="9.0.2.7610" BIN_PRODUCT_VERSION="9.0.2.0" FILE_DESCRIPTION="Sybase Inc. Product File" COMPANY_NAME="Sybase Inc." PRODUCT_NAME="PowerBuilder/InfoMaker" FILE_VERSION="9.0.2.7610" INTERNAL_NAME="PB 9.0" LEGAL_COPYRIGHT="Copyright Sybase Inc. 2002" VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x10001" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="9.0.2.7610" UPTO_BIN_PRODUCT_VERSION="9.0.2.0" LINK_DATE="03/01/2005 07:47:02" UPTO_LINK_DATE="03/01/2005 07:47:02" VER_LANGUAGE="Inglés (Estados Unidos) [0x409]" />
    <MATCHING_FILE NAME="SDK\PBNI\pbx2pbd90.exe" SIZE="35840" CHECKSUM="0x6B4EE225" BIN_FILE_VERSION="9.0.2.7610" BIN_PRODUCT_VERSION="9.0.2.0" FILE_DESCRIPTION="Sybase Inc. Product File" COMPANY_NAME="Sybase Inc." PRODUCT_NAME="PowerBuilder/InfoMaker" FILE_VERSION="9.0.2.7610" INTERNAL_NAME="PB 9.0" LEGAL_COPYRIGHT="Copyright Sybase Inc. 2002" VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x10001" VERFILETYPE="0x1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" UPTO_BIN_FILE_VERSION="9.0.2.7610" UPTO_BIN_PRODUCT_VERSION="9.0.2.0" LINK_DATE="03/01/2005 07:46:55" UPTO_LINK_DATE="03/01/2005 07:46:55" VER_LANGUAGE="Inglés (Estados Unidos) [0x409]" />
</EXE>
<EXE NAME="myodbc3.dll" FILTER="GRABMI_FILTER_THISFILEONLY">
    <MATCHING_FILE NAME="myodbc3.dll" SIZE="1114112" CHECKSUM="0xD0149A1D" BIN_FILE_VERSION="3.51.11.0" BIN_PRODUCT_VERSION="3.51.0.0" PRODUCT_VERSION="3.51" FILE_DESCRIPTION="MySQL ODBC 3.51 Driver" COMPANY_NAME="MySQL AB" PRODUCT_NAME="Connector/ODBC 3.51" FILE_VERSION="3.51.10 (GA)" ORIGINAL_FILENAME="myodbc3.dll" INTERNAL_NAME="myodbc3" LEGAL_COPYRIGHT="Copyright © MySQL AB 1995-2005" VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x11F58F" LINKER_VERSION="0x30033" UPTO_BIN_FILE_VERSION="3.51.11.0" UPTO_BIN_PRODUCT_VERSION="3.51.0.0" LINK_DATE="02/11/2005 08:05:43" UPTO_LINK_DATE="02/11/2005 08:05:43" VER_LANGUAGE="Inglés (Estados Unidos) [0x409]" />
</EXE>
<EXE NAME="kernel32.dll" FILTER="GRABMI_FILTER_THISFILEONLY">
    <MATCHING_FILE NAME="kernel32.dll" SIZE="979968" CHECKSUM="0x977818F5" BIN_FILE_VERSION="5.1.2600.0" BIN_PRODUCT_VERSION="5.1.2600.0" PRODUCT_VERSION="5.1.2600.0" FILE_DESCRIPTION="DLL de cliente API BASE de Windows NT" COMPANY_NAME="Microsoft Corporation" PRODUCT_NAME="Sistema operativo Microsoft® Windows®" FILE_VERSION="5.1.2600.0 (xpclient.010817-1148)" ORIGINAL_FILENAME="kernel32" INTERNAL_NAME="kernel32" LEGAL_COPYRIGHT="Copyright (C) Microsoft Corporation. Reservados todos los derechos." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0xF4F64" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="5.1.2600.0" UPTO_BIN_PRODUCT_VERSION="5.1.2600.0" LINK_DATE="08/22/2001 21:12:24" UPTO_LINK_DATE="08/22/2001 21:12:24" VER_LANGUAGE="Español (alfabetización internacional) [0xc0a]" />
</EXE>
</DATABASE>

How to repeat:
retrieve data from  table reg_pla_emp with dbpainter in power builder. adjunt script of db structure. the problem is only with this table.

file with chash

Attachment: appcompat.txt (application/octet-stream, text), 7.53 KiB.

the crash ocurr when i retrieve data in Power builder (any version). I open the window DATABASE, find the table reg_pla_emp and doubleclick over this table PB crash, ocurred by  ODBC CONNECTOR. this problem ocurr with this table only and when all structure are generated.

Hi!

what exactly query lead to carsh?

HI Aleksey ! sorry for wait.

when Powerbuilder connect to DB. and open then window "DATABASE", this is for admin database objects. when i do doubleclick over the table reg_pla_emp then crash ocurr. this problem ocurr only with this table.

TNX,
Kmesen

the  crash ocurr when all tables is generated, if only reg_pla_emp table es generated in the DB not ocurr then crash.

Kmesen

I created a test case and opened reg_pla_emp without problems. I think it is not bug of ODBC connector. I attached case test.

Test case

Attachment: test.c (text/plain), 3.72 KiB.

The problem not ocurr when "select * from reg_pla_emp", the crash ocurr when open window DATABASE in power builder and tri to open table in object tree of this window. the problem is only in this window not for select's.

Sorry...but if myODBC returns correct result and does't crash I think this is bug of Power Builder.