It's not possible to enable identifier_mangling extension via DB_URL

[wuarmin]

Hey 👋,

I think it should be possible to include an extension in the DB_URL, right?
I want to enable the identifier_mangling extension via...

DB_URL = "mysql2://dbuser:abc123@my_db_host/tele_db?extensions=identifier_mangling&identifier_output_method=upcase"

...but it does not seem to work. I have to call DB.extension :identifier_mangling. The identifier_output_method option from the URL, on the other hand, is taken into account correctly, when identifier_mangling is enabled.

Thanks

[jeremyevans]

It seems to be working here, both for the identifier input and output methods:

$ ruby bin/sequel -E mysql2://127.0.0.1/sequel_test?extensions=identifier_mangling\&identifier_output_method=upcase -c 'DB.create_table!(:table){Integer :i}; DB[:table].insert(1); p DB[:table].all'
2024-09-26 07:26:22 INFO: (0.002235s) SET @@wait_timeout = 2147483
2024-09-26 07:26:22 INFO: (0.000326s) SET SQL_AUTO_IS_NULL=0
2024-09-26 07:26:22 INFO: (0.005028s) DROP TABLE IF EXISTS `table`
2024-09-26 07:26:22 INFO: (0.006875s) CREATE TABLE `table` (`i` integer)
2024-09-26 07:26:22 INFO: (0.001286s) INSERT INTO `table` VALUES (1)
2024-09-26 07:26:22 INFO: (0.001207s) SELECT version()
2024-09-26 07:26:22 INFO: (0.000342s) SELECT version()
2024-09-26 07:26:22 INFO: (0.000622s) SELECT * FROM `table`
[{:I=>1}]

$ ruby bin/sequel -E mysql2://127.0.0.1/sequel_test?extensions=identifier_mangling\&identifier_input_method=upcase -c 'DB.create_table!(:table){Integer :i}; DB[:table].insert(1); p DB[:table].all'  
2024-09-26 07:27:51 INFO: (0.002376s) SET @@wait_timeout = 2147483
2024-09-26 07:27:51 INFO: (0.000319s) SET SQL_AUTO_IS_NULL=0
2024-09-26 07:27:51 INFO: (0.017924s) DROP TABLE IF EXISTS `TABLE`
2024-09-26 07:27:51 INFO: (0.008317s) CREATE TABLE `TABLE` (`I` integer)
2024-09-26 07:27:51 INFO: (0.001769s) INSERT INTO `TABLE` VALUES (1)
2024-09-26 07:27:51 INFO: (0.001317s) SELECT version()
2024-09-26 07:27:51 INFO: (0.000372s) SELECT version()
2024-09-26 07:27:51 INFO: (0.000543s) SELECT * FROM `TABLE`
[{:I=>1}]

The extensions parameter just calls extension on the Database. If you typo the value of the extensions parameter, you will get an error. However, if you typo the name of the parameter, then it will be ignored. That seems unlikely to be the cause, since it is spelled correctly in your example, but you may want to double check.

[wuarmin]

Strange. I'll check it out and give you feedback.
Thanks!