Firebird Wire Protocol Carlos Guzman Alvarez, Mark Rotteveel Version 0.15, 26 December 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 5.1.1. Deviations for protocol version 11 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 5.2.1. Deviations for protocol version 11 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Serge Klochkov (Integrations Team) 31 October 2023 Agenda Motivation and Context 01 MySQL Wire Protocol Compatibility 02 MySQL SQL Dialect Compatibility 03 2 Motivation 3 ClickHouse and Other Databases password has to be encrypted with Double SHA1 What does “MySQL Wire Protocol” mean? 6 ● TCP Connection ● MySQL authentication support ● Incoming command packets handler * ● Result set protocols - text text and binary * https://dev.mysql.com/doc/dev/mysql-server/latest/PAGE_PROTOCOL.html How it started … 7 What is “command \x16”? ? QuickSight Tableau Online How it started … 8 QuickSight Tableau

Settings 0 Configuring the Timezone 287 About Locale Support in Greenplum Database 288 Locale Behavior 289 Troubleshooting Locales 290 Character Set Support 290 Setting the Character Set 292 Character Set About PostGIS 413 Greenplum PostGIS Extension 413 Enabling and Removing PostGIS Support 415 Enabling PostGIS Support 415 Installing the Greenplum PostGIS Extension Package 415 Using the CREATE EXTENSION Command 415 Enabling GDAL Raster Drivers 416 Enabling Out-of-Database Rasters 417 Removing PostGIS Support 417 Using the DROP EXTENSION Command 417 Uninstalling the Greenplum PostGIS Extension Package 418

Settings 0 Configuring the Timezone 278 About Locale Support in Greenplum Database 279 Locale Behavior 280 Troubleshooting Locales 281 Character Set Support 281 Setting the Character Set 283 Character Set About PostGIS 404 Greenplum PostGIS Extension 404 Enabling and Removing PostGIS Support 406 Enabling PostGIS Support 406 Installing the Greenplum PostGIS Extension Package 406 Using the CREATE EXTENSION Out-of-Database Rasters 408 VMware Greenplum v6.18 Documentation VMware, Inc. 19 Removing PostGIS Support 408 Using the DROP EXTENSION Command 408 Uninstalling the Greenplum PostGIS Extension Package 409

448 Configuring the Timezone 448 About Locale Support in Greenplum Database 449 Locale Behavior 451 Troubleshooting Locales 451 Character Set Support 451 Setting the Character Set 453 Character Set Access with PXF 470 Removing the gphdfs External Tables 470 Revoking Privileges to the gphdfs Protocol 470 Upgrading PXF When You Upgrade from a Previous Greenplum Database 6.x Version 471 Step 1: compressed table 570 Checking the Compression and Distribution of an Append-Optimized Table 570 Support for Run-length Encoding 571 VMware Greenplum 6 Documentation VMware by Broadcom 27 Adding Column-level

429 Configuring the Timezone 429 About Locale Support in Greenplum Database 430 Locale Behavior 432 Troubleshooting Locales 432 Character Set Support 432 Setting the Character Set 434 Character Set Access with PXF 451 Removing the gphdfs External Tables 451 Revoking Privileges to the gphdfs Protocol 451 Upgrading PXF When You Upgrade from a Previous Greenplum Database 6.x Version 452 Step 1: compressed table 541 Checking the Compression and Distribution of an Append-Optimized Table 541 Support for Run-length Encoding 542 Adding Column-level Compression 543 Default Compression Values 544

454 Configuring the Timezone 454 About Locale Support in Greenplum Database 455 Locale Behavior 456 Troubleshooting Locales 457 Character Set Support 457 Setting the Character Set 459 Character Set Access with PXF 476 Removing the gphdfs External Tables 476 Revoking Privileges to the gphdfs Protocol 476 VMware Greenplum 6 Documentation VMware, Inc 19 Upgrading PXF When You Upgrade from a Previous compressed table 565 Checking the Compression and Distribution of an Append-Optimized Table 565 Support for Run-length Encoding 566 Adding Column-level Compression 566 Default Compression Values 568

283 Configuring the Timezone 283 About Locale Support in Greenplum Database 284 Locale Behavior 285 Troubleshooting Locales 286 Character Set Support 286 Setting the Character Set 288 Character Set About PostGIS 408 Greenplum PostGIS Extension 408 Enabling and Removing PostGIS Support 410 Enabling PostGIS Support 410 Installing the Greenplum PostGIS Extension Package 410 Using the CREATE EXTENSION Command 411 Enabling GDAL Raster Drivers 411 Enabling Out-of-Database Rasters 412 Removing PostGIS Support 412 Using the DROP EXTENSION Command 413 Uninstalling the Greenplum PostGIS Extension Package 413

438 Configuring the Timezone 439 About Locale Support in Greenplum Database 439 Locale Behavior 441 Troubleshooting Locales 441 Character Set Support 441 Setting the Character Set 443 Character Set Access with PXF 460 Removing the gphdfs External Tables 460 Revoking Privileges to the gphdfs Protocol 460 Upgrading PXF When You Upgrade from a Previous Greenplum Database 6.x Version 460 Step 1: compressed table 544 Checking the Compression and Distribution of an Append-Optimized Table 544 Support for Run-length Encoding 545 Adding Column-level Compression 545 Default Compression Values 547

Settings 0 Configuring the Timezone 212 About Locale Support in Greenplum Database 213 Locale Behavior 214 Troubleshooting Locales 215 Character Set Support 215 Setting the Character Set 217 Character Set About PostGIS 339 Greenplum PostGIS Extension 339 Enabling and Removing PostGIS Support 341 Enabling PostGIS Support 341 Installing the Greenplum PostGIS Extension Package 341 Using the CREATE EXTENSION Command 341 Enabling GDAL Raster Drivers 342 Enabling Out-of-Database Rasters 343 Removing PostGIS Support 343 Using the DROP EXTENSION Command 343 Uninstalling the Greenplum PostGIS Extension Package 344