diff options
Diffstat (limited to 'mysql-test/suite/perfschema/r/prepared_statements.result')
| -rw-r--r-- | mysql-test/suite/perfschema/r/prepared_statements.result | 21 |
1 files changed, 12 insertions, 9 deletions
diff --git a/mysql-test/suite/perfschema/r/prepared_statements.result b/mysql-test/suite/perfschema/r/prepared_statements.result index 78ca2a65a1d..c11b486094e 100644 --- a/mysql-test/suite/perfschema/r/prepared_statements.result +++ b/mysql-test/suite/perfschema/r/prepared_statements.result @@ -57,7 +57,7 @@ OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql -SQL_TEXT PREPARE st1 FROM ... +SQL_TEXT PREPARE st1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse' OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL @@ -77,12 +77,13 @@ OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql -SQL_TEXT PREPARE st3 FROM ... +SQL_TEXT PREPARE st3 FROM 'INSERT INTO t1 SELECT * FROM t1 WHERE a<=?' OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql -SQL_TEXT PREPARE st4 FROM ... +SQL_TEXT PREPARE st4 FROM +'(SELECT a FROM t1) UNION (SELECT a+10 FROM t1) ORDER BY RAND()*0+a' OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL @@ -163,7 +164,7 @@ OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql -SQL_TEXT PREPARE st1 FROM ... +SQL_TEXT PREPARE st1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse' OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL @@ -183,12 +184,13 @@ OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql -SQL_TEXT PREPARE st3 FROM ... +SQL_TEXT PREPARE st3 FROM 'INSERT INTO t1 SELECT * FROM t1 WHERE a<=?' OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql -SQL_TEXT PREPARE st4 FROM ... +SQL_TEXT PREPARE st4 FROM +'(SELECT a FROM t1) UNION (SELECT a+10 FROM t1) ORDER BY RAND()*0+a' OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL @@ -295,7 +297,7 @@ OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql -SQL_TEXT PREPARE st1 FROM ... +SQL_TEXT PREPARE st1 FROM 'SELECT SQRT(POW(?,2) + POW(?,2)) AS hypotenuse' OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL @@ -315,12 +317,13 @@ OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql -SQL_TEXT PREPARE st3 FROM ... +SQL_TEXT PREPARE st3 FROM 'INSERT INTO t1 SELECT * FROM t1 WHERE a<=?' OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL EVENT_NAME statement/sql/prepare_sql -SQL_TEXT PREPARE st4 FROM ... +SQL_TEXT PREPARE st4 FROM +'(SELECT a FROM t1) UNION (SELECT a+10 FROM t1) ORDER BY RAND()*0+a' OBJECT_TYPE NULL OBJECT_SCHEMA NULL OBJECT_NAME NULL |