SQL in Config.ConfigFile returns with fatal error

Question

Question

Anderson Negreli · Dec 26, 2022

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

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.

Product version: IRIS 2022.1

Discussion (6)3

Log in or sign up to continue

Alexander Koblov · Dec 26, 2022

Choose Logical Mode in dropdown near the Query Builder. Perhaps IRIS SQL tries to do some Logical -> Display conversion and fails.

0 0

Andreas Schneider · Dec 26, 2022

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(ID AS VARCHAR(512)),
       CAST(CPFName AS VARCHAR(255)),
       CAST(Comments AS VARCHAR(4096)),
       CAST(Name AS VARCHAR(64)),
       CAST(Product AS VARCHAR(64)),
       CAST(SectionHeader AS VARCHAR(255)),
       CAST(Version AS VARCHAR(7))
FROM Config.ConfigFile

0 0

Robert Cemper · Dec 26, 2022

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

Cache for Windows (x86-64) 2018.1.7 (Build 721U)

0 0

score 1 · Answer 1 · 2022-12-26T13:46:10-05:00

Anderson Negreli Dec 26, 2022 to Alexander Koblov

Logical mode worked without any problems, thanks.
But it looks like an IRIS bug anyway.

1 0

score 0 · Answer 2 · 2022-12-27T04:15:26-05:00

Alexander Koblov Dec 27, 2022 to Anderson Negreli

It's possible. Please report it to WRC.

0 0

score 0 · Answer 3 · 2022-12-26T13:48:33-05:00

Anderson Negreli Dec 26, 2022 to Andreas Schneider

Interesting solution, it already serves as a diagnosis of what seems to be a bug, thank you.

0 0