Welcome, Guest
Username: Password: Remember me
Components and Libraries for Database Development, discussions, problems and suggestions
  • Page:
  • 1

TOPIC:

SQLite SigSegV after excuting Pragma statement in Zeos query 5 years 2 months ago #13109

  • universe
  • universe's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 122
  • Thank you received: 8
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.

SQLite SigSegV after excuting Pragma statement in Zeos query 5 years 2 months ago #13134

  • universe
  • universe's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 122
  • Thank you received: 8
No body tried this?

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

SQLite SigSegV after excuting Pragma statement in Zeos query 5 years 2 months ago #13135

  • Matis A.
  • Matis A.'s Avatar
  • Offline
  • Moderator
  • Moderator
  • Posts: 1060
  • Thank you received: 149
A project sample with the problem ?
for our help
PilotLogic Core Programmer

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

SQLite SigSegV after excuting Pragma statement in Zeos query 5 years 2 months ago #13138

  • universe
  • universe's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 122
  • Thank you received: 8
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.

SQLite SigSegV after excuting Pragma statement in Zeos query 5 years 2 months ago #13139

  • Matis A.
  • Matis A.'s Avatar
  • Offline
  • Moderator
  • Moderator
  • Posts: 1060
  • Thank you received: 149
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.

SQLite SigSegV after excuting Pragma statement in Zeos query 5 years 2 months ago #13153

  • universe
  • universe's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 122
  • Thank you received: 8
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.

SQLite SigSegV after excuting Pragma statement in Zeos query 5 years 2 months ago #13154

  • Sternas Stefanos
  • Sternas Stefanos's Avatar
  • Offline
  • Moderator
  • Moderator
  • Ex Pilot, M.Sc, Ph.D
  • Posts: 4511
  • Thank you received: 1101
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.

  • Page:
  • 1