diff options
| author | unknown <bell@sanja.is.com.ua> | 2004-08-24 18:46:27 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2004-08-24 18:46:27 +0300 |
| commit | c331d6c59feb1064fab6512bd9156b09742b6cfc (patch) | |
| tree | 1ab4dfcca9834d0531f3f48f719fbae7ea8fc3b4 /mysql-test | |
| parent | b131ce03e5cc900c7b61e427456456e630d0aeca (diff) | |
| download | mariadb-git-c331d6c59feb1064fab6512bd9156b09742b6cfc.tar.gz | |
items for functions which is converted to constants internally to support its correct printing added (BUG#4663)
mysql-test/r/view.result:
test of functions in VIEW which is converted to constants internally
mysql-test/t/view.test:
test of functions in VIEW which is converted to constants internally
sql/item.h:
items for functions which is converted to constants internally to support its correct printing
sql/item_create.cc:
items for functions which is converted to constants internally to support its correct printing
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/view.result | 5 | ||||
| -rw-r--r-- | mysql-test/t/view.test | 7 |
2 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index f2a4648bdc4..ac19dbe4ffa 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -1053,3 +1053,8 @@ create index i1 on v1 (col1); ERROR HY000: 'test.v1' is not BASIC TABLE drop view v1; drop table t1; +CREATE VIEW v1 (f1,f2,f3,f4) AS SELECT connection_id(), pi(), current_user(), version(); +SHOW CREATE VIEW v1; +Table Create Table +v1 CREATE VIEW test.v1 AS select sql_no_cache connection_id() AS `f1`,pi() AS `f2`,current_user() AS `f3`,version() AS `f4` +drop view v1; diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index d9d9d0ba765..dc92d7936eb 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -997,3 +997,10 @@ create view v1 as select * from t1; create index i1 on v1 (col1); drop view v1; drop table t1; + +# +# connection_id(), pi(), current_user(), version() representation test +# +CREATE VIEW v1 (f1,f2,f3,f4) AS SELECT connection_id(), pi(), current_user(), version(); +SHOW CREATE VIEW v1; +drop view v1; |