summaryrefslogtreecommitdiff
path: root/mysql-test/suite/json
diff options
context:
space:
mode:
authorOleksandr Byelkin <sanja@mariadb.com>2022-10-17 12:39:25 +0200
committerOleksandr Byelkin <sanja@mariadb.com>2022-10-17 12:39:25 +0200
commitd86ad1f127fdc71e888e2e168b99f561f111a0b2 (patch)
treedf05decbc411609ddb875c371cf2549b0a4aaa26 /mysql-test/suite/json
parent069552a41d27b44016f54225af1c172b7df4e8bb (diff)
parentf3fddc1b4a3d05167303a87b04be985b17096a46 (diff)
downloadmariadb-git-d86ad1f127fdc71e888e2e168b99f561f111a0b2.tar.gz
Merge branch '10.8' into 10.9
Diffstat (limited to 'mysql-test/suite/json')
-rw-r--r--mysql-test/suite/json/r/json_table.result6
-rw-r--r--mysql-test/suite/json/t/json_table.test8
2 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/suite/json/r/json_table.result b/mysql-test/suite/json/r/json_table.result
index 1bfcb4ca23a..44957352865 100644
--- a/mysql-test/suite/json/r/json_table.result
+++ b/mysql-test/suite/json/r/json_table.result
@@ -1009,6 +1009,12 @@ name VARCHAR(10) CHARACTER SET latin1 COLLATE DEFAULT PATH '$.name'
name
Jeans
#
+# MDEV-28480: Assertion `0' failed in Item_row::illegal_method_call
+# on SELECT FROM JSON_TABLE
+#
+SELECT 1 FROM JSON_TABLE (row(1,2), '$' COLUMNS (o FOR ORDINALITY)) AS j;
+ERROR 21000: Operand should contain 1 column(s)
+#
# End of 10.6 tests
#
#
diff --git a/mysql-test/suite/json/t/json_table.test b/mysql-test/suite/json/t/json_table.test
index 18ea0b9f166..05db8f66a59 100644
--- a/mysql-test/suite/json/t/json_table.test
+++ b/mysql-test/suite/json/t/json_table.test
@@ -864,6 +864,14 @@ SELECT * FROM json_table('[{"name":"Jeans"}]', '$[*]'
--echo #
+--echo # MDEV-28480: Assertion `0' failed in Item_row::illegal_method_call
+--echo # on SELECT FROM JSON_TABLE
+--echo #
+
+--error ER_OPERAND_COLUMNS
+SELECT 1 FROM JSON_TABLE (row(1,2), '$' COLUMNS (o FOR ORDINALITY)) AS j;
+
+--echo #
--echo # End of 10.6 tests
--echo #