Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-5408

Qserv do not return very same BLOB field than MySQL

    Details

    • Type: Bug
    • Status: To Do
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
      None
    • Templates:
    • Story Points:
      8
    • Team:
      Data Access and Database

      Description

      Enabling query qserv_testdata/datasets/case01/queries/0007.2_fetchSourceByObjIdSelectBLOB.sql.FIXME will reveal this bug.

      Qserv chunk table contains next BLOB:

      mysql --socket /home/dev/qserv-run/git/var/lib/mysql/mysql.sock --user=root --password=changeme qservTest_case01_qserv -e "select blobField from Source_6630 where SourceId=29809239313746172;" > 29809239313746172.chunk6630
       
      vi 29809239313746172.chunk6630
       
      blobField
       
      ^D^B\0^W\0\0\0^B\0^K\0~B\0first_fieldsecond_field(�q.\\�
      

      But Qserv returns:

      ^D^B\0^W\0\0\0^B\0^K\0~B\0first_fieldsecond_field(�q.�
      

      See DM-991 for additional informations.

        Attachments

          Container Issues

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  jammes Fabrice Jammes
                  Watchers:
                  Andy Salnikov, Fabrice Jammes, Fritz Mueller, Serge Monkewitz
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                  Dates

                  • Created:
                    Updated:

                    Summary Panel