MySQL identifier case problems

Code patches written by our users to solve certain "problems" that were not solved, yet.

Moderators: gto, cipto_kh, EgonHugeist, mdaems

Locked
leus
Fresh Boarder
Fresh Boarder
Posts: 11
Joined: 07.01.2021, 18:38

MySQL identifier case problems

Post by leus »

This patch solves problems I observed with mORMot's
CreateMissingTables
procedure. I think this patch is correct, however, I don't have the capabilities to test it.

The problem seems to be how case insensivity is treated in MySQL. Zeos tends to lowercase identifiers aggressively and this is making that table and columns extraction from a MySQL database hosted on Linux to fail.
You do not have the required permissions to view the files attached to this post.
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: MySQL identifier case problems

Post by marsupilami »

Hello leus,

I am locking this thread in favour of viewtopic.php?f=40&t=131179#p162054.

Best regards,

Jan
Locked