1 files changed, 8 insertions, 8 deletions
diff --git a/mysql-test/suite/compat/oracle/r/sp-param.result b/mysql-test/suite/compat/oracle/r/sp-param.result
index 68ecefa5077..aab1811ef67 100644
--- a/mysql-test/suite/compat/oracle/r/sp-param.result
+++ b/mysql-test/suite/compat/oracle/r/sp-param.result
@@ -14,7 +14,7 @@ CREATE TABLE t1 AS SELECT f1(REPEAT('a',2000)) AS a;;
 SHOW CREATE TABLE t1;
 Table	Create Table
 t1	CREATE TABLE "t1" (
-  "a" text DEFAULT NULL
+  "a" varchar(2000) DEFAULT NULL
 )
 DROP TABLE t1;
 DROP FUNCTION f1;
@@ -30,7 +30,7 @@ CREATE TABLE t1 AS SELECT f1(REPEAT('a',2000)) AS a;;
 SHOW CREATE TABLE t1;
 Table	Create Table
 t1	CREATE TABLE "t1" (
-  "a" text CHARACTER SET utf8 DEFAULT NULL
+  "a" varchar(2000) CHARACTER SET utf8 DEFAULT NULL
 )
 DROP TABLE t1;
 DROP FUNCTION f1;
@@ -46,7 +46,7 @@ CREATE TABLE t1 AS SELECT f1(REPEAT('a',2000)) AS a;;
 SHOW CREATE TABLE t1;
 Table	Create Table
 t1	CREATE TABLE "t1" (
-  "a" blob DEFAULT NULL
+  "a" varbinary(2000) DEFAULT NULL
 )
 DROP TABLE t1;
 DROP FUNCTION f1;
@@ -62,7 +62,7 @@ CREATE TABLE t1 AS SELECT f1(REPEAT('a',4000)) AS a;;
 SHOW CREATE TABLE t1;
 Table	Create Table
 t1	CREATE TABLE "t1" (
-  "a" text DEFAULT NULL
+  "a" varchar(4000) DEFAULT NULL
 )
 DROP TABLE t1;
 DROP FUNCTION f1;
@@ -78,7 +78,7 @@ CREATE TABLE t1 AS SELECT f1(REPEAT('a',4000)) AS a;;
 SHOW CREATE TABLE t1;
 Table	Create Table
 t1	CREATE TABLE "t1" (
-  "a" text DEFAULT NULL
+  "a" varchar(4000) DEFAULT NULL
 )
 DROP TABLE t1;
 DROP FUNCTION f1;
@@ -94,7 +94,7 @@ CREATE TABLE t1 AS SELECT f1(REPEAT('a',4000)) AS a;;
 SHOW CREATE TABLE t1;
 Table	Create Table
 t1	CREATE TABLE "t1" (
-  "a" text CHARACTER SET utf8 DEFAULT NULL
+  "a" varchar(4000) CHARACTER SET utf8 DEFAULT NULL
 )
 DROP TABLE t1;
 DROP FUNCTION f1;
@@ -110,7 +110,7 @@ CREATE TABLE t1 AS SELECT f1(REPEAT('a',4000)) AS a;;
 SHOW CREATE TABLE t1;
 Table	Create Table
 t1	CREATE TABLE "t1" (
-  "a" blob DEFAULT NULL
+  "a" varbinary(4000) DEFAULT NULL
 )
 DROP TABLE t1;
 DROP FUNCTION f1;
@@ -126,7 +126,7 @@ CREATE TABLE t1 AS SELECT f1(REPEAT('a',4000)) AS a;;
 SHOW CREATE TABLE t1;
 Table	Create Table
 t1	CREATE TABLE "t1" (
-  "a" blob DEFAULT NULL
+  "a" varbinary(4000) DEFAULT NULL
 )
 DROP TABLE t1;
 DROP FUNCTION f1;