1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/main/function_defaults.test b/mysql-test/main/function_defaults.test
new file mode 100644
index 00000000000..f8b23d0eda8
--- /dev/null
+++ b/mysql-test/main/function_defaults.test
@@ -0,0 +1,21 @@
+--echo #
+--echo # Test of function defaults for any server, including embedded.
+--echo #
+
+--echo #
+--echo # Function defaults run 1. No microsecond precision.
+--echo #
+let $current_timestamp=CURRENT_TIMESTAMP;
+let $now=NOW();
+let $timestamp=TIMESTAMP;
+let $datetime=DATETIME;
+source 'include/function_defaults.inc';
+
+--echo #
+--echo # Function defaults run 2. Six digits scale on seconds precision.
+--echo #
+let $current_timestamp=CURRENT_TIMESTAMP(6);
+let $now=NOW(6);
+let $timestamp=TIMESTAMP(6);
+let $datetime=DATETIME(6);
+source 'include/function_defaults.inc';