Search found 11 matches

by leus
13.01.2021, 00:43
Forum: ZeosLib 7.2 Forum
Topic: MySQL identifier case questions
Replies: 17
Views: 802

Re: MySQL identifier case questions

Okay. I'm using master from the git repository; once I add the create / drop sql scripts for bugreports, the test doesn't fail here. Is this the way to configure tests? [sqlite3] ; DBC protocol name sqlite3.protocol=sqlite ; BDE alias for performance tests sqlite3.alias=sqlite_zeoslib ; Host name sq...
by leus
12.01.2021, 14:24
Forum: ZeosLib 7.2 Forum
Topic: MySQL identifier case questions
Replies: 17
Views: 802

Re: MySQL identifier case questions

miab3 wrote: 12.01.2021, 10:12 I have for Zeos8 svn7215 yet:

TestCompTicket386: ETestFailure
at $009B08B5
sqlite3/sqlite: the fieldcount of table table_ticket_386 and Field_1, expected: <1> but was: <0>

Michał
Beginner question: I'm using git, which branch should I use for testing?
by leus
12.01.2021, 00:49
Forum: ZeosLib 7.2 Forum
Topic: MySQL identifier case questions
Replies: 17
Views: 802

Re: MySQL identifier case questions

Regarding TestCompTicket386, it seems that the database.properties template file is missing the creation and drop of ticket report tables: ; SQL scripts to create database objects sqlite3.create.scripts=create_sqlite.sql,populate_any.sql ; SQL scripts to drop database objects sqlite3.drop.scripts=dr...
by leus
11.01.2021, 15:21
Forum: ZeosLib 7.2 Forum
Topic: MySQL identifier case questions
Replies: 17
Views: 802

Re: MySQL identifier case questions

marsupilami wrote: 11.01.2021, 12:26 Maybe it makes sense to just focus on TestCompTicket386?
Oh. Yes, sure.
by leus
10.01.2021, 20:48
Forum: ZeosLib 7.2 Forum
Topic: MySQL identifier case questions
Replies: 17
Views: 802

Re: MySQL identifier case questions

Hello leus, you should be able to send and receive private messages now. Regarding MySQLs tableticket304: I just added a patch to trunk to have it there too. I wonder why this change never made it there... Regarding the other errors on MySQL: They don't fail on the test system, I will have to look ...
by leus
08.01.2021, 22:31
Forum: ZeosLib 7.2 Forum
Topic: MySQL identifier case questions
Replies: 17
Views: 802

Re: MySQL identifier case questions

Following my previous post, mysql test results from the same code, no changes: C:\delphi\zeoslib\packages\DelphiXE10.3\build>ZTestAll.exe -b Config File Name: C:\delphi\zeoslib\database\test.properties Executing C:\delphi\zeoslib\database\drop_mysql.sql Executing C:\delphi\zeoslib\database\drop_mysq...
by leus
08.01.2021, 22:06
Forum: ZeosLib 7.2 Forum
Topic: MySQL identifier case questions
Replies: 17
Views: 802

Re: MySQL identifier case questions

Hello leus, your changes make a test on SQLite fail: TestCompTicket386 in test\bugreport\ZTestBugCompSQLite.pas fails now. Do you have a chance to look into this? Some hints on running the test suites can be found on this wiki page . If you have questions regarding this, I will be happy to answer t...
by leus
08.01.2021, 21:17
Forum: ZeosLib 7.2 Forum
Topic: MySQL identifier case questions
Replies: 17
Views: 802

Re: MySQL identifier case questions

Hello leus, your changes make a test on SQLite fail: TestCompTicket386 in test\bugreport\ZTestBugCompSQLite.pas fails now. Do you have a chance to look into this? Some hints on running the test suites can be found on this wiki page . If you have questions regarding this, I will be happy to answer t...
by leus
08.01.2021, 20:14
Forum: ZeosLib 7.2 Forum
Topic: MySQL identifier case questions
Replies: 17
Views: 802

Re: MySQL identifier case questions

Thank you!

I'll definitely take a look and try to fix these issues.
by leus
07.01.2021, 20:17
Forum: User Patches
Topic: MySQL identifier case problems
Replies: 1
Views: 373

MySQL identifier case problems

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 t...
by leus
07.01.2021, 19:34
Forum: ZeosLib 7.2 Forum
Topic: MySQL identifier case questions
Replies: 17
Views: 802

MySQL identifier case questions

Hello, I've been having problems with MySQL with mixed case tables and columns. First, the following code in src/dbc/ZDbcMetadata.pas, TZAbstractDatabaseMetadata.NormalizePatternCase seems weird to me, because it is converting mixed case identifiers (like a table name) to lowercase. icMixed: if not ...