[libgda/LIBGDA_5.2] MySQL: initial support for JSON type



commit eb733c24973d803793828a5fc69baec02b1ab284
Author: Daniel Espinosa <esodan gmail com>
Date:   Mon Oct 14 12:26:39 2019 -0500

    MySQL: initial support for JSON type

 providers/reuseable/mysql/gda-mysql-reuseable.c | 3 +++
 tests/providers/TYPES_SCHEMA_MySQL.xml          | 7 +++++++
 2 files changed, 10 insertions(+)
---
diff --git a/providers/reuseable/mysql/gda-mysql-reuseable.c b/providers/reuseable/mysql/gda-mysql-reuseable.c
index a5a1e82c2..fef7f115e 100644
--- a/providers/reuseable/mysql/gda-mysql-reuseable.c
+++ b/providers/reuseable/mysql/gda-mysql-reuseable.c
@@ -256,6 +256,9 @@ mysql_name_to_g_type (const gchar *name, const gchar *conv_func_name)
                return GDA_TYPE_BLOB;
        else if (!strcmp (name, "bytea"))
                return GDA_TYPE_BINARY;
+       else if (!strcmp (name, "json"))
+               return G_TYPE_STRING;
+
 
        /* other data types, using the conversion function name as a hint */
        if (!conv_func_name)
diff --git a/tests/providers/TYPES_SCHEMA_MySQL.xml b/tests/providers/TYPES_SCHEMA_MySQL.xml
index 1f0b3a745..c3dd6d54e 100644
--- a/tests/providers/TYPES_SCHEMA_MySQL.xml
+++ b/tests/providers/TYPES_SCHEMA_MySQL.xml
@@ -195,6 +195,13 @@
       <gda_value>139894960</gda_value>
       <gda_value isnull="t"/>
     </gda_array_row>
+    <gda_array_row>
+      <gda_value>json</gda_value>
+      <gda_value/>
+      <gda_value>JSON data type defined at RFC 7159</gda_value>
+      <gda_value>139894960</gda_value>
+      <gda_value isnull="t"/>
+    </gda_array_row>
     <gda_array_row>
       <gda_value>tinyint</gda_value>
       <gda_value/>


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]