diff options
| author | Dmitry Shulga <dmitry.shulga@mariadb.com> | 2021-07-19 19:25:11 +0700 |
|---|---|---|
| committer | Dmitry Shulga <dmitry.shulga@mariadb.com> | 2021-07-19 19:25:11 +0700 |
| commit | bab989ab38a4d1d93f0f783fa0ee5e9f641a8566 (patch) | |
| tree | b0ff2167d70ba2b47c753bbbcd50a1d8e15a6c73 /mysql-test/r | |
| parent | c47e4aab62c65e1a1d431f9888ba1bc6b9841687 (diff) | |
| download | mariadb-git-bab989ab38a4d1d93f0f783fa0ee5e9f641a8566.tar.gz | |
MDEV-26145: Incorrect metadata is sent on running query with union in PS mode
Test cases like the following one produce different result sets if it's run
with and without th option --ps-protocol.
CREATE TABLE t1(a INT);
--enable_metadata
(SELECT MAX(a) FROM t1) UNION (SELECT MAX(a) FROM t1);
--disable_metadata
DROP TABLE t1;
Result sets differ in metadata for the query
(SELECT MAX(a) FROM t1) UNION (SELECT MAX(a) FROM t1);
The reason for different content of query metadata is that for queries
with union the items being created on JOIN preparing phase is placed into
item_list from SELECT_LEX_UNIT whereas for queries without union item_list
from SELECT_LEX is used instead.
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/mysql_client_test.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/mysql_client_test.result b/mysql-test/r/mysql_client_test.result index 9538475fb86..37a735286da 100644 --- a/mysql-test/r/mysql_client_test.result +++ b/mysql-test/r/mysql_client_test.result @@ -126,6 +126,11 @@ Data: EOF mysql_stmt_next_result(): 0; field_count: 0 # ------------------------------------ +# cat MYSQL_TMP_DIR/test_mdev26145.out.log +# ------------------------------------ +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def MAX(a) MAX(a) 3 11 0 Y 32768 0 63 +# ------------------------------------ SET @@global.general_log= @old_general_log; SET @@global.slow_query_log= @old_slow_query_log; |