View Issue Details

IDProjectCategoryView StatusLast Update
0003660SymmetricDSBugpublic2019-08-26 08:45
ReporteranchitancAssigned To 
Status closedResolutionopen 
Product Version3.9.9 
Target VersionFixed in Version 
Summary0003660: Initial Load with Order by in initial_load_select MSSQL
Descriptionsym_trigger_router table has initial_load_select = "1 = 1 order by t.CreationTime" which create query like below :-
select count(*) from "board"."dbo"."currencies" t where 1=1 order by t.CreationTime;

It works with MySQL but not with MSSQL because MSSQL does not support order by with count(*).

MSSQL gives :-
Column "board.dbo.currencies.creationtime" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.

its due to
as symmetricds 3.9 has removed sym_trigger_router.initial_load_batch_count.

Now what is workaround to ignore count(*) query for MSSQL for initial load?
Steps To Reproduceset initial_load_select = "1 = 1 order by <anycolumn>" in sym_trigger_router for mssql database.
Tagsdialect: sql-server, initial/partial load



2018-08-04 00:50

reporter   ~0001222

sorry, its not due to I have tried the same in 3.8, same issue there as well.
Problem is symmetricds drafting wrong query for MSSQL. in case of MSSQL there should be option to disable count(*) query if order by clause is used in initial_load_select.


2018-10-03 10:27

developer   ~0001251

Q: Is there a particular reason you need the initial load select to order the columns when doing the load?


2019-08-26 08:45

administrator   ~0001578

Auto closing all issues waiting for feedback after 4 months. We don't have enough information to take any action.

Issue History

Date Modified Username Field Change
2018-08-03 15:25 anchitanc New Issue
2018-08-03 15:25 anchitanc Tag Attached: mssql
2018-08-04 00:50 anchitanc Note Added: 0001222
2018-10-03 10:27 hanes Status new => feedback
2018-10-03 10:27 hanes Note Added: 0001251
2019-04-23 16:49 admin Tag Renamed mssql => dialect: mssql
2019-04-24 08:50 admin Tag Renamed dialect: mssql => dialect: sql-server
2019-04-24 14:40 elong Tag Attached: initial/partial load
2019-08-26 08:45 admin Note Added: 0001578
2019-08-26 08:45 admin Status feedback => closed