comment in explain clause is always null

10 views
Skip to first unread message

hosotaka

unread,
May 2, 2020, 10:05:36 PM5/2/20
to Xerial
hello.

comment in explain clause is always null.

it is bug?
                Connection connection = null;
               
try {
                        connection
= DriverManager.getConnection("jdbc:sqlite::memory:");
                       
Statement statement = connection.createStatement();

                       
ResultSet rs = statement.executeQuery("explain select 1 as b");
                       
while (rs.next()) {
                               
System.out.println("comment = " + rs.getString("comment"));
                       
}
               
} catch (SQLException e) {
                       
System.err.println(e.getMessage());
               
} finally {
                       
try {
                               
if (connection != null)
                                        connection
.close();
                       
} catch (SQLException e) {
                               
System.err.println(e.getMessage());
                       
}
               
}




thank you

hosotaka

unread,
May 3, 2020, 11:44:52 PM5/3/20
to Xerial

Was self resolved

I found that compile option.

thank you!
Reply all
Reply to author
Forward
0 new messages