Jump to content
  • Query Designer can't handle a hyphen in sql table Names


    Areport
    CategoryBug report
    Component: 9616
    PriorityNormal
    ReproducibilityAlways
    ResolutionOpen
    SeverityMajor
    StatusNew
    Versionv5.2

    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"

     

     

     

     



    User Feedback

    Recommended Comments

    There are no comments to display.


×
×
  • Create New...