mysql / mysql/mysql-server

Support JSON column type in Json Duality

Open
#700 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
C++
Stars
12.4k
Forks
4.4k
Avg merge
8d 16h
Merged PRs (30d)
1

Description

Problem / use case

Json Duality Views currently do not allow projecting MySQL Column of Type 'JSON'.
This feature should support JSON Column type projection in JSON duality views.

Proposed behavior

The feature would specify behavior of Json Duality View with 'JSON' column.

  • Enable DDL to accept JSON column type.
  • Make ETAG calculation considering JSON column.
  • Define and implement behavior of DML operations taking JSON column value as input.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by locating the Json Duality View implementation and its DDL, ETAG, and DML tests; the issue does not name specific files or entry points. Read the existing handling of supported column types, then define completion as accepted JSON columns, JSON-aware ETAG calculation, and documented and tested DML behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
cpp, mysql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.