[MDEV-11932] JSON DATA TYPE (MySql 5.7.8) Created: 2017-01-29 Updated: 2017-01-30 Resolved: 2017-01-30 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data types |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Critical |
| Reporter: | Smail Mustafa | Assignee: | Sergei Golubchik |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | innodb | ||
| Issue Links: |
|
||||||||
| Description |
|
Dear colleagues, my name is Smail and I'm new to this community and I hope you go easy on me. I'm using MySql for 7 years now, even before MariaDb was a thing. We believed Monty and migrated immediately, but since then nothing happened. PostgreSql is way ahead of you these days, I would have migrated again, if our system was small. Recently I was excited about the upcoming features namely "Window Functions" and JSON, but then I was disappointed when I found out that you don't plan to support JSON DATA TYPE (MySql 5.7.8). Dynamic Column != JSON, they don't have anything in common. If I have to create columns, why would I use JSON, I can just create normal tables. engine=Connect -> I strongly recommend dropping that one, It's way too new and doesn't support transactions. We want JSON Data Type support in this version! |
| Comments |
| Comment by Sergei Golubchik [ 2017-01-30 ] |
|
10.2 has JSON functions, but not the JSON data type, because SQL standard specifies that JSON should be stored in normal VARCHARs, there should be no special JSON type. Nevertheless, we have a task for JSON type ( |