diff options
| author | unknown <igor@rurik.mysql.com> | 2006-04-10 17:48:17 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2006-04-10 17:48:17 -0700 |
| commit | 69e54f84ec810d60bfd1d66b1d44d4a1dd7b0a9c (patch) | |
| tree | 7214a2bf92c191d1f39585cf03f36d6302fc00b0 /mysql-test/r/view.result | |
| parent | 099e770e7d4ab76c48ec81d07754b828594f5bce (diff) | |
| parent | 6978949b49a6c9b2746ac8aab1a1362c5db8d576 (diff) | |
| download | mariadb-git-69e54f84ec810d60bfd1d66b1d44d4a1dd7b0a9c.tar.gz | |
Merge rurik.mysql.com:/home/igor/dev/mysql-5.0-0
into rurik.mysql.com:/home/igor/dev/mysql-5.1-0
mysql-test/mysql-test-run.pl:
Auto merged
mysql-test/r/view.result:
Auto merged
mysql-test/t/view.test:
Auto merged
sql/item_cmpfunc.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index fc3e5475ae7..0b6ebe9dd89 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -2579,3 +2579,24 @@ COUNT(*) 2 DROP VIEW v2; DROP TABLE t1, t2; +CREATE TABLE t1 (id int NOT NULL PRIMARY KEY, +td date DEFAULT NULL, KEY idx(td)); +INSERT INTO t1 VALUES +(1, '2005-01-01'), (2, '2005-01-02'), (3, '2005-01-02'), +(4, '2005-01-03'), (5, '2005-01-04'), (6, '2005-01-05'), +(7, '2005-01-05'), (8, '2005-01-05'), (9, '2005-01-06'); +CREATE VIEW v1 AS SELECT * FROM t1; +SELECT * FROM t1 WHERE td BETWEEN '2005.01.02' AND '2005.01.04'; +id td +2 2005-01-02 +3 2005-01-02 +4 2005-01-03 +5 2005-01-04 +SELECT * FROM v1 WHERE td BETWEEN '2005.01.02' AND '2005.01.04'; +id td +2 2005-01-02 +3 2005-01-02 +4 2005-01-03 +5 2005-01-04 +DROP VIEW v1; +DROP TABLE t1; |