[IGNITE-8948] Allow checking of LOGGING status via SQL/JDBC - ASF JIRA

Attach files

Attach Screenshot

Add vote

Voters

Watch issue

Watchers

Create sub-task

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: New Feature
Status: Open
Priority: Minor
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: None
Component/s: jdbc, sql
Labels:
None

Description

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 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.