Details

    • Technical task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • None
    • N/A
    • OTHER
    • None

    Attachments

      1. 68311-desc.txt
        5 kB
        Elena Stepanova
      2. 68311-how-to-repeat.txt
        1 kB
        Elena Stepanova

      Activity

        elenst Elena Stepanova added a comment - - edited

        http://bugs.mysql.com/bug.php?id=68759

        DROP TABLE IF EXISTS t_inno;
        CREATE TABLE t_inno (pk INT PRIMARY KEY, t_key TIME, t TIME, KEY(t_key)) ENGINE=InnoDB;
        INSERT INTO t_inno VALUES (1,'12:12:12','12:12:12'),(2,'21:21:21','21:21:21');

        SELECT * FROM t_inno WHERE t < 'z';
        SELECT pk FROM t_inno WHERE t_key < 'z';
        SELECT * FROM t_inno WHERE t_key < 'z';

        MySQL [test]> DROP TABLE IF EXISTS t_inno;
        Query OK, 0 rows affected (0.20 sec)

        MySQL [test]> CREATE TABLE t_inno (pk INT PRIMARY KEY, t_key TIME, t TIME, KEY(t_key)) ENGINE=InnoDB;
        Query OK, 0 rows affected (1.20 sec)

        MySQL [test]> INSERT INTO t_inno VALUES (1,'12:12:12','12:12:12'),(2,'21:21:21','21:21:21');
        Query OK, 2 rows affected (0.07 sec)
        Records: 2 Duplicates: 0 Warnings: 0

        MySQL [test]>
        MySQL [test]> SELECT * FROM t_inno WHERE t < 'z';
        --------------------

        pk t_key t

        --------------------

        1 12:12:12 12:12:12
        2 21:21:21 21:21:21

        --------------------
        2 rows in set, 1 warning (0.00 sec)

        MySQL [test]> SELECT pk FROM t_inno WHERE t_key < 'z';
        ----

        pk

        ----

        1
        2

        ----
        2 rows in set, 2 warnings (0.00 sec)

        MySQL [test]> SELECT * FROM t_inno WHERE t_key < 'z';
        Empty set, 2 warnings (0.00 sec)

        elenst Elena Stepanova added a comment - - edited http://bugs.mysql.com/bug.php?id=68759 DROP TABLE IF EXISTS t_inno; CREATE TABLE t_inno (pk INT PRIMARY KEY, t_key TIME, t TIME, KEY(t_key)) ENGINE=InnoDB; INSERT INTO t_inno VALUES (1,'12:12:12','12:12:12'),(2,'21:21:21','21:21:21'); SELECT * FROM t_inno WHERE t < 'z'; SELECT pk FROM t_inno WHERE t_key < 'z'; SELECT * FROM t_inno WHERE t_key < 'z'; MySQL [test] > DROP TABLE IF EXISTS t_inno; Query OK, 0 rows affected (0.20 sec) MySQL [test] > CREATE TABLE t_inno (pk INT PRIMARY KEY, t_key TIME, t TIME, KEY(t_key)) ENGINE=InnoDB; Query OK, 0 rows affected (1.20 sec) MySQL [test] > INSERT INTO t_inno VALUES (1,'12:12:12','12:12:12'),(2,'21:21:21','21:21:21'); Query OK, 2 rows affected (0.07 sec) Records: 2 Duplicates: 0 Warnings: 0 MySQL [test] > MySQL [test] > SELECT * FROM t_inno WHERE t < 'z'; --- -------- --------- pk t_key t --- -------- --------- 1 12:12:12 12:12:12 2 21:21:21 21:21:21 --- -------- --------- 2 rows in set, 1 warning (0.00 sec) MySQL [test] > SELECT pk FROM t_inno WHERE t_key < 'z'; ---- pk ---- 1 2 ---- 2 rows in set, 2 warnings (0.00 sec) MySQL [test] > SELECT * FROM t_inno WHERE t_key < 'z'; Empty set, 2 warnings (0.00 sec)

        Possibly file later

        MySQL [test]> select @@sql_mode;
        ------------------------

        @@sql_mode

        ------------------------

        NO_ENGINE_SUBSTITUTION

        ------------------------
        1 row in set (0.00 sec)

        MySQL [test]> show create table t2;
        --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

        Table Create Table

        --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

        t2 CREATE TABLE `t2` (
        `pk` int(11) NOT NULL AUTO_INCREMENT,
        `c1` varchar(8) CHARACTER SET latin1 DEFAULT NULL,
        `c2` char(3) CHARACTER SET latin1 DEFAULT NULL,
        `i` int(11) DEFAULT NULL,
        `u` int(10) unsigned DEFAULT NULL,
        PRIMARY KEY (`pk`),
        KEY `c1` (`c1`),
        KEY `c2` (`c2`),
        KEY `i` (`i`),
        KEY `u` (`u`),
        KEY `c1_2` (`c1`,`i`),
        KEY `c2_2` (`c2`,`u`)
        ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_bin

        --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
        1 row in set (0.00 sec)

        MySQL [test]> select * from t2;
        --------------------

        pk c1 c2 i u

        --------------------

        1 ab ab 0 0
        2 NULL NULL NULL 0

        --------------------
        2 rows in set (0.00 sec)

        MySQL [test]> update t2 set i = u-1;
        ERROR 1690 (22003): BIGINT UNSIGNED value is out of range in '(`test`.`t2`.`u` - 1)'
        MySQL [test]>

        elenst Elena Stepanova added a comment - Possibly file later MySQL [test] > select @@sql_mode; ------------------------ @@sql_mode ------------------------ NO_ENGINE_SUBSTITUTION ------------------------ 1 row in set (0.00 sec) MySQL [test] > show create table t2; ------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Table Create Table ------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ t2 CREATE TABLE `t2` ( `pk` int(11) NOT NULL AUTO_INCREMENT, `c1` varchar(8) CHARACTER SET latin1 DEFAULT NULL, `c2` char(3) CHARACTER SET latin1 DEFAULT NULL, `i` int(11) DEFAULT NULL, `u` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`pk`), KEY `c1` (`c1`), KEY `c2` (`c2`), KEY `i` (`i`), KEY `u` (`u`), KEY `c1_2` (`c1`,`i`), KEY `c2_2` (`c2`,`u`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_bin ------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) MySQL [test] > select * from t2; --- ---- ---- ---- ----- pk c1 c2 i u --- ---- ---- ---- ----- 1 ab ab 0 0 2 NULL NULL NULL 0 --- ---- ---- ---- ----- 2 rows in set (0.00 sec) MySQL [test] > update t2 set i = u-1; ERROR 1690 (22003): BIGINT UNSIGNED value is out of range in '(`test`.`t2`.`u` - 1)' MySQL [test] >

        Filed bug http://bugs.mysql.com/bug.php?id=69203 (Valgrind warnings and crash on select from an InnoDB table), for 5.7 revno 5216.
        Test case:
        CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB;
        INSERT INTO t1 VALUES (10),(11);

        SELECT * FROM t1;

        1. End of test case

        When run with --valgrind-mysqld under MTR, causes a valgrind warnings and a crash on BUILD/compile-pentium-debug-max-no-ndb

        elenst Elena Stepanova added a comment - Filed bug http://bugs.mysql.com/bug.php?id=69203 (Valgrind warnings and crash on select from an InnoDB table), for 5.7 revno 5216. Test case: CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=InnoDB; INSERT INTO t1 VALUES (10),(11); SELECT * FROM t1; End of test case When run with --valgrind-mysqld under MTR, causes a valgrind warnings and a crash on BUILD/compile-pentium-debug-max-no-ndb

        MySQL (and MariaDB) prints garbage in warning records:

        2013-08-09 23:46:52 7f4dafeec740 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
        2013-08-09 23:46:52 7f4dafeec740 InnoDB: Warning: Using innodb_locks_unsafe_for_binlog is DEPRECATED. This option may be removed in future releases. Please use READ COMMITTED transaction isolation level instead, see http://dev.mysql.com/doc/refman/10.0/en/set-transaction.html.

        I think there was an upstream bug about it, but can't find it now, need to check later.

        elenst Elena Stepanova added a comment - MySQL (and MariaDB) prints garbage in warning records: 2013-08-09 23:46:52 7f4dafeec740 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2013-08-09 23:46:52 7f4dafeec740 InnoDB: Warning: Using innodb_locks_unsafe_for_binlog is DEPRECATED. This option may be removed in future releases. Please use READ COMMITTED transaction isolation level instead, see http://dev.mysql.com/doc/refman/10.0/en/set-transaction.html . I think there was an upstream bug about it, but can't find it now, need to check later.
        elenst Elena Stepanova added a comment - https://github.com/MySQLOnRocksDB/mysql-5.6/issues/70

        People

          elenst Elena Stepanova
          elenst Elena Stepanova
          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.