coercibility gives incorrect results

Bug #617576 reported by Andrew Hutchings
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Fix Released
Medium
Andrew Hutchings
Dexter
Fix Released
Medium
Andrew Hutchings

Bug Description

The following should return 3, do we still need this function anyway?:

drizzle> select coercibility(user());
+----------------------+
| coercibility(user()) |
+----------------------+
| 4 |
+----------------------+
1 row in set (0 sec)

Related branches

Revision history for this message
Andrew Hutchings (linuxjedi) wrote :

<LinuxJedi> krow: In mysql the user function uses Item_func_sysconst which sets DERIVATION_SYSCONST. In drizzle it uses Item_str_func which does not. Shouldn't be too hard to fix if you want it. The rest of coercibility seems ok in my quick tests
<krow> LinuxJedi: If you and pcrews want to devise some tests that cover the issue I don't care if the function exists (it is just for debugging). If you mention it to stewart most likely it will get moved to being a plugin with the tests only running during one of our builds :)
<pcrews> LinuxJedi: We can probably cook up a decent set of cases for the test suite without a lot of hassle. Let me know if you are interested in doing so.

Revision history for this message
Andrew Hutchings (linuxjedi) wrote :

Pushed branch to make coercibility a plugin

Revision history for this message
Andrew Hutchings (linuxjedi) wrote :

Added tests and fixed bug. Need to make some more test changes

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.