Details
-
Type:
Improvement
-
Status:
Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: 2.4
-
Component/s: Platforms, Schema Managers
-
Labels:None
Description
- Make the use of `` a general approach for explicit quoting of identifiers
- introduce AbstractPlatform::getRegularSQLIdentifierCase($identifier)
- Introduce AbstractPlatform::isRegularIdentifier($identifier)
- Fix Schema Assets not to lower-case, but to check for explicit quoting before.
- Filter values of identifiers passed to all platform functions when they are used in information schema queries according to `` explicit quoting rules.
Problem: Schema is independent of a vendor, this means we have to pick a behavior, i propose SQL-92
- http://savage.net.au/SQL/sql-92.bnf See <actual identifier>
- http://www.alberton.info/dbms_identifiers_and_case_sensitivity.html
This means:
- strtoupper() ALL tables, column, index, foreign key names that are not quoted by ``
- For any Quoted identifiers by `` the case is kept.
- We can introduce a validator to detect a schema that cannot be implemented with a given vendor platform.
In conjunction with the SQL reserved keywords tickets we can then improve the DatabaseDriver considerably to detect identifier casings
Issue Links
Activity
Benjamin Eberlei
made changes -
Benjamin Eberlei
made changes -
Benjamin Eberlei
made changes -
Benjamin Eberlei
made changes -
| Fix Version/s | 2.1.1 [ 10156 ] | |
| Fix Version/s | 2.1 [ 10068 ] |
Benjamin Eberlei
made changes -
| Fix Version/s | 2.1.2 [ 10160 ] | |
| Fix Version/s | 2.1.1 [ 10156 ] |
Benjamin Eberlei
made changes -
| Fix Version/s | 2.1.3 [ 10162 ] | |
| Fix Version/s | 2.1.2 [ 10160 ] |
Benjamin Eberlei
made changes -
| Fix Version/s | 2.2 [ 10142 ] | |
| Fix Version/s | 2.1.3 [ 10162 ] |
Guilherme Blanco
made changes -
| Fix Version/s | 2.3 [ 10184 ] | |
| Fix Version/s | 2.2 [ 10142 ] |
Benjamin Eberlei
made changes -
| Workflow | jira [ 12431 ] | jira-feedback2 [ 17569 ] |
Benjamin Eberlei
made changes -
| Workflow | jira-feedback2 [ 17569 ] | jira-feedback3 [ 19923 ] |
Benjamin Eberlei
made changes -
| Fix Version/s | 2.4 [ 10320 ] | |
| Fix Version/s | 2.3 [ 10184 ] |
This list may be incomplete, as errors occurred whilst retrieving source from linked applications:
- Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DBAL-96, expand=changesets[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)