diff options
| author | unknown <monty@narttu.mysql.fi> | 2003-05-13 19:26:07 +0300 |
|---|---|---|
| committer | unknown <monty@narttu.mysql.fi> | 2003-05-13 19:26:07 +0300 |
| commit | d05cd28c10bdc94783074ebaba40a3ed1fabe6a6 (patch) | |
| tree | 475f7895f8b8ca9b87712c500177e254a1b0e08e /mysql-test/r/ansi.result | |
| parent | dc1e55f8194db83e7a40dea5bf49e9fef970826c (diff) | |
| download | mariadb-git-d05cd28c10bdc94783074ebaba40a3ed1fabe6a6.tar.gz | |
Fixed problem with ansi mode and GROUP BY with constants. (Bug #387)
sql/sql_select.cc:
Fixed problem with ansi mode and GROUP BY with constants
Diffstat (limited to 'mysql-test/r/ansi.result')
| -rw-r--r-- | mysql-test/r/ansi.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/ansi.result b/mysql-test/r/ansi.result new file mode 100644 index 00000000000..f9f96310b73 --- /dev/null +++ b/mysql-test/r/ansi.result @@ -0,0 +1,10 @@ +drop table if exists t1; +SELECT 'A' || 'B'; +'A' || 'B' +AB +CREATE TABLE t1 (id INT, id2 int); +SELECT id,NULL,1,1.1,'a' FROM t1 GROUP BY id; +id NULL 1 1.1 a +SELECT id FROM t1 GROUP BY id2; +'t1.id' isn't in GROUP BY +drop table t1; |