MySQL Bugs: #29342: Unsupported query executed by Brighthouse(storage engine) with no error message.

Bug #29342	Unsupported query executed by Brighthouse(storage engine) with no error message.
Submitted:	25 Jun 2007 17:33	Modified:	25 Jul 2007 18:49
Reporter:	amir sheikh	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Memory storage engine	Severity:	S3 (Non-critical)
Version:	5.1.14-beta	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
The following defect is reproduciable for our storage engine(The Brighthouse) implemented with mysql.

How to repeat:
Steps to Reproduce:
1. Create two Brighthouse tables with same table structures. 
For example:
create table t1(a int) engine=brighthouse; and 
create table t2(a int) engine=brighthouse;

2. Load some data in table t1.

3. Execute the following query.

mysql> insert into t2 select * from t1;

This query will execute with zero rows affected and one warning. 
Note: inserting data from BH table to BH table is not supported.

4. Execute
mysql> show warnings;
+-------+------+----------------------------------------------------------+
| Level | Code | Message |
+-------+------+----------------------------------------------------------+
| Error | 1031 | Table storage engine for 't2' doesn't have this option |
+-------+------+----------------------------------------------------------+
1 row in set (0.00 sec)

The above message should appear at the time the above unsupported query is executed.

Suggested fix:
It is assumed about engines that they provide a certain interface. Some function like inserting rows in a table are optional functions in this interface.

If MySQL tries to use an optional function and it is not implemented in a given engine usually it reports an error.

In this case it reports a warning instead of an error so it is a bug in mysql.

Simply speaking, we report the information that the functionality of rows inserting is not implemented for BrightHouse tables. MySQL decides what to do with this information: whether to report it as warning or an error. MySQL reports it as warning.

 

Regards

Arek

Thank you for the report.

But version 5.1.14 is quite old. Please try with current version 5.1.19 and say us result.

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".