SQL in Config.ConfigFile returns with fatal error
Hello,
I tested the query on the Config.ConfigFile table of the Namespace %SYS, it returned 3 lines and a fatal error:
SELECT
*
FROM Config.ConfigFile.png)
I tested the same query on other IRIS instances (including a 2021.1 instance) and got the same error.
Is it a bug in IRIS or is there something wrong with the installations?
Anyone who can test and leave in the answers if they got the same result, I would be grateful.
Thank you for your attention.
Comments
Choose Logical Mode in dropdown near the Query Builder. Perhaps IRIS SQL tries to do some Logical -> Display conversion and fails.
Logical mode worked without any problems, thanks.
But it looks like an IRIS bug anyway.
It's possible. Please report it to WRC.
That looks strange. If you execute the query via JDBC the error ist the same. A CAST to the same datatype as provided from Config.ConfigFile works:
SELECT CAST(IDASVARCHAR(512)),CAST(CPFNameASVARCHAR(255)),CAST(CommentsASVARCHAR(4096)),CAST(NameASVARCHAR(64)),CAST(ProductASVARCHAR(64)),CAST(SectionHeaderASVARCHAR(255)),CAST(VersionASVARCHAR(7))FROMConfig.ConfigFile
Interesting solution, it already serves as a diagnosis of what seems to be a bug, thank you.
The content of Column COMMENT is expected to be $LB() format.
The most likely reason is : this property contains some ages-old junk
This works:
SELECT
ID,
CPFName,
%INTERNAL(Comments),
Name, Product, SectionHeader, Version
FROM Config.ConfigFileCache for Windows (x86-64) 2018.1.7 (Build 721U)