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

possible error with function insert()

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.5
    • Fix Version/s: 5.5.48, 10.0.24, 10.1.12
    • Component/s: OTHER
    • Labels:
      None
    • Environment:
      windows 10

      Description

      with a table type:

      CREATE TABLE `fcdcm001` (
      	`DCOD` DOUBLE(9,0) NULL DEFAULT '0',
      	`DOBS` MEDIUMTEXT NOT NULL,
      	UNIQUE INDEX `DCOD` (`DCOD`)
      )COLLATE='latin1_swedish_ci' ENGINE=MyISAM;
      

      if i execute this two instructions in mariadb 5.5:

      INSERT INTO FCDCM001 (dobs,dcod) values ('a',14);
      update fcdcm001 set dobs=INSERT(dobs,2,10,'1234567890' ) WHERE dcod=14
      

      result is that dcod returns 'a1234567890'

      but if i use in version 10.1.12 dcod returns 'a'

      ¿is that an error?

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              josej69 jose javier
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: