× Components and Libraries for Database Development, discussions, problems and suggestions

Question SQLite SigSegV after excuting Pragma statement in Zeos query

Start
Prev
1
Next
End

universe
Topic Author
Offline
Junior Member

3 years 4 months ago #13109 by universe

SQLite SigSegV after excuting Pragma statement in Zeos query was created by universe

Hello all,
Could anyone please confirm that this SQLite statement

PRAGMA table_info('my_tablename')

generates a SigSegV in Zeos Query the error is located in the function TZGenericStatementAnalyser.SplitSections (ZGenericSqlAnalyser.pas) it seems that

CheckForKeyword(Tokens, TokenIndex, SectionNames, Keyword{%H-}, WordCount{%H-});

is returning with null WordCount.
I'm using CT6.7 32bit on Windows 7 64bit.
PS: This code works with old CT6.0.
Thanks

Please Log in or Create an account to join the conversation.

universe
Topic Author
Offline
Junior Member

3 years 4 months ago #13134 by universe

Replied by universe on topic SQLite SigSegV after excuting Pragma statement in Zeos query

No body tried this?

Please Log in or Create an account to join the conversation.

Matis A.
Offline
Moderator

3 years 4 months ago #13135 by Matis A.

Replied by Matis A. on topic SQLite SigSegV after excuting Pragma statement in Zeos query

A project sample with the problem ?
for our help

PilotLogic Core Programmer

Please Log in or Create an account to join the conversation.

universe
Topic Author
Offline
Junior Member

3 years 4 months ago #13138 by universe

Replied by universe on topic SQLite SigSegV after excuting Pragma statement in Zeos query

Please find attached a sample project.
Thanks.

File Attachment:

File Name: Sample_Project.zip
File Size:522 KB

Please Log in or Create an account to join the conversation.

Matis A.
Offline
Moderator

3 years 4 months ago #13139 by Matis A.

Replied by Matis A. on topic SQLite SigSegV after excuting Pragma statement in Zeos query

Yes this Error exists
but I can't help with PRAGMA SQL command.

PilotLogic Core Programmer

Please Log in or Create an account to join the conversation.

universe
Topic Author
Offline
Junior Member

3 years 4 months ago #13153 by universe

Replied by universe on topic SQLite SigSegV after excuting Pragma statement in Zeos query

I figured out the error exists for Postgresql if the query starts WITH RECURSIVE statement. Apparently only simple SELECT query are executed.

Please Log in or Create an account to join the conversation.

Sternas Stefanos
Offline
Moderator
Ex Pilot, M.Sc, Ph.D

3 years 4 months ago #13154 by Sternas Stefanos

Replied by Sternas Stefanos on topic SQLite SigSegV after excuting Pragma statement in Zeos query

I am NOT so familiar with
SQLite3 library SQL syntax and abilities

PilotLogic Architect and Core Programmer

Please Log in or Create an account to join the conversation.

Start
Prev
1
Next
End

Question SQLite SigSegV after excuting Pragma statement in Zeos query

File Attachment:

Attachments: