View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0011084 | MMW v4 | DB/FileMonitor | public | 2013-07-20 17:54 | 2013-07-20 17:54 |
| Reporter | zvezdan | Assigned To | |||
| Priority | none | Severity | minor | Reproducibility | always |
| Status | new | Resolution | open | ||
| Summary | 0011084: Wrong SQL result with the current SQLite engine 3.7.6.3 used in program | ||||
| Description | I have the next SQL: SELECT * FROM Albums GROUP BY Tracks HAVING Max(Album COLLATE NOCASE) = Album COLLATE NOCASE In MM 4.1.0.1650 and SQL Viewer script I get zero rows returned with the attached database. I get the same result with SQLiteSpy 1.9.0 which have SQLite 3.7.6 engine. However, when I load the same SQL query into SQLiteSpy 1.9.3 which use SQLite 3.7.16.1 or SQLite Expert Personal 3.4.71.2301 which use SQLite 3.7.17 I get the one record returned, which I think is correct. I have one another database where the resulting rows are much more different between those versions, but it is fairly large for upload. By the way, just to mention if you don't know, the SQLite 3.7.15 has added the InStr function. I am wondering if it would interfere with your function of the same name if you decide to use the new SQLite engine. | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Fixed in build | |||||
