oceanbase / oceanbase/oceanbase

[Question]: how does oceanbase return datetime format?

Open
#1,746 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

type: question
Dominant language
C++
Stars
10.3k
Forks
1.9k
PR merge metrics
No merged PRs in 30d

Description

If the question is concise and probably has a short answer, asking it in community Slack

Question
how does oceanbase return datetime format? for 0000-00-00 00:00:00,does it return only 1 length bytes array (only 0 lenght field) , or a 12 length bytes array(1 byte length field indicate 11, and 11 byte with 0)?
Environment
linux,I test in two version oceanbase, 3.2.3.1 return 12 length bytes array, 3.2.3.3 return a one byte array

  • OS Version and CPU Arch(uname -a):
    Not sure
  • OB Version(LD_LIBRARY_PATH=../lib:$LD_LIBRARY_PATH ./observer -V):
    Not sure

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 comparing OceanBase versions 3.2.3.1 and 3.2.3.3 using the reported datetime value 0000-00-00 00:00:00. The issue names no source file or test; completion would require identifying the intended byte-array format and documenting or correcting the version discrepancy.

Written by the indexing model from the issue text.

Assessment

Domain
databases
Issue type
Bug
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
10/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.