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

possible error with function insert()

    XMLWordPrintable

    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: