PromQL __field__ column has Upper

[Fordisk123]

What type of bug is this?

Incorrect result

What subsystems are affected?

Query Engine

Minimal reproduce step

I get an error when I query this field

What did you expect to see?

this query will

What did you see instead?

Is it a bug or does it need additional escaping?

What operating system did you use?

Centos7

What version of GreptimeDB did you use?

0.9.3

Relevant log output and stack trace

Internal error during building DataFusion plan: No field named ess_meter_negativeacticet. Valid fields are "snStorageEssMeterYcTopic"."ess_meter_negativeacticeT", "snStorageEssMeterYcTopic"."ess_meter_positiveacticeT", "snStorageEssMeterYcTopic".ess_meter_cos, "snStorageEssMeterYcTopic".ess_meter_f, "snStorageEssMeterYcTopic".ess_meter_ia, "snStorageEssMeterYcTopic".ess_meter_ib, "snStorageEssMeterYcTopic".ess_meter_ic, "snStorageEssMeterYcTopic".ess_meter_negativeacticef, "snStorageEssMeterYcTopic".ess_meter_negativeacticeg, "snStorageEssMeterYcTopic".ess_meter_negativeacticej, "snStorageEssMeterYcTopic".ess_meter_negativeacticep, "snStorageEssMeterYcTopic".ess_meter_p, "snStorageEssMeterYcTopic".ess_meter_positiveacticef, "snStorageEssMeterYcTopic".ess_meter_positiveacticeg, "snStorageEssMeterYcTopic".ess_meter_positiveacticej, "snStorageEssMeterYcTopic".ess_meter_positiveacticep, "snStorageEssMeterYcTopic".ess_meter_q, "snStorageEssMeterYcTopic".ess_meter_ua, "snStorageEssMeterYcTopic".ess_meter_ub, "snStorageEssMeterYcTopic".ess_meter_uc, "snStorageEssMeterYcTopic"."jiancedianID", "snStorageEssMeterYcTopic".ts.

[evenyag]

Looks like a bug. Could you also provide the SQL that creates this table?

[killme2008]

Could you try use the single quote? 'ess_meger_xxx'.

[Fordisk123]

Looks like a bug. Could you also provide the SQL that creates this table?

CREATE TABLE IF NOT EXISTS "snStorageEssMeterYcTopic" (
"jiancedianID" STRING NULL,
"ess_meter_negativeacticeT" DOUBLE NULL,
"ess_meter_positiveacticeT" DOUBLE NULL,
"ts" TIMESTAMP(9) NOT NULL,
"ess_meter_cos" DOUBLE NULL,
"ess_meter_f" DOUBLE NULL,
"ess_meter_ia" DOUBLE NULL,
"ess_meter_ib" DOUBLE NULL,
"ess_meter_ic" DOUBLE NULL,
"ess_meter_negativeacticef" DOUBLE NULL,
"ess_meter_negativeacticeg" DOUBLE NULL,
"ess_meter_negativeacticej" DOUBLE NULL,
"ess_meter_negativeacticep" DOUBLE NULL,
"ess_meter_p" DOUBLE NULL,
"ess_meter_positiveacticef" DOUBLE NULL,
"ess_meter_positiveacticeg" DOUBLE NULL,
"ess_meter_positiveacticej" DOUBLE NULL,
"ess_meter_positiveacticep" DOUBLE NULL,
"ess_meter_q" DOUBLE NULL,
"ess_meter_ua" DOUBLE NULL,
"ess_meter_ub" DOUBLE NULL,
"ess_meter_uc" DOUBLE NULL,
TIME INDEX ("ts"),
PRIMARY KEY ("jiancedianID")
)

ENGINE=mito
WITH(
merge_mode = 'last_non_null'
)

[Fordisk123]

Could you try use the single quote? 'ess_meger_xxx'.

[Fordisk123]

Could you try use the single quote? 'ess_meger_xxx'.

{
"code": 3000,
"error": "Internal error during building DataFusion plan: No field named filed. Valid fields are "snStorageEssMeterYcTopic"."ess_meter_negativeacticeT", "snStorageEssMeterYcTopic"."ess_meter_positiveacticeT", "snStorageEssMeterYcTopic".ess_meter_cos, "snStorageEssMeterYcTopic".ess_meter_f, "snStorageEssMeterYcTopic".ess_meter_ia, "snStorageEssMeterYcTopic".ess_meter_ib, "snStorageEssMeterYcTopic".ess_meter_ic, "snStorageEssMeterYcTopic".ess_meter_negativeacticef, "snStorageEssMeterYcTopic".ess_meter_negativeacticeg, "snStorageEssMeterYcTopic".ess_meter_negativeacticej, "snStorageEssMeterYcTopic".ess_meter_negativeacticep, "snStorageEssMeterYcTopic".ess_meter_p, "snStorageEssMeterYcTopic".ess_meter_positiveacticef, "snStorageEssMeterYcTopic".ess_meter_positiveacticeg, "snStorageEssMeterYcTopic".ess_meter_positiveacticej, "snStorageEssMeterYcTopic".ess_meter_positiveacticep, "snStorageEssMeterYcTopic".ess_meter_q, "snStorageEssMeterYcTopic".ess_meter_ua, "snStorageEssMeterYcTopic".ess_meter_ub, "snStorageEssMeterYcTopic".ess_meter_uc, "snStorageEssMeterYcTopic"."jiancedianID", "snStorageEssMeterYcTopic".ts, "snStorageEssMeterYcTopic"."jiancedianID", "snStorageEssMeterYcTopic"."ess_meter_negativeacticeT", "snStorageEssMeterYcTopic"."ess_meter_positiveacticeT", "snStorageEssMeterYcTopic".ts, "snStorageEssMeterYcTopic".ess_meter_cos, "snStorageEssMeterYcTopic".ess_meter_f, "snStorageEssMeterYcTopic".ess_meter_ia, "snStorageEssMeterYcTopic".ess_meter_ib, "snStorageEssMeterYcTopic".ess_meter_ic, "snStorageEssMeterYcTopic".ess_meter_negativeacticef, "snStorageEssMeterYcTopic".ess_meter_negativeacticeg, "snStorageEssMeterYcTopic".ess_meter_negativeacticej, "snStorageEssMeterYcTopic".ess_meter_negativeacticep, "snStorageEssMeterYcTopic".ess_meter_p, "snStorageEssMeterYcTopic".ess_meter_positiveacticef, "snStorageEssMeterYcTopic".ess_meter_positiveacticeg, "snStorageEssMeterYcTopic".ess_meter_positiveacticej, "snStorageEssMeterYcTopic".ess_meter_positiveacticep, "snStorageEssMeterYcTopic".ess_meter_q, "snStorageEssMeterYcTopic".ess_meter_ua, "snStorageEssMeterYcTopic".ess_meter_ub, "snStorageEssMeterYcTopic".ess_meter_uc.",
"execution_time_ms": 2
}