Similiar queries returning different results - should report dup columns
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.
ERROR 138 (HY000):
The query includes syntax that is not supported by InfiniDB.
Use 'show warnings;' to get more infomation.
the query with supported syntax.
mysql>
mysql> select * from qastringtest1, qastringtest2 where
qastringtest1.
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'
insert into qastringtest2 values ('a','abcdefgh'
insert into qastringtest1 values ('c','aaaaaaaa'
insert into qastringtest2 values ('c','aaaaaaaa'
description: | updated |
Changed in infinidb: | |
importance: | Undecided → Low |
status: | New → Confirmed |