Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Trivial
-
Resolution: Not a Bug
-
Affects Version/s: Mercury
-
Fix Version/s: Mercury
-
Component/s: Other / Misc.
-
Labels:None
-
Environment:
Tech Ops #743
-
Sprint:Sprint 9
Description
Google Data discrepancy script throws sql syntax error when there is no performance data in the tables.
[amlops@aml-qa4-monman1 DataChecker]$ ./AMLGetAllDataDiscrepencies.sh -h aml-qa4-mysql1
Spend Information (Warehouse, GoogleDC, GoogleMCC, GoogleMCCAdmax): 0:0:NULL:NULL
Runtime error (func=(main), adr=9): Divide by zero
GoogleDC - warehouse %: 0.00%
(standard_in) 1: illegal character: N
(standard_in) 1: illegal character: U
(standard_in) 1: illegal character: L
(standard_in) 1: illegal character: L
(standard_in) 1: syntax error
GooleDC - GoogleMCC %: 0.00%
(standard_in) 1: illegal character: N
(standard_in) 1: illegal character: U
(standard_in) 1: illegal character: L
(standard_in) 1: illegal character: L
(standard_in) 1: syntax error
GoogleDC - GoogleMCCAdmax %: 0.00%
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
searchEngineUID that need to resolved for discrepancy:
Expected Result: ERROR 1064 should not appear
