Unknown unit m in duration 15m

[nostdm]

Hello,

This might be something I missed but I'm not exactly sure why doesn't it work.

I'm trying to add parameters to my database connection as specified in the README but I get this error:

2017/04/29 22:25:28 time: unknown unit m‌ in duration 15m‌

This is the full code:

db, err = sql.Open("mysql", "root:password@tcp(127.0.0.1:3306)/employees?readTimeout=15m‌")

Any ideas as to what's happening here?
Thanks.

[julienschmidt]

Please provide your configuration, as requested in the issue template:

### Configuration
*Driver version (or git SHA):*

*Go version:* run `go version` in your console

*Server version:* E.g. MySQL 5.6, MariaDB 10.0.20

*Server OS:* E.g. Debian 8.1 (Jessie), Windows 10

[julienschmidt]

I just checked your DSN with our DSN parser test and can not reproduce the problem. I suspect that you are either using an outdated version of the driver or an outdated Go version.

[nostdm]

Driver commit SHA: 15dbaae

Go version: go1.8 linux/amd64

MySQL version: mysql Ver 14.14 Distrib 5.7.18, for Linux (x86_64)

Server OS: Linux 4.4.0-75-generic #96-Ubuntu SMP x86_64 x86_64 x86_64 GNU/Linux

When I add a & after the parameter value, it seems to run fine. But I'm not sure if the parameter takes effect in that case.

[julienschmidt]

I was able to reproduce it. Could be a bug in the DSN parser.
Working on it...

[julienschmidt]

Unicode is a dangerous thing...
I figured out why it worked when I just typed your DSN and I was able to reproduce it when I copy/pasted your DSN string:

You have an invisible U+200C [226 128 140] ZERO WIDTH NON-JOINER character in it. To be exact after your m:

fmt.Println(0, []byte("root:password@tcp(127.0.0.1:3306)/employees?readTimeout=15m‌"))
fmt.Println(1, []byte("root:password@tcp(127.0.0.1:3306)/employees?readTimeout=15m"))

0 [114 111 111 116 58 112 97 115 115 119 111 114 100 64 116 99 112 40 49 50 55 46 48 46 48 46 49 58 51 51 48 54 41 47 101 109 112 108 111 121 101 101 115 63 114 101 97 100 84 105 109 101 111 117 116 61 49 53 109 226 128 140]
1 [114 111 111 116 58 112 97 115 115 119 111 114 100 64 116 99 112 40 49 50 55 46 48 46 48 46 49 58 51 51 48 54 41 47 101 109 112 108 111 121 101 101 115 63 114 101 97 100 84 105 109 101 111 117 116 61 49 53 109]

https://play.golang.org/p/pDBTCFAWd8

[nostdm]

Wow, that's a first. Thanks a lot. I copy pasted the parameter value from stack overflow. Must have copied some invisible characters with it. I'll have to check the Unicode next time when pasting.

[julienschmidt]

From where exactly? Maybe someone played a joke there

[nostdm]

From comments on my post here: http://stackoverflow.com/questions/43696607/mysql-to-json-inconsistent-extraction

I tried copying only the parameter and there is no problem, but when I copy the whole expression with the parentheses, it also copies some invisible characters.

Edit: actually it always inserts the character. Sometimes even two: [226 128 140 226 128 139] zero-width-joiner and zero-width-space