Bug #3764 in SQL Statements using 2 where condititions never return an result
Submitted: 14 May 2004 14:58 Modified: 14 May 2004 16:43
Reporter: Volker Schmidt Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.1.1 OS:Linux (linux 2.4.21)
Assigned to: CPU Architecture:Any

[14 May 2004 14:58] Volker Schmidt 
Description:
A combination of 2 where statments + 1 order statement does not work any more! No resultdata is given back. 

How to repeat:
The statement: 

SELECT *
FROM `Workflows` 
WHERE FlowTypeId = 12 and FlowActivationStatus > 0

returns 2 raws. Adding an order by clause like:

SELECT *
FROM `Workflows` 
WHERE FlowTypeId = 12 and FlowActivationStatus > 0
ORDER BY FlowId

gives no result ( any other order column doesn't work either ).

Taking one of the where statements away again gives the 2 columns result:
e.g. 
SELECT *
FROM `Workflows` 
WHERE FlowTypeId = 12 
ORDER BY FlowId

returns 2 columns again.

The underlying table:
# Host: parmos01
# Database: virago
# Table: 'Workflows'
# 
CREATE TABLE `Workflows` (
  `FlowTypeId` int(11) NOT NULL default '0',
  `FlowId` int(11) NOT NULL default '0',
  `FlowParentType` int(11) NOT NULL default '0',
  `FlowParentId` int(11) default '0',
  `FlowActivationStatus` int(11) NOT NULL default '0',
  `FlowLevel` int(11) NOT NULL default '0',
  `FlowSubLevel` int(11) NOT NULL default '0',
  `DateCreated` timestamp NOT NULL,
  `LastModified` timestamp NOT NULL,
  `LastLevelSwitch` timestamp NOT NULL,
  `OwnerId` int(11) NOT NULL default '0',
  `FlowProperties` text NOT NULL,
  `FlowData` text NOT NULL,
  `FlowLanguage` char(2) default 'en',
  `SessionKey` varchar(64) NOT NULL default 'none',
  PRIMARY KEY  (`FlowId`),
  KEY `ParentIndex` (`FlowParentId`),
  KEY `LoadIndex` (`FlowTypeId`,`FlowActivationStatus`)
) TYPE=MyISAM DEFAULT CHARSET=latin1; 

Analysing and repairing of the table have not shown any problems

Suggested fix:
?
[14 May 2004 15:29] Volker Schmidt 
using:
ORDER BY FlowTypeId, FlowId, FlowActivationStatus ASC

do work again!
[14 May 2004 16:43] Alexander Keremidarski 
Tested with current 4.1 source from BK tree (post 4.1.1).

All queries return exactly the same result with 1 row (which is correct).

There is something wrong with the report:

SELECT *
FROM `Workflows` 
WHERE FlowTypeId = 12 and FlowActivationStatus > 0

> returns 2 raws.
          ^^^^^^^

This is impossible because 
  PRIMARY KEY  (`FlowId`)
[14 May 2004 17:31] Volker Schmidt 
The case is correct. The unique key is FlowId but the selection had been made on FlowTypeId.
I attach a dump for testing:

-- MySQL dump 9.08
--
-- Host: localhost    Database: virago
---------------------------------------------------------
-- Server version	4.1.1-alpha-standard-log

--
-- Table structure for table 'Workflows'
--

DROP TABLE IF EXISTS Workflows;
CREATE TABLE Workflows (
  FlowTypeId int(11) NOT NULL default '0',
  FlowId int(11) NOT NULL default '0',
  FlowParentType int(11) NOT NULL default '0',
  FlowParentId int(11) default '0',
  FlowActivationStatus int(11) NOT NULL default '0',
  FlowLevel int(11) NOT NULL default '0',
  FlowSubLevel int(11) NOT NULL default '0',
  DateCreated timestamp NOT NULL,
  LastModified timestamp NOT NULL,
  LastLevelSwitch timestamp NOT NULL,
  OwnerId int(11) NOT NULL default '0',
  FlowProperties text NOT NULL,
  FlowData text NOT NULL,
  FlowLanguage char(2) default 'en',
  SessionKey varchar(64) NOT NULL default 'none',
  PRIMARY KEY  (FlowId),
  KEY ParentIndex (FlowParentId),
  KEY LoadIndex (FlowTypeId,FlowActivationStatus)
) TYPE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table 'Workflows'
--

INSERT INTO Workflows VALUES (2000,101539,-1,0,3,0,0,'2004-05-06 14:33:21','2004-05-14 12:29:35','0000-00-00 00:00:00',0,'¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0\0xsq\0~\0\0?@\0\0\0\0\0w\0\0\0\0\0\0t\0FalkImportExtraServicessr\0java.util.VectorÙ—}[€;¯\0I\0capacityIncrementI\0elementCount[\0elementDatat\0[Ljava/lang/Object;xp\0\0\0\0\0\0\0ur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0\nsr\03com.adpepper.virago.dataaccess.FlowServiceOfferLinkêª\\¿SWŒÄ\0I\0BoundToFlowLevelL\0\nServiceKeyt\0Ljava/lang/String;L\0ServiceNameq\0~\0\nxp\0\0\0\0t\0dc83462f4cae9bbct\0FalkImportExtraServicespppppppppxt\0\nFalkImportsq\0~\0\0\0\0\0\0\0\0uq\0~\0\0\0\0\nsq\0~\0	\0\0\0\0t\0fdbd31f03fb1a2f6t\0\nFalkImportsq\0~\0	\0\0\0\0t\0dd458e70999d8b32q\0~\0sq\0~\0	\0\0\0\0t\0daf9de6c17bcc856q\0~\0sq\0~\0	\0\0\0\0t\0b5e56e93d9f46e85q\0~\0ppppppxx','¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0DailyImportDatasr\0&com.adpepper.virago.general.ViragoKeysPå½û§ý€7\0[\0KeyArrayt\0[Ljava/lang/Object;xpur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0sr\0java.lang.Long;‹ä?Ì?#ß\0J\0valuexr\0java.lang.Number†¬•”à‹\0\0xp\0\0\0\0\0©çx','EN','dc83462f4cae9bbc');
INSERT INTO Workflows VALUES (2000,101541,-1,0,3,0,0,'2004-05-06 15:55:38','2004-05-14 12:29:35','0000-00-00 00:00:00',0,'¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0\0xsq\0~\0\0?@\0\0\0\0\0w\0\0\0\0\0\0t\0FalkImportExtraServicessr\0java.util.VectorÙ—}[€;¯\0I\0capacityIncrementI\0elementCount[\0elementDatat\0[Ljava/lang/Object;xp\0\0\0\0\0\0\0ur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0\nsr\03com.adpepper.virago.dataaccess.FlowServiceOfferLinkêª\\¿SWŒÄ\0I\0BoundToFlowLevelL\0\nServiceKeyt\0Ljava/lang/String;L\0ServiceNameq\0~\0\nxp\0\0\0\0t\09f2ca4921fae7cct\0FalkImportExtraServicespppppppppxt\0\nFalkImportsq\0~\0\0\0\0\0\0\0\0uq\0~\0\0\0\0\nsq\0~\0	\0\0\0\0t\0e1787046c8c8ad8at\0\nFalkImportsq\0~\0	\0\0\0\0t\0ebdb0208466cf3a1q\0~\0sq\0~\0	\0\0\0\0t\0d1a6c679192fa5b6q\0~\0sq\0~\0	\0\0\0\0t\02c37f3935edd9c89q\0~\0ppppppxx','¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0DailyImportDatasr\0&com.adpepper.virago.general.ViragoKeysPå½û§ý€7\0[\0KeyArrayt\0[Ljava/lang/Object;xpur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0sr\0java.lang.Long;‹ä?Ì?#ß\0J\0valuexr\0java.lang.Number†¬•”à‹\0\0xp\0\0\0\0\0©éx','EN','9f2ca4921fae7cc');
INSERT INTO Workflows VALUES (2000,101542,-1,0,3,1,0,'2004-05-06 16:25:31','2004-05-06 16:25:57','0000-00-00 00:00:00',0,'¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0\0xsq\0~\0\0?@\0\0\0\0\0w\0\0\0\0\0\0t\0FalkImportExtraServicessr\0java.util.VectorÙ—}[€;¯\0I\0capacityIncrementI\0elementCount[\0elementDatat\0[Ljava/lang/Object;xp\0\0\0\0\0\0\0ur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0\nsr\03com.adpepper.virago.dataaccess.FlowServiceOfferLinkêª\\¿SWŒÄ\0I\0BoundToFlowLevelL\0\nServiceKeyt\0Ljava/lang/String;L\0ServiceNameq\0~\0\nxp\0\0\0t\05d12f9414e3416a7t\0FalkImportExtraServicespppppppppxt\0\nFalkImportsq\0~\0\0\0\0\0\0\0\0uq\0~\0\0\0\0\nsq\0~\0	\0\0\0t\0dafd88b0cb8a84b7t\0\nFalkImportsq\0~\0	\0\0\0t\0ad08651cc5b785bq\0~\0sq\0~\0	\0\0\0t\092014cb5d8c536f5q\0~\0sq\0~\0	\0\0\0t\06baa1c1efc6e6adcq\0~\0ppppppxx','¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0DailyImportDatasr\0&com.adpepper.virago.general.ViragoKeysPå½û§ý€7\0[\0KeyArrayt\0[Ljava/lang/Object;xpur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0sr\0java.lang.Long;‹ä?Ì?#ß\0J\0valuexr\0java.lang.Number†¬•”à‹\0\0xp\0\0\0\0\0©êx','EN','5d12f9414e3416a7');
INSERT INTO Workflows VALUES (12,102919,-1,0,3,3,0,'2004-05-14 13:34:25','2004-05-14 13:35:03','0000-00-00 00:00:00',0,'¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0MissingApprovalssr\0(com.adpepper.virago.eval.rt.ViragoRTTint\0\0\0\Z!¢c\0I\0valuexr\0,com.adpepper.virago.eval.rt.ViragoRTTNumeric)S¼?ûc9\0\0xp\0\0\0\0t\0ContractNamesr\0+com.adpepper.virago.eval.rt.ViragoRTTString\0\0\0\Z!¢c\0L\0valuet\0Ljava/lang/String;xpt\0DE 03/04-4168 (iLead für BUZ)t\0currentFileNamesr\01com.adpepper.virago.eval.rt.ViragoRTTStringBuffer\0\0\0\Z!¢c\n\0L\0valuet\0Ljava/lang/StringBuffer;xpsr\0java.lang.StringBuffer/ÙêÈêÓ\0I\0countZ\0shared[\0valuet\0[Cxp\0\0\07\0ur\0[C°&f°â]„¬\0\0xp\0\0\0n\0d\0o\0c\0u\0m\0e\0n\0t\0s\0/\0o\0f\0f\0e\0r\0/\02\00\00\04\0/\00\05\0/\02\00\00\04\00\05\01\04\00\01\04\05\05\09\0_\0D\0E\00\03\0-\00\04\0-\04\01\06\08\0.\0p\0d\0f\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0xt\0pureFileNamesq\0~\0t\0DE03-04-4168.pdfxsq\0~\0\0?@\0\0\0\0\0w\0\0\0\0\0\0t\0Contractsr\0java.util.VectorÙ—}[€;¯\0I\0capacityIncrementI\0elementCount[\0elementDatat\0[Ljava/lang/Object;xp\0\0\0\0\0\0\0ur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0\nsr\03com.adpepper.virago.dataaccess.FlowServiceOfferLinkêª\\¿SWŒÄ\0I\0BoundToFlowLevelL\0\nServiceKeyq\0~\0L\0ServiceNameq\0~\0xp\0\0\0t\04845fc0d687ae91q\0~\0sq\0~\0\0\0\0t\066dd807aa9ba611aq\0~\0sq\0~\0\0\0\0t\0359d83b878d177b8q\0~\0sq\0~\0\0\0\0t\0f733075bd714a074q\0~\0sq\0~\0\0\0\0t\09fd71c4174d88383q\0~\0pppppxx','¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0SATCRsr\0&com.adpepper.virago.general.ViragoKeysPå½û§ý€7\0[\0KeyArrayt\0[Ljava/lang/Object;xpur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0sr\0java.lang.Long;‹ä?Ì?#ß\0J\0valuexr\0java.lang.Number†¬•”à‹\0\0xp\0\0\0\0\0¯Kx','de','ef2c9bca57694080');
INSERT INTO Workflows VALUES (2001,101546,-1,0,3,2,0,'2004-05-07 11:31:46','2004-05-07 11:45:49','0000-00-00 00:00:00',0,'¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0\0xsq\0~\0\0?@\0\0\0\0\0w\0\0\0\0\0\0t\0iLeadImportExtraServicessr\0java.util.VectorÙ—}[€;¯\0I\0capacityIncrementI\0elementCount[\0elementDatat\0[Ljava/lang/Object;xp\0\0\0\0\0\0\0ur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0\nsr\03com.adpepper.virago.dataaccess.FlowServiceOfferLinkêª\\¿SWŒÄ\0I\0BoundToFlowLevelL\0\nServiceKeyt\0Ljava/lang/String;L\0ServiceNameq\0~\0\nxp\0\0\0t\0e11e9a6ba32c6418t\0iLeadImportExtraServicespppppppppxx','¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0DailyImportDatasr\0&com.adpepper.virago.general.ViragoKeysPå½û§ý€7\0[\0KeyArrayt\0[Ljava/lang/Object;xpur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0sr\0java.lang.Long;‹ä?Ì?#ß\0J\0valuexr\0java.lang.Number†¬•”à‹\0\0xp\0\0\0\0\0©îx','EN','e11e9a6ba32c6418');
INSERT INTO Workflows VALUES (2000,101547,-1,0,3,1,0,'2004-05-07 11:48:39','2004-05-07 11:49:03','0000-00-00 00:00:00',0,'¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0\0xsq\0~\0\0?@\0\0\0\0\0w\0\0\0\0\0\0t\0FalkImportExtraServicessr\0java.util.VectorÙ—}[€;¯\0I\0capacityIncrementI\0elementCount[\0elementDatat\0[Ljava/lang/Object;xp\0\0\0\0\0\0\0ur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0\nsr\03com.adpepper.virago.dataaccess.FlowServiceOfferLinkêª\\¿SWŒÄ\0I\0BoundToFlowLevelL\0\nServiceKeyt\0Ljava/lang/String;L\0ServiceNameq\0~\0\nxp\0\0\0t\038a61c1c915ef848t\0FalkImportExtraServicespppppppppxt\0\nFalkImportsq\0~\0\0\0\0\0\0\0\0uq\0~\0\0\0\0\nsq\0~\0	\0\0\0t\0b0e56d1db9e72911t\0\nFalkImportsq\0~\0	\0\0\0t\0fbe91e3097cad6aaq\0~\0sq\0~\0	\0\0\0t\074fb54aa61d66d8aq\0~\0sq\0~\0	\0\0\0t\0246abd86492f1a3aq\0~\0ppppppxx','¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0DailyImportDatasr\0&com.adpepper.virago.general.ViragoKeysPå½û§ý€7\0[\0KeyArrayt\0[Ljava/lang/Object;xpur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0sr\0java.lang.Long;‹ä?Ì?#ß\0J\0valuexr\0java.lang.Number†¬•”à‹\0\0xp\0\0\0\0\0©ïx','EN','38a61c1c915ef848');
INSERT INTO Workflows VALUES (2000,101548,-1,0,3,1,0,'2004-05-11 14:29:23','2004-05-11 14:31:33','0000-00-00 00:00:00',0,'¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0\0xsq\0~\0\0?@\0\0\0\0\0w\0\0\0\0\0\0t\0FalkImportExtraServicessr\0java.util.VectorÙ—}[€;¯\0I\0capacityIncrementI\0elementCount[\0elementDatat\0[Ljava/lang/Object;xp\0\0\0\0\0\0\0ur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0\nsr\03com.adpepper.virago.dataaccess.FlowServiceOfferLinkêª\\¿SWŒÄ\0I\0BoundToFlowLevelL\0\nServiceKeyt\0Ljava/lang/String;L\0ServiceNameq\0~\0\nxp\0\0\0t\0aa2c2d737307efebt\0FalkImportExtraServicespppppppppxt\0\nFalkImportsq\0~\0\0\0\0\0\0\0\0uq\0~\0\0\0\0sq\0~\0	\0\0\0t\0656242b10f14ab9t\0\nFalkImportsq\0~\0	\0\0\0t\08b146a8c1abd289eq\0~\0sq\0~\0	\0\0\0t\09463626b71ce6630q\0~\0sq\0~\0	\0\0\0t\063e15c713d43ba32q\0~\0sq\0~\0	\0\0\0t\08d3ef85939c6a6c2q\0~\0sq\0~\0	\0\0\0t\0b2b5faa9e18fd190q\0~\0sq\0~\0	\0\0\0t\0a6e22416a4fc8a7fq\0~\0sq\0~\0	\0\0\0t\0f720f319c8cb4afq\0~\0sq\0~\0	\0\0\0t\0a75d7d75a82afe49q\0~\0sq\0~\0	\0\0\0t\05aafb57f9f0f516q\0~\0sq\0~\0	\0\0\0t\0910bf80c4440d0caq\0~\0sq\0~\0	\0\0\0t\07b68a3269ca7aca2q\0~\0ppppppppxx','¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0DailyImportDatasr\0&com.adpepper.virago.general.ViragoKeysPå½û§ý€7\0[\0KeyArrayt\0[Ljava/lang/Object;xpur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0sr\0java.lang.Long;‹ä?Ì?#ß\0J\0valuexr\0java.lang.Number†¬•”à‹\0\0xp\0\0\0\0\0©ðx','EN','aa2c2d737307efeb');
INSERT INTO Workflows VALUES (2000,101550,-1,0,3,0,0,'2004-05-11 14:30:38','2004-05-13 13:51:39','0000-00-00 00:00:00',0,'¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0\0xsq\0~\0\0?@\0\0\0\0\0w\0\0\0\0\0\0t\0FalkImportExtraServicessr\0java.util.VectorÙ—}[€;¯\0I\0capacityIncrementI\0elementCount[\0elementDatat\0[Ljava/lang/Object;xp\0\0\0\0\0\0\0ur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0\nsr\03com.adpepper.virago.dataaccess.FlowServiceOfferLinkêª\\¿SWŒÄ\0I\0BoundToFlowLevelL\0\nServiceKeyt\0Ljava/lang/String;L\0ServiceNameq\0~\0\nxp\0\0\0\0t\0a078a7081cfad7bct\0FalkImportExtraServicespppppppppxx','¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0DailyImportDatasr\0&com.adpepper.virago.general.ViragoKeysPå½û§ý€7\0[\0KeyArrayt\0[Ljava/lang/Object;xpur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0sr\0java.lang.Long;‹ä?Ì?#ß\0J\0valuexr\0java.lang.Number†¬•”à‹\0\0xp\0\0\0\0\0©òx','en','a078a7081cfad7bc');
INSERT INTO Workflows VALUES (2000,101549,-1,0,3,0,0,'2004-05-11 14:29:37','2004-05-13 13:51:39','0000-00-00 00:00:00',0,'¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0\0xsq\0~\0\0?@\0\0\0\0\0w\0\0\0\0\0\0t\0FalkImportExtraServicessr\0java.util.VectorÙ—}[€;¯\0I\0capacityIncrementI\0elementCount[\0elementDatat\0[Ljava/lang/Object;xp\0\0\0\0\0\0\0ur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0\nsr\03com.adpepper.virago.dataaccess.FlowServiceOfferLinkêª\\¿SWŒÄ\0I\0BoundToFlowLevelL\0\nServiceKeyt\0Ljava/lang/String;L\0ServiceNameq\0~\0\nxp\0\0\0\0t\0dd607bbf1fd5688t\0FalkImportExtraServicespppppppppxx','¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0DailyImportDatasr\0&com.adpepper.virago.general.ViragoKeysPå½û§ý€7\0[\0KeyArrayt\0[Ljava/lang/Object;xpur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0sr\0java.lang.Long;‹ä?Ì?#ß\0J\0valuexr\0java.lang.Number†¬•”à‹\0\0xp\0\0\0\0\0©ñx','en','dd607bbf1fd5688');
INSERT INTO Workflows VALUES (12,102918,-1,0,3,2,0,'2004-05-13 18:44:25','2004-05-13 18:47:16','0000-00-00 00:00:00',0,'¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0	minnetcplsr\0+com.adpepper.virago.eval.rt.ViragoRTTDouble\0\0\0\Z!¢c\0D\0valuexr\0,com.adpepper.virago.eval.rt.ViragoRTTNumeric)S¼?ûc9\0\0xp?ç\ZŸ¾vÈ´t\0ContractNamesr\0+com.adpepper.virago.eval.rt.ViragoRTTString\0\0\0\Z!¢c\0L\0valuet\0Ljava/lang/String;xpt\0/DE 03/04-4180 (Demo Campaign complex lead deal)t\0\nwatchemailsr\01com.adpepper.virago.eval.rt.ViragoRTTStringBuffer\0\0\0\Z!¢c\n\0L\0valuet\0Ljava/lang/StringBuffer;xpsr\0java.lang.StringBuffer/ÙêÈêÓ\0I\0countZ\0shared[\0valuet\0[Cxp\0\0\0\0ur\0[C°&f°â]„¬\0\0xp\0\0\0\"\0v\0s\0c\0h\0m\0i\0d\0t\0@\0a\0d\0p\0e\0p\0p\0e\0r\0.\0c\0o\0m\0 \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0xt\0SupervisorInfosr\0*com.adpepper.virago.eval.rt.ViragoRTTArray\0\0\0\Z!¢c\0Z\0isDereferingL\0mlengtht\0*Lcom/adpepper/virago/eval/rt/ViragoRTTint;L\0valuet\0Ljava/util/Hashtable;xp\0sr\0(com.adpepper.virago.eval.rt.ViragoRTTint\0\0\0\Z!¢c\0I\0valuexq\0~\0\0\0\0\0sq\0~\0\0?@\0\0\0\0\0w\0\0\0\0\0\0t\0thisq\0~\0t\0ebader@adpepper.comsq\0~\0\0sq\0~\0\0\0\0\0sq\0~\0\0?@\0\0\0\0\0w\0\0\0	\0\0\0	t\0Emailsq\0~\0q\0~\0t\0LastNamesq\0~\0t\0Badert\0Statussq\0~\0sq\0~\0\0\0\0,\0uq\0~\0\0\0\0T\0A\0p\0p\0r\0o\0v\0a\0l\0 \0R\0e\0q\0u\0e\0s\0t\0 \0s\0e\0n\0d\0e\0d\0:\0 \01\04\0.\00\05\0.\02\00\00\04\0 \01\00\0:\00\05\0:\01\05\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0xt\0UserIdsq\0~\0\0\0\0t\0	NumStatussq\0~\0\0\0\0\0q\0~\0q\0~\0t\0Reasonsq\0~\0t\0Sales Supervisort\0\nSessionKeysq\0~\0t\01870e6cfb5a08d59t\0	FirstNamesq\0~\0t\0	Eckerhardxxt\0eurorevenuesq\0~\0@¬ì™™™št\0currentFileNamesq\0~\0sq\0~\0\0\0\07\0uq\0~\0\0\0\0n\0d\0o\0c\0u\0m\0e\0n\0t\0s\0/\0o\0f\0f\0e\0r\0/\02\00\00\04\0/\00\03\0/\02\00\00\04\00\05\01\04\01\01\04\08\05\06\0_\0D\0E\00\03\0-\00\04\0-\04\01\08\00\0.\0p\0d\0f\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0xt\0	watchlistsq\0~\0\0sq\0~\0\0\0\0sq\0~\0\0?@\0\0\0\0\0w\0\0\0\0\0\0sr\0java.lang.Integerâ ¤÷?‡8\0I\0valuexr\0java.lang.Number†¬•”à‹\0\0xp\0\0\0sq\0~\0\0\0\0sq\0~\0A\0\0\0\0sq\0~\0\0\0\0q\0~\0q\0~\0>xt\0pureFileNamesq\0~\0t\0DE03-04-4180.pdft\0	minnetcpcsq\0~\0@øiÿ×\n=qt\0	minnetcpmsq\0~\0?Ç\ZŸ¾vÈ´t\0MissingApprovalssq\0~\0\0\0\0xsq\0~\0\0?@\0\0\0\0\0w\0\0\0\0\0\0t\0Contract_Supervisor_Oksr\0java.util.VectorÙ—}[€;¯\0I\0capacityIncrementI\0elementCount[\0elementDatat\0[Ljava/lang/Object;xp\0\0\0\0\0\0\0ur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0\nsr\03com.adpepper.virago.dataaccess.FlowServiceOfferLinkêª\\¿SWŒÄ\0I\0BoundToFlowLevelL\0\nServiceKeyq\0~\0L\0ServiceNameq\0~\0xp\0\0\0t\0c952db51afc9df1ct\0Contract_Supervisor_Oksq\0~\0W\0\0\0q\0~\03q\0~\0Zppppppppxx','¬í\0sr\0java.util.Hashtable»%!Jä¸\0F\0\nloadFactorI\0	thresholdxp?@\0\0\0\0\0w\0\0\0\0\0\0t\0SATCRsr\0&com.adpepper.virago.general.ViragoKeysPå½û§ý€7\0[\0KeyArrayt\0[Ljava/lang/Object;xpur\0[Ljava.lang.Object;?ÎXŸs)l\0\0xp\0\0\0sr\0java.lang.Long;‹ä?Ì?#ß\0J\0valuexr\0java.lang.Number†¬•”à‹\0\0xp\0\0\0\0\0¯Jx','de','627e5fd345f95168');
[14 May 2004 17:46] Volker Schmidt 
A dump of the table in question

Attachment: test.sql (text/plain), 16.34 KiB.