diff options
| author | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2010-03-26 11:46:18 +0400 |
|---|---|---|
| committer | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2010-03-26 11:46:18 +0400 |
| commit | 3658bde7361e862fd87ae5e28f03cc52c4e9fa6a (patch) | |
| tree | 1a93ebbfeade1cda83dd2afabd4b3ef3991556e2 /mysql-test/t/join.test | |
| parent | 28e95ba535e175dc696fe7a739736ae9bf2a2b36 (diff) | |
| parent | f57839cd6060ff2d8edb4bf0875b67d0176d88e4 (diff) | |
| download | mariadb-git-3658bde7361e862fd87ae5e28f03cc52c4e9fa6a.tar.gz | |
5.0-bugteam->5.1-bugteam merge
Diffstat (limited to 'mysql-test/t/join.test')
| -rw-r--r-- | mysql-test/t/join.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/join.test b/mysql-test/t/join.test index c1b35b51563..09464c4d926 100644 --- a/mysql-test/t/join.test +++ b/mysql-test/t/join.test @@ -796,6 +796,17 @@ SELECT 1 FROM v1 right join v1 AS v2 ON RAND(); DROP VIEW v1; DROP TABLE t1; +--echo # +--echo # Bug#52177 crash with explain, row comparison, join, text field +--echo # +CREATE TABLE t1 (a TINYINT, b TEXT, KEY (a)); +INSERT INTO t1 VALUES (0,''),(0,''); +FLUSH TABLES; +EXPLAIN SELECT 1 FROM t1 LEFT JOIN t1 a ON 1 +WHERE ROW(t1.a, 1111.11) = ROW(1111.11, 1111.11) AND +ROW(t1.b, 1111.11) <=> ROW('',''); +DROP TABLE t1; + --echo End of 5.0 tests. |