taosdata/TDengine

auto create table insertion failed with : "table does not exist"

Open

#24,142 opened on Dec 20, 2023

View on GitHub
 (1 comment) (0 reactions) (0 assignees)C (5,002 forks)batch import
help wantedquestion

Repository metrics

Stars
 (24,849 stars)
PR merge metrics
 (Avg merge 1d 1h) (4 merged PRs in 30d)

Description

sql语句是：INSERT INTO icp_test.person_error_zb2-07 USING icp_test.person_error TAGS (1,1,1,1) VALUES (1703036825001,1,1,1,1,1,1) 提示报错：### Cause: java.sql.SQLException: TDengine ERROR (0x80002603): Table does not exist ; uncategorized SQLException; SQL state []; error code [-2147473917]; TDengine ERROR (0x80002603): Table does not exist 这是为什么

Contributor guide

Research direction
Inspect the SQL INSERT statement syntax, especially table names with hyphens, and verify that the target table is created before insertion. Check if the table name needs quoting or if the hyphen causes parsing issues.
Tech stack
c
Domain
databasebackend
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Needs investigation
Prerequisites
SQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
65