Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12155

PREPARE fails with ERROR 1064 (42000):

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Not a Bug
    • 10.1.19
    • N/A
    • Prepared Statements
    • None
    • Windows Server 2012 R2 Standard

    Description

      PREPARE vdcignitionselect FROM '
      SELECT  V3ER1_CRAH40_TR,
       V3ER1_UPSB24_LOAD,
       V3ER1_UPSB22_LOAD,
       V3ER1_UPSB23_LOAD,
       V3ER1_UPSB21_LOAD,
       V3ER1_UPSA21_LOAD,
       V3ER1_UPSA22_LOAD,
       V3ER1_UPSA23_LOAD,
       V3ER1_UPSB24_OUTPUT_VOLTS_P1,
       V3ER1_UPSB24_INPUT_VOLTS_P1,
       V3ER1_UPSB24_OUTPUT_VOLTS_P2,
       V3ER1_UPSB24_OUTPUT_VOLTS_P3,
       V3DM2_MT1,
       V3DM2_MT10,
       V3DM2_MT11,
       V3DM2_MT12,
       V3DM2_MT2,
       V3DM2_MT3,
       V3DM2_MT4,
       V3DM2_MT5,
       V3DM2_MT6,
       V3DM2_MT7,
       V3DM2_MT8,
       V3DM2_MT9,
       V3DM2_PDUA4_23_KW,
       V3DM2_PDUA5_24_KW,
       V3DM2_PDUA6_25_KW,
       V3DM2_PDUA7_26_KW,
       V3DM2_PDUB4_30_KW,
       V3DM2_PDUB5_31_KW,
       V3DM2_PDUB6_32_KW,
       V3DM2_PDUB7_33_KW,
       V3DM2_TT1,
       V3DM2_TT10,
       V3DM2_TT11,
       V3DM2_TT12,
       V3DM2_TT2,
       V3DM2_TT3,
       V3DM2_TT4,
       V3DM2_TT5,
       V3DM2_TT6,
       V3DM2_TT7,
       V3DM2_TT8,
       V3DM2_TT9,
       V3DM2_PDUA4_23_AB_VOLTS_INP,
       V3DM2_PDUA4_23_BC_VOLTS_INP,
       V3DM2_PDUA4_23_CA_VOLTS_INP,
       V3DM2_PDUA4_23_AB_VOLTS_OUT,
       V3DM2_PDUA4_23_BC_VOLTS_OUT,
       V3DM2_PDUA4_23_CA_VOLTS_OUT,
       V3DM2_PDUA4_23_AN_VOLTS_OUT,
       V3DM2_PDUA4_23_BN_VOLTS_OUT,
       V3DM2_PDUA4_23_CN_VOLTS_OUT,
       V3DM2_PDUA4_23_A_AMPS_OUT,
       V3DM2_PDUA4_23_B_AMPS_OUT,
       V3DM2_PDUA4_23_C_AMPS_OUT,
       V3DM2_PDUA4_23_KVA_TOTAL,
       V3DM2_PDUA4_23_A_KVA_TOTAL,
       V3DM2_PDUA4_23_B_KVA_TOTAL,
       V3DM2_PDUA4_23_C_KVA_TOTAL,
       V3DM2_PDUA4_23_A_LOAD_PCT,
       V3DM2_PDUA4_23_B_LOAD_PCT,
       V3DM2_PDUA4_23_C_LOAD_PCT,
       V3DM2_PDUA4_23_ALARM,
       V3DM2_PDUA5_24_AB_VOLTS_INP,
       V3DM2_PDUA5_24_AB_VOLTS_OUT,
       V3DM2_PDUA5_24_ALARM,
       V3DM2_PDUA5_24_AN_VOLTS_OUT,
       V3DM2_PDUA5_24_A_AMPS_OUT,
       V3DM2_PDUA5_24_A_KVA_TOTAL,
       V3DM2_PDUA5_24_A_LOAD_PCT,
       V3DM2_PDUA5_24_BC_VOLTS_INP,
       V3DM2_PDUA5_24_BC_VOLTS_OUT,
       V3DM2_PDUA5_24_BN_VOLTS_OUT,
       V3DM2_PDUA5_24_B_AMPS_OUT,
       V3DM2_PDUA5_24_B_KVA_TOTAL,
       V3DM2_PDUA5_24_B_LOAD_PCT,
       V3DM2_PDUA5_24_CA_VOLTS_INP,
       V3DM2_PDUA5_24_CA_VOLTS_OUT,
       V3DM2_PDUA5_24_CN_VOLTS_OUT,
       V3DM2_PDUA5_24_C_AMPS_OUT,
       V3DM2_PDUA5_24_C_KVA_TOTAL,
       V3DM2_PDUA5_24_C_LOAD_PCT,
       V3DM2_PDUA5_24_KVA_TOTAL,
       V3DM2_PDUA6_25_AB_VOLTS_INP,
       V3DM2_PDUA6_25_AB_VOLTS_OUT,
       V3DM2_PDUA6_25_ALARM,
       V3DM2_PDUA6_25_AN_VOLTS_OUT,
       V3DM2_PDUA6_25_A_AMPS_OUT,
       V3DM2_PDUA6_25_A_KVA_TOTAL,
       V3DM2_PDUA6_25_A_LOAD_PCT,
       V3DM2_PDUA6_25_BC_VOLTS_INP,
       V3DM2_PDUA6_25_BC_VOLTS_OUT,
       V3DM2_PDUA6_25_BN_VOLTS_OUT,
       V3DM2_PDUA6_25_B_AMPS_OUT,
       V3DM2_PDUA6_25_B_KVA_TOTAL,
       V3DM2_PDUA6_25_B_LOAD_PCT,
       V3DM2_PDUA6_25_CA_VOLTS_INP,
       V3DM2_PDUA6_25_CA_VOLTS_OUT,
       V3DM2_PDUA6_25_CN_VOLTS_OUT,
       V3DM2_PDUA6_25_C_AMPS_OUT,
       V3DM2_PDUA6_25_C_KVA_TOTAL,
       V3DM2_PDUA6_25_C_LOAD_PCT,
       V3DM2_PDUA6_25_KVA_TOTAL,
       V3DM2_PDUA7_27_AB_VOLTS_INP,
       V3DM2_PDUA7_27_AB_VOLTS_OUT,
       V3DM2_PDUA7_26_ALARM,
       V3DM2_PDUA7_26_AN_VOLTS_OUT,
       V3DM2_PDUA7_26_A_AMPS_OUT,
       V3DM2_PDUA7_26_A_KVA_TOTAL,
       V3DM2_PDUA7_26_A_LOAD_PCT,
       V3DM2_PDUA7_26_BC_VOLTS_INP,
       V3DM2_PDUA7_26_BC_VOLTS_OUT,
       V3DM2_PDUA7_26_BN_VOLTS_OUT,
       V3DM2_PDUA7_26_B_AMPS_OUT,
       V3DM2_PDUA7_26_B_KVA_TOTAL,
       V3DM2_PDUA7_26_B_LOAD_PCT,
       V3DM2_PDUA7_26_CA_VOLTS_INP,
       V3DM2_PDUA7_26_CA_VOLTS_OUT,
       V3DM2_PDUA7_26_CN_VOLTS_OUT,
       V3DM2_PDUA7_26_C_AMPS_OUT,
       V3DM2_PDUA7_26_C_KVA_TOTAL,
       V3DM2_PDUA7_26_C_LOAD_PCT,
       V3DM2_PDUA7_26_KVA_TOTAL,
       V3DM2_PDUA7_26_AB_VOLTS_OUT,
       V3DM2_PDUA7_26_AB_VOLTS_INP,
       V3DM2_PDUB4_30_AB_VOLTS_INP,
       V3DM2_PDUB4_30_BC_VOLTS_INP,
       V3DM2_PDUB4_30_CA_VOLTS_INP,
       V3DM2_PDUB4_30_AB_VOLTS_OUT,
       V3DM2_PDUB4_30_BC_VOLTS_OUT,
       V3DM2_PDUB4_30_CA_VOLTS_OUT,
       V3DM2_PDUB4_30_AN_VOLTS_OUT,
       V3DM2_PDUB4_30_BN_VOLTS_OUT,
       V3DM2_PDUB4_30_CN_VOLTS_OUT,
       V3DM2_PDUB4_30_A_AMPS_OUT,
       V3DM2_PDUB4_30_B_AMPS_OUT,
       V3DM2_PDUB4_30_C_AMPS_OUT,
       V3DM2_PDUB4_30_KVA_TOTAL,
       V3DM2_PDUB4_30_A_KVA_TOTAL,
       V3DM2_PDUB4_30_B_KVA_TOTAL,
       V3DM2_PDUB4_30_C_KVA_TOTAL,
       V3DM2_PDUB4_30_A_LOAD_PCT,
       V3DM2_PDUB4_30_B_LOAD_PCT,
       V3DM2_PDUB4_30_C_LOAD_PCT,
       V3DM2_PDUB4_30_ALARM,
       V3DM2_PDUB5_31_AB_VOLTS_INP,
       V3DM2_PDUB5_31_BC_VOLTS_INP,
       V3DM2_PDUB5_31_CA_VOLTS_INP,
       V3DM2_PDUB5_31_AB_VOLTS_OUT,
       V3DM2_PDUB5_31_BC_VOLTS_OUT,
       V3DM2_PDUB5_31_CA_VOLTS_OUT,
       V3DM2_PDUB5_31_AN_VOLTS_OUT,
       V3DM2_PDUB5_31_BN_VOLTS_OUT,
       V3DM2_PDUB5_31_CN_VOLTS_OUT,
       V3DM2_PDUB5_31_A_AMPS_OUT,
       V3DM2_PDUB5_31_B_AMPS_OUT,
       V3DM2_PDUB5_31_C_AMPS_OUT,
       V3DM2_PDUB5_31_KVA_TOTAL,
       V3DM2_PDUB5_31_A_KVA_TOTAL,
       V3DM2_PDUB5_31_B_KVA_TOTAL,
       V3DM2_PDUB5_31_C_KVA_TOTAL,
       V3DM2_PDUB5_31_A_LOAD_PCT,
       V3DM2_PDUB5_31_B_LOAD_PCT,
       V3DM2_PDUB5_31_C_LOAD_PCT,
       V3DM2_PDUB5_31_ALARM,
       V3DM2_PDUB6_32_AB_VOLTS_INP,
       V3DM2_PDUB6_32_BC_VOLTS_INP,
       V3DM2_PDUB6_32_CA_VOLTS_INP,
       V3DM2_PDUB6_32_AB_VOLTS_OUT,
       V3DM2_PDUB6_32_BC_VOLTS_OUT,
       V3DM2_PDUB6_32_CA_VOLTS_OUT,
       V3DM2_PDUB6_32_AN_VOLTS_OUT,
       V3DM2_PDUB6_32_BN_VOLTS_OUT,
       V3DM2_PDUB6_32_CN_VOLTS_OUT,
       V3DM2_PDUB6_32_A_AMPS_OUT,
       V3DM2_PDUB6_32_B_AMPS_OUT,
       V3DM2_PDUB6_32_C_AMPS_OUT,
       V3DM2_PDUB6_32_KVA_TOTAL,
       V3DM2_PDUB6_32_A_KVA_TOTAL,
       V3DM2_PDUB6_32_B_KVA_TOTAL,
       V3DM2_PDUB6_32_C_KVA_TOTAL,
       V3DM2_PDUB6_32_A_LOAD_PCT,
       V3DM2_PDUB6_32_B_LOAD_PCT,
       V3DM2_PDUB6_32_C_LOAD_PCT,
       V3DM2_PDUB6_32_ALARM,
       V3DM2_PDUB7_33_AB_VOLTS_INP,
       V3DM2_PDUB7_33_BC_VOLTS_INP,
       V3DM2_PDUB7_33_CA_VOLTS_INP,
       V3DM2_PDUB7_33_AB_VOLTS_OUT,
       V3DM2_PDUB7_33_BC_VOLTS_OUT,
       V3DM2_PDUB7_33_CA_VOLTS_OUT,
       V3DM2_PDUB7_33_AN_VOLTS_OUT,
       V3DM2_PDUB7_33_BN_VOLTS_OUT,
       V3DM2_PDUB7_33_CN_VOLTS_OUT,
       V3DM2_PDUB7_33_A_AMPS_OUT,
       V3DM2_PDUB7_33_B_AMPS_OUT,
       V3DM2_PDUB7_33_C_AMPS_OUT,
       V3DM2_PDUB7_33_KVA_TOTAL,
       V3DM2_PDUB7_33_A_KVA_TOTAL,
       V3DM2_PDUB7_33_B_KVA_TOTAL,
       V3DM2_PDUB7_33_C_KVA_TOTAL,
       V3DM2_PDUB7_33_A_LOAD_PCT,
       V3DM2_PDUB7_33_B_LOAD_PCT,
       V3DM2_PDUB7_33_C_LOAD_PCT,
       V3DM2_PDUB7_33_ALARM,
       V3DM1_MT1,
       V3DM2_PDUA3_22_KW,
       V3DM2_PDUA3_22_AB_VOLTS_INP,
       V3DM2_PDUA3_22_BC_VOLTS_INP,
       V3DM2_PDUA3_22_CA_VOLTS_INP,
       V3DM2_PDUA3_22_AB_VOLTS_OUT,
       V3DM2_PDUA3_22_BC_VOLTS_OUT,
       V3DM2_PDUA3_22_CA_VOLTS_OUT,
       V3DM2_PDUA3_22_AN_VOLTS_OUT,
       V3DM2_PDUA3_22_BN_VOLTS_OUT,
       V3DM2_PDUA3_22_CN_VOLTS_OUT,
       V3DM2_PDUA3_22_A_AMPS_OUT,
       V3DM2_PDUA3_22_B_AMPS_OUT,
       V3DM2_PDUA3_22_C_AMPS_OUT,
       V3DM2_PDUA3_22_KVA_TOTAL,
       V3DM2_PDUA3_22_A_KVA_TOTAL,
       V3DM2_PDUA3_22_B_KVA_TOTAL,
       V3DM2_PDUA3_22_C_KVA_TOTAL,
       V3DM2_PDUA3_22_A_LOAD_PCT,
       V3DM2_PDUA3_22_B_LOAD_PCT,
       V3DM2_PDUA3_22_C_LOAD_PCT,
       V3DM2_PDUA3_22_ALARM,
       V3DM2_PDUA2_21_AB_VOLTS_INP,
       V3DM2_PDUA2_21_AB_VOLTS_OUT,
       V3DM2_PDUA2_21_ALARM,
       V3DM2_PDUA2_21_AN_VOLTS_OUT,
       V3DM2_PDUA2_21_A_AMPS_OUT,
       V3DM2_PDUA2_21_A_KVA_TOTAL,
       V3DM2_PDUA2_21_A_LOAD_PCT,
       V3DM2_PDUA2_21_BC_VOLTS_INP,
       V3DM2_PDUA2_21_BC_VOLTS_OUT,
       V3DM2_PDUA2_21_BN_VOLTS_OUT,
       V3DM2_PDUA2_21_B_AMPS_OUT,
       V3DM2_PDUA2_21_B_KVA_TOTAL,
       V3DM2_PDUA2_21_B_LOAD_PCT,
       V3DM2_PDUA2_21_CA_VOLTS_INP,
       V3DM2_PDUA2_21_CA_VOLTS_OUT,
       V3DM2_PDUA2_21_CN_VOLTS_OUT,
       V3DM2_PDUA2_21_C_AMPS_OUT,
       V3DM2_PDUA2_21_C_KVA_TOTAL,
       V3DM2_PDUA2_21_C_LOAD_PCT,
       V3DM2_PDUA2_21_KVA_TOTAL,
       V3DM2_PDUA2_21_KW,
       V3DM2_PDUA1_40_AB_VOLTS_INP,
       V3DM2_PDUA1_40_AB_VOLTS_OUT,
       V3DM2_PDUA1_40_ALARM,
       V3DM2_PDUA1_40_AN_VOLTS_OUT,
       V3DM2_PDUA1_40_A_AMPS_OUT,
       V3DM2_PDUA1_40_A_KVA_TOTAL,
       V3DM2_PDUA1_40_A_LOAD_PCT,
       V3DM2_PDUA1_40_BC_VOLTS_INP,
       V3DM2_PDUA1_40_BC_VOLTS_OUT,
       V3DM2_PDUA1_40_BN_VOLTS_OUT,
       V3DM2_PDUA1_40_B_AMPS_OUT,
       V3DM2_PDUA1_40_B_KVA_TOTAL,
       V3DM2_PDUA1_40_B_LOAD_PCT,
       V3DM2_PDUA1_40_CA_VOLTS_INP,
       V3DM2_PDUA1_40_CA_VOLTS_OUT,
       V3DM2_PDUA1_40_CN_VOLTS_OUT,
       V3DM2_PDUA1_40_C_AMPS_OUT,
       V3DM2_PDUA1_40_C_KVA_TOTAL,
       V3DM2_PDUA1_40_C_LOAD_PCT,
       V3DM2_PDUA1_40_KVA_TOTAL,
       V3DM2_PDUA1_40_KW,
       V3DM2_PDUB1_39_AB_VOLTS_INP,
       V3DM2_PDUB1_39_AB_VOLTS_OUT,
       V3DM2_PDUB1_39_ALARM,
       V3DM2_PDUB1_39_AN_VOLTS_OUT,
       V3DM2_PDUB1_39_A_AMPS_OUT,
       V3DM2_PDUB1_39_A_KVA_TOTAL,
       V3DM2_PDUB1_39_A_LOAD_PCT,
       V3DM2_PDUB1_39_BC_VOLTS_INP,
       V3DM2_PDUB1_39_BC_VOLTS_OUT,
       V3DM2_PDUB1_39_BN_VOLTS_OUT,
       V3DM2_PDUB1_39_B_AMPS_OUT,
       V3DM2_PDUB1_39_B_KVA_TOTAL,
       V3DM2_PDUB1_39_B_LOAD_PCT,
       V3DM2_PDUB1_39_CA_VOLTS_INP,
       V3DM2_PDUB1_39_CA_VOLTS_OUT,
       V3DM2_PDUB1_39_CN_VOLTS_OUT,
       V3DM2_PDUB1_39_C_AMPS_OUT,
       V3DM2_PDUB1_39_C_KVA_TOTAL,
       V3DM2_PDUB1_39_C_LOAD_PCT,
       V3DM2_PDUB1_39_KVA_TOTAL,
       V3DM2_PDUB1_39_KW,
       V3DM2_PDUB2_38_AB_VOLTS_INP,
       V3DM2_PDUB2_38_AB_VOLTS_OUT,
       V3DM2_PDUB2_38_ALARM,
       V3DM2_PDUB2_38_AN_VOLTS_OUT,
       V3DM2_PDUB2_38_A_AMPS_OUT,
       V3DM2_PDUB2_38_A_KVA_TOTAL,
       V3DM2_PDUB2_38_A_LOAD_PCT,
       V3DM2_PDUB2_38_BC_VOLTS_INP,
       V3DM2_PDUB2_38_BC_VOLTS_OUT,
       V3DM2_PDUB2_38_BN_VOLTS_OUT,
       V3DM2_PDUB2_38_B_AMPS_OUT,
       V3DM2_PDUB2_38_B_KVA_TOTAL,
       V3DM2_PDUB2_38_B_LOAD_PCT,
       V3DM2_PDUB2_38_CA_VOLTS_INP,
       V3DM2_PDUB2_38_CA_VOLTS_OUT,
       V3DM2_PDUB2_38_CN_VOLTS_OUT,
       V3DM2_PDUB2_38_C_AMPS_OUT,
       V3DM2_PDUB2_38_C_KVA_TOTAL,
       V3DM2_PDUB2_38_C_LOAD_PCT,
       V3DM2_PDUB2_38_KVA_TOTAL,
       V3DM2_PDUB2_38_KW,
       V3DM2_PDUB3_37_AB_VOLTS_INP,
       V3DM2_PDUB3_37_AB_VOLTS_OUT,
       V3DM2_PDUB3_37_ALARM,
       V3DM2_PDUB3_37_AN_VOLTS_OUT,
       V3DM2_PDUB3_37_A_AMPS_OUT,
       V3DM2_PDUB3_37_A_KVA_TOTAL,
       V3DM2_PDUB3_37_A_LOAD_PCT,
       V3DM2_PDUB3_37_BC_VOLTS_INP,
       V3DM2_PDUB3_37_BC_VOLTS_OUT,
       V3DM2_PDUB3_37_BN_VOLTS_OUT,
       V3DM2_PDUB3_37_B_AMPS_OUT,
       V3DM2_PDUB3_37_B_KVA_TOTAL,
       V3DM2_PDUB3_37_B_LOAD_PCT,
       V3DM2_PDUB3_37_CA_VOLTS_INP,
       V3DM2_PDUB3_37_CA_VOLTS_OUT,
       V3DM2_PDUB3_37_CN_VOLTS_OUT,
       V3DM2_PDUB3_37_C_AMPS_OUT,
       V3DM2_PDUB3_37_C_KVA_TOTAL,
       V3DM2_PDUB3_37_C_LOAD_PCT,
       V3DM2_PDUB3_37_KVA_TOTAL,
       V3DM2_PDUB3_37_KW,
       V3DM2_PDUB8_32_AB_VOLTS_INP,
       V3DM2_PDUB8_32_AB_VOLTS_OUT,
       V3DM2_PDUB8_32_ALARM,
       V3DM2_PDUB8_32_AN_VOLTS_OUT,
       V3DM2_PDUB8_32_A_AMPS_OUT,
       V3DM2_PDUB8_32_A_KVA_TOTAL,
       V3DM2_PDUB8_32_A_LOAD_PCT,
       V3DM2_PDUB8_32_BC_VOLTS_INP,
       V3DM2_PDUB8_32_BC_VOLTS_OUT,
       V3DM2_PDUB8_32_BN_VOLTS_OUT,
       V3DM2_PDUB8_32_B_AMPS_OUT,
       V3DM2_PDUB8_32_B_KVA_TOTAL,
       V3DM2_PDUB8_32_B_LOAD_PCT,
       V3DM2_PDUB8_32_CA_VOLTS_INP,
       V3DM2_PDUB8_32_CA_VOLTS_OUT,
       V3DM2_PDUB8_32_CN_VOLTS_OUT,
       V3DM2_PDUB8_32_C_AMPS_OUT,
       V3DM2_PDUB8_32_C_KVA_TOTAL,
       V3DM2_PDUB8_32_C_LOAD_PCT,
       V3DM2_PDUB8_32_KVA_TOTAL,
       V3DM2_PDUB8_32_KW,
       V3DM2_PDUB9_31_AB_VOLTS_INP,
       V3DM2_PDUA10_29_AB_VOLTS_OUT,
       V3DM2_PDUB9_31_ALARM,
       V3DM2_PDUB9_31_AN_VOLTS_OUT,
       V3DM2_PDUB9_31_A_AMPS_OUT,
       V3DM2_PDUB9_31_A_KVA_TOTAL,
       V3DM2_PDUB9_31_A_LOAD_PCT,
       V3DM2_PDUB9_31_BC_VOLTS_INP,
       V3DM2_PDUB9_31_BC_VOLTS_OUT,
       V3DM2_PDUB9_31_BN_VOLTS_OUT,
       V3DM2_PDUB9_31_B_AMPS_OUT,
       V3DM2_PDUB9_31_B_KVA_TOTAL,
       V3DM2_PDUB9_31_B_LOAD_PCT,
       V3DM2_PDUB9_31_CA_VOLTS_INP,
       V3DM2_PDUB9_31_CA_VOLTS_OUT,
       V3DM2_PDUB9_31_CN_VOLTS_OUT,
       V3DM2_PDUB9_31_C_AMPS_OUT,
       V3DM2_PDUB9_31_C_KVA_TOTAL,
       V3DM2_PDUB9_31_C_LOAD_PCT,
       V3DM2_PDUB9_31_KVA_TOTAL,
       V3DM2_PDUB9_31_KW,
       V3DM2_PDUB10_30_AB_VOLTS_INP,
       V3DM2_PDUB9_31_AB_VOLTS_OUT,
       V3DM2_PDUB10_30_ALARM,
       V3DM2_PDUB10_30_AN_VOLTS_OUT,
       V3DM2_PDUB10_30_A_AMPS_OUT,
       V3DM2_PDUB10_30_A_KVA_TOTAL,
       V3DM2_PDUB10_30_A_LOAD_PCT,
       V3DM2_PDUB10_30_BC_VOLTS_INP,
       V3DM2_PDUB10_30_BC_VOLTS_OUT,
       V3DM2_PDUB10_30_BN_VOLTS_OUT,
       V3DM2_PDUB10_30_B_AMPS_OUT,
       V3DM2_PDUB10_30_B_KVA_TOTAL,
       V3DM2_PDUB10_30_B_LOAD_PCT,
       V3DM2_PDUB10_30_CA_VOLTS_INP,
       V3DM2_PDUB10_30_CA_VOLTS_OUT,
       V3DM2_PDUB10_30_CN_VOLTS_OUT,
       V3DM2_PDUB10_30_C_AMPS_OUT,
       V3DM2_PDUB10_30_C_KVA_TOTAL,
       V3DM2_PDUB10_30_C_LOAD_PCT,
       V3DM2_PDUB10_30_KVA_TOTAL,
       V3DM2_PDUB10_30_KW,
       V3DM2_PDUA10_29_AB_VOLTS_INP,
       V3DM2_PDUB10_30_AB_VOLTS_OUT,
       V3DM2_PDUA10_29_ALARM,
       V3DM2_PDUA10_29_AN_VOLTS_OUT,
       V3DM2_PDUA10_29_A_AMPS_OUT,
       V3DM2_PDUA10_29_A_KVA_TOTAL,
       V3DM2_PDUA10_29_A_LOAD_PCT,
       V3DM2_PDUA10_29_BC_VOLTS_INP,
       V3DM2_PDUA10_29_BC_VOLTS_OUT,
       V3DM2_PDUA10_29_BN_VOLTS_OUT,
       V3DM2_PDUA10_29_B_AMPS_OUT,
       V3DM2_PDUA10_29_B_KVA_TOTAL,
       V3DM2_PDUA10_29_B_LOAD_PCT,
       V3DM2_PDUA10_29_CA_VOLTS_INP,
       V3DM2_PDUA10_29_CA_VOLTS_OUT,
       V3DM2_PDUA10_29_CN_VOLTS_OUT,
       V3DM2_PDUA10_29_C_AMPS_OUT,
       V3DM2_PDUA10_29_C_KVA_TOTAL,
       V3DM2_PDUA10_29_C_LOAD_PCT,
       V3DM2_PDUA10_29_KVA_TOTAL,
       V3DM2_PDUA10_29_KW,
       V3DM2_PDUA9_28_AB_VOLTS_INP,
       V3DM2_PDUA9_28_AB_VOLTS_OUT,
       V3DM2_PDUA9_28_ALARM,
       V3DM2_PDUA9_28_AN_VOLTS_OUT,
       V3DM2_PDUA9_28_A_AMPS_OUT,
       V3DM2_PDUA9_28_A_KVA_TOTAL,
       V3DM2_PDUA9_28_A_LOAD_PCT,
       V3DM2_PDUA9_28_BC_VOLTS_INP,
       V3DM2_PDUA9_28_BC_VOLTS_OUT,
       V3DM2_PDUA9_28_BN_VOLTS_OUT,
       V3DM2_PDUA9_28_B_AMPS_OUT,
       V3DM2_PDUA9_28_B_KVA_TOTAL,
       V3DM2_PDUA9_28_B_LOAD_PCT,
       V3DM2_PDUA9_28_CA_VOLTS_INP,
       V3DM2_PDUA9_28_CA_VOLTS_OUT,
       V3DM2_PDUA9_28_CN_VOLTS_OUT,
       V3DM2_PDUA9_28_C_AMPS_OUT,
       V3DM2_PDUA9_28_C_KVA_TOTAL,
       V3DM2_PDUA9_28_C_LOAD_PCT,
       V3DM2_PDUA9_28_KVA_TOTAL,
       V3DM2_PDUA9_28_KW,
       V3DM2_PDUA8_27_AB_VOLTS_INP,
       V3DM2_PDUA8_27_AB_VOLTS_OUT,
       V3DM2_PDUA8_27_ALARM,
       V3DM2_PDUA8_27_AN_VOLTS_OUT,
       V3DM2_PDUA8_27_A_AMPS_OUT,
       V3DM2_PDUA8_27_A_KVA_TOTAL,
       V3DM2_PDUA8_27_A_LOAD_PCT,
       V3DM2_PDUA8_27_BC_VOLTS_INP,
       V3DM2_PDUA8_27_BC_VOLTS_OUT,
       V3DM2_PDUA8_27_BN_VOLTS_OUT,
       V3DM2_PDUA8_27_B_AMPS_OUT,
       V3DM2_PDUA8_27_B_KVA_TOTAL,
       V3DM2_PDUA8_27_B_LOAD_PCT,
       V3DM2_PDUA8_27_CA_VOLTS_INP,
       V3DM2_PDUA8_27_CA_VOLTS_OUT,
       V3DM2_PDUA8_27_CN_VOLTS_OUT,
       V3DM2_PDUA8_27_C_AMPS_OUT,
       V3DM2_PDUA8_27_C_KVA_TOTAL,
       V3DM2_PDUA8_27_C_LOAD_PCT,
       V3DM2_PDUA8_27_KVA_TOTAL,
       V3DM2_PDUA8_27_KW,
       V3DM2_CRAH_19_ALARM,
       V3DM2_CRAH_19_FREE_COOLING_%,
       V3DM2_CRAH_19_FAN_SPEED,
       V3DM2_CRAH_19_TEMP_DEADBAND_SP,
       V3DM2_CRAH_19_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_19_TEMP_PROP_BAND,
       V3DM2_CRAH_19_TEMP_RTN_AIR,
       V3DM2_CRAH_19_TEMP_SPLY_AIR,
       V3DM2_CRAH_19_TEMP_SP,
       V3DM2_CRAH_20_ALARM,
       V3DM2_CRAH_20_FAN_SPEED,
       V3DM2_CRAH_20_FREE_COOLING_%,
       V3DM2_CRAH_20_TEMP_DEADBAND_SP,
       V3DM2_CRAH_20_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_20_TEMP_PROP_BAND,
       V3DM2_CRAH_20_TEMP_RTN_AIR,
       V3DM2_CRAH_20_TEMP_SP,
       V3DM2_CRAH_20_TEMP_SPLY_AIR,
       V3DM2_CRAH_21_ALARM,
       V3DM2_CRAH_21_FAN_SPEED,
       V3DM2_CRAH_21_FREE_COOLING_%,
       V3DM2_CRAH_21_TEMP_DEADBAND_SP,
       V3DM2_CRAH_21_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_21_TEMP_PROP_BAND,
       V3DM2_CRAH_21_TEMP_RTN_AIR,
       V3DM2_CRAH_21_TEMP_SP,
       V3DM2_CRAH_21_TEMP_SPLY_AIR,
       V3DM2_CRAH_22_ALARM,
       V3DM2_CRAH_22_FAN_SPEED,
       V3DM2_CRAH_22_FREE_COOLING_%,
       V3DM2_CRAH_22_TEMP_DEADBAND_SP,
       V3DM2_CRAH_22_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_22_TEMP_PROP_BAND,
       V3DM2_CRAH_22_TEMP_RTN_AIR,
       V3DM2_CRAH_22_TEMP_SP,
       V3DM2_CRAH_22_TEMP_SPLY_AIR,
       V3DM2_CRAH_23_ALARM,
       V3DM2_CRAH_23_FAN_SPEED,
       V3DM2_CRAH_23_FREE_COOLING_%,
       V3DM2_CRAH_23_TEMP_DEADBAND_SP,
       V3DM2_CRAH_23_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_23_TEMP_PROP_BAND,
       V3DM2_CRAH_23_TEMP_RTN_AIR,
       V3DM2_CRAH_23_TEMP_SP,
       V3DM2_CRAH_23_TEMP_SPLY_AIR,
       V3DM2_CRAH_24_ALARM,
       V3DM2_CRAH_24_FAN_SPEED,
       V3DM2_CRAH_24_FREE_COOLING_%,
       V3DM2_CRAH_24_TEMP_DEADBAND_SP,
       V3DM2_CRAH_24_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_24_TEMP_PROP_BAND,
       V3DM2_CRAH_24_TEMP_RTN_AIR,
       V3DM2_CRAH_24_TEMP_SP,
       V3DM2_CRAH_24_TEMP_SPLY_AIR,
       V3DM2_CRAH_25_ALARM,
       V3DM2_CRAH_25_FAN_SPEED,
       V3DM2_CRAH_25_FREE_COOLING_%,
       V3DM2_CRAH_25_TEMP_DEADBAND_SP,
       V3DM2_CRAH_25_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_25_TEMP_PROP_BAND,
       V3DM2_CRAH_25_TEMP_RTN_AIR,
       V3DM2_CRAH_25_TEMP_SP,
       V3DM2_CRAH_25_TEMP_SPLY_AIR,
       V3DM2_CRAH_26_ALARM,
       V3DM2_CRAH_26_FAN_SPEED,
       V3DM2_CRAH_26_FREE_COOLING_%,
       V3DM2_CRAH_26_TEMP_DEADBAND_SP,
       V3DM2_CRAH_26_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_26_TEMP_PROP_BAND,
       V3DM2_CRAH_26_TEMP_RTN_AIR,
       V3DM2_CRAH_26_TEMP_SP,
       V3DM2_CRAH_26_TEMP_SPLY_AIR,
       V3DM2_CRAH_27_ALARM,
       V3DM2_CRAH_27_FAN_SPEED,
       V3DM2_CRAH_27_FREE_COOLING_%,
       V3DM2_CRAH_27_TEMP_DEADBAND_SP,
       V3DM2_CRAH_27_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_27_TEMP_PROP_BAND,
       V3DM2_CRAH_27_TEMP_RTN_AIR,
       V3DM2_CRAH_27_TEMP_SP,
       V3DM2_CRAH_27_TEMP_SPLY_AIR,
       V3DM2_CRAH_28_ALARM,
       V3DM2_CRAH_28_FAN_SPEED,
       V3DM2_CRAH_28_FREE_COOLING_%,
       V3DM2_CRAH_28_TEMP_DEADBAND_SP,
       V3DM2_CRAH_28_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_28_TEMP_PROP_BAND,
       V3DM2_CRAH_28_TEMP_RTN_AIR,
       V3DM2_CRAH_28_TEMP_SP,
       V3DM2_CRAH_28_TEMP_SPLY_AIR,
       V3DM2_CRAH_29_ALARM,
       V3DM2_CRAH_29_FAN_SPEED,
       V3DM2_CRAH_29_FREE_COOLING_%,
       V3DM2_CRAH_29_TEMP_DEADBAND_SP,
       V3DM2_CRAH_29_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_29_TEMP_PROP_BAND,
       V3DM2_CRAH_29_TEMP_RTN_AIR,
       V3DM2_CRAH_29_TEMP_SP,
       V3DM2_CRAH_29_TEMP_SPLY_AIR,
       V3DM2_CRAH_30_ALARM,
       V3DM2_CRAH_30_FAN_SPEED,
       V3DM2_CRAH_30_FREE_COOLING_%,
       V3DM2_CRAH_30_TEMP_DEADBAND_SP,
       V3DM2_CRAH_30_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_30_TEMP_PROP_BAND,
       V3DM2_CRAH_30_TEMP_RTN_AIR,
       V3DM2_CRAH_30_TEMP_SP,
       V3DM2_CRAH_30_TEMP_SPLY_AIR,
       V3DM2_CRAH_31_ALARM,
       V3DM2_CRAH_31_FAN_SPEED,
       V3DM2_CRAH_31_FREE_COOLING_%,
       V3DM2_CRAH_31_TEMP_DEADBAND_SP,
       V3DM2_CRAH_31_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_31_TEMP_PROP_BAND,
       V3DM2_CRAH_31_TEMP_RTN_AIR,
       V3DM2_CRAH_31_TEMP_SP,
       V3DM2_CRAH_31_TEMP_SPLY_AIR,
       V3DM2_CRAH_32_ALARM,
       V3DM2_CRAH_32_FAN_SPEED,
       V3DM2_CRAH_32_FREE_COOLING_%,
       V3DM2_CRAH_32_TEMP_DEADBAND_SP,
       V3DM2_CRAH_32_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_32_TEMP_PROP_BAND,
       V3DM2_CRAH_32_TEMP_RTN_AIR,
       V3DM2_CRAH_32_TEMP_SP,
       V3DM2_CRAH_32_TEMP_SPLY_AIR,
       V3DM2_CRAH_33_ALARM,
       V3DM2_CRAH_33_FAN_SPEED,
       V3DM2_CRAH_33_FREE_COOLING_%,
       V3DM2_CRAH_33_TEMP_DEADBAND_SP,
       V3DM2_CRAH_33_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_33_TEMP_PROP_BAND,
       V3DM2_CRAH_33_TEMP_RTN_AIR,
       V3DM2_CRAH_33_TEMP_SP,
       V3DM2_CRAH_33_TEMP_SPLY_AIR,
       V3DM2_CRAH_34_ALARM,
       V3DM2_CRAH_34_FAN_SPEED,
       V3DM2_CRAH_34_FREE_COOLING_%,
       V3DM2_CRAH_34_TEMP_DEADBAND_SP,
       V3DM2_CRAH_34_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_34_TEMP_PROP_BAND,
       V3DM2_CRAH_34_TEMP_RTN_AIR,
       V3DM2_CRAH_34_TEMP_SP,
       V3DM2_CRAH_34_TEMP_SPLY_AIR,
       V3DM2_CRAH_35_ALARM,
       V3DM2_CRAH_35_FAN_SPEED,
       V3DM2_CRAH_35_FREE_COOLING_%,
       V3DM2_CRAH_35_TEMP_DEADBAND_SP,
       V3DM2_CRAH_35_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_35_TEMP_PROP_BAND,
       V3DM2_CRAH_35_TEMP_RTN_AIR,
       V3DM2_CRAH_35_TEMP_SP,
       V3DM2_CRAH_35_TEMP_SPLY_AIR,
       V3DM2_CRAH_36_ALARM,
       V3DM2_CRAH_36_FAN_SPEED,
       V3DM2_CRAH_36_FREE_COOLING_%,
       V3DM2_CRAH_36_TEMP_DEADBAND_SP,
       V3DM2_CRAH_36_TEMP_INTEGRATION_TIME,
       V3DM2_CRAH_36_TEMP_PROP_BAND,
       V3DM2_CRAH_36_TEMP_RTN_AIR,
       V3DM2_CRAH_36_TEMP_SP,
       V3DM2_CRAH_36_TEMP_SPLY_AIR,
       t_stamp 
       FROM v1_ignition.v3dm2_collector where t_stamp > now() - interval 3 minute;
      '
      ;
      

      the following error is displayed

          -> ;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near
       '
       V3DM2_CRAH_19_FAN_SPEED,
       V3DM2_CRAH_19_TEMP_DEADBAND_SP,
       V3DM2_CRAH_19_TEMP_' at line 461
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            Marappa Ganesan
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.