Bug #23833 compiler error in database scripts
Submitted: 1 Nov 2006 11:57 Modified: 8 Oct 2007 3:16
Reporter: Tobias Barth Email Updates:
Status: No Feedback Impact on me:
None 
Category:MaxDB Severity:S2 (Serious)
Version:7.6.00.34 OS:Linux (SuSE Linux 10.1 (32 Bit))
Assigned to: CPU Architecture:Any

[1 Nov 2006 11:57] Tobias Barth 
Description:
I defined a DB Function and two indexes:

CREATE FUNCTION USER_VARCHAR_LOWER (value VARCHAR) RETURNS VARCHAR DETERMINISTIC AS RETURN LOWER(value);
//
create index DEOL on ORDERS (USER_VARCHAR_LOWER(DELIV_EMAIL))
//
create index IEOL on ORDERS (USER_VARCHAR_LOWER(INVOICE_EMAIL))

and explained:
explain SELECT MAX(ORDER_KEY) FROM ORDERS WHERE CUST_IMPORT_REF LIKE 'D%' AND (USER_VARCHAR_LOWER(DELIV_EMAIL)='tobias.barth@web-arts.com' OR USER_VARCHAR_LOWER(DELIV_EMAIL)='tobias.barth@web-arts.com.' OR USER_VARCHAR_LOWER(INVOICE_EMAIL)='tobias.barth@web-arts.com')

after explaining,
the database crashed. db messages will be attached.

How to repeat:
create table "ORDERS", the function and the indexes and then do the explain.
[1 Nov 2006 13:08] MySQL Verification Team 
The Windows on Win2003 Server version not crashes and the explain result is:

MIGUEL	ORDERS		TABLE SCAN	         1	
			MIN/MAX OPTIMIZATION		
			     RESULT IS COPIED   , COSTVALUE IS	         3
[8 Sep 2007 3:16] Valeriy Kravchuk 
Please, try to repeat with a newer version, 7.6.00.37, and inform about the results.
[8 Oct 2007 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".