Concat Fails

[cursed]

Hi, 5.21 crashes when executing certain queries. I added some stuff here, don't really know if they are helpful or not.

Code:

Error message(in finnish, sorry):
=============================================================
SQLYOG aiheutti pinovirheen moduulissa KERNEL32.DLL muistipaikassa 0167:bff7429f.
Rekisterit:
EAX=81629be4 CS=0167 EIP=bff7429f EFLGS=00000287
EBX=00940010 SS=016f ESP=00949ff0 EBP=00008fe8
ECX=c1665720 DS=016f ESI=00000000 FS=1b57
EDX=0001eb04 ES=016f EDI=0000ffff GS=0000
Tavut muistipaikassa CS:EIP:
eb 95 8b 54 24 04 50 e8 04 00 00 00 58 c2 04 00
Pinon vedos:
bff71547 00000000 0094a1d2 0094a1ae 00000000 1000a07c 4b4843e0 00000004
00000f60 00000000 00000000 0094a1d2 0094a194 0094a1ae 00000000 00000000

Code:

Query:
=============================================================
SELECT
CONCAT( s.skill, '(', ss.specialty, ')' ) AS skill,
s.attribute,
s.difficulty
FROM
specialties AS ss
LEFT JOIN
skills AS s
ON
ss.skill_id = s.id
ORDER BY
skill

Code:

Table structures:
=============================================================
skills CREATE TABLE `skills` (
`id` int(10) unsigned NOT NULL auto_increment,
`skill` varchar(50) NOT NULL default '',
`attribute` enum('ST','DX','IQ','HT','Will','Per','DX or IQ') NOT NULL default 'DX',
`difficulty` enum('Easy','Average','Hard','Very Hard') NOT NULL default 'Average',
`tech_level` tinyint(3) unsigned NOT NULL default '0',
`specialty` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

specialties CREATE TABLE `specialties` (
`id` int(10) unsigned NOT NULL auto_increment,
`skill_id` int(10) unsigned NOT NULL default '0',
`specialty` varchar(30) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

Code:

Other information:
=============================================================
Microsoft Windows 98 4.10.2222 A
Puhdas asennus käyttäen /T:C:WININST0.400 /SrcDir=C:WINDOWSOPTIONSCABS /IS /IW /IQ /ID /IV /IZ /II /NR /II /C /U:xxxxxxxxxxxxxxxxx
IE 5 6.0.2800.1106
IBM Corporation
GenuineIntel x86 Family 6 Model 8 Stepping 6
64 Mt RAM

-Cursed

[peterlaursen]

It works here. Also on W98. It could be data-specific.

Could you provide a compete (and small and simple!) test case consisting of:

*table structures

*data

*querie

.. to reproduce with?

Yes it is a problem with Finnish! I only know the name of the Finnish Miniters of Health ('Hygiejnen') and Energy ('Kakkelovnen') – – – sorry about my bad Danish jokes!

[cursed]

peterlaursen wrote on Dec 11 2006, 07:45 AM:

It works here. Also on W98. It could be data-specific.

Could you provide a compete (and small and simple!) test case consisting of:

*table structures

*data

*querie

.. to reproduce with?

Yes it is a problem with Finnish! I only know the name of the Finnish Miniters of Health ('Hygiejnen') and Energy ('Kakkelovnen') – – – sorry about my bad Danish jokes!

I'll try to post you examples tomorrow.

-Cursed

[Author]

Posts