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

Question SQLite SigSegV after excuting Pragma statement in Zeos query

  • universe
  • universe's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
More
5 months 1 week ago #13109 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
  • universe's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
More
5 months 5 days ago #13134 by universe
No body tried this?

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

More
5 months 5 days ago #13135 by Matis A.
A project sample with the problem ?
for our help

PilotLogic Core Programmer

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

  • universe
  • universe's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
More
5 months 5 days ago #13138 by universe
Please find attached a sample project.
Thanks.

File Attachment:

File Name: Sample_Project.zip
File Size:522 KB
Attachments:

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

More
5 months 4 days ago #13139 by Matis A.
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
  • universe's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
More
5 months 1 day ago #13153 by universe
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
  • Sternas Stefanos's Avatar
  • Away
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
More
5 months 1 day ago #13154 by Sternas Stefanos
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.