Search found 11 matches
- 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...
- 12.01.2021, 14:24
- Forum: ZeosLib 7.2 Forum
- Topic: MySQL identifier case questions
- Replies: 17
- Views: 802
- 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...
- 11.01.2021, 15:21
- Forum: ZeosLib 7.2 Forum
- Topic: MySQL identifier case questions
- Replies: 17
- Views: 802
Re: MySQL identifier case questions
Oh. Yes, sure.
- 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 ...
- 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...
- 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...
- 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...
- 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.
I'll definitely take a look and try to fix these issues.
- 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...
- 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 ...