SELECT 'This script will cause the following error:' As Information UNION ALL
SELECT '------------------------------------------------------' UNION ALL
SELECT 'mysqld-nt.exe - Application Error' UNION ALL
SELECT '------------------------------------------------------' UNION ALL
SELECT 'The instruction at "0x00000003" referenced ' UNION ALL
SELECT 'memory at "0x00000003". The memory could not be "read".';


use mysql;
drop database Crash;
create database Crash;
use Crash;

SELECT 'Creating table data';
CREATE TABLE data (
  A                                      float8,
  B                                      float8
);


INSERT INTO data(A, B) VALUES ('0.8', '0.9');
INSERT INTO data(A, B) VALUES ('0.8', '1.8');
INSERT INTO data(A, B) VALUES ('0.8', '2.7');
INSERT INTO data(A, B) VALUES ('0.8', '3.6');
INSERT INTO data(A, B) VALUES ('1.6', '0.9');
INSERT INTO data(A, B) VALUES ('1.6', '1.8');
INSERT INTO data(A, B) VALUES ('1.6', '2.7');
INSERT INTO data(A, B) VALUES ('1.6', '3.6');

SELECT 'EXECUTING CRASH QUERY.. MYSQL will crash here!' As Information;
SELECT 'select C from (select truncate(sum(a), 0) as c from data) as p;' As Information;

select C from (select truncate(sum(a), 0) as c from data) as p;