Uploaded image for project: 'Spring Data JDBC'
  1. Spring Data JDBC
  2. DATAJDBC-343

INSERT and UPDATE statement assignments contain table prefix

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.1 M3 (Moore)
    • Component/s: Statement Builder
    • Labels:
      None
    • Sprint:
      Lovelace SR1

      Description

      Rendered INSERT and UPDATE statements contain table prefixes in their assignments:

      UPDATE legoset SET legoset.name = $1

      This fails on Postgres and may work on other databases. We should not render the table prefix unless we get Dialect-awareness.

      Postgres error:

      UPDATE legoset SET legoset.name = $1, legoset.manual = $2 WHERE legoset.id = $3
      
      Error: column "legoset" of relation "legoset" does not exist
      

        Attachments

          Activity

            People

            Assignee:
            mp911de Mark Paluch
            Reporter:
            mp911de Mark Paluch
            Last updater:
            Spring Issues Spring Issues
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: