Version: 15.0.0-dev-262
Build #: 37648
Schema Script generator on Apache Derby Tables: Cannot convert types 'INTEGER' to 'VARCHAR'.
Database : Apache Derby all versions
To reproduce:
1. Open Apache Derby Schema Script Generator
2. Select all tables from the APP schema and script it.
You get below exception:
java.sql.SQLSyntaxErrorException: Cannot convert types 'INTEGER' to 'VARCHAR'.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.Statement.executeQuery(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.l⣻ꐇꌺ⠗ for final.executeQuery(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.vꆗꋢꃬꅛ public.b(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.vꆗꋢꃬꅛ public.b(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.vꆗꋢꃬꅛ public.b(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.vꆗꋢꃬꅛ public.b(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.bꃉꀵꆎ⡦ finally case.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.jꏘꀅᛕ⡮.c(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.jꏘꀅᛕ⡮.b(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.jꏘꀅᛕ⡮.run(Unknown Source)
Caused by: org.apache.derby.client.am.SqlException: Cannot convert types 'INTEGER' to 'VARCHAR'.
at org.apache.derby.client.am.Statement.completeSqlca(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown Source)
at org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown Source)
at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
at org.apache.derby.client.am.Statement.executeQueryX(Unknown Source)
... 10 more
this is reproducible with older versions but we are unable to reproduce this on current code... not sure what the cause or fix was