common_schema

common_schema copied to clipboard

MySQL 5.7: Unknown column 'password' in 'field list'

14

I'm getting the following on MySQL 5.7: ``` ERROR 1054 (42S22) at line 12498 in file: 'structure/common-schema.sql': Unknown column 'password' in 'field list' ``` Looks like they renamed the `password`...

Preetam

ERROR 1171 (42000) at line 195: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

1

Hi, i'm trying install common_schema in mysql 5.7.24 but i'm getting this error: ERROR 1171 (42000) at line 195: All parts of a PRIMARY KEY must be NOT NULL; if...

majost-colombia

Delete charting_routines.html

1

ghost

Escaped double quotes don't work in json_to_xml

3

SQL: select common_schema.json_to_xml('{"key":"ab\"cd"}') Expected result: ab\cd Current result: NULL The problem is in _get_json_token line 166, as substr won't find the "\" char as it expects. Don't know how to...

jfneis

updating the code for _sql_accounts_base and sql_grants views to chec…

2

…k whether the mysql.user.password column exists or not, and use the authentication_string column in its place if password does not exist

ikewalker

How to build the project?

8

@shlomi-noach would you mind to give a quick overview of the build requirements?

jfneis

Risks page still mentions GPL licensing

1

http://shlomi-noach.github.io/common_schema/risks.html

t-8ch

json_to_xml returns NULL if text value begins with -

2

When using json_to_xml parse fails (returns NULL) if there is a text value beginning with "-" signal. Doesn't work: ``` select common_schema.json_to_xml('{"key":"-123456"}') select common_schema.json_to_xml('{"key":"-abcde"}') ``` Work: `select common_schema.json_to_xml('{"key":-123456}')`

jfneis

When the value is empty, the parser fails and returns NULL. In the example below **name** is empty object. So when you try to extract the value, it returns null....

venugopp

Fixed data size mysql_user issue

1

Fixed issue where routine and sql_show_grants view have different user char size, resulting in mysql_user data size error.

marksmeed