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 Ret…

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 r…

Missing data on BETWEEN with MySQL

Questions

forums Heeft dit topic gesplitst 30 december 2022 om 18:08 5

Een bericht is gesplitst naar een nieuw topic: Itgenclr000 NullReferenceException

Topic		Antwoorden	Weergaven
Itgenrst004 : issue with UINT datatype between MySQL and SQL Server container with BULK INSERT after CREATE OR REPLACE Questions invantive-query-tool , mysql , sql-server	3	348	11 april 2024
Itgenclr000 NullReferenceException Questions mysql , invantive-sql	15	379	11 april 2024
Itgensql006: MAX and MIN operator with uint32 on @Mysql container not supported Questions invantive-psql , invantive-sql , mysql	4	266	11 april 2024
Invantive limits on WHERE IN () clause for performance optimizations Questions invantive-query-tool , invantive-sql	3	152	18 april 2024
Strange behaviour with data-type dates on Oracle resulting on failing to get the field value due to SET invantive-sql-correct-invalid-date Questions invantive-query-tool , oracle	9	1728	20 september 2023

Missing data on BETWEEN with MySQL

Gerelateerde topics