4paradigm / 4paradigm/OpenMLDB

Ensuring consistency in support for the Timestamp data type format in different statements.

Offen
#3,875 1 Kommentar 0 Reaktionen 0 zugewiesene Personen Auf GitHub ansehen
enhancement sql
Vorherrschende Sprache
C++
Sterne
1.7k
Forks
331
Ø Merge
12 T. 12 Std.
Gemergte PRs (30 T.)
1

Beschreibung

**Describe the feature you'd like**

Currently, there is inconsistency in the support for the Timestamp data type format across statements such as insert, select, and load data infile. Furthermore, the documentation lacks comprehensive descriptions in this regard.
Some test cases and examples: https://qiok3h8ob4.feishu.cn/docx/P1LBdzVIeoPSuHxUUBBcgGq9n7c?from=from_copylink

**Desired Improvements**

1. Support for String Format Timestamps
Implement support for Timestamps in string format, including parsing, validation, and support for millisecond-level precision. The expected format is: yyyy-MM-dd HH:mm:ss.SS.

2. Support for int64 Format Timestamps
Extend support to include Timestamps in int64 format.

3. Conversion Support with timestamp Function
Allow conversion between string/int64 format Timestamps using the timestamp function.

4. Consistent Behavior for Timestamp Columns with Indexes
Ensure uniform behavior when dealing with Timestamp columns that have indexes.

By implementing these improvements, we aim to enhance consistency and usability across various statements and operations involving Timestamp data types.

Beitragsleitfaden

Beitragsleitfaden öffnen

Rechercherichtung

The issue describes inconsistencies in timestamp format support across insert, select, and load data infile statements. Start by examining the SQL parser and execution engine code for timestamp handling. Look for existing timestamp parsing and validation logic. The linked test cases document provides specific examples to understand the current behavior and desired improvements.

Vom Indexierungsmodell aus dem Issue-Text verfasst.

Bewertung

Tech-Stack
sql
Bereich
backend, databases, machine-learning
Issue-Typ
Feature
Schwierigkeit
5/5
Geschätzter Aufwand
Über eine Woche
Aktivitätsstatus
Veraltet
Klarheit
Größtenteils klar
Anfängerfreundlichkeit
25/100

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.