Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: unspecified
-
Fix Version/s: None
-
Component/s: Data Checker
-
Labels:None
-
Environment:
Operating System: Windows XP
Platform: PC
-
Bugzilla Id:3604
Description
--------------------------------------------------
Project: DataChecker
Component Used: ./generate-discrepancies.sh
Build: /var/local/builds/tsa-build-bidmgr-2010-03-09-p14-r25168
--------------------------------------------------
Its observed that after executing “./generate-discrepancies.sh -d3 -account 289
-distribution 3 -E 2010-02-02 -T 2010-03-02” for google, we are getting
following exception…
2010-03-09 05:14:31.387 (1) [main]: Exception [Error in
createTempTable2()]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException:
Unknown column 'google.conv' in 'field list'/
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)/
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)/
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)/
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)/
at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)/
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1316)/
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1235)/
Expected/Suggestions:
Better to have have sql file having alter statements (as Patch) with the build.
Also it will be great if user gets proper message for the exception.
