The query designer produces wrong output if there is a hyphen in the name of the sql table.
Example:
SELECT
Sample-Alarm."trigger" AS Sample-Alarm_trigger,
Sample-Alarm."ts" AS Sample-Alarm_ts,
Sample-Alarm."rec_rate" AS Sample-Alarm_rec_rate,
Sample-Alarm."equip_id" AS Sample-Alarm_equip_id,
Sample-Alarm."test" AS Sample-Alarm_test
FROM
"pda"."Sample-Alarm" Sample-Alarm
should look like
SELECT
"Sample-Alarm"."trigger" AS "Sample-Alarm_trigger",
"Sample-Alarm"."ts" AS "Sample-Alarm_ts",
"Sample-Alarm"."rec_rate" AS "Sample-Alarm_rec_rate",
"Sample-Alarm"."equip_id" AS "Sample-Alarm_equip_id",
"Sample-Alarm"."test" AS "Sample-Alarm_test"
FROM
"pda"."Sample-Alarm" "Sample-Alarm"
Recommended Comments
There are no comments to display.