Hi, I have pentaho CE 8.1 with MySQL...I'm doing the tutorial from "Pentaho Data Integration - Beginners' Guide", chap 8 inserting new products or updating existing ones


In the Insert/Update step
At the moment of configuring the step and setting the fields to map, when clicking on "edit mapping" I've got the following error:
Couldn't get field info from [SELECT * FROM products LIMIT 0]
Error determining value metadata from SQL resultset metadata
Unknown system variable 'OPTION'

and asking for details I've got the log:
==============================

org.pentaho.di.core.exception.KettleException:
Unable to determine the required fields.


Couldn't get field info from [SELECT * FROM products LIMIT 0]




Error determining value metadata from SQL resultset metadata
Unknown system variable 'OPTION'






at org.pentaho.di.trans.steps.insertupdate.InsertUpdateMeta.getRequiredFields(InsertUpdateMeta.java:881)
at org.pentaho.di.ui.trans.steps.insertupdate.InsertUpdateDialog.generateMappings(InsertUpdateDialog.java:558)
at org.pentaho.di.ui.trans.steps.insertupdate.InsertUpdateDialog.access$200(InsertUpdateDialog.java:82)
at org.pentaho.di.ui.trans.steps.insertupdate.InsertUpdateDialog$4.handleEvent(InsertUpdateDialog.java:400)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at org.pentaho.di.ui.trans.steps.insertupdate.InsertUpdateDialog.open(InsertUpdateDialog.java:507)
at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:120)
at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8949)
at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3291)
at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:785)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1375)
at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:8104)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9466)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:701)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
Couldn't get field info from [SELECT * FROM products LIMIT 0]




Error determining value metadata from SQL resultset metadata
Unknown system variable 'OPTION'




at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2354)
at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2193)
at org.pentaho.di.core.database.Database.getQueryFields(Database.java:1847)
at org.pentaho.di.core.database.Database.getTableFields(Database.java:1843)
at org.pentaho.di.trans.steps.insertupdate.InsertUpdateMeta.getRequiredFields(InsertUpdateMeta.java:872)
... 28 more
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
Error determining value metadata from SQL resultset metadata
Unknown system variable 'OPTION'


at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromSQLType(ValueMetaBase.java:4881)
at org.pentaho.di.core.database.Database.getValueFromSQLType(Database.java:2439)
at org.pentaho.di.core.database.Database.getRowInfo(Database.java:2400)
at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2345)
... 32 more
Caused by: java.sql.SQLException: Unknown system variable 'OPTION'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
at com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1606)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1503)
at com.mysql.jdbc.ConnectionImpl.getMaxBytesPerChar(ConnectionImpl.java:3003)
at com.mysql.jdbc.Field.getMaxBytesPerCharacter(Field.java:602)
at com.mysql.jdbc.ResultSetMetaData.getColumnDisplaySize(ResultSetMetaData.java:213)
at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromSQLType(ValueMetaBase.java:4657)
... 35 more


==============================

I finished entering the transformation and run with the same result (error).

Any idea to solve it ? as I have not found the same problem

Thanks