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

main.func_isnull fails in buildbot on Windows 32bit

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Duplicate
        • Affects Version/s: 10.0
        • Fix Version/s: 10.0.16
        • Component/s: Tests
        • Labels:

          Description

          http://buildbot.askmonty.org/buildbot/builders/win32-debug2/builds/6560/steps/test/logs/stdio

          main.func_isnull                         [ fail ]
        Test ended at 2014-11-21 17:41:53

CURRENT_TEST: main.func_isnull
mysqltest: At line 24: query 'SELECT ISNULL((SELECT GET_LOCK('Bug#53933', 0) FROM t1 GROUP BY f1)) AS f2
FROM t1 GROUP BY f1 HAVING f2 = f2' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
drop table if exists t1;
create table t1 (id int auto_increment primary key not null, mydate date not null);
insert into t1 values (0,"2002-05-01"),(0,"2002-05-01"),(0,"2002-05-01");
flush tables;
select * from t1 where isnull(to_days(mydate));
id	mydate
drop table t1;
#
# Bug#53933 crash when using uncacheable subquery in the having clause of outer query
#
CREATE TABLE t1 (f1 INT);
INSERT INTO t1 VALUES (0),(0);
SELECT ISNULL((SELECT GET_LOCK('Bug#53933', 0) FROM t1 GROUP BY f1)) AS f2
FROM t1 GROUP BY f1 HAVING f2 = f2;


Server [mysqld.1 - pid: 270144, winpid: 270144, exit: 768] failed during test run
Server log from this test:
----------SERVER LOG START-----------
----------SERVER LOG END-------------

            Gliffy Diagrams

              Attachments

                Issue Links

                blocks

                Task - A task that needs to be done. MDEV-7069 Fix buildbot failures in main server trees

                • Major - Major loss of function.
                • Stalled
                is blocked by

                Bug - A problem which impairs or prevents the functions of the product. MDEV-7186 get_lock() crashes on Windows, main.sp_notembedded and main.trigger_notembedded fail in buildbot

                • Major - Major loss of function.
                • Closed

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment - - edited

                  It's a duplicate of MDEV-7186 in the sense that it's caused by the same crash; but since a different test fails, I'll keep it open until the other one gets closed.

                  Show
                  elenst Elena Stepanova added a comment - - edited It's a duplicate of MDEV-7186 in the sense that it's caused by the same crash; but since a different test fails, I'll keep it open until the other one gets closed.
                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  Fixed along with MDEV-7186

                  Show
                  elenst Elena Stepanova added a comment - Fixed along with MDEV-7186

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Due:
                        Created:
                        Updated:
                        Resolved: