[Typo3] typo3.6, mysql 4 and reserved words

[Paul Matthews]

Hi,

I have migrated a typo 3.6.2 site from a mysql-3 d/b to a server running
mysql-4. I have imported the database requiring only to put backquotes
around the field 'hash' found in a number of tables as it is reserved in
mysql-4. The trouble is the site is failing as sql statements can not use
the word hash

Here is an example of the failing which is revealed when debug is applied:-

caller =  t3lib_DB::exec_SELECTquery

ERROR You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'hash="6393a28197"' at line 4

lastBuiltQuery =  SELECT *
FROM fe_session_data
WHERE
hash="6393a28197"

I have tried the various install tool steps of Compare tables etc to see if
this is in some way corrected but it seems the problem could be with the
code as mysql does not like use of the word hash in "where hash=...".

I believe typo3.6 should run with mysql 4 so I am a bit confused as to why
I have not found more occurrences of this problem in this list

Any help appreciated