Uploaded image for project: 'FreeSWITCH'
  1. FreeSWITCH
  2. FS-9727

Fields extracted from the DB are only limited to 255

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.6.12
    • Fix Version/s: 1.8
    • Component/s: mod_lua
    • Security Level: public
    • Labels:
      None
    • Environment:
      debian 8.4
      postgresql 9.4
      python 3.4
      django 1.10
    • CPU Architecture:
      x86-64
    • Kernel:
      Linux
    • uname:
      Linux at173 3.16.0-4-amd64 #1 SMP Debian 3.16.36-1+deb8u2 (2016-10-19) x86_64 GNU/Linux
    • Userland:
      GNU/Linux
    • Distribution:
      Debian
    • Distribution Version:
      Debian 8 jessie
    • lsb_release:
      Hide
      root@at173:/usr/share/freeswitch/scripts# lsb_release -a
      No LSB modules are available.
      Distributor ID: Debian
      Description: Debian GNU/Linux 8.6 (jessie)
      Release: 8.6
      Codename: jessie
      Show
      root@at173 :/usr/share/freeswitch/scripts# lsb_release -a No LSB modules are available. Distributor ID: Debian Description: Debian GNU/Linux 8.6 (jessie) Release: 8.6 Codename: jessie
    • Compiler:
      gcc
    • FreeSWITCH GIT Revision:
      master
    • GIT Master Revision hash::
      instal from debian repositories

      Description

                assert(dbh:query(sql_rol_default, function(row)
                  for key, val in pairs(row) do
                    data_rol_default[key] = val
                    freeswitch.consoleLog("debug", "ROL " .. key .. " / " .. val )
                  end
                end))

      row::STRING is limited to 255 characters, but if fields in postgresql is JsonFIELD should be a row::TEXT.

      If the field of postgresql is a jsonfield, to make it a lua to a json object, but it is not possible because the change is limited to 255 characters.

        Attachments

          Activity

            People

            • Assignee:
              mikej Mike Jerris
              Reporter:
              aztrock Jorge Cadena Argote
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: