Similiar queries returning different results - should report dup columns

Bug #461511 reported by mroberts
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
InfiniDB Community
Confirmed
Low
Unassigned

Bug Description

Similiar queries returning different results. Both queries should report,
duplicate columns.

mysql> desc qastringtest1;
+-------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------+------+-----+---------+-------+
| c1 | char(1) | YES | | NULL | |
| c2 | char(8) | YES | | NULL | |
| c3 | varchar(1) | YES | | NULL | |
| c4 | varchar(8) | YES | | NULL | |
| c5 | char(5) | YES | | NULL | |
+-------+------------+------+-----+---------+-------+
5 rows in set (0.04 sec)

mysql> desc qastringtest2;
+-------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------+------+-----+---------+-------+
| c1 | char(1) | YES | | NULL | |
| c2 | char(8) | YES | | NULL | |
| c3 | varchar(1) | YES | | NULL | |
| c4 | varchar(8) | YES | | NULL | |
| c5 | varchar(5) | YES | | NULL | |
+-------+------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> select * from qastringtest1, qastringtest2 where
qastringtest1.c4=qastringtest2.c4;
ERROR 138 (HY000):
The query includes syntax that is not supported by InfiniDB.

Use 'show warnings;' to get more infomation.
                                                                 Restructure
the query with supported syntax.
mysql>
mysql> select * from qastringtest1, qastringtest2 where
qastringtest1.c5=qastringtest2.c5;
Empty set (0.14 sec)

Notice the second query is comparing a char to a varchar.

It returns the wrong resutls (0 rows), but should report duplicate column, as
should the first or not supported since it's comparing a char to a varchar.

create table qastringtest1 (c1 char(1), c2 char(8), c3 varchar(1), c4
varchar(8), c5 char(5)) ENGINE=infinicb;
create table qastringtest2 (c1 char(1), c2 char(8), c3 varchar(1), c4
varchar(8), c5 varchar(5)) ENGINE=infinidb;
insert into qastringtest1 values ('a','abcdefgh','b','ijklmnop','1234 ');
insert into qastringtest2 values ('a','abcdefgh','b','ijklmnop','1234 ');
insert into qastringtest1 values ('c','aaaaaaaa','d','bbbbbbbb','5678 ');
insert into qastringtest2 values ('c','aaaaaaaa','d','bbbbbbbb','5678 ');

mroberts (mroberts)
description: updated
Changed in infinidb:
importance: Undecided → Low
status: New → Confirmed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.