MySQL Bugs: #266: Fatal error resulting from use of SUBSELECT

Bug #266	Fatal error resulting from use of SUBSELECT
Submitted:	9 Apr 2003 21:18	Modified:	16 Apr 2003 4:03
Reporter:	James Katarski	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	4.1	OS:	Windows (Windows XP SP1)
Assigned to:	Vasily Kishkin	CPU Architecture:	Any

Description:
Use of a subquery systematically killed each and every process on the machine. Machine became unresponsive. On subsequent occurences of this happening, I was able to shutdown the MySQL service cleanly; The first time, only a reboot of the machine worked, and even then it struggled to shutdown.

I attempted the query 3 times; The first two times, I entered correct syntax, the 3rd time I entered INcorrect syntax (supplied a name of a non-existant table), all with the same results.

I also attempted the queries seperately, as described in 'How to repeat'. They worked fine.

How to repeat:
I tried a query as follows:

SELECT object_title
FROM tblobject
WHERE
week_no IN (
       SELECT week_no
       FROM tblweek
       WHERE
       unit_code like 'CSG2130'
);

object_title and unit_code are VARCHARS
week_no is an autoincremented INTEGER

Individual queries (No errors)
select week_no from tblweek where unit_code like 'CSG2130';
select object_title from tblobject where week_no = 5036;

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Please provide repeatable test case. With your explanations it is impossible to repeat it. It works well with follwoing tables:

show create table tblweek;
CREATE TABLE `tblweek` (
  `week_no` int(10) unsigned NOT NULL auto_increment,
  `unit_code` varchar(20) default NULL,
  PRIMARY KEY  (`week_no`)
) TYPE=MyISAM CHARSET=latin1 |

show create table tblobject;

tblobject | CREATE TABLE `tblobject` (
  `week_no` int(10) unsigned default NULL,
  `object_title` varchar(20) default NULL
) TYPE=MyISAM CHARSET=latin1 

Provide exact CREATE statement as well as couple of rows in both table which are enough to repeat bug.

There is big chance that different Indexes might turn on or off such bugs or that they depend on specific data values.

James,
I forgot to ask if yiu can repeat it with mysqld or it happens with embeded server only.

Here is the extra info you needed. Included are the table creation statements as well as data for three units (unit_code), csg2220, csg2130 and csg3332.

I selected embedded server by mistake, it is actually mysqld.

Thanks,

James.

CREATE TABLE tblweek (
  week_no int(5) NOT NULL auto_increment,
  unit_code varchar(25) character set latin1 default NULL,
  unit_week int(11) default NULL,
  week_heading text character set latin1,
  week_type text character set latin1,
  visible enum('TRUE','FALSE') character set latin1 default NULL,
  priority int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (week_no)
) TYPE=MyISAM;

CREATE TABLE tblobject (
  object_no int(5) NOT NULL auto_increment,
  week_no int(5) default NULL,
  object_type text character set latin1,
  object_title text character set latin1,
  object_description text character set latin1,
  object_url text character set latin1,
  directory text character set latin1,
  url text character set latin1,
  size text character set latin1,
  heading_type enum('0','1') character set latin1 default '1',
  last_updated int(11) default NULL,
  priority int(1) default NULL,
  active enum('TRUE','FALSE') character set latin1 default 'TRUE',
  country int(1) default '0',
  heading_colour varchar(6) character set latin1 default '000000',
  feedback_total int(1) default NULL,
  feedback_number int(1) default NULL,
  unit_code varchar(25) character set latin1 default NULL,
  PRIMARY KEY  (object_no)
) TYPE=MyISAM;

insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG3332', '4', 'Process Models: A Strategic Perspective', 'normal', 'TRUE', '4');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Other', 'An Ethical Issue to Think About', 'A ethical problem to consider. Would you make the right decision?', 'An+issues+to+think+about+2.doc', '', '', '22 Kb', '1', '0', '3645', 'TRUE', '0', '3333CC', '0', '0', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Movie', 'Adams and Caldeney Lifecycle Model', 'A link to this movie is provided in the Guide notes.  Access this movie from the Guide initially - it will make a lot more sense.  Use this link only for revision purposes.', 's15-s18.swf', '', '', '86 Kb', '1', '0', '3645', 'TRUE', '0', '3333CC', '0', '0', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Movie', 'Life Cycle Model - Morris', 'A link to this movie is provided in the Guide notes.  Access this movie from the Guide initially - it will make a lot more sense.  Use this link only for revision purposes.', 's08.swf', '', '', '16 Kb', '1', '0', '4251', 'TRUE', '0', '3333CC', '0', '0', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Tutorial: Process Models', 'Follow the link to view the Powerpoint Slides for the Week 4 Tutorial.', 'Week 4 Tutorial 2003 Process Models Ver 1.ppt', '', '', '86 Kb', '1', '', '25177', 'TRUE', '0', '000000', '', '', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Lecture Week 4: Process Models', 'Follow the link to view the Powerpoint Slides for Week 4.', 'Week 4 Lecture 2003 Process Models Ver 1.ppt', '', '', '347 Kb', '1', '', '25178', 'TRUE', '0', '000000', '', '', 'CSG3332');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG3332', '1', 'Unit Introduction, Project Management History and Development', 'Lecture', 'TRUE', '1');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Project Management Glossary', 'This is a general glossary of Project Management terms.', '', '', 'http://netman.cit.buffalo.edu/FAQs/proj-plan.glossary.html#Predecessor';, '', '1', '', '3122', 'TRUE', '0', '3333CC', '', '', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Notes', 'UNIT PLAN', 'This document includes everything you need to know about the next 13 weeks.', 'CSG3332 - Student Ver1.doc', '', '', '130 Kb', '1', '0', '4321', 'TRUE', '0', '3333CC', '0', '0', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Arthicle: What the Australian CEOs want from IT', 'This is the first of six (6) articles to read for Assignment 1. Students are to write a one page analysis and critique of the article.  Please give your paper to your tutor at the commencement of your week three workshop.  In addition to your name, student number, title of the article, tutor, time and date of your workshop, your paper should include an Introduction, discussion and conclusion.  Please note that you may have to "Rotate view clockwise" to read the article.', 'Journal of R&P in IT (VOL32, No 3-4 2000).pdf', '', '', '914 Kb', '0', '', '5881', 'TRUE', '0', '3333CC', '', '', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Weekly Schedule for CSG3332', 'Follow the link to the CSG3332 weekly schedule. The schedule will be revised during the first weeks of the semester.', 'Unit Calendar 2003 Ver1.DOC', '', '', '46 Kb', '1', '', '18954', 'TRUE', '0', '000000', '', '', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Week 1 Lecture: Introduction to CSG3332!', 'Follow the link to the first CSG3332 lecture. The lecture introduces the unit and outlines the history of project management.', 'Week1 2003 Lecture - Unit Intro Ver 1.ppt', '', '', '1481 Kb', '1', '', '18955', 'TRUE', '0', '000000', '', '', 'CSG3332');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG3332', '2', 'Basic Principles', 'Lecture', 'TRUE', '2');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'ACS Code of Ethics', 'The Australian Computer Society (ACS) states: "An essential characteristic of a profession is the need for its members to abide by a Code of Ethics. The Australian Computer Society (ACS) requires its members to subscribe to a set of values and ideals which uphold and advance the honour, dignity and effectiveness of the profession of information technology."  During the week to lecture on Pject Management Basic Principles we will incorporate matters relating to ethics in IT and potential project management impacts.  ', 'ACS Code of Ethics.doc', '', '', '34 Kb', '1', '', '5899', 'TRUE', '0', '3333CC', '', '', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Student Guide for Articles', 'Follow this link to see a guide for developing the analysis and critique of the fortnightly project management related articles.', 'Student Guide for Articles ver2 .doc', '', '', '33 Kb', '0', '', '6057', 'TRUE', '0', '3333CC', '', '', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Student Guide for Assignment 2', 'Follow this link to view the guide for Assignment 2. This guide will be discussed during this week tutorials. ', 'Assignment 2 Guide 2003 Ver 2.DOC', '', '', '63 Kb', '0', '', '20542', 'TRUE', '0', '000000', '', '', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', '', '', '', '', '', '', '0', '', '20543', 'TRUE', '0', '000000', '', '', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Week 2 Lecture', 'Follow the link to view the presentation used during the Week 2 lecture about the basics principles of project management. ', 'Week 2 2003 Lecture PM Basics Ver 1.ppt', '', '', '522 Kb', '1', '', '20544', 'TRUE', '0', '000000', '', '', 'CSG3332');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG3332', '3', 'Strategic Project Planning', 'Lecture', 'TRUE', '3');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Ethics in Cyberspace (an ACS article)', 'The ACS states in this articles that "one of the dangers of this preoccupation with technology is that we can lose sight of the bigger picture and don&#039;t always stop to consider the social and ethical implications of these developments for our society and culture."  THis article provides insight on some ethical issues that have emerged as a result of the growth of Internet usage. ', 'Ethics in cyberspace.doc', '', '', '37 Kb', '1', '', '4250', 'TRUE', '0', '3333CC', '', '', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Lecture: Week 3 Strategic Project Management', 'Follow the link to view the Powerpoint slides for the Week 3 Lecture.', 'Week 3 2003 Strategic PM ver1.ppt', '', '', '213 Kb', '1', '', '24064', 'TRUE', '0', '000000', '', '', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Tutorial: Week 3 Strategic Project Management  ', 'Follow the link to view the Powerpoint slides for the Week 3 Tutorial.', 'Week 3 Tute 2003 Strategic PM ver1.ppt', '', '', '70 Kb', '1', '', '24065', 'TRUE', '0', '000000', '', '', 'CSG3332');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG3332', '5', 'Scoping and Planning', 'Lecture', 'TRUE', '5');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Taking Projects to the Extreme', 'A very interesting article on a recent project management trend.', '', '', 'http://www.computerworld.com/managementtopics/management/project/story/0,10801,72827,00.ht...;, '', '1', '', '6530', 'TRUE', '0', '3333CC', '', '', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Lecture: Project Scope and Planning', 'Please follow the link to view the slides for the Week 5 lecture: Project Scope and Planning.', 'Week 5 Scoping Ver 2.ppt', '', '', '594 Kb', '0', '', '26030', 'TRUE', '0', '000000', '', '', 'CSG3332');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG3332', '6', 'Project Risk Management', 'normal', 'TRUE', '6');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Article: Monkey Business. (IT Ethics)', 'An article about ethics in the IT industry.', 'IT Ethics.doc', '', '', '37 Kb', '0', '', '18953', 'TRUE', '0', '000000', '', '', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Week 6 Lecture: Risk Management', 'Please follow the link to view the Lecture for Week 6 on Risk MAnagement.', 'Week 6 Risk Management 2003 Ver 1.ppt', '', '', '510 Kb', '1', '', '26974', 'TRUE', '0', '000000', '', '', 'CSG3332');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG3332', '7', 'Teams & Team Leadership', 'normal', 'TRUE', '7');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Movie', 'Theory of Constraints', 'A link to this movie is provided in the Guide notes.  Access this movie from the Guide initially - it will make a lot more sense.  Use this link only for revision purposes.', 's16-31.swf', '', '', '104 Kb', '1', '0', '4262', 'TRUE', '0', '3333CC', '0', '0', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Week 7 Lecture: Project Teams & Team Leadership', 'Please follow the link to the Week 7 Lecture about Project Teams and Team Leadership. After the lecture, meetings will be hld with the project teams. ', 'Week 7 Team and Team Leadership 2003 Ver 1a.ppt', '', '', '295 Kb', '1', '', '27828', 'TRUE', '0', '000000', '', '', 'CSG3332');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG3332', '8', 'Leadership, Professionalism & Ethics', 'normal', 'TRUE', '8');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Movie', 'Culture of Organisations', 'A link to this movie is provided in the Guide notes.  Access this movie from the Guide initially - it will make a lot more sense.  Use this link only for revision purposes.', 's02.swf', '', '', '13 Kb', '1', '0', '4246', 'TRUE', '0', '3333CC', '0', '0', 'CSG3332');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG3332', '9', 'Project Control', 'normal', 'TRUE', '9');
select @week_no:= LAST_INSERT_ID();
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG3332', '10', 'Problem Solving and Decisionmaking', 'Lecture', 'TRUE', '10');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Project Managing E-Government ', 'A short video about how government can use technology to improve services to the community. What are the issues associated with project managing a project as depicted in the video? What factors can influence decison making process? ', '', '', '', '0 Kb', '1', '', '7205', 'TRUE', '0', '3333CC', '', '', 'CSG3332');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG3332', '11', 'Change Management', 'Lecture', 'TRUE', '11');
select @week_no:= LAST_INSERT_ID();
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG3332', '12', 'Project Management Professionalism', 'normal', 'TRUE', '12');
select @week_no:= LAST_INSERT_ID();
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG3332', '13', 'Unit Review', 'normal', 'TRUE', '13');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Lecture: Unit Review', 'No materials will be distributed during the lecture. ', '', '', '', '', '0', '', '7433', 'TRUE', '0', '3333CC', '', '', 'CSG3332');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Lecture: Unit Review ', 'No materials will be distributed during the lecture.   ', '', '', '', '', '1', '', '7434', 'TRUE', '0', '3333CC', '', '', 'CSG3332');

insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2220', '1', 'Introduction to RF', 'Lecture', 'TRUE', '1');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Workshop', 'Sine Waves', 'Workshop', 'lab1.doc', '', '', '112 Kb', '1', '0', '3771', 'TRUE', '0', '999900', '0', '0', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading', 'Chapter 1', '', '', '', '', '0', '', '4241', 'TRUE', '0', '660066', '', '', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Unit Outline', 'Unit outline for CSG2220', '', 'Wireless+unit+outline.doc', '', '', '29 Kb', '1', '0', '4521', 'TRUE', '0', '3333CC', '0', '0', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Lecture', 'Introduction to RF', 'Lecture', 'Lecture 1 intro.ppt', '', '', '441 Kb', '0', '0', '23533', 'TRUE', '0', '3333CC', '0', '0', 'CSG2220');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2220', '2', 'Analog and Digital Modulation', 'normal', 'TRUE', '2');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Workshop', 'AM Modulation', 'Workshop.  We will look at a simulation about AM modulation, then measure the modulation percentage of a carrier signal that we will modulate in the lab using the digital CRO and function generator.', 'lab2.doc', '', '', '100 Kb', '1', '0', '3345', 'TRUE', '0', '999900', '0', '0', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Lecture', 'Analog and Digital Modulation', 'Lecture', 'Lecture 2 modulation new.ppt', '', '', '239 Kb', '0', '0', '3768', 'TRUE', '0', '3333CC', '0', '0', 'CSG2220');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2220', '3', 'Spread Spectrum Technologies', 'normal', 'TRUE', '3');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading', 'Chapter 2, pp 27-46', '', '', '', '', '0', '', '3344', 'TRUE', '0', '660066', '', '', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Workshop', 'FM Modulation', 'We will look at a simulation about FM modulation, then measure the degree of modulation of a carrier signal that we will modulate in the lab using the digital CRO and function generator.', 'lab3.doc', '', '', '104 Kb', '1', '0', '4604', 'TRUE', '0', '999900', '0', '0', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Lecture', 'Spread Spectrum Technologies', '', 'Lecture 3 spread spectrum.ppt', '', '', '674 Kb', '0', '0', '23528', 'TRUE', '0', '3333CC', '0', '0', 'CSG2220');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2220', '4', 'Antenna Theory and Fundamentals', 'normal', 'TRUE', '4');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Lecture', 'Antenna Theory and Fundamentals', '', 'Lecture 4 antennas.ppt', '', '', '4827 Kb', '0', '0', '3159', 'TRUE', '0', '3333CC', '0', '0', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Workshop', 'Digital modulation simulation and measurements', '', 'Laboratory+4.doc', '', '', '27 Kb', '1', '0', '5321', 'TRUE', '0', '999900', '0', '0', 'CSG2220');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2220', '5', 'Wireless RF Standards', 'normal', 'TRUE', '5');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading', 'Chapter 3 pp62-72', '', '', '', '', '0', '', '3149', 'TRUE', '0', '660066', '', '', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Reading', 'Antenna Theory And Design', '', 'an-23.pdf', '', '', '63 Kb', '1', '0', '4498', 'TRUE', '0', '3333CC', '0', '0', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Workshop', 'Antenna radiation mapping', 'In this lab we will map the horizontal radiation patterns of a dipole (omni directional) and then a yagi (directional) antenna on a polar diagram.', '', '', '', '0 Kb', '1', '0', '4902', 'TRUE', '0', '3333CC', '0', '0', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Workshop', 'Blank Polar Diagrams for use in this weeks lab - Download this and print', '', 'polar+diagram.doc', '', '', '1045 Kb', '1', '0', '4904', 'TRUE', '0', '3333CC', '0', '0', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'new lab for week 5', '', 'Laboratory 5.doc', '', '', '1689 Kb', '1', '', '6660', 'FALSE', '0', '999900', '', '', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Lecture', 'Wireless RF Standards', '', 'Lecture 5 RF standards.ppt', '', '', '124 Kb', '0', '0', '23531', 'TRUE', '0', '3333CC', '0', '0', 'CSG2220');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2220', '6', 'Wireless LAN Infrastructure Devices', 'normal', 'TRUE', '6');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading', 'Chapter 2 pp47-53', '', '', '', '', '0', '', '4803', 'TRUE', '0', '660066', '', '', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Workshop', 'More antenna mapping', 'This week we will again be mapping the radiation from an antenna. We will use a high gain omni directional antenna, and do the mapping indoors. The idea being to examine the effect of walls, floors, whiteboards and other materials on transmission range.', '', '', '', '0 Kb', '1', '0', '4846', 'TRUE', '0', '999900', '0', '0', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Lecture', 'Wireless LAN Infrastructure Devices', '', 'Lecture 6 Wireless LAN devices.ppt', '', '', '388 Kb', '0', '0', '23530', 'TRUE', '0', '3333CC', '0', '0', 'CSG2220');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2220', '7', 'Wireless Network Architecture I', 'normal', 'TRUE', '7');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading', 'Chapter 4 pp108-118', '', '', '', '', '0', '', '4961', 'TRUE', '0', '660066', '', '', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Lecture', '802.11 Network Architecture I', '', 'Lecture 7 802_11 network architecture.ppt', '', '', '255 Kb', '0', '0', '23532', 'TRUE', '0', '3333CC', '0', '0', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'CISCO Wireless LAN PCMCIA Card Setup', 'We will be configuring a CISCO 350 series client card using the desktop machines and Windows XP.', 'Lab 7.DOC', '', '', '28 Kb', '1', '', '27215', 'TRUE', '0', '999900', '', '', 'CSG2220');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2220', '8', 'Wireless Network Architecture II', 'normal', 'TRUE', '8');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Lecture', '802.11 Network Architecture II', 'This lecture looks at authentication and association between 802.11 wireless clients and access points.', 'Lecture 8 802_11 network architecture part II.ppt', '', '', '404 Kb', '0', '0', '5020', 'TRUE', '0', '3333CC', '0', '0', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Workshop', 'Access Point Configuration', '', 'Lab+8+-+AP+config.DOC', '', '', '118 Kb', '1', '0', '5021', 'TRUE', '0', '999900', '0', '0', 'CSG2220');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2220', '10', 'Site Survey Part I', 'Lecture', 'TRUE', '10');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Lecture', 'Site Survey Part I', '', 'Lecture 10 - Site Survey I.ppt', '', '', '274 Kb', '0', '0', '5201', 'TRUE', '0', '3333CC', '0', '0', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Reading', 'CISCO site survey lab guide', '', 'CISCO+lab.doc', '', '', '3035 Kb', '1', '0', '5207', 'TRUE', '0', '999900', '0', '0', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Reading', 'CISCO sample site survey', '', 'Site+survey+example.doc', '', '', '13993 Kb', '1', '0', '5208', 'TRUE', '0', '006666', '0', '0', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Reading', 'CISCO wireless equipment price list', '', 'Price+list+for+CISCO+wireless+LAN+equipment.doc', '', '', '20 Kb', '1', '0', '5216', 'TRUE', '0', '006666', '0', '0', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Notes', 'How to correctly setup the CISCO ACU for performing a site survey', '', 'ACU+setup+for+site+survey.doc', '', '', '114 Kb', '1', '0', '5228', 'TRUE', '0', '006666', '0', '0', 'CSG2220');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2220', '9', 'MAC and Physical Layers', 'normal', 'TRUE', '9');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading', 'Chapters 4 and 5', '', '', '', '', '0', '', '5022', 'TRUE', '0', '660066', '', '', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Lecture', '802.11 MAC and Physical Layers', '', 'Lecture 9 mac and physical layers.ppt', '', '', '154 Kb', '0', '0', '23529', 'TRUE', '0', '3333CC', '0', '0', 'CSG2220');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2220', '11', 'Site Survey Part II', 'Lecture', 'TRUE', '11');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Lecture', 'Site Survey Part II', '', 'Lecture 11 - Site Survey II.ppt', '', '', '254 Kb', '0', '0', '5252', 'TRUE', '0', '3333CC', '0', '0', 'CSG2220');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2220', '12', 'Security of Wireless LAN&#039;s', 'Lecture', 'TRUE', '12');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Lecture', 'Security of Wireless LAN&#039;s', '', 'Lecture 12 - Wireless LAN Security.ppt', '', '', '237 Kb', '0', '0', '5285', 'TRUE', '0', '3333CC', '0', '0', 'CSG2220');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Secret Security Sniffer Stuff', 'For those of you that have finished your site survey, you have the opportunity to use the laptops to wander the campus in pursuit of rogue AP&#039;s. Check out the download for more info...', 'lab 12.pdf', '', '', '109 Kb', '1', '', '7424', 'TRUE', '0', '999900', '', '', 'CSG2220');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2220', '13', 'Review', 'Lecture', 'TRUE', '13');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, 'Lecture', 'Review', 'There will be a very brief review of the unit material, and what type of questions to expect in the exam.', 'review and sample exam questions.ppt', '', '', '98 Kb', '0', '0', '5286', 'TRUE', '0', '990000', '0', '0', 'CSG2220');

insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2130', '1', 'Introduction', 'normal', 'TRUE', '1');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Other useful stuff', 'Any links referred to in the Lectures or Workshops plus any other useful stuff can be found behind the Links button at the top of this page.', '', '', '', '', '1', '0', '7951', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Quick Quiz', '', 'csg2130week1quiz.htm', '', '', '25 Kb', '1', '0', '8335', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Workshop 1', 'You will find the plan for each week&#039;s learning activities under this heading. Any resources used in the workshops are linked to each week&#039;s workshop file.', 'csg2130week1workshop.pdf', '', '', '56 Kb', '1', '0', '8445', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Learning Objectives for Week 1', '', '', '', '', '', '', '0', '8449', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Learning Objectives for Week 1', '', '', '', '', '', '', '0', '8451', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading for this week', 'Textbook:  Dennis, Alan (2002). Networking in the Internet Age. New York: Wiley.  Chapter 1:Introduction to Data Communications', '', '', '', '', '1', '0', '8484', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'ASSESSMENT', 'Details of the formal assessments for this unit are located behind the Assessment button at the top of this page.', '', '', '', '', '0', '0', '8691', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Lecture -- Introduction to Data Communications', 'The powerpoint slides used in the lecture can be found here.', 'csg2130week1.ppt', '', '', '723 Kb', '1', '0', '9144', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Learning goals for week 1 ', '<ul><li>Be aware of the history of communications, information systems and the Internet <li>Be aware of the applications of data communications networks <li>Be familiar with the major components of and types of networks <li>Understand the role of network layers <li>Be familiar with the role of network standards <li>Be aware of three key trends in communications and networking</ul>', '', '', '', '', '0', '0', '9763', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2130', '2', 'Application Layers', 'normal', 'TRUE', '2');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Quick Quiz', '', 'csg2130week2quiz.htm', '', '', '26 Kb', '1', '0', '8336', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Workshop 2', '', 'csg2130week2workshop.pdf', '', '', '77 Kb', '1', '0', '8530', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading for this week', 'Textbook: Chapter 2  Application Layers', '', '', '', '', '1', '0', '8950', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Lecture -- Application Layers', '', 'csg2130week2.ppt', '', '', '882 Kb', '1', '0', '9527', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Learning goals for week 2', '<ul> <li>Understand host-based, client-based, and client-server architectures <li>Understand how the Web works <li>Understand how e-mail works <li>Be aware of how FTP, Telnet, and Instant Messaging work</ul>', '', '', '', '', '0', '0', '9761', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2130', '3', 'Internetwork Layers', 'normal', 'TRUE', '3');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Quick Quiz', '', 'csg2130week3quiz.htm', '', '', '26 Kb', '1', '0', '8339', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Workshop 3', '', 'csg2130week3workshop.pdf', '', '', '67 Kb', '1', '0', '8535', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading for this week', 'Textbook: Chapter 3 Internetwork Layers', '', '', '', '', '1', '0', '8537', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Lecture --Internetwork Layers', '', 'csg2130week3.ppt', '', '', '1189 Kb', '1', '0', '9528', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Learning goals for week 3', '<ul> <li>Be aware of four transport/network layer protocols  <li>Be familiar with segmenting and linking to the application layer <li>Be familiar with reliable delivery <li>Be familiar with addressing  <li>Be familiar with routing <li>Understand how TCP/IP works</ul> ', '', '', '', '', '0', '0', '9854', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2130', '4', 'Harware Layers: Local Area Networks', 'normal', 'TRUE', '4');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Quick Quiz', '', 'csg2130week4quiz.htm', '', '', '26 Kb', '1', '0', '8340', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Workshop 4', '', 'csg2130week4workshop.pdf', '', '', '64 Kb', '1', '0', '8538', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading for this week', 'Textbook: Chapter 4 Hardware Layers: Local Area Networks', '', '', '', '', '1', '0', '8539', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'ATTENDANCE AT WORKSHOP ', 'You need to attend the workshop this week so hat you can participate in the TCP/IP Exercise for Assessment 1.  ', '', '', '', '', '0', '0', '8698', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Lecture -- Hardware Layers: Local Area Networks', '', 'csg2130week4.ppt', '', '', '971 Kb', '1', '0', '9529', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Learning goals for week 4', '<ul> <li>Understand the major components of LANs <li>Understand shared Ethernet and switched Ethernet topologies <li>Understand Ethernet media access control <li>Understand Ethernet error control <li>Be familiar with Ethernet message delineation <li>Be familiar with how data is transmitted through physical circuits <li>Understand the best practice recommendations for LAN design</ul> ', '', '', '', '', '0', '0', '9855', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2130', '5', 'Hardware Layers: Backbone Networks', 'normal', 'TRUE', '5');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Quick Quiz', '', 'csg2130week5quiz.htm', '', '', '26 Kb', '1', '0', '8341', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Workshop 5', '', 'csg2130week5workshop.pdf', '', '', '59 Kb', '1', '0', '8540', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading for this week', 'Textbook: Chapter 5 Hardware Layers: Backbone Networks', '', '', '', '', '1', '0', '8541', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'ATTENDANCE AT WORKSHOP', 'You need to attend the workshop this week so hat you can participate in the TCP/IP Exercise for Assessment 1.', '', '', '', '', '0', '0', '8699', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Lecture-- Hardware Layers: Backbone Networks', '', 'csg2130week5.ppt', '', '', '1245 Kb', '1', '0', '9530', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Learning goals for week 5', '<ul><li>Understand hierarchical backbones and the devices they use <li>Understand flat backbones and the devices they use <li>Understand collapsed backbones and the devices they use <li>Understand VLANs and the devices they use <li>Be familiar with FDDI  <li>Be familiar with ATM <li>Understand the best practice recommendations for backbone design</ul> ', '', '', '', '', '0', '0', '9856', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2130', '6', 'Harware Layers: Metropolitan and Wide Area Networks -- Part 1', 'normal', 'TRUE', '6');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Quick Quiz', '', 'csg2130week6quiz.htm', '', '', '28 Kb', '1', '0', '8342', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Workshop 6', '', 'csg2130week6workshop.pdf', '', '', '49 Kb', '1', '0', '8543', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading for this week', 'Textbook: Chapter 6 Hardware Layers: Metropolitan and Wide Area Networks. Pages 172-191.', '', '', '', '', '1', '0', '8544', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'ASSESSMENT 1 DUE THIS WEEK', 'Make sure that you submit your Laboratory Report on the TCP/IP Exercise on time this week.', '', '', '', '', '0', '0', '8918', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Lecture--Hardware Layers: Metropolitan and Wide Area Networks--Part1', '', 'csg2130week6.ppt', '', '', '850 Kb', '1', '0', '9531', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Learning goals for week 6', '<ul><li>Understand circuit-switched services and topologies  <li>Understand PSTN architecture <li>Understand Analog transmission <li>Be familiar with Digital transmission of voice data <li>Understand the various methods of multiplexing</ul> ', '', '', '', '', '0', '0', '9857', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2130', '7', 'Harware Layers: Metropolitan and Wide Area Networks -- Part 2', 'normal', 'TRUE', '7');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Quick Quiz', '', 'csg2130week7quiz.htm', '', '', '24 Kb', '1', '0', '8343', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Workshop 7', '', 'csg2130workshopweek7.pdf', '', '', '305 Kb', '1', '0', '8545', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading for this week', 'Textbook: Chapter 6 Hardware Layers: Metropolitan and Wide Area Networks. Pages 191-215.', '', '', '', '', '1', '0', '8547', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Lecture-- Hardware Layers:Metropolitan and Wide Area Networks--Part 2', '', 'csg2130week7.ppt', '', '', '976 Kb', '1', '0', '9532', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Learning goals for week 7', '<ul><li>Understand dedicated-circuit services and topologies  <li>Understand packet-switched services and topologies  <li>Be familiar with virtual private network services and topologies <li>Understand the best practice recommendations for MAN/WAN design</ul> ', '', '', '', '', '0', '0', '9858', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2130', '9', 'The Internet', 'normal', 'TRUE', '11');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Quick Quiz', '', 'csg2130week8quiz.htm', '', '', '26 Kb', '1', '0', '8344', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Workshop 8', '', 'csg2130workshopweek8.pdf', '', '', '60 Kb', '1', '0', '8548', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading for this week', 'Textbook: Chapter 7 The Internet', '', '', '', '', '1', '0', '8549', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Lecture -- The Internet', '', 'csg2130week8.ppt', '', '', '1333 Kb', '1', '0', '9533', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Learning goals for week 8', '<ul> <li>Understand the overall design of the Internet <li>Understand DSL and cable modem  <li>Be familiar with wireless services <li>Be familiar with Internet 2</ul> ', '', '', '', '', '0', '0', '9859', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2130', '10', 'Hardware Layers: Wireless Local Area Networks', 'normal', 'TRUE', '12');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Quick Quiz', '', 'csg2130week9quiz.htm', '', '', '27 Kb', '1', '0', '8345', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Workshop 9', '', 'csg2130workshopweek9.pdf', '', '', '73 Kb', '1', '0', '8550', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading for this week', 'Textbook: Chapter 8 Hardware Layers: Wireless Local Area Networks', '', '', '', '', '1', '0', '8551', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'ASSESSMENT 2 DUE THIS WEEK', 'Make sure that you submit your Case Study report on time this week.', '', '', '', '', '0', '0', '8723', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Hardware Layers: Wireless Local Area Networks', '', 'csg2130week9.ppt', '', '', '1139 Kb', '1', '0', '9535', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Learning goals for week 9', '<ul> <li>Understand the major components of WLANs <li>Understand 802.11b WLANs <li>Understand 802.11a WLANs <li>Understand 802.11g WLANs <li>Be familiar with Bluetooth WLANs <li>Understand the best practice recommendations for WLAN design</ul> ', '', '', '', '', '0', '0', '9860', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblweek(week_no, unit_code, unit_week, we

insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2130', '11', 'Network Design', 'normal', 'TRUE', '13');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Quick Quiz', '', 'csg2130week10quiz.htm', '', '', '27 Kb', '1', '0', '8347', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Workshop 10', '', 'csg2130workshopweek10.pdf', '', '', '47 Kb', '1', '0', '8552', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading for this week', 'Textbook: Chapter 9 Network Design', '', '', '', '', '1', '0', '8553', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Lecture--Network Design', '', 'csg2130week10.ppt', '', '', '1117 Kb', '1', '0', '9536', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Learning goals for week 10', '<ul> <li>Be familiar with the overall process of design and implementing a network <li>Be familiar with techniques for developing a logical network design <li>Be familiar with techniques for developing a physical network design <li>Be familiar with network design principles</ul> ', '', '', '', '', '0', '0', '9861', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2130', '12', 'Network Security', 'normal', 'TRUE', '14');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Quick Quiz', '', 'csg2130week11quiz.htm', '', '', '26 Kb', '1', '0', '8348', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Workshop 11', '', 'csg2130workshopweek11.pdf', '', '', '70 Kb', '1', '0', '8554', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading for this week', 'Textbook: Chapter 10 Network Security', '', '', '', '', '1', '0', '8555', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Lecture--Network Security', '', 'csg2130week11.ppt', '', '', '1117 Kb', '1', '0', '9537', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Learning goals for week 11', '<ul> <li>Be familiar with the major threats to network security <li>Be familiar with how to conduct a risk assessment <li>Understand how to prevent, detect, and correct disruptions, destruction, and disaster <li>Understand how to prevent, detect, and correct unauthorized access</ul> ', '', '', '', '', '0', '0', '9863', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2130', '13', 'Network Management', 'normal', 'TRUE', '15');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Quick Quiz', '', 'csg2130week12quiz.htm', '', '', '26 Kb', '1', '0', '8349', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Workshop 12 --Revision', 'Your tutor will guide you through some revision activities and suggestions for exam preparation in the workshop.', '', '', '', '', '1', '0', '8556', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Reading for this week', 'Textbook: Chapter 11 Network Management', '', '', '', '', '1', '0', '8557', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Lecture--Network Management', '', 'csg2130week12.ppt', '', '', '895 Kb', '1', '0', '9538', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Learning goals for week 12', '<ul> <li>Understand what is required to manage the day-to-day operation of networks <li>Be familiar with the network management organization <li>Understand configuration management <li>Understand performance and fault management <li>Be familiar with end user support <li>Be familiar with cost management</ul> ', '', '', '', '', '0', '0', '9864', 'TRUE', '0', '000000', '0', '0', 'CSG2130');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2130', '14', 'SWOT VAC', 'exam', 'TRUE', '16');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Sample Exam Questions', 'The Quick quizzes provide you with good practice for multiple choice questions in the exam. Here are some other questions that provide practice short and essay style quuestions.', 'samplequestions.pdf', '', '', '53 Kb', '1', '0', '8463', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Study Week', '', '', '', '', '', '0', '0', '8963', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2130', '8', 'CATCH UP WEEK (ECU only)', 'normal', 'TRUE', '9');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'CATCH UP WEEK (ECU only)', '', '', '', '', '', '0', '0', '8961', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblweek(week_no, unit_code, unit_week, week_heading, week_type, visible, priority) values (NULL, 'CSG2130', '0', 'MID-SEMESTER BREAK', 'break', 'TRUE', '10');
select @week_no:= LAST_INSERT_ID();
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Study Week', '', '', '', '', '', '0', '0', '8461', 'TRUE', '0', '990000', '0', '0', 'CSG2130');
insert into tblobject (object_no, week_no, object_type, object_title, object_description, object_url, directory, url, size, heading_type, last_updated, priority, active, country, heading_colour, feedback_total, feedback_number, unit_code) values (NULL, @week_no, '', 'Study Week', '', '', '', '', '', '0', '0', '8962', 'TRUE', '0', '990000', '0', '0', 'CSG2130');

New comments have been added including creating scripts for a large set of data for testing.

Also, I am running mysqld, not Embedded server which I selected by mistake.

Sorry but I wasn't be able to repeat the behavior
reported having by cause the subquery stuff, below
the last lines of your test case (I issued several
times):

+-----------------------------+
| @week_no:= LAST_INSERT_ID() |
+-----------------------------+
|                       14350 |
+-----------------------------+
1 row in set (0.00 sec)

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.00 sec)

On another hand I guess that you are using any of the
below servers:

mysqld.exe, mysqld-opt.exe mysqld-max.exe

which presents a shutdown bug already reported and
for to get this behavior you don't need to do any
query, only issue a net start mysql followed
by net stop mysql for to get the service irresponsive
to shutdown for these servers:

c:\mysql\bin>net stop mysql
O serviço de MySql está sendo finalizado ...............................................
........................................................................................
........................................................................................
........................and so on.....

This bug will be fixed in the next release.

Thanks for giving it a go, it's a pity the results couldn't be replicated. The db, tables and data were not built from scripts, I simply copied the folder from a 4.0 database. I can only assume that this is not the cause. I shall attempt a complete scripted rebuild and report my results.

As a side note, I am using mysqld-max-nt.exe, however I had the same results with mysqld-nt.exe.

Thanks again,

James.

Ok, having inadvertantly left the query after it 'crashed', three minutes later it returned the correct results.

So, the subselect IS working, however, on that particular query it takes a minimum of about 3 minutes 20 seconds. I tried it a number of times, before and after doing a repair and optimize on the tables; same results, 3 minutes min.

Tests revealed that it is not a bug