summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/main/anel_int.result11
-rw-r--r--mysql-test/main/anel_int.test17
-rw-r--r--mysql-test/main/anel_json.result2
3 files changed, 29 insertions, 1 deletions
diff --git a/mysql-test/main/anel_int.result b/mysql-test/main/anel_int.result
new file mode 100644
index 00000000000..b452bbc4625
--- /dev/null
+++ b/mysql-test/main/anel_int.result
@@ -0,0 +1,11 @@
+drop table if exists mysql_json;
+Warnings:
+Note 1051 Unknown table 'test.mysql_json'
+#
+# Mix of INT32 and UINT64
+#
+select * from test.mysql_json;
+t
+{"neg":-1234567890,"pos":9876543210}
+Finshed
+drop table mysql_json;
diff --git a/mysql-test/main/anel_int.test b/mysql-test/main/anel_int.test
new file mode 100644
index 00000000000..370c312844a
--- /dev/null
+++ b/mysql-test/main/anel_int.test
@@ -0,0 +1,17 @@
+let $datadir=`select @@datadir`;
+drop table if exists mysql_json;
+
+--echo #
+--echo # Mix of INT32 and UINT64
+--echo #
+
+
+
+# Make sure you have placed `json.[frm/myd/myi]` files in `source/mysql-test/std_data/`
+--copy_file std_data/simple_ints_table_json_object.frm $datadir/test/mysql_json.frm
+--copy_file std_data/simple_ints_table_json_object.MYI $datadir/test/mysql_json.MYI
+--copy_file std_data/simple_ints_table_json_object.MYD $datadir/test/mysql_json.MYD
+
+# Now can read
+select * from test.mysql_json;
+drop table mysql_json;
diff --git a/mysql-test/main/anel_json.result b/mysql-test/main/anel_json.result
index 3522cff268d..56652e374c1 100644
--- a/mysql-test/main/anel_json.result
+++ b/mysql-test/main/anel_json.result
@@ -26,6 +26,6 @@ drop table mysql_json;
#
select * from test.mysql_json;
t
-{"neg":470417432,"pos":8317990626162245660}
+{"neg":-1234567890,"pos":9876543210}
Finshed
drop table mysql_json;