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

possible error with function insert()

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 5.5
    • 5.5.48, 10.0.24, 10.1.12
    • OTHER
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.