summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_misc.result
diff options
context:
space:
mode:
authortsmith@ramayana.hindu.god <>2007-12-04 20:58:21 -0700
committertsmith@ramayana.hindu.god <>2007-12-04 20:58:21 -0700
commit10cab933b29583df5d9d4c490c6e602d35264385 (patch)
tree0314ad5cd173e9b49968cb56e0081e21eb2fdd5f /mysql-test/r/func_misc.result
parent0e78354baa5ed83f115b6f96e21b31fe0b1e4cbc (diff)
parent02e321d3502e8771f2092c6167de189423f4ec49 (diff)
downloadmariadb-git-10cab933b29583df5d9d4c490c6e602d35264385.tar.gz
Merge tsmith@bk-internal.mysql.com:/home/bk/mysql-5.0
into ramayana.hindu.god:/home/tsmith/m/bk/maint/50
Diffstat (limited to 'mysql-test/r/func_misc.result')
-rw-r--r--mysql-test/r/func_misc.result22
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/func_misc.result b/mysql-test/r/func_misc.result
index db2490bd261..a302ad4769e 100644
--- a/mysql-test/r/func_misc.result
+++ b/mysql-test/r/func_misc.result
@@ -185,6 +185,28 @@ ERROR 21000: Operand should contain 1 column(s)
drop table table_26093;
drop function func_26093_a;
drop function func_26093_b;
+SELECT NAME_CONST('test', NOW());
+ERROR HY000: Incorrect arguments to NAME_CONST
+SELECT NAME_CONST('test', UPPER('test'));
+ERROR HY000: Incorrect arguments to NAME_CONST
+SELECT NAME_CONST('test', NULL);
+test
+NULL
+SELECT NAME_CONST('test', 1);
+test
+1
+SELECT NAME_CONST('test', -1);
+test
+-1
+SELECT NAME_CONST('test', 1.0);
+test
+1.0
+SELECT NAME_CONST('test', -1.0);
+test
+-1.0
+SELECT NAME_CONST('test', 'test');
+test
+test
create table t1 (a int not null);
insert into t1 values (-1), (-2);
select min(a) from t1 group by inet_ntoa(a);