Missing data on BETWEEN with MySQL

Questions
, ,
1

We are implementing a new sync between MySql and Microsoft SQL Server.

I am having difficulties with the BETWEEN Statement on Mysql container where Query Tool does return incorrect results.

The table contains a column with ID being an INT.

Results are returned by:

SELECT * from tbllog@Mysql

Returns one result:

select * from tbllog@Mysql WHERE ID = 1001

Returns 687 results:

select * from tbllog@Mysql WHERE ID BETWEEN 1 AND 5000

Returns no results, expectation is at least 687:

select * from tbllog@Mysql WHERE ID BETWEEN 1 AND 10000

Returns 50 results:

select * from tbllog@Mysql WHERE ID BETWEEN 1 AND 900

Returns no results, expectation is at least the 50 from the BETWEEN 1 AND 900:

select * from tbllog@Mysql WHERE ID BETWEEN 1 AND 1000
2

Can you provide the DDL create table-statement to create the tbllog table and a few insert statement to reproduce?

What release of Invantive SQL is being used?

3

Yes, sure. Version : Query Tool 22.0.455 PROD+3713

Script

Creation script with some data below.

Script 
-- --------------------------------------------------------
-- Host:                         172.22.50.1
-- Server version:               5.1.39-community - MySQL Community Server (GPL)
-- Server OS:                    Win32
-- HeidiSQL Version:             12.3.0.6589
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- Dumping database structure for ecat
CREATE DATABASE IF NOT EXISTS `ecat` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `ecat`;

-- Dumping structure for table ecat.tbllog
CREATE TABLE IF NOT EXISTS `tbllog` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `BeginVerbruik` int(11) DEFAULT '0',
  `EindVerbruik` int(11) DEFAULT '0',
  `GastID` int(11) DEFAULT '0',
  `LocatieID` int(11) DEFAULT '0',
  `KaartNummer` int(11) DEFAULT '0',
  `Result` int(11) DEFAULT '0',
  `BeginDatumTijd` datetime DEFAULT NULL,
  `EindDatumTijd` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `GastID` (`GastID`),
  KEY `LocatieID` (`LocatieID`),
  KEY `Result` (`Result`)
) ENGINE=InnoDB AUTO_INCREMENT=1493828 DEFAULT CHARSET=utf8;

-- Dumping data for table ecat.tbllog: ~385 536 rows (approximately)
REPLACE INTO `tbllog` (`ID`, `BeginVerbruik`, `EindVerbruik`, `GastID`, `LocatieID`, `KaartNummer`, `Result`, `BeginDatumTijd`, `EindDatumTijd`) VALUES
	(658, 0, 3, 0, 0, 0, 0, NULL, '2014-03-27 10:21:50'),
	(660, 0, 5, 0, 0, 0, 0, NULL, '2014-03-27 10:26:59'),
	(662, 0, 7, 0, 0, 0, 0, NULL, '2014-03-27 10:40:44'),
	(664, 0, 8, 0, 0, 0, 0, NULL, '2014-03-27 11:20:47'),
	(667, 0, 6, 0, 0, 0, 0, NULL, '2014-03-27 11:27:27'),
	(673, 0, 10479, 0, 0, 0, 0, NULL, '2014-03-27 12:05:13'),
	(682, 0, 20, 0, 0, 0, 0, NULL, '2014-03-27 15:26:24'),
	(686, 0, 749, 0, 0, 0, 0, NULL, '2014-03-28 09:03:27'),
	(690, 0, 679, 0, 0, 0, 0, NULL, '2014-03-28 11:02:05'),
	(697, 0, 1006, 0, 0, 0, 0, NULL, '2014-03-28 11:47:08'),
	(698, 0, 22, 0, 0, 0, 0, NULL, '2014-03-28 11:48:36'),
	(701, 0, 6, 0, 0, 0, 0, NULL, '2014-03-28 12:26:46'),
	(714, 0, 1, 0, 0, 0, 0, NULL, '2014-03-28 16:04:54'),
	(716, 0, 1, 0, 0, 0, 0, NULL, '2014-03-28 16:07:31'),
	(719, 0, 327, 0, 0, 0, 0, NULL, '2014-03-28 19:01:56'),
	(720, 0, 10015, 0, 0, 0, 0, NULL, '2014-03-29 09:38:53'),
	(723, 0, 1757, 0, 0, 0, 0, NULL, '2014-03-29 09:56:32'),
	(727, 0, 1769, 0, 0, 0, 0, NULL, '2014-03-29 09:59:03'),
	(729, 0, 1780, 0, 0, 0, 0, NULL, '2014-03-29 10:01:28'),
	(731, 0, 36890, 0, 0, 0, 0, NULL, '2014-03-29 11:12:17'),
	(734, 0, 7617, 0, 0, 0, 0, NULL, '2014-03-29 11:45:51'),
	(748, 0, 1, 0, 0, 0, 0, NULL, '2014-03-29 16:22:27'),
	(749, 0, 42, 0, 0, 0, 0, NULL, '2014-03-29 16:27:38'),
	(751, 0, 36890, 0, 0, 0, 0, NULL, '2014-03-29 17:05:23'),
	(765, 0, 9, 0, 0, 0, 0, NULL, '2014-03-29 18:42:41'),
	(769, 0, 9, 0, 0, 0, 0, NULL, '2014-03-29 18:52:06'),
	(772, 0, 169217, 0, 0, 0, 0, NULL, '2014-03-30 10:13:33'),
	(773, 0, 620, 0, 0, 0, 0, NULL, '2014-03-30 10:43:58'),
	(774, 0, 14039, 0, 0, 0, 0, NULL, '2014-03-30 10:59:05'),
	(775, 0, 1030, 0, 0, 0, 0, NULL, '2014-03-30 11:34:13'),
	(776, 0, 0, 0, 0, 0, 0, NULL, '2014-03-30 11:36:19'),
	(777, 0, 30889, 0, 0, 0, 0, NULL, '2014-03-30 12:30:28'),
	(781, 0, 397, 0, 0, 0, 0, NULL, '2014-03-30 13:07:11'),
	(784, 0, 4408, 0, 0, 0, 0, NULL, '2014-03-30 13:24:38'),
	(788, 0, 10291, 0, 0, 0, 0, NULL, '2014-03-30 14:36:09'),
	(793, 0, 23645, 0, 0, 0, 0, NULL, '2014-03-30 15:16:14'),
	(795, 0, 18836, 0, 0, 0, 0, NULL, '2014-03-30 16:31:36'),
	(807, 0, 7005, 0, 0, 0, 0, NULL, '2014-03-30 17:36:25'),
	(810, 0, 7686, 0, 0, 0, 0, NULL, '2014-03-31 10:33:04'),
	(814, 0, 6, 0, 0, 0, 0, NULL, '2014-03-31 13:38:12'),
	(819, 0, 12, 0, 0, 0, 0, NULL, '2014-03-31 15:38:20'),
	(823, 0, 183873, 0, 0, 0, 0, NULL, '2014-03-31 18:06:07'),
	(830, 0, 4190, 0, 0, 0, 0, NULL, '2014-04-01 15:53:38'),
	(864, 0, 1, 0, 0, 0, 0, NULL, '2014-04-02 13:05:33'),
	(868, 0, 1, 0, 0, 0, 0, NULL, '2014-04-02 13:24:25'),
	(871, 0, 1, 0, 0, 0, 0, NULL, '2014-04-02 13:26:20'),
	(873, 0, 1, 0, 0, 0, 0, NULL, '2014-04-02 13:28:36'),
	(875, 0, 1, 0, 0, 0, 0, NULL, '2014-04-02 13:29:50'),
	(893, 0, 1, 0, 0, 0, 0, NULL, '2014-04-02 14:19:53'),
	(899, 0, 1, 0, 0, 0, 0, NULL, '2014-04-02 15:02:21'),
	(904, 0, 254, 0, 0, 0, 0, NULL, '2014-04-02 16:06:52'),
	(909, 0, 1, 0, 0, 0, 0, NULL, '2014-04-02 18:16:59'),
	(910, 0, 1059, 0, 0, 0, 0, NULL, '2014-04-02 18:32:58'),
	(911, 0, 890, 0, 0, 0, 0, NULL, '2014-04-02 19:08:44'),
	(914, 0, 3, 0, 0, 0, 0, NULL, '2014-04-03 10:25:05'),
	(921, 0, 7732, 0, 0, 0, 0, NULL, '2014-04-03 14:26:06'),
	(922, 0, 17928, 0, 0, 0, 0, NULL, '2014-04-03 14:58:55'),
	(928, 0, 18562, 0, 0, 0, 0, NULL, '2014-04-03 15:48:49'),
	(930, 0, 7757, 0, 0, 0, 0, NULL, '2014-04-03 16:11:25'),
	(931, 0, 18910, 0, 0, 0, 0, NULL, '2014-04-03 16:17:39'),
	(933, 0, 19567, 0, 0, 0, 0, NULL, '2014-04-03 16:57:47'),
	(936, 0, 1971, 0, 0, 0, 0, NULL, '2014-04-03 17:06:14'),
	(939, 0, 7056, 0, 0, 0, 0, NULL, '2014-04-03 17:57:20'),
	(947, 0, 4408, 0, 0, 0, 0, NULL, '2014-04-04 12:06:00'),
	(949, 0, 4413, 0, 0, 0, 0, NULL, '2014-04-04 12:14:17'),
	(955, 0, 17, 0, 0, 0, 0, NULL, '2014-04-04 12:58:37'),
	(957, 0, 4414, 0, 0, 0, 0, NULL, '2014-04-04 13:24:31'),
	(963, 0, 25105, 0, 0, 0, 0, NULL, '2014-04-04 15:05:02'),
	(968, 0, 1, 0, 0, 0, 0, NULL, '2014-04-04 15:52:34'),
	(972, 0, 1, 0, 0, 0, 0, NULL, '2014-04-04 16:07:17'),
	(974, 0, 30696, 0, 0, 0, 0, NULL, '2014-04-04 17:03:20'),
	(976, 0, 4752, 0, 0, 0, 0, NULL, '2014-04-04 17:42:00'),
	(982, 0, 3, 0, 0, 0, 0, NULL, '2014-04-05 10:23:39'),
	(984, 0, 3, 0, 0, 0, 0, NULL, '2014-04-05 10:27:02'),
	(986, 0, 8951, 0, 0, 0, 0, NULL, '2014-04-05 11:10:19');
REPLACE INTO `tbllog` (`ID`, `BeginVerbruik`, `EindVerbruik`, `GastID`, `LocatieID`, `KaartNummer`, `Result`, `BeginDatumTijd`, `EindDatumTijd`) VALUES
	(987, 0, 2872, 0, 0, 0, 0, NULL, '2014-04-05 11:17:55'),
	(988, 0, 15392, 0, 0, 0, 0, NULL, '2014-04-05 11:20:41'),
	(989, 0, 31152, 0, 0, 0, 0, NULL, '2014-04-05 11:28:47'),
	(993, 0, 9334, 0, 0, 0, 0, NULL, '2014-04-05 12:12:30'),
	(995, 0, 9, 0, 0, 0, 0, NULL, '2014-04-05 12:15:14'),
	(999, 0, 10, 0, 0, 0, 0, NULL, '2014-04-05 12:17:20'),
	(1001, 0, 10, 0, 0, 0, 0, NULL, '2014-04-05 12:18:44'),
	(1004, 0, 434, 0, 0, 0, 0, NULL, '2014-04-05 13:10:17'),
	(1005, 0, 5530, 0, 0, 0, 0, NULL, '2014-04-05 13:15:40'),
	(1006, 0, 2557, 0, 0, 0, 0, NULL, '2014-04-05 13:24:57'),
	(1011, 0, 294, 0, 0, 0, 0, NULL, '2014-04-05 14:40:51'),
	(1012, 0, 6677, 0, 0, 0, 0, NULL, '2014-04-05 15:01:50'),
	(1014, 0, 7676, 0, 0, 0, 0, NULL, '2014-04-05 15:12:50'),
	(1016, 0, 2, 0, 0, 0, 0, NULL, '2014-04-05 15:14:37'),
	(1019, 0, 2, 0, 0, 0, 0, NULL, '2014-04-05 15:16:44'),
	(1026, 0, 824, 0, 0, 0, 0, NULL, '2014-04-05 15:21:01'),
	(1027, 0, 1761, 0, 0, 0, 0, NULL, '2014-04-05 15:34:39'),
	(1032, 0, 777, 0, 0, 0, 0, NULL, '2014-04-05 18:51:59'),
	(1034, 0, 4713, 0, 0, 0, 0, NULL, '2014-04-06 11:29:03'),
	(1035, 0, 224354, 0, 0, 0, 0, NULL, '2014-04-06 11:39:15'),
	(1037, 0, 54955, 0, 0, 0, 0, NULL, '2014-04-06 11:48:11'),
	(1038, 0, 2042, 0, 0, 0, 0, NULL, '2014-04-06 12:02:07'),
	(1043, 0, 407, 0, 0, 0, 0, NULL, '2014-04-06 14:38:43'),
	(1048, 0, 5110, 0, 0, 0, 0, NULL, '2014-04-06 15:07:12'),
	(1051, 0, 785, 0, 0, 0, 0, NULL, '2014-04-06 15:20:19'),
	(1054, 0, 17238, 0, 0, 0, 0, NULL, '2014-04-06 15:35:38'),
	(1055, 0, 254, 0, 0, 0, 0, NULL, '2014-04-06 15:36:07'),
	(1067, 0, 55, 0, 0, 0, 0, NULL, '2014-04-06 17:08:06'),
	(1075, 0, 2, 0, 0, 0, 0, NULL, '2014-04-06 17:36:59'),
	(1077, 0, 54978, 0, 0, 0, 0, NULL, '2014-04-06 17:46:58'),
	(1078, 0, 586, 0, 0, 0, 0, NULL, '2014-04-06 18:26:52'),
	(1088, 0, 33989, 0, 0, 0, 0, NULL, '2014-04-08 15:40:13'),
	(1092, 0, 11944, 0, 0, 0, 0, NULL, '2014-04-09 11:08:12'),
	(1094, 0, 5015, 0, 0, 0, 0, NULL, '2014-04-09 11:47:43'),
	(1100, 0, 777, 0, 0, 0, 0, NULL, '2014-04-09 12:10:51'),
	(1102, 0, 777, 0, 0, 0, 0, NULL, '2014-04-09 12:14:32'),
	(1104, 0, 777, 0, 0, 0, 0, NULL, '2014-04-09 12:18:16'),
	(1106, 0, 777, 0, 0, 0, 0, NULL, '2014-04-09 12:29:48'),
	(1113, 0, 777, 0, 0, 0, 0, NULL, '2014-04-09 12:35:53'),
	(1115, 0, 1, 0, 0, 0, 0, NULL, '2014-04-09 12:40:06'),
	(1126, 0, 1900, 0, 0, 0, 0, NULL, '2014-04-09 16:29:44'),
	(1130, 0, 97, 0, 0, 0, 0, NULL, '2014-04-09 20:02:50'),
	(1131, 0, 6220, 0, 0, 0, 0, NULL, '2014-04-10 08:45:26'),
	(1134, 0, 15365, 0, 0, 0, 0, NULL, '2014-04-10 11:26:28'),
	(1135, 0, 3469, 0, 0, 0, 0, NULL, '2014-04-10 11:30:51'),
	(1136, 0, 260018, 0, 0, 0, 0, NULL, '2014-04-10 11:41:27'),
	(1138, 0, 19883, 0, 0, 0, 0, NULL, '2014-04-10 13:13:54'),
	(1142, 0, 3626, 0, 0, 0, 0, NULL, '2014-04-10 15:34:39'),
	(1143, 0, 8785, 0, 0, 0, 0, NULL, '2014-04-10 20:38:36'),
	(1147, 0, 8785, 0, 0, 0, 0, NULL, '2014-04-11 09:18:51'),
	(1150, 0, 8785, 0, 0, 0, 0, NULL, '2014-04-11 09:23:42'),
	(1163, 0, 9588, 0, 0, 0, 0, NULL, '2014-04-11 14:16:35'),
	(1164, 0, 19446, 0, 0, 0, 0, NULL, '2014-04-11 14:33:45'),
	(1167, 0, 21442, 0, 0, 0, 0, NULL, '2014-04-11 15:25:42'),
	(1170, 0, 61784, 0, 0, 0, 0, NULL, '2014-04-11 15:37:07'),
	(1173, 0, 8263, 0, 0, 0, 0, NULL, '2014-04-11 16:21:10'),
	(1178, 0, 9604, 0, 0, 0, 0, NULL, '2014-04-11 16:59:23'),
	(1181, 0, 14228, 0, 0, 0, 0, NULL, '2014-04-11 18:19:39'),
	(1183, 0, 10047, 0, 0, 0, 0, NULL, '2014-04-12 08:41:53'),
	(1186, 0, 3, 0, 0, 0, 0, NULL, '2014-04-12 09:52:34'),
	(1192, 0, 56620, 0, 0, 0, 0, NULL, '2014-04-12 10:46:20'),
	(1195, 0, 7142, 0, 0, 0, 0, NULL, '2014-04-12 10:52:00'),
	(1198, 0, 3877, 0, 0, 0, 0, NULL, '2014-04-12 11:13:36'),
	(1199, 0, 5323, 0, 0, 0, 0, NULL, '2014-04-12 11:26:19'),
	(1200, 0, 2033, 0, 0, 0, 0, NULL, '2014-04-12 11:35:51'),
	(1202, 0, 4842, 0, 0, 0, 0, NULL, '2014-04-12 12:01:11'),
	(1204, 0, 480, 0, 0, 0, 0, NULL, '2014-04-12 12:42:38'),
	(1212, 0, 1354, 0, 0, 0, 0, NULL, '2014-04-12 13:21:36'),
	(1214, 0, 16846, 0, 0, 0, 0, NULL, '2014-04-12 13:29:21'),
	(1216, 0, 3979, 0, 0, 0, 0, NULL, '2014-04-12 13:37:39'),
	(1227, 0, 2622, 0, 0, 0, 0, NULL, '2014-04-12 14:40:04'),
	(1228, 0, 10374, 0, 0, 0, 0, NULL, '2014-04-12 14:44:09'),
	(1233, 0, 475, 0, 0, 0, 0, NULL, '2014-04-12 15:12:50'),
	(1238, 0, 2522, 0, 0, 0, 0, NULL, '2014-04-12 15:33:11');
REPLACE INTO `tbllog` (`ID`, `BeginVerbruik`, `EindVerbruik`, `GastID`, `LocatieID`, `KaartNummer`, `Result`, `BeginDatumTijd`, `EindDatumTijd`) VALUES
	(1242, 0, 3817, 0, 0, 0, 0, NULL, '2014-04-12 16:01:18'),
	(1256, 0, 15856, 0, 0, 0, 0, NULL, '2014-04-13 11:27:32'),
	(1265, 0, 4936, 0, 0, 0, 0, NULL, '2014-04-13 13:04:20'),
	(1267, 0, 23980, 0, 0, 0, 0, NULL, '2014-04-13 13:16:04'),
	(1278, 0, 55, 0, 0, 0, 0, NULL, '2014-04-13 13:46:19'),
	(1279, 0, 3, 0, 0, 0, 0, NULL, '2014-04-13 13:48:01'),
	(1294, 0, 170, 0, 0, 0, 0, NULL, '2014-04-13 16:00:46'),
	(1296, 0, 498, 0, 0, 0, 0, NULL, '2014-04-13 16:20:38'),
	(1299, 0, 3817, 0, 0, 0, 0, NULL, '2014-04-14 12:22:36'),
	(1305, 0, 11533, 0, 0, 0, 0, NULL, '2014-04-15 15:14:43'),
	(1306, 0, 301519, 0, 0, 0, 0, NULL, '2014-04-15 18:17:15'),
	(1312, 0, 28137, 0, 0, 0, 0, NULL, '2014-04-16 10:09:50'),
	(1314, 0, 1, 0, 0, 0, 0, NULL, '2014-04-16 10:33:18'),
	(1316, 0, 15325, 0, 0, 0, 0, NULL, '2014-04-16 10:56:05'),
	(1319, 0, 4687, 0, 0, 0, 0, NULL, '2014-04-16 11:22:01'),
	(1320, 0, 16960, 0, 0, 0, 0, NULL, '2014-04-16 11:42:27'),
	(1326, 0, 2, 0, 0, 0, 0, NULL, '2014-04-16 13:44:55'),
	(1327, 0, 190, 0, 0, 0, 0, NULL, '2014-04-16 13:53:40'),
	(1331, 0, 1348, 0, 0, 0, 0, NULL, '2014-04-16 14:12:25'),
	(1333, 0, 1348, 0, 0, 0, 0, NULL, '2014-04-16 14:19:32'),
	(1335, 0, 1350, 0, 0, 0, 0, NULL, '2014-04-16 14:23:30'),
	(1337, 0, 1351, 0, 0, 0, 0, NULL, '2014-04-16 14:25:13'),
	(1340, 0, 288, 0, 0, 0, 0, NULL, '2014-04-16 14:26:38'),
	(1343, 0, 15220, 0, 0, 0, 0, NULL, '2014-04-16 16:29:58'),
	(1345, 0, 2393, 0, 0, 0, 0, NULL, '2014-04-16 17:42:57'),
	(1347, 0, 22083, 0, 0, 0, 0, NULL, '2014-04-16 18:41:29'),
	(1348, 0, 6848, 0, 0, 0, 0, NULL, '2014-04-16 18:42:51'),
	(1349, 0, 4552, 0, 0, 0, 0, NULL, '2014-04-16 18:42:54'),
	(1350, 0, 3686, 0, 0, 0, 0, NULL, '2014-04-16 18:43:28'),
	(1351, 0, 7248, 0, 0, 0, 0, NULL, '2014-04-16 18:44:11'),
	(1352, 0, 6440, 0, 0, 0, 0, NULL, '2014-04-16 18:46:54'),
	(1353, 0, 12017, 0, 0, 0, 0, NULL, '2014-04-16 18:50:49'),
	(1354, 0, 13247, 0, 0, 0, 0, NULL, '2014-04-16 18:59:33'),
	(1355, 0, 311629, 0, 0, 0, 0, NULL, '2014-04-16 19:06:15'),
	(1363, 0, 22101, 0, 0, 0, 0, NULL, '2014-04-17 09:13:39'),
	(1366, 0, 7686, 0, 0, 0, 0, NULL, '2014-04-17 09:51:53'),
	(1368, 0, 7686, 0, 0, 0, 0, NULL, '2014-04-17 09:52:49'),
	(1370, 0, 7686, 0, 0, 0, 0, NULL, '2014-04-17 09:54:37'),
	(1373, 0, 6635, 0, 0, 0, 0, NULL, '2014-04-17 09:57:11'),
	(1388, 0, 29779, 0, 0, 0, 0, NULL, '2014-04-17 10:32:54'),
	(1391, 0, 2144, 0, 0, 0, 0, NULL, '2014-04-17 10:37:43'),
	(1405, 0, 29779, 0, 0, 0, 0, NULL, '2014-04-17 11:16:41'),
	(1418, 0, 4, 0, 0, 0, 0, NULL, '2014-04-17 11:42:16'),
	(1426, 0, 1, 0, 0, 0, 0, NULL, '2014-04-17 12:24:59'),
	(1430, 0, 1, 0, 0, 0, 0, NULL, '2014-04-17 12:26:46'),
	(1432, 0, 1, 0, 0, 0, 0, NULL, '2014-04-17 12:28:33'),
	(1434, 0, 1, 0, 0, 0, 0, NULL, '2014-04-17 12:33:46'),
	(1458, 0, 1317, 0, 0, 0, 0, NULL, '2014-04-17 13:53:08'),
	(1459, 0, 179, 0, 0, 0, 0, NULL, '2014-04-17 13:53:30'),
	(1463, 0, 22992, 0, 0, 0, 0, NULL, '2014-04-17 14:05:22'),
	(1470, 0, 65923, 0, 0, 0, 0, NULL, '2014-04-17 14:26:20'),
	(1473, 0, 8589, 0, 0, 0, 0, NULL, '2014-04-17 14:30:42'),
	(1475, 0, 325, 0, 0, 0, 0, NULL, '2014-04-17 15:45:44'),
	(1478, 0, 3234, 0, 0, 0, 0, NULL, '2014-04-17 17:18:15'),
	(1479, 0, 44170, 0, 0, 0, 0, NULL, '2014-04-17 18:07:44'),
	(1485, 0, 1, 0, 0, 0, 0, NULL, '2014-04-17 22:09:58'),
	(1486, 0, 7224, 0, 0, 0, 0, NULL, '2014-04-17 22:18:39'),
	(1487, 0, 7950, 0, 0, 0, 0, NULL, '2014-04-17 22:18:51'),
	(1489, 0, 1, 0, 0, 0, 0, NULL, '2014-04-17 22:22:34'),
	(1493, 0, 1, 0, 0, 0, 0, NULL, '2014-04-18 09:11:09'),
	(1495, 0, 1, 0, 0, 0, 0, NULL, '2014-04-18 09:32:55'),
	(1500, 0, 27359, 0, 0, 0, 0, NULL, '2014-04-18 11:08:16'),
	(1503, 0, 772, 0, 0, 0, 0, NULL, '2014-04-18 12:20:34'),
	(1506, 0, 6601, 0, 0, 0, 0, NULL, '2014-04-18 12:49:31'),
	(1523, 0, 8204, 0, 0, 0, 0, NULL, '2014-04-18 21:31:55'),
	(1524, 0, 29106, 0, 0, 0, 0, NULL, '2014-04-19 09:20:39'),
	(1526, 0, 2811, 0, 0, 0, 0, NULL, '2014-04-19 10:13:46'),
	(1527, 0, 4783, 0, 0, 0, 0, NULL, '2014-04-19 10:41:19'),
	(1528, 0, 5961, 0, 0, 0, 0, NULL, '2014-04-19 10:49:40'),
	(1529, 0, 10123, 0, 0, 0, 0, NULL, '2014-04-19 11:04:55'),
	(1530, 0, 9703, 0, 0, 0, 0, NULL, '2014-04-19 11:09:01'),
	(1531, 0, 2296, 0, 0, 0, 0, NULL, '2014-04-19 11:09:08'),
	(1533, 0, 10199, 0, 0, 0, 0, NULL, '2014-04-19 11:19:46'),
	(1535, 0, 6321, 0, 0, 0, 0, NULL, '2014-04-19 11:37:58');
REPLACE INTO `tbllog` (`ID`, `BeginVerbruik`, `EindVerbruik`, `GastID`, `LocatieID`, `KaartNummer`, `Result`, `BeginDatumTijd`, `EindDatumTijd`) VALUES
	(1537, 0, 1, 0, 0, 0, 0, NULL, '2014-04-19 11:39:24'),
	(1538, 0, 20146, 0, 0, 0, 0, NULL, '2014-04-19 11:40:48'),
	(1539, 0, 15330, 0, 0, 0, 0, NULL, '2014-04-19 11:43:13'),
	(1541, 0, 8834, 0, 0, 0, 0, NULL, '2014-04-19 11:47:33'),
	(1543, 0, 18532, 0, 0, 0, 0, NULL, '2014-04-19 12:20:26'),
	(1545, 0, 12151, 0, 0, 0, 0, NULL, '2014-04-19 12:23:26'),
	(1546, 0, 49557, 0, 0, 0, 0, NULL, '2014-04-19 12:34:09'),
	(1547, 0, 9909, 0, 0, 0, 0, NULL, '2014-04-19 12:49:47'),
	(1549, 0, 20173, 0, 0, 0, 0, NULL, '2014-04-19 13:13:10'),
	(1551, 0, 23118, 0, 0, 0, 0, NULL, '2014-04-19 13:14:45'),
	(1552, 0, 1, 0, 0, 0, 0, NULL, '2014-04-19 13:15:54'),
	(1553, 0, 17384, 0, 0, 0, 0, NULL, '2014-04-19 13:23:32'),
	(1555, 0, 11525, 0, 0, 0, 0, NULL, '2014-04-19 13:55:06'),
	(1557, 0, 6623, 0, 0, 0, 0, NULL, '2014-04-19 14:33:38'),
	(1560, 0, 7667, 0, 0, 0, 0, NULL, '2014-04-19 14:55:42'),
	(1561, 0, 4845, 0, 0, 0, 0, NULL, '2014-04-19 15:15:26'),
	(1565, 0, 10617, 0, 0, 0, 0, NULL, '2014-04-19 15:40:59'),
	(1569, 0, 1816, 0, 0, 0, 0, NULL, '2014-04-19 17:33:41'),
	(1570, 0, 12494, 0, 0, 0, 0, NULL, '2014-04-19 17:47:04'),
	(1578, 0, 19, 0, 0, 0, 0, NULL, '2014-04-20 09:36:53'),
	(1580, 0, 10903, 0, 0, 0, 0, NULL, '2014-04-20 09:59:02'),
	(1581, 0, 3159, 0, 0, 0, 0, NULL, '2014-04-20 10:25:26'),
	(1582, 0, 16693, 0, 0, 0, 0, NULL, '2014-04-20 10:30:57'),
	(1585, 0, 5866, 0, 0, 0, 0, NULL, '2014-04-20 11:14:28'),
	(1586, 0, 118, 0, 0, 0, 0, NULL, '2014-04-20 11:28:12'),
	(1587, 0, 5199, 0, 0, 0, 0, NULL, '2014-04-20 11:28:36'),
	(1589, 0, 13392, 0, 0, 0, 0, NULL, '2014-04-20 11:55:24'),
	(1590, 0, 8649, 0, 0, 0, 0, NULL, '2014-04-20 12:12:08'),
	(1591, 0, 4797, 0, 0, 0, 0, NULL, '2014-04-20 12:40:37'),
	(1594, 0, 15198, 0, 0, 0, 0, NULL, '2014-04-20 13:54:33'),
	(1598, 0, 2580, 0, 0, 0, 0, NULL, '2014-04-20 14:34:40'),
	(1600, 0, 300, 0, 0, 0, 0, NULL, '2014-04-20 15:03:31'),
	(1601, 0, 15497, 0, 0, 0, 0, NULL, '2014-04-20 15:05:53'),
	(1602, 0, 21166, 0, 0, 0, 0, NULL, '2014-04-20 15:12:45'),
	(1614, 0, 20065, 0, 0, 0, 0, NULL, '2014-04-20 18:05:53'),
	(1615, 0, 8274, 0, 0, 0, 0, NULL, '2014-04-20 18:28:56'),
	(1617, 0, 571, 0, 0, 0, 0, NULL, '2014-04-20 20:02:12'),
	(1619, 0, 14445, 0, 0, 0, 0, NULL, '2014-04-21 09:30:37'),
	(1621, 0, 35391, 0, 0, 0, 0, NULL, '2014-04-21 10:43:34'),
	(1642, 0, 15166, 0, 0, 0, 0, NULL, '2014-04-21 17:08:22'),
	(1645, 0, 4083, 0, 0, 0, 0, NULL, '2014-04-22 10:49:54'),
	(1649, 0, 22783, 0, 0, 0, 0, NULL, '2014-04-22 12:16:30'),
	(1662, 0, 27432, 0, 0, 0, 0, NULL, '2014-04-23 08:09:37'),
	(1670, 0, 6076, 0, 0, 0, 0, NULL, '2014-04-23 10:38:01'),
	(1671, 0, 79252, 0, 0, 0, 0, NULL, '2014-04-23 10:46:03'),
	(1680, 0, 787, 0, 0, 0, 0, NULL, '2014-04-23 12:36:53'),
	(1684, 0, 6025, 0, 0, 0, 0, NULL, '2014-04-23 15:17:26'),
	(1705, 0, 7842, 0, 0, 0, 0, NULL, '2014-04-23 18:31:29'),
	(1706, 0, 100703, 0, 0, 0, 0, NULL, '2014-04-23 18:36:22'),
	(1707, 0, 12355, 0, 0, 0, 0, NULL, '2014-04-23 18:37:47'),
	(1708, 0, 8836, 0, 0, 0, 0, NULL, '2014-04-23 18:41:27'),
	(1709, 0, 30365, 0, 0, 0, 0, NULL, '2014-04-23 18:42:08'),
	(1710, 0, 8198, 0, 0, 0, 0, NULL, '2014-04-23 18:43:48'),
	(1711, 0, 8093, 0, 0, 0, 0, NULL, '2014-04-23 18:50:39'),
	(1712, 0, 111150, 0, 0, 0, 0, NULL, '2014-04-23 18:56:56'),
	(1713, 0, 13123, 0, 0, 0, 0, NULL, '2014-04-23 18:58:32'),
	(1714, 0, 15937, 0, 0, 0, 0, NULL, '2014-04-23 18:58:51'),
	(1715, 0, 349711, 0, 0, 0, 0, NULL, '2014-04-23 18:59:35'),
	(1716, 0, 19420, 0, 0, 0, 0, NULL, '2014-04-23 19:03:26'),
	(1717, 0, 3686, 0, 0, 0, 0, NULL, '2014-04-23 19:08:31'),
	(1723, 0, 2719, 0, 0, 0, 0, NULL, '2014-04-23 22:01:01'),
	(1731, 0, 8201, 0, 0, 0, 0, NULL, '2014-04-23 22:08:36'),
	(1745, 0, 100730, 0, 0, 0, 0, NULL, '2014-04-23 22:29:54'),
	(1767, 0, 8363, 0, 0, 0, 0, NULL, '2014-04-24 13:57:27'),
	(1778, 0, 2120, 0, 0, 0, 0, NULL, '2014-04-24 16:32:46'),
	(1781, 0, 386, 0, 0, 0, 0, NULL, '2014-04-24 17:58:05'),
	(1783, 0, 76746, 0, 0, 0, 0, NULL, '2014-04-25 06:03:22'),
	(1784, 0, 26917, 0, 0, 0, 0, NULL, '2014-04-25 09:40:56'),
	(1787, 0, 12071, 0, 0, 0, 0, NULL, '2014-04-25 11:17:06'),
	(1792, 0, 21294, 0, 0, 0, 0, NULL, '2014-04-25 13:18:44'),
	(1793, 0, 660, 0, 0, 0, 0, NULL, '2014-04-25 13:49:29'),
	(1797, 0, 12648, 0, 0, 0, 0, NULL, '2014-04-25 14:10:22'),
	(1798, 0, 2623, 0, 0, 0, 0, NULL, '2014-04-25 14:17:39');
REPLACE INTO `tbllog` (`ID`, `BeginVerbruik`, `EindVerbruik`, `GastID`, `LocatieID`, `KaartNummer`, `Result`, `BeginDatumTijd`, `EindDatumTijd`) VALUES
	(1799, 0, 12115, 0, 0, 0, 0, NULL, '2014-04-25 14:20:31'),
	(1802, 0, 5286, 0, 0, 0, 0, NULL, '2014-04-25 14:40:27'),
	(1816, 0, 3283, 0, 0, 0, 0, NULL, '2014-04-25 17:01:45'),
	(1828, 0, 14973, 0, 0, 0, 0, NULL, '2014-04-26 08:22:26'),
	(1830, 0, 33184, 0, 0, 0, 0, NULL, '2014-04-26 09:17:23'),
	(1831, 0, 3830, 0, 0, 0, 0, NULL, '2014-04-26 09:23:10'),
	(1834, 0, 14830, 0, 0, 0, 0, NULL, '2014-04-26 10:20:10'),
	(1838, 0, 39653, 0, 0, 0, 0, NULL, '2014-04-26 10:41:47'),
	(1839, 0, 6685, 0, 0, 0, 0, NULL, '2014-04-26 10:43:53'),
	(1845, 0, 24881, 0, 0, 0, 0, NULL, '2014-04-26 10:58:57'),
	(1846, 0, 70942, 0, 0, 0, 0, NULL, '2014-04-26 11:02:55'),
	(1847, 0, 1936, 0, 0, 0, 0, NULL, '2014-04-26 11:31:10'),
	(1851, 0, 6173, 0, 0, 0, 0, NULL, '2014-04-26 11:34:09'),
	(1852, 0, 13487, 0, 0, 0, 0, NULL, '2014-04-26 11:37:54'),
	(1855, 0, 289, 0, 0, 0, 0, NULL, '2014-04-26 12:05:34'),
	(1856, 0, 5015, 0, 0, 0, 0, NULL, '2014-04-26 12:17:25'),
	(1857, 0, 49009, 0, 0, 0, 0, NULL, '2014-04-26 12:20:58'),
	(1863, 0, 15772, 0, 0, 0, 0, NULL, '2014-04-26 12:23:10'),
	(1864, 0, 7837, 0, 0, 0, 0, NULL, '2014-04-26 12:24:51'),
	(1870, 0, 189, 0, 0, 0, 0, NULL, '2014-04-26 12:37:07'),
	(1874, 0, 32854, 0, 0, 0, 0, NULL, '2014-04-26 12:50:28'),
	(1877, 0, 7495, 0, 0, 0, 0, NULL, '2014-04-26 12:54:31'),
	(1880, 0, 6686, 0, 0, 0, 0, NULL, '2014-04-26 13:20:47'),
	(1893, 0, 6688, 0, 0, 0, 0, NULL, '2014-04-26 13:54:22'),
	(1901, 0, 6689, 0, 0, 0, 0, NULL, '2014-04-26 13:57:52'),
	(1911, 0, 22778, 0, 0, 0, 0, NULL, '2014-04-26 14:33:49'),
	(1912, 0, 386, 0, 0, 0, 0, NULL, '2014-04-26 14:47:01'),
	(1938, 0, 1, 0, 0, 0, 0, NULL, '2014-04-26 16:18:47'),
	(1969, 0, 21150, 0, 0, 0, 0, NULL, '2014-04-27 09:36:07'),
	(1970, 0, 7179, 0, 0, 0, 0, NULL, '2014-04-27 10:32:29'),
	(1980, 0, 2, 0, 0, 0, 0, NULL, '2014-04-27 14:29:49'),
	(2006, 0, 9606, 0, 0, 0, 0, NULL, '2014-04-27 15:54:33'),
	(2014, 0, 7239, 0, 0, 0, 0, NULL, '2014-04-27 16:33:26'),
	(2021, 0, 14769, 0, 0, 0, 0, NULL, '2014-04-27 17:45:18'),
	(2024, 0, 7409, 0, 0, 0, 0, NULL, '2014-04-27 17:56:27'),
	(2037, 0, 2843, 0, 0, 0, 0, NULL, '2014-04-27 19:08:41'),
	(2142, 0, 20436, 0, 0, 0, 0, NULL, '2014-04-28 10:01:27'),
	(2143, 0, 27904, 0, 0, 0, 0, NULL, '2014-04-28 11:46:58'),
	(2146, 0, 5752, 0, 0, 0, 0, NULL, '2014-04-28 13:14:52'),
	(2147, 0, 1872, 0, 0, 0, 0, NULL, '2014-04-28 13:55:21'),
	(2157, 0, 23113, 0, 0, 0, 0, NULL, '2014-04-28 14:35:33'),
	(2158, 0, 24842, 0, 0, 0, 0, NULL, '2014-04-28 14:50:37'),
	(2159, 0, 43912, 0, 0, 0, 0, NULL, '2014-04-28 15:19:26'),
	(2160, 0, 631, 0, 0, 0, 0, NULL, '2014-04-28 15:50:52'),
	(2178, 0, 376620, 0, 0, 0, 0, NULL, '2014-04-28 18:14:08'),
	(2184, 0, 12137, 0, 0, 0, 0, NULL, '2014-04-29 11:19:31'),
	(2185, 0, 32415, 0, 0, 0, 0, NULL, '2014-04-29 11:43:57'),
	(2188, 0, 2673, 0, 0, 0, 0, NULL, '2014-04-29 15:36:29'),
	(2210, 0, 12450, 0, 0, 0, 0, NULL, '2014-04-30 12:18:14'),
	(2211, 0, 722, 0, 0, 0, 0, NULL, '2014-04-30 13:14:45'),
	(2214, 0, 3284, 0, 0, 0, 0, NULL, '2014-04-30 15:19:20'),
	(2225, 0, 3286, 0, 0, 0, 0, NULL, '2014-04-30 16:22:26'),
	(2228, 0, 3287, 0, 0, 0, 0, NULL, '2014-04-30 16:42:09'),
	(2240, 0, 4678, 0, 0, 0, 0, NULL, '2014-04-30 18:28:38'),
	(2242, 0, 11091, 0, 0, 0, 0, NULL, '2014-04-30 18:32:07'),
	(2243, 0, 31541, 0, 0, 0, 0, NULL, '2014-04-30 18:35:34'),
	(2244, 0, 9505, 0, 0, 0, 0, NULL, '2014-04-30 18:36:38'),
	(2245, 0, 8537, 0, 0, 0, 0, NULL, '2014-04-30 18:36:55'),
	(2246, 0, 14576, 0, 0, 0, 0, NULL, '2014-04-30 18:45:23'),
	(2247, 0, 16110, 0, 0, 0, 0, NULL, '2014-04-30 18:56:28'),
	(2248, 0, 35344, 0, 0, 0, 0, NULL, '2014-04-30 18:58:16'),
	(2249, 0, 1, 0, 0, 0, 0, NULL, '2014-04-30 19:00:31'),
	(2250, 0, 395450, 0, 0, 0, 0, NULL, '2014-04-30 19:01:39'),
	(2277, 0, 9, 0, 0, 0, 0, NULL, '2014-05-01 09:04:17'),
	(2281, 0, 13, 0, 0, 0, 0, NULL, '2014-05-01 09:06:42'),
	(2285, 0, 16, 0, 0, 0, 0, NULL, '2014-05-01 09:08:37'),
	(2289, 0, 16, 0, 0, 0, 0, NULL, '2014-05-01 09:11:19'),
	(2293, 0, 16, 0, 0, 0, 0, NULL, '2014-05-01 09:19:25'),
	(2298, 0, 55133, 0, 0, 0, 0, NULL, '2014-05-01 10:47:23'),
	(2299, 0, 54736, 0, 0, 0, 0, NULL, '2014-05-01 10:49:06'),
	(2300, 0, 16414, 0, 0, 0, 0, NULL, '2014-05-01 10:57:50'),
	(2303, 0, 16414, 0, 0, 0, 0, NULL, '2014-05-01 11:05:49'),
	(2307, 0, 8330, 0, 0, 0, 0, NULL, '2014-05-01 11:08:08'),
	(2308, 0, 12587, 0, 0, 0, 0, NULL, '2014-05-01 11:08:32');
REPLACE INTO `tbllog` (`ID`, `BeginVerbruik`, `EindVerbruik`, `GastID`, `LocatieID`, `KaartNummer`, `Result`, `BeginDatumTijd`, `EindDatumTijd`) VALUES
	(2309, 0, 5151, 0, 0, 0, 0, NULL, '2014-05-01 12:21:15'),
	(2319, 0, 29687, 0, 0, 0, 0, NULL, '2014-05-01 13:34:40'),
	(2321, 0, 7522, 0, 0, 0, 0, NULL, '2014-05-01 14:04:30'),
	(2322, 0, 150, 0, 0, 0, 0, NULL, '2014-05-01 15:08:46'),
	(2342, 0, 962, 0, 0, 0, 0, NULL, '2014-05-01 18:19:19'),
	(2354, 0, 48460, 0, 0, 0, 0, NULL, '2014-05-01 19:09:14'),
	(2363, 0, 1, 0, 0, 0, 0, NULL, '2014-05-01 20:13:21'),
	(2368, 0, 33242, 0, 0, 0, 0, NULL, '2014-05-02 09:28:04'),
	(2369, 0, 36954, 0, 0, 0, 0, NULL, '2014-05-02 10:21:38'),
	(2415, 0, 3606, 0, 0, 0, 0, NULL, '2014-05-02 15:35:15'),
	(2442, 0, 52652, 0, 0, 0, 0, NULL, '2014-05-02 16:51:24'),
	(2450, 0, 7584, 0, 0, 0, 0, NULL, '2014-05-02 18:00:16'),
	(2454, 0, 19909, 0, 0, 0, 0, NULL, '2014-05-02 19:32:33'),
	(2457, 0, 12653, 0, 0, 0, 0, NULL, '2014-05-02 19:56:07'),
	(2491, 0, 11325, 0, 0, 0, 0, NULL, '2014-05-03 07:11:29'),
	(2492, 0, 6318, 0, 0, 0, 0, NULL, '2014-05-03 08:36:39'),
	(2496, 0, 5, 0, 0, 0, 0, NULL, '2014-05-03 09:17:28'),
	(2502, 0, 7389, 0, 0, 0, 0, NULL, '2014-05-03 09:40:20'),
	(2514, 0, 103338, 0, 0, 0, 0, NULL, '2014-05-03 10:16:17'),
	(2518, 0, 28682, 0, 0, 0, 0, NULL, '2014-05-03 10:56:31'),
	(2519, 0, 6492, 0, 0, 0, 0, NULL, '2014-05-03 11:06:01'),
	(2526, 0, 568, 0, 0, 0, 0, NULL, '2014-05-03 12:11:51'),
	(2527, 0, 7229, 0, 0, 0, 0, NULL, '2014-05-03 12:13:08'),
	(2528, 0, 31577, 0, 0, 0, 0, NULL, '2014-05-03 12:17:15'),
	(2535, 0, 15852, 0, 0, 0, 0, NULL, '2014-05-03 12:25:41'),
	(2536, 0, 2495, 0, 0, 0, 0, NULL, '2014-05-03 13:02:34'),
	(2538, 0, 1381, 0, 0, 0, 0, NULL, '2014-05-03 13:17:27'),
	(2539, 0, 91906, 0, 0, 0, 0, NULL, '2014-05-03 13:25:05'),
	(2554, 0, 656, 0, 0, 0, 0, NULL, '2014-05-03 14:29:31'),
	(2566, 0, 3945, 0, 0, 0, 0, NULL, '2014-05-03 14:54:07'),
	(2569, 0, 8009, 0, 0, 0, 0, NULL, '2014-05-03 15:19:33'),
	(2577, 0, 1134, 0, 0, 0, 0, NULL, '2014-05-03 15:54:09'),
	(2603, 0, 20181, 0, 0, 0, 0, NULL, '2014-05-03 17:15:13'),
	(2610, 0, 1011, 0, 0, 0, 0, NULL, '2014-05-03 18:43:32'),
	(2628, 0, 3125, 0, 0, 0, 0, NULL, '2014-05-04 10:41:32'),
	(2630, 0, 61614, 0, 0, 0, 0, NULL, '2014-05-04 11:08:37'),
	(2631, 0, 8603, 0, 0, 0, 0, NULL, '2014-05-04 11:30:17'),
	(2634, 0, 1202, 0, 0, 0, 0, NULL, '2014-05-04 11:36:26'),
	(2644, 0, 12536, 0, 0, 0, 0, NULL, '2014-05-04 13:11:14'),
	(2649, 0, 1936, 0, 0, 0, 0, NULL, '2014-05-04 13:27:37'),
	(2682, 0, 50013, 0, 0, 0, 0, NULL, '2014-05-04 16:11:24'),
	(2683, 0, 3787, 0, 0, 0, 0, NULL, '2014-05-04 16:11:56'),
	(2702, 0, 1, 0, 0, 0, 0, NULL, '2014-05-04 16:22:36'),
	(2703, 0, 3787, 0, 0, 0, 0, NULL, '2014-05-04 16:22:55'),
	(2712, 0, 13949, 0, 0, 0, 0, NULL, '2014-05-04 17:23:01'),
	(2721, 0, 31800, 0, 0, 0, 0, NULL, '2014-05-04 18:00:53'),
	(2723, 0, 3393, 0, 0, 0, 0, NULL, '2014-05-04 18:13:51'),
	(2749, 0, 4276, 0, 0, 0, 0, NULL, '2014-05-05 09:10:21'),
	(2755, 0, 6138, 0, 0, 0, 0, NULL, '2014-05-05 10:06:44'),
	(2762, 0, 2, 0, 0, 0, 0, NULL, '2014-05-05 10:57:09'),
	(2765, 0, 5262, 0, 0, 0, 0, NULL, '2014-05-05 11:36:21'),
	(2767, 0, 10215, 0, 0, 0, 0, NULL, '2014-05-05 11:44:35'),
	(2769, 0, 729, 0, 0, 0, 0, NULL, '2014-05-05 12:43:38'),
	(2775, 0, 6098, 0, 0, 0, 0, NULL, '2014-05-05 13:48:41'),
	(2783, 0, 202884, 0, 0, 0, 0, NULL, '2014-05-05 14:01:11'),
	(2789, 0, 4851, 0, 0, 0, 0, NULL, '2014-05-05 15:17:55'),
	(2793, 0, 3287, 0, 0, 0, 0, NULL, '2014-05-05 15:59:40'),
	(2796, 0, 3287, 0, 0, 0, 0, NULL, '2014-05-05 16:03:07'),
	(2809, 0, 3306, 0, 0, 0, 0, NULL, '2014-05-05 17:10:14'),
	(2810, 0, 10227, 0, 0, 0, 0, NULL, '2014-05-05 17:11:42'),
	(2821, 0, 420390, 0, 0, 0, 0, NULL, '2014-05-05 17:59:46'),
	(2849, 0, 1095, 0, 0, 0, 0, NULL, '2014-05-06 12:49:08'),
	(2855, 0, 47740, 0, 0, 0, 0, NULL, '2014-05-06 14:39:17'),
	(2870, 0, 22661, 0, 0, 0, 0, NULL, '2014-05-07 09:01:57'),
	(2882, 0, 6417, 0, 0, 0, 0, NULL, '2014-05-07 16:09:32'),
	(2890, 0, 9, 0, 0, 0, 0, NULL, '2014-05-07 16:41:26'),
	(2894, 0, 9240, 0, 0, 0, 0, NULL, '2014-05-07 18:25:32'),
	(2895, 0, 435728, 0, 0, 0, 0, NULL, '2014-05-07 18:34:54'),
	(2896, 0, 15549, 0, 0, 0, 0, NULL, '2014-05-07 18:37:21'),
	(2897, 0, 10246, 0, 0, 0, 0, NULL, '2014-05-07 18:39:49'),
	(2898, 0, 18284, 0, 0, 0, 0, NULL, '2014-05-07 18:42:43'),
	(2899, 0, 1715, 0, 0, 0, 0, NULL, '2014-05-07 18:48:23'),
	(2900, 0, 64622, 0, 0, 0, 0, NULL, '2014-05-07 18:49:08'),
	(2901, 0, 16619, 0, 0, 0, 0, NULL, '2014-05-07 18:50:26');
REPLACE INTO `tbllog` (`ID`, `BeginVerbruik`, `EindVerbruik`, `GastID`, `LocatieID`, `KaartNummer`, `Result`, `BeginDatumTijd`, `EindDatumTijd`) VALUES
	(2902, 0, 7545, 0, 0, 0, 0, NULL, '2014-05-07 18:53:55'),
	(2903, 0, 8187, 0, 0, 0, 0, NULL, '2014-05-07 18:56:55'),
	(2904, 0, 13222, 0, 0, 0, 0, NULL, '2014-05-07 18:58:04'),
	(2905, 0, 27707, 0, 0, 0, 0, NULL, '2014-05-07 19:03:11'),
	(2906, 0, 7985, 0, 0, 0, 0, NULL, '2014-05-07 19:09:43'),
	(2936, 0, 116109, 0, 0, 0, 0, NULL, '2014-05-08 08:41:17'),
	(2941, 0, 13177, 0, 0, 0, 0, NULL, '2014-05-08 14:40:45'),
	(2952, 0, 14696, 0, 0, 0, 0, NULL, '2014-05-09 11:39:12'),
	(2968, 0, 6220, 0, 0, 0, 0, NULL, '2014-05-09 13:48:55'),
	(2976, 0, 27589, 0, 0, 0, 0, NULL, '2014-05-09 14:56:29'),
	(2986, 0, 15887, 0, 0, 0, 0, NULL, '2014-05-09 20:15:05'),
	(2995, 0, 1202, 0, 0, 0, 0, NULL, '2014-05-09 22:11:48'),
	(2998, 0, 1210, 0, 0, 0, 0, NULL, '2014-05-09 22:45:42'),
	(3001, 0, 1219, 0, 0, 0, 0, NULL, '2014-05-10 00:03:54'),
	(3007, 0, 1229, 0, 0, 0, 0, NULL, '2014-05-10 00:06:38'),
	(3010, 0, 7142, 0, 0, 0, 0, NULL, '2014-05-10 10:05:31'),
	(3011, 0, 31255, 0, 0, 0, 0, NULL, '2014-05-10 10:53:54'),
	(3024, 0, 208, 0, 0, 0, 0, NULL, '2014-05-10 14:39:52'),
	(3030, 0, 208, 0, 0, 0, 0, NULL, '2014-05-10 14:43:44'),
	(3033, 0, 208, 0, 0, 0, 0, NULL, '2014-05-10 14:47:03'),
	(3039, 0, 27595, 0, 0, 0, 0, NULL, '2014-05-10 16:13:41'),
	(3049, 0, 2330, 0, 0, 0, 0, NULL, '2014-05-11 12:06:45'),
	(3070, 0, 7911, 0, 0, 0, 0, NULL, '2014-05-12 14:44:11'),
	(3076, 0, 6946, 0, 0, 0, 0, NULL, '2014-05-13 08:21:27'),
	(3077, 0, 9973, 0, 0, 0, 0, NULL, '2014-05-13 09:53:35'),
	(3078, 0, 80229, 0, 0, 0, 0, NULL, '2014-05-13 10:35:36'),
	(3079, 0, 12264, 0, 0, 0, 0, NULL, '2014-05-13 11:41:25'),
	(3080, 0, 28872, 0, 0, 0, 0, NULL, '2014-05-13 11:56:44'),
	(3090, 0, 10720, 0, 0, 0, 0, NULL, '2014-05-13 14:07:04'),
	(3093, 0, 28890, 0, 0, 0, 0, NULL, '2014-05-13 15:14:06'),
	(3097, 0, 28907, 0, 0, 0, 0, NULL, '2014-05-13 15:20:00'),
	(3103, 0, 28909, 0, 0, 0, 0, NULL, '2014-05-13 15:31:06'),
	(3106, 0, 28911, 0, 0, 0, 0, NULL, '2014-05-13 15:33:16'),
	(3109, 0, 28911, 0, 0, 0, 0, NULL, '2014-05-13 15:35:36'),
	(3110, 0, 5482, 0, 0, 0, 0, NULL, '2014-05-13 15:54:58'),
	(3119, 0, 470764, 0, 0, 0, 0, NULL, '2014-05-13 17:20:21'),
	(3120, 0, 11688, 0, 0, 0, 0, NULL, '2014-05-13 17:30:48'),
	(3133, 0, 2144, 0, 0, 0, 0, NULL, '2014-05-14 11:36:16'),
	(3148, 0, 76888, 0, 0, 0, 0, NULL, '2014-05-14 16:07:56'),
	(3151, 0, 17702, 0, 0, 0, 0, NULL, '2014-05-14 17:53:17'),
	(3155, 0, 19891, 0, 0, 0, 0, NULL, '2014-05-14 18:34:18'),
	(3156, 0, 15181, 0, 0, 0, 0, NULL, '2014-05-14 18:36:57'),
	(3157, 0, 24521, 0, 0, 0, 0, NULL, '2014-05-14 18:37:40'),
	(3158, 0, 11566, 0, 0, 0, 0, NULL, '2014-05-14 18:41:24'),
	(3159, 0, 9490, 0, 0, 0, 0, NULL, '2014-05-14 18:49:17'),
	(3160, 0, 18908, 0, 0, 0, 0, NULL, '2014-05-14 18:51:42'),
	(3161, 0, 481195, 0, 0, 0, 0, NULL, '2014-05-14 18:54:07'),
	(3162, 0, 11879, 0, 0, 0, 0, NULL, '2014-05-14 18:55:42'),
	(3163, 0, 22798, 0, 0, 0, 0, NULL, '2014-05-14 18:58:31'),
	(3164, 0, 36323, 0, 0, 0, 0, NULL, '2014-05-14 18:59:39'),
	(3165, 0, 11319, 0, 0, 0, 0, NULL, '2014-05-14 19:00:29'),
	(3166, 0, 28745, 0, 0, 0, 0, NULL, '2014-05-14 19:06:58'),
	(3196, 0, 120569, 0, 0, 0, 0, NULL, '2014-05-15 10:16:03'),
	(3197, 0, 8289, 0, 0, 0, 0, NULL, '2014-05-15 10:32:20'),
	(3198, 0, 8189, 0, 0, 0, 0, NULL, '2014-05-15 11:00:22'),
	(3373, 0, 5482, 0, 0, 0, 0, NULL, '2014-05-15 14:10:42'),
	(3494, 0, 4347, 0, 0, 0, 0, NULL, '2014-05-15 15:51:50'),
	(3619, 0, 8293, 0, 0, 0, 0, NULL, '2014-05-15 18:18:36'),
	(3632, 0, 45452, 0, 0, 0, 0, NULL, '2014-05-16 10:47:39'),
	(3635, 0, 2495, 0, 0, 0, 0, NULL, '2014-05-16 11:12:26'),
	(3636, 0, 5862, 0, 0, 0, 0, NULL, '2014-05-16 11:27:02'),
	(3640, 0, 47118, 0, 0, 0, 0, NULL, '2014-05-16 12:22:12'),
	(3641, 0, 19718, 0, 0, 0, 0, NULL, '2014-05-16 12:22:24'),
	(3645, 0, 7229, 0, 0, 0, 0, NULL, '2014-05-16 13:10:43'),
	(3648, 0, 13482, 0, 0, 0, 0, NULL, '2014-05-16 13:49:54'),
	(3661, 0, 62265, 0, 0, 0, 0, NULL, '2014-05-16 14:53:30'),
	(3662, 0, 32238, 0, 0, 0, 0, NULL, '2014-05-16 15:02:33'),
	(3693, 0, 2330, 0, 0, 0, 0, NULL, '2014-05-16 20:20:51'),
	(3705, 0, 67145, 0, 0, 0, 0, NULL, '2014-05-17 08:22:21'),
	(3706, 0, 1586, 0, 0, 0, 0, NULL, '2014-05-17 08:25:23'),
	(3707, 0, 505739, 0, 0, 0, 0, NULL, '2014-05-17 08:33:25'),
	(3708, 0, 14172, 0, 0, 0, 0, NULL, '2014-05-17 08:35:30'),
	(3709, 0, 7811, 0, 0, 0, 0, NULL, '2014-05-17 08:51:30');

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
4

I am having similar issue with the following request:

select *
from   tbllog@catserver T 
where  T.ID > 1 
AND    T.ID < 1000

0 results are returned whereas it should return 81 rows.

5

Een bericht is gesplitst naar een nieuw topic: Itgenclr000 NullReferenceException

6

The following query directly on MySQL Workbench returns indeed 81 rows:

select *
from   tbllog T 
where  T.ID > 1 
AND    T.ID < 1000

On BETA 22.1.107, the query above returns no rows. However, the following query returns 517 rows:

select *
from   tbllog@mysql T

The following query returns 81 rows:

select *
from   tbllog@mysql T 
where  to_number(to_char(T.ID)) > 1 
AND    to_number(to_char(T.ID)) < 1000

The use of to_number and to_char effectively disables server-side filtering.

Funny enough, the following query returns 80 rows in Invantive SQL:

select *
from   tbllog@mysql T 
where  T.ID > 1
and    T.ID < 999

Which might be a hint that the column ID is handled as a text field instead of a number.

A describe of tbllog however shows an int as resolved data type:

image

A query on gass usage however works fine returning the expected number of 6 rows:

select beginverbruik
,      eindverbruik
from   tbllog@mysql T 
where  eindverbruik > 1
and    eindverbruik < 3

The cause was found to be an incorrect comparison of unsigned integers after applying server-side filtering. The cause was not server-side filtering; server-side filtering nicely applied an efficient filter.

A fix has been created and will be made available in all releases starting 22.0.479. This release will be available in the course of the first week of 2023.

Thanks for reporting the problem.

7

Hi,

now it works like a charm with 22.0.480-PROD.

thanks !

1 like