InfiniDB Community Database

Activity log for bug #461511

Date Who What changed Old value New value Message
2009-10-26 22:33:39 mroberts bug added bug
2009-10-27 20:58:25 mroberts 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=CALPONT; create table qastringtest2 (c1 char(1), c2 char(8), c3 varchar(1), c4 varchar(8), c5 varchar(5)) ENGINE=CALPONT; 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 '); 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 ');
2009-10-27 20:58:38 mroberts infinidb: importance Undecided Low
2009-10-27 20:58:38 mroberts infinidb: status New Confirmed