Details
-
Technical task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL)
-
None
-
10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.1.18
Description
We'll add a new function CHR(num).
It will be very similar to MariaDB's CHAR(num), but
- will accept only one argument
- will return a VARCHAR(1) with character set and collation according to @@character_set_database and @@collation_database, rather than VARBINARY(N).
It will be available in all sql_mode's.
Attachments
Issue Links
- relates to
-
MDEV-10342
Providing compatibility for basic SQL built-in functions
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue relates to |
| Description |
We'll add a new function {{CHR(num)}}.
It will be very similar to MariaDB's {{CHAR(num)}}, but - will accept only one argument - will return a VARCHAR(N) with character set and collation according to @@character_set_database and @@collation_database, rather than VARBINARY. |
We'll add a new function {{CHR(num)}}.
It will be very similar to MariaDB's {{CHAR(num)}}, but - will accept only one argument - will return a VARCHAR(N) with character set and collation according to @@character_set_database and @@collation_database, rather than VARBINARY. It will be available in all {{sql_mode}}'s. |
| Description |
We'll add a new function {{CHR(num)}}.
It will be very similar to MariaDB's {{CHAR(num)}}, but - will accept only one argument - will return a VARCHAR(N) with character set and collation according to @@character_set_database and @@collation_database, rather than VARBINARY. It will be available in all {{sql_mode}}'s. |
We'll add a new function {{CHR(num)}}.
It will be very similar to MariaDB's {{CHAR(num)}}, but - will accept only one argument - will return a VARCHAR(N) with character set and collation according to @@character_set_database and @@collation_database, rather than VARBINARY(N). It will be available in all {{sql_mode}}'s. |
| Description |
We'll add a new function {{CHR(num)}}.
It will be very similar to MariaDB's {{CHAR(num)}}, but - will accept only one argument - will return a VARCHAR(N) with character set and collation according to @@character_set_database and @@collation_database, rather than VARBINARY(N). It will be available in all {{sql_mode}}'s. |
We'll add a new function {{CHR(num)}}.
It will be very similar to MariaDB's {{CHAR(num)}}, but - will accept only one argument - will return a VARCHAR(1) with character set and collation according to @@character_set_database and @@collation_database, rather than VARBINARY(N). It will be available in all {{sql_mode}}'s. |
| issue.field.resolutiondate | 2017-05-08 11:56:52.0 | 2017-05-08 11:56:52.546 |
| Fix Version/s | 10.3.1 [ 22532 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Parent Issue | MDEV-10764 [ MDEV-10764 ] |
|
| Workflow | MariaDB v3 [ 80600 ] | MariaDB v4 [ 152087 ] |
Merged Jerome's pull request to bb-10.2-ext.