Menu

#479 NULL Bigint function param problem with postgres

8.0-Beta
closed
None
Bug Report
2021-02-27
2021-01-20
No

This is a cross post from the forums: https://zeoslib.sourceforge.io/viewtopic.php?f=50&t=131989

Just updated 7.3/8.0 from SVN, has problem with bigint parameters when it's NULL
Postgres reports error: invalid input syntax for type bigint ""

Discussion

  • Alexey Nalimov

    Alexey Nalimov - 2021-01-22

    Complier is Delphi 10.1 Berlin update 2
    Postgres - got same problems with 12.5 and 11.1

     
  • Alexey Nalimov

    Alexey Nalimov - 2021-01-22

    The problem is idenitied, it's not related to the case originally described. After TZQuery SQL text is changed, parameters assigned to the previous SQL are partially unchanged, i.e. parameter names are set to new SQL, but data types are unmodified !

     
  • Alexey Nalimov

    Alexey Nalimov - 2021-01-22

    and values also kept wrong

     
    • EgonHugeist

      EgonHugeist - 2021-01-23

      Please update from trunk (SVN).
      Patch done r7234
      Regards, Michael

       
  • EgonHugeist

    EgonHugeist - 2021-01-23
    • assigned_to: EgonHugeist
     
  • EgonHugeist

    EgonHugeist - 2021-02-27
    • status: open --> closed
     
  • EgonHugeist

    EgonHugeist - 2021-02-27

    Rsolved already.

     

Log in to post a comment.

MongoDB Logo MongoDB