Ilya Kasnacheev created IGNITE-8948:
---------------------------------------
Summary: Allow checking of LOGGING status via SQL/JDBC
Key: IGNITE-8948
URL: https://issues.apache.org/jira/browse/IGNITE-8948
Project: Ignite
Issue Type: New Feature
Components: jdbc, sql
Reporter: Ilya Kasnacheev
It is now possible to enable/disable WAL via ALTER TABLE tblName
{LOGGING|NOLOGGING};
However, it's not possible to check current LOGGING status. It is desired that
this is available.
The suggested method is via [JDBC metadata
table|https://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getTables(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String[])]
info: right now we return null as REMARKS, but we could return the WITH "..."
string in REMARKS. Which will allow more introspection to JDBC clients. We
could store this line somewhere, or reconstruct it from scratch. And, we can
allow WITH "logging={true|false}" and return the current logging status in the
same fashion.
The problem here is that non-JDBC SQL clients still can't do that. So maybe we
need a dedicated statements for this eventually.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
