~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/r/execution_constants.result

  • Committer: Bazaar Package Importer
  • Author(s): Norbert Tretkowski
  • Date: 2010-03-17 14:56:02 UTC
  • Revision ID: james.westby@ubuntu.com-20100317145602-x7e30l1b2sb5s6w6
Tags: upstream-5.1.45
ImportĀ upstreamĀ versionĀ 5.1.45

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
CREATE TABLE `t_bug21476` (
 
2
`ID_BOARD` smallint(5) unsigned NOT NULL default '0',
 
3
`ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
 
4
`logTime` int(10) unsigned NOT NULL default '0',
 
5
`ID_MSG` mediumint(8) unsigned NOT NULL default '0',
 
6
PRIMARY KEY  (`ID_MEMBER`,`ID_BOARD`),
 
7
KEY `logTime` (`logTime`)
 
8
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_bulgarian_ci;
 
9
INSERT INTO `t_bug21476` VALUES (2,2,1154870939,0),(1,2,1154870957,0),(2,183,1154941362,0),(2,84,1154904301,0),(1,84,1154905867,0),(2,13,1154947484,10271),(3,84,1154880549,0),(1,6,1154892183,0),(2,25,1154947581,10271),(3,25,1154904760,0),(1,25,1154947373,10271),(1,179,1154899992,0),(2,179,1154899410,0),(5,25,1154901666,0),(2,329,1154902026,0),(3,329,1154902040,0),(1,329,1154902058,0),(1,13,1154930841,0),(3,85,1154904987,0),(1,183,1154929665,0),(3,13,1154931268,0),(1,85,1154936888,0),(1,169,1154937959,0),(2,169,1154941717,0),(3,183,1154939810,0),(3,169,1154941734,0);
 
10
Assertion: mysql_errno 1436 == 1436
 
11
DROP TABLE `t_bug21476`;
 
12
End of 5.0 tests.