Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add remaining Information Functions #8438

Closed
13 of 15 tasks
morgo opened this issue Nov 25, 2018 · 2 comments
Closed
13 of 15 tasks

Add remaining Information Functions #8438

morgo opened this issue Nov 25, 2018 · 2 comments
Labels
component/expression help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. type/compatibility

Comments

@morgo
Copy link
Contributor

morgo commented Nov 25, 2018

From the MySQL manual:

  • BENCHMARK() Repeatedly execute an expression expression, planner: support builtin function benchmark #9252
  • CHARSET() Return the character set of the argument Built-in function CHARSET not supported #3931
  • COERCIBILITY() Return the collation coercibility value of the string argument Function coercibility not supported #4056
  • COLLATION() Return the collation of the string argument
  • CONNECTION_ID() Return the connection ID (thread ID) for the connection
  • CURRENT_USER(), CURRENT_USER The authenticated user name and host name
  • DATABASE() Return the default (current) database name
  • FOUND_ROWS() For a SELECT with a LIMIT clause, the number of rows that would be returned were there no LIMIT clause (Exists, but not correctly implemented) inconsistent behavior of Found_Rows and sql_calc_found_rows #8235
  • LAST_INSERT_ID() Value of the AUTOINCREMENT column for the last INSERT
  • ROW_COUNT() The number of rows updated (Limited; hard to impliment in optimistic system)
  • SCHEMA() Synonym for DATABASE()
  • SESSION_USER() Synonym for USER()
  • SYSTEM_USER() Synonym for USER()
  • USER() The user name and host name provided by the client
  • VERSION() Return a string that indicates the MySQL server version
@morgo morgo added type/compatibility help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. labels Nov 25, 2018
@wwar
Copy link

wwar commented Apr 8, 2020

COLLATION() and COERCIBILITY() can be checked as complete.

CHARSET() is still not done, and FOUND_ROWS() is still broken.

@ghost
Copy link

ghost commented Aug 12, 2020

I am going to close this issue now. There are only two remaining functions, and both have dedicated issues to track them. Thanks!

@ghost ghost closed this as completed Aug 12, 2020
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
component/expression help wanted Denotes an issue that needs help from a contributor. Must meet "help wanted" guidelines. type/compatibility
Projects
None yet
Development

No branches or pull requests

3 participants