Peter Bowyer

[EN] Month of May issues even when latent enabled

1

I have identified a problem when using May in English results. Other issues (#521 #207) have touched on the problem, and according to https://github.com/facebook/duckling/issues/207#issuecomment-396779507 to use "May" you need to...

Conflict with jquery tools 'tooltip' plugin

1

I love using cornerz, but it has an issue with the jquery tools 'tooltip' plugin (see http://flowplayer.org/tools/demos/tooltip/index.html) - the positioning of the tooltip is completely destroyed. If I disable cornerz...

PHPUnit constructor deprecation

4

Using PHPUnit 9.1.5 I'm seeing this deprecation notice on every run. ``` Other deprecation notices (1) 1x: The "PHPUnit\Framework\TestCase::__construct()" method is considered internal This method is not covered by the...

When using --output have option to preserve directory structure

1

Thanks for writing this script! When using ``` npx avif --input="/path/to/www/assets/**/*.*" --output=/path/to/www/assets-avif --verbose ``` It would be really nice if there was a built-in way to preserve the input directory...

Handle when sponsors engage in harassing behavior

3

Currently the code of conduct says sponsors are also subject to the anti-harassment policy, but doesn't state what action will be taken if they breach it (sponsors are not defined...

Dolt insists reserved words are always quoted

4

I encountered this with the reserved keyword 'rank'. The MySQL manual says > Exception: A word that follows a period in a qualified name must be an identifier, so it...

Possibly related to #3976: ``` error=syntax error at position 34 near 'Event', query=SELECT Event.name AS `event`, PluginEvent.pluginid, PropertySet.name AS propertyset FROM `abcx_site_plugin_events` PluginEvent INNER JOIN `abcx_site_plugins` Plugin ON Plugin.id =...

`sql_mode` is always strict

1

I have a query failing with `ERROR 1105 (HY000): expression 'Policy.data' doesn't appear in the group by expressions`. With legacy systems normally I relax `sql_mode` to TRADITIONAL or "" to...

Support indexes on `TEXT` and `BLOB` column types

3

MySQL supports indexes on `TEXT` and `BLOB` types[^1] - in single and composite indexes. They require a length prefix: > When you index a [BLOB](https://dev.mysql.com/doc/refman/8.0/en/blob.html) or [TEXT](https://dev.mysql.com/doc/refman/8.0/en/blob.html) column, you must...

Add an equivalent to .gitignore.

1

### Use case There are some files (tables) that I never want to commit - files that change regularly, where the content doesn't need versioning, and where performance is important....