coercibility gives incorrect results
Bug #617576 reported by
Andrew Hutchings
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(
+------
| coercibility(
+------
| 4 |
+------
1 row in set (0 sec)
Related branches
lp://staging/~linuxjedi/drizzle/drizzle-bug-617576
- Drizzle Merge Team: Pending requested
-
Diff: 680 lines (+240/-205)17 files modifieddrizzled/function/coercibility.cc (+0/-34)
drizzled/function/coercibility.h (+0/-41)
drizzled/function/func.cc (+2/-0)
drizzled/function/func.h (+6/-0)
drizzled/include.am (+0/-2)
drizzled/item/create.cc (+0/-28)
plugin/coercibility_function/coercibility_function.cc (+87/-0)
plugin/coercibility_function/plugin.ini (+5/-0)
plugin/coercibility_function/tests/r/coercibility.result (+75/-0)
plugin/coercibility_function/tests/t/coercibility.test (+65/-0)
support-files/drizzle.spec.in (+0/-1)
tests/r/func_group.result (+0/-6)
tests/r/func_str.result (+0/-5)
tests/r/user_var.result (+0/-48)
tests/t/func_group.test (+0/-6)
tests/t/func_str.test (+0/-1)
tests/t/user_var.test (+0/-33)
To post a comment you must log in.
<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.