Aurelius Windows vs MacOS

BIZ TMS Aurelius
1

Hello

I have a Delphi app on Wiindows that uses Aurelius to send SQL to a remote MySQL database. The app runs as expected. But when I recompile the app for MacOS, the Mac version diverges from the Windows vesion and attempts to re-create the already existing database.

Logs from the 2 platforms show that during the schema validation the exact same SQL is being sent to the database on each platform, and the responses to each SQL statement are identical. Yet after validation, whereas the Windows version begins selecting data to initialize the app, the Mac version instead sends Create Table commands to create tables that already exist, producing table creation errors, and eventually stops on what appears to be a primary key not assigned error.

I am stumped by this situation. I wonder whether you have seen anything like this, and if you have any suggestions about how I might investigate it.

Thanks

David

The server is a serveless MySQL server at Amazon RDS. SQL is delivered by HTTP. Results are received as JSON. Here are the first 16 commands of the Windows log. The first 15 commands of the Mac log are identical. I show command 16 from the Mac at the end.


1 Win	select 'formvalet_dev' as 'DATABASE'
{"columnMetadata":[{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"DATABASE","name":"DATABASE","nullable":0,"precision":13,"scale":0,"schemaName":"","tableName":"","type":12,"typeName":"VARCHAR"}],"numberOfRecordsUpdated":0,"records":[[{"stringValue":"formvalet_dev"}]]}

2 Win	show variables like 'character_set_database'
{"columnMetadata":[{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"Variable_name","name":"VARIABLE_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"VARIABLES","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"Value","name":"VARIABLE_VALUE","nullable":1,"precision":1024,"scale":0,"schemaName":"","tableName":"VARIABLES","type":12,"typeName":"VARCHAR"}],"numberOfRecordsUpdated":0,"records":[[{"stringValue":"character_set_database"},{"stringValue":"latin1"}]]}

3 Win	SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA = 'formvalet_dev' ORDER BY TABLE_NAME
{"columnMetadata":[{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"TABLE_NAME","name":"TABLE_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"TABLES","type":12,"typeName":"VARCHAR"}],"numberOfRecordsUpdated":0,"records":[[{"stringValue":"FieldInfos"}],[{"stringValue":"FieldTypes"}],[{"stringValue":"FormDatas"}],[{"stringValue":"FormHeaders"}],[{"stringValue":"FormTypeInfos"}],[{"stringValue":"GlobalDefaults"}],[{"stringValue":"PageInfos"}],[{"stringValue":"Products"}],[{"stringValue":"Purchases"}],[{"stringValue":"RecipientInfos"}],[{"stringValue":"ShareInfos"}],[{"stringValue":"Users"}]]}

4 Win	show variables like 'lower_case_table_names'
{"columnMetadata":[{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"Variable_name","name":"VARIABLE_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"VARIABLES","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"Value","name":"VARIABLE_VALUE","nullable":1,"precision":1024,"scale":0,"schemaName":"","tableName":"VARIABLES","type":12,"typeName":"VARCHAR"}],"numberOfRecordsUpdated":0,"records":[[{"stringValue":"lower_case_table_names"},{"stringValue":"0"}]]}

5 Win	SHOW TABLES FROM formvalet_dev LIKE 'TABLES'
{"columnMetadata":[{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"Tables_in_formvalet_dev (TABLES)","name":"TABLE_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"TABLE_NAMES","type":12,"typeName":"VARCHAR"}],"numberOfRecordsUpdated":0,"records":[]}

6 Win	SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, IS_NULLABLE, EXTRA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'formvalet_dev' ORDER BY TABLE_NAME, ORDINAL_POSITION
{"columnMetadata":[{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"TABLE_NAME","name":"TABLE_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"COLUMNS","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"COLUMN_NAME","name":"COLUMN_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"COLUMNS","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"DATA_TYPE","name":"DATA_TYPE","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"COLUMNS","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"CHARACTER_MAXIMUM_LENGTH","name":"CHARACTER_MAXIMUM_LENGTH","nullable":1,"precision":20,"scale":0,"schemaName":"","tableName":"COLUMNS","type":-5,"typeName":"BIGINT UNSIGNED"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"NUMERIC_PRECISION","name":"NUMERIC_PRECISION","nullable":1,"precision":20,"scale":0,"schemaName":"","tableName":"COLUMNS","type":-5,"typeName":"BIGINT UNSIGNED"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"NUMERIC_SCALE","name":"NUMERIC_SCALE","nullable":1,"precision":20,"scale":0,"schemaName":"","tableName":"COLUMNS","type":-5,"typeName":"BIGINT UNSIGNED"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"IS_NULLABLE","name":"IS_NULLABLE","nullable":0,"precision":3,"scale":0,"schemaName":"","tableName":"COLUMNS","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"EXTRA","name":"EXTRA","nullable":0,"precision":30,"scale":0,"schemaName":"","tableName":"COLUMNS","type":12,"typeName":"VARCHAR"}],"numberOfRecordsUpdated":0,"records":[[{"stringValue":"FieldInfos"},{"stringValue":"CreatedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"ID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"ModifiedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"CaptionID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"ColumnInfosStr"},{"stringValue":"varchar"},{"longValue":2048},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"FieldName"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"FieldTypeID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"FigureID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"FormatStr"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"IsActive"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"IsAdded"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"IsSingleSelectionRequired"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"PageInfoID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"PortraitFontSize"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"Position"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"Preset"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"TextColor"},{"stringValue":"bigint"},{"isNull":true},{"longValue":19},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldInfos"},{"stringValue":"ValuesList"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldTypes"},{"stringValue":"CreatedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"FieldTypes"},{"stringValue":"ID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"FieldTypes"},{"stringValue":"ModifiedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldTypes"},{"stringValue":"IsAddable"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldTypes"},{"stringValue":"FieldTypeName"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FieldTypes"},{"stringValue":"FieldTypeValue"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"FieldTypes"},{"stringValue":"Tags"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormDatas"},{"stringValue":"CreatedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"FormDatas"},{"stringValue":"ID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"FormDatas"},{"stringValue":"ModifiedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormDatas"},{"stringValue":"FormHeaderID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormDatas"},{"stringValue":"HasFile"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormDatas"},{"stringValue":"PageNumber"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormDatas"},{"stringValue":"Position"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormDatas"},{"stringValue":"StringValue"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormHeaders"},{"stringValue":"CreatedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"FormHeaders"},{"stringValue":"ID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"FormHeaders"},{"stringValue":"ModifiedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormHeaders"},{"stringValue":"AddedPages"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormHeaders"},{"stringValue":"FormTypeInfoID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormHeaders"},{"stringValue":"Identifier"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormHeaders"},{"stringValue":"Owner"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormHeaders"},{"stringValue":"RecipientID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormTypeInfos"},{"stringValue":"CreatedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"FormTypeInfos"},{"stringValue":"ID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"FormTypeInfos"},{"stringValue":"ModifiedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormTypeInfos"},{"stringValue":"DefaultTextColor"},{"stringValue":"bigint"},{"isNull":true},{"longValue":19},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormTypeInfos"},{"stringValue":"FormName"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormTypeInfos"},{"stringValue":"HasFormAdditions"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormTypeInfos"},{"stringValue":"ImportFileName"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormTypeInfos"},{"stringValue":"IsDocumentControlled"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormTypeInfos"},{"stringValue":"IsForm"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormTypeInfos"},{"stringValue":"Owner"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"FormTypeInfos"},{"stringValue":"PortraitFontSize"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"GlobalDefaults"},{"stringValue":"CreatedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"GlobalDefaults"},{"stringValue":"ID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"GlobalDefaults"},{"stringValue":"ModifiedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"GlobalDefaults"},{"stringValue":"KeyValue"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"GlobalDefaults"},{"stringValue":"StringValue"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"PageInfos"},{"stringValue":"CreatedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"PageInfos"},{"stringValue":"ID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"PageInfos"},{"stringValue":"ModifiedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"PageInfos"},{"stringValue":"Background"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"PageInfos"},{"stringValue":"FormTypeInfoID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"PageInfos"},{"stringValue":"IsAdded"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"PageInfos"},{"stringValue":"PageInfoName"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"PageInfos"},{"stringValue":"Position"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"PageInfos"},{"stringValue":"Rotation"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"Products"},{"stringValue":"CreatedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"Products"},{"stringValue":"ID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"Products"},{"stringValue":"ModifiedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"Products"},{"stringValue":"Description"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"Products"},{"stringValue":"Name"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"Purchases"},{"stringValue":"CreatedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"Purchases"},{"stringValue":"ID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"Purchases"},{"stringValue":"ModifiedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"Purchases"},{"stringValue":"ProductID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"Purchases"},{"stringValue":"UserId"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"RecipientInfos"},{"stringValue":"CreatedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"RecipientInfos"},{"stringValue":"ID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"RecipientInfos"},{"stringValue":"ModifiedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"RecipientInfos"},{"stringValue":"ContactID"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"RecipientInfos"},{"stringValue":"EmailAddress"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"RecipientInfos"},{"stringValue":"FormHeaderID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"RecipientInfos"},{"stringValue":"DisplayName"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"RecipientInfos"},{"stringValue":"IsConnected"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"RecipientInfos"},{"stringValue":"IsLocked"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"RecipientInfos"},{"stringValue":"Note"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"RecipientInfos"},{"stringValue":"ResponseDate"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"RecipientInfos"},{"stringValue":"ShareInfoID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"ShareInfos"},{"stringValue":"ContactSource"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"ShareInfos"},{"stringValue":"CreatedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"ShareInfos"},{"stringValue":"ID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"ShareInfos"},{"stringValue":"ModifiedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"ShareInfos"},{"stringValue":"ExpirationDate"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"ShareInfos"},{"stringValue":"FormTypeInfoID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"ShareInfos"},{"stringValue":"IsAllLocked"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"ShareInfos"},{"stringValue":"IsAutolocked"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"ShareInfos"},{"stringValue":"IsAdded"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"ShareInfos"},{"stringValue":"IsDocumentControlled"},{"stringValue":"int"},{"isNull":true},{"longValue":10},{"longValue":0},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"ShareInfos"},{"stringValue":"LastUpdate"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"ShareInfos"},{"stringValue":"Note"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"ShareInfos"},{"stringValue":"ShareDate"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"Users"},{"stringValue":"CreatedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"Users"},{"stringValue":"ID"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"NO"},{"stringValue":""}],[{"stringValue":"Users"},{"stringValue":"ModifiedAt"},{"stringValue":"datetime"},{"isNull":true},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"Users"},{"stringValue":"Purchases"},{"stringValue":"varchar"},{"longValue":255},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}],[{"stringValue":"Users"},{"stringValue":"UserName"},{"stringValue":"varchar"},{"longValue":256},{"isNull":true},{"isNull":true},{"stringValue":"YES"},{"stringValue":""}]]}

7 Win	SHOW TABLES FROM formvalet_dev LIKE 'COLUMNS'
{"columnMetadata":[{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"Tables_in_formvalet_dev (COLUMNS)","name":"TABLE_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"TABLE_NAMES","type":12,"typeName":"VARCHAR"}],"numberOfRecordsUpdated":0,"records":[]}

8 Win	SELECT C.CONSTRAINT_NAME, C.TABLE_NAME, K.COLUMN_NAME, K.ORDINAL_POSITION FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS C, INFORMATION_SCHEMA.KEY_COLUMN_USAGE K WHERE C.CONSTRAINT_TYPE='PRIMARY KEY' AND C.TABLE_NAME = K.TABLE_NAME AND C.CONSTRAINT_NAME = K.CONSTRAINT_NAME AND C.CONSTRAINT_SCHEMA = 'formvalet_dev' AND K.CONSTRAINT_SCHEMA = 'formvalet_dev' ORDER BY C.TABLE_NAME, C.CONSTRAINT_NAME, K.ORDINAL_POSITION
{"columnMetadata":[{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"CONSTRAINT_NAME","name":"CONSTRAINT_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"TABLE_CONSTRAINTS","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"TABLE_NAME","name":"TABLE_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"TABLE_CONSTRAINTS","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"COLUMN_NAME","name":"COLUMN_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"KEY_COLUMN_USAGE","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":true,"label":"ORDINAL_POSITION","name":"ORDINAL_POSITION","nullable":0,"precision":19,"scale":0,"schemaName":"","tableName":"KEY_COLUMN_USAGE","type":-5,"typeName":"BIGINT"}],"numberOfRecordsUpdated":0,"records":[[{"stringValue":"PRIMARY"},{"stringValue":"FieldInfos"},{"stringValue":"ID"},{"longValue":1}],[{"stringValue":"PRIMARY"},{"stringValue":"FieldTypes"},{"stringValue":"ID"},{"longValue":1}],[{"stringValue":"PRIMARY"},{"stringValue":"FormDatas"},{"stringValue":"ID"},{"longValue":1}],[{"stringValue":"PRIMARY"},{"stringValue":"FormHeaders"},{"stringValue":"ID"},{"longValue":1}],[{"stringValue":"PRIMARY"},{"stringValue":"FormTypeInfos"},{"stringValue":"ID"},{"longValue":1}],[{"stringValue":"PRIMARY"},{"stringValue":"GlobalDefaults"},{"stringValue":"ID"},{"longValue":1}],[{"stringValue":"PRIMARY"},{"stringValue":"PageInfos"},{"stringValue":"ID"},{"longValue":1}],[{"stringValue":"PRIMARY"},{"stringValue":"Products"},{"stringValue":"ID"},{"longValue":1}],[{"stringValue":"PRIMARY"},{"stringValue":"Purchases"},{"stringValue":"ID"},{"longValue":1}],[{"stringValue":"PRIMARY"},{"stringValue":"RecipientInfos"},{"stringValue":"ID"},{"longValue":1}],[{"stringValue":"PRIMARY"},{"stringValue":"ShareInfos"},{"stringValue":"ID"},{"longValue":1}],[{"stringValue":"PRIMARY"},{"stringValue":"Users"},{"stringValue":"ID"},{"longValue":1}]]}

9 Win	SHOW TABLES FROM formvalet_dev LIKE 'TABLE\_CONSTRAINTS'
{"columnMetadata":[{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"Tables_in_formvalet_dev (TABLECONSTRAINTS)","name":"TABLE_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"TABLE_NAMES","type":12,"typeName":"VARCHAR"}],"numberOfRecordsUpdated":0,"records":[]}

10 Win	SHOW TABLES FROM formvalet_dev LIKE 'KEY\_COLUMN\_USAGE'
{"columnMetadata":[{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"Tables_in_formvalet_dev (KEYCOLUMNUSAGE)","name":"TABLE_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"TABLE_NAMES","type":12,"typeName":"VARCHAR"}],"numberOfRecordsUpdated":0,"records":[]}

11 Win	SELECT C.CONSTRAINT_NAME, C.TABLE_NAME, K.COLUMN_NAME, K.ORDINAL_POSITION FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS C, INFORMATION_SCHEMA.KEY_COLUMN_USAGE K WHERE C.CONSTRAINT_TYPE='UNIQUE' AND C.TABLE_NAME = K.TABLE_NAME AND C.CONSTRAINT_NAME = K.CONSTRAINT_NAME AND C.CONSTRAINT_SCHEMA = 'formvalet_dev' AND K.CONSTRAINT_SCHEMA = 'formvalet_dev' ORDER BY C.TABLE_NAME, C.CONSTRAINT_NAME, K.ORDINAL_POSITION
{"columnMetadata":[{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"CONSTRAINT_NAME","name":"CONSTRAINT_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"TABLE_CONSTRAINTS","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"TABLE_NAME","name":"TABLE_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"TABLE_CONSTRAINTS","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"COLUMN_NAME","name":"COLUMN_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"KEY_COLUMN_USAGE","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":true,"label":"ORDINAL_POSITION","name":"ORDINAL_POSITION","nullable":0,"precision":19,"scale":0,"schemaName":"","tableName":"KEY_COLUMN_USAGE","type":-5,"typeName":"BIGINT"}],"numberOfRecordsUpdated":0,"records":[[{"stringValue":"UK_2FA1B861_FieldTypes"},{"stringValue":"FieldTypes"},{"stringValue":"FieldTypeName"},{"longValue":1}],[{"stringValue":"UK_FD0847DA_Users"},{"stringValue":"Users"},{"stringValue":"UserName"},{"longValue":1}]]}

12 Win	SELECT S.TABLE_NAME, S.INDEX_NAME, S.COLUMN_NAME FROM INFORMATION_SCHEMA.STATISTICS S, INFORMATION_SCHEMA.COLUMNS C WHERE S.INDEX_NAME<>'PRIMARY' AND S.TABLE_NAME=C.TABLE_NAME AND S.COLUMN_NAME=C.COLUMN_NAME AND (C.COLUMN_KEY <> 'PRI') AND C.TABLE_SCHEMA = 'formvalet_dev' AND S.INDEX_SCHEMA = 'formvalet_dev' AND (S.NON_UNIQUE <> 0) OR (S.NON_UNIQUE IS NULL) ORDER BY S.TABLE_NAME, S.INDEX_NAME, S.SEQ_IN_INDEX
{"columnMetadata":[{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"TABLE_NAME","name":"TABLE_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"STATISTICS","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"INDEX_NAME","name":"INDEX_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"STATISTICS","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"COLUMN_NAME","name":"COLUMN_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"STATISTICS","type":12,"typeName":"VARCHAR"}],"numberOfRecordsUpdated":0,"records":[[{"stringValue":"FieldInfos"},{"stringValue":"FK_FieldInfos_FieldInfos_CaptionID"},{"stringValue":"CaptionID"}],[{"stringValue":"FieldInfos"},{"stringValue":"FK_FieldInfos_FieldInfos_FigureID"},{"stringValue":"FigureID"}],[{"stringValue":"FieldInfos"},{"stringValue":"FK_FieldInfos_FieldTypes_FieldTypeID"},{"stringValue":"FieldTypeID"}],[{"stringValue":"FieldInfos"},{"stringValue":"FK_FieldInfos_PageInfos_PageInfoID"},{"stringValue":"PageInfoID"}],[{"stringValue":"FormDatas"},{"stringValue":"FK_FormDatas_FormHeaders_FormHeaderID"},{"stringValue":"FormHeaderID"}],[{"stringValue":"FormHeaders"},{"stringValue":"FK_FormHeaders_FormTypeInfos_FormTypeInfoID"},{"stringValue":"FormTypeInfoID"}],[{"stringValue":"FormHeaders"},{"stringValue":"FK_FormHeaders_RecipientInfos_RecipientID"},{"stringValue":"RecipientID"}],[{"stringValue":"PageInfos"},{"stringValue":"FK_PageInfos_FormTypeInfos_FormTypeInfoID"},{"stringValue":"FormTypeInfoID"}],[{"stringValue":"Purchases"},{"stringValue":"FK_Purchases_Products_ProductID"},{"stringValue":"ProductID"}],[{"stringValue":"Purchases"},{"stringValue":"FK_Purchases_Users_UserId"},{"stringValue":"UserId"}],[{"stringValue":"RecipientInfos"},{"stringValue":"FK_RecipientInfos_FormHeaders_FormHeaderID"},{"stringValue":"FormHeaderID"}],[{"stringValue":"RecipientInfos"},{"stringValue":"FK_RecipientInfos_ShareInfos_ShareInfoID"},{"stringValue":"ShareInfoID"}],[{"stringValue":"ShareInfos"},{"stringValue":"FK_ShareInfos_FormTypeInfos_FormTypeInfoID"},{"stringValue":"FormTypeInfoID"}]]}

13 Win	SHOW TABLES FROM formvalet_dev LIKE 'STATISTICS'
{"columnMetadata":[{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"Tables_in_formvalet_dev (STATISTICS)","name":"TABLE_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"TABLE_NAMES","type":12,"typeName":"VARCHAR"}],"numberOfRecordsUpdated":0,"records":[]}

14 Win	SELECT R.CONSTRAINT_NAME, R.TABLE_NAME AS FK_TABLE_NAME, R.REFERENCED_TABLE_NAME AS PK_TABLE_NAME, KC.COLUMN_NAME AS FK_COLUMN_NAME, KC.REFERENCED_COLUMN_NAME AS PK_COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE KC, INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS R WHERE R.CONSTRAINT_NAME = KC.CONSTRAINT_NAME AND R.TABLE_NAME = KC.TABLE_NAME AND KC.CONSTRAINT_SCHEMA = 'formvalet_dev' AND R.CONSTRAINT_SCHEMA = 'formvalet_dev' ORDER BY R.CONSTRAINT_NAME, KC.POSITION_IN_UNIQUE_CONSTRAINT
{"columnMetadata":[{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"CONSTRAINT_NAME","name":"CONSTRAINT_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"REFERENTIAL_CONSTRAINTS","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"FK_TABLE_NAME","name":"TABLE_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"REFERENTIAL_CONSTRAINTS","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"PK_TABLE_NAME","name":"REFERENCED_TABLE_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"REFERENTIAL_CONSTRAINTS","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"FK_COLUMN_NAME","name":"COLUMN_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"KEY_COLUMN_USAGE","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"PK_COLUMN_NAME","name":"REFERENCED_COLUMN_NAME","nullable":1,"precision":64,"scale":0,"schemaName":"","tableName":"KEY_COLUMN_USAGE","type":12,"typeName":"VARCHAR"}],"numberOfRecordsUpdated":0,"records":[[{"stringValue":"FK_FieldInfos_FieldInfos_CaptionID"},{"stringValue":"FieldInfos"},{"stringValue":"FieldInfos"},{"stringValue":"CaptionID"},{"stringValue":"ID"}],[{"stringValue":"FK_FieldInfos_FieldInfos_FigureID"},{"stringValue":"FieldInfos"},{"stringValue":"FieldInfos"},{"stringValue":"FigureID"},{"stringValue":"ID"}],[{"stringValue":"FK_FieldInfos_FieldTypes_FieldTypeID"},{"stringValue":"FieldInfos"},{"stringValue":"FieldTypes"},{"stringValue":"FieldTypeID"},{"stringValue":"ID"}],[{"stringValue":"FK_FieldInfos_PageInfos_PageInfoID"},{"stringValue":"FieldInfos"},{"stringValue":"PageInfos"},{"stringValue":"PageInfoID"},{"stringValue":"ID"}],[{"stringValue":"FK_FormDatas_FormHeaders_FormHeaderID"},{"stringValue":"FormDatas"},{"stringValue":"FormHeaders"},{"stringValue":"FormHeaderID"},{"stringValue":"ID"}],[{"stringValue":"FK_FormHeaders_FormTypeInfos_FormTypeInfoID"},{"stringValue":"FormHeaders"},{"stringValue":"FormTypeInfos"},{"stringValue":"FormTypeInfoID"},{"stringValue":"ID"}],[{"stringValue":"FK_FormHeaders_RecipientInfos_RecipientID"},{"stringValue":"FormHeaders"},{"stringValue":"RecipientInfos"},{"stringValue":"RecipientID"},{"stringValue":"ID"}],[{"stringValue":"FK_PageInfos_FormTypeInfos_FormTypeInfoID"},{"stringValue":"PageInfos"},{"stringValue":"FormTypeInfos"},{"stringValue":"FormTypeInfoID"},{"stringValue":"ID"}],[{"stringValue":"FK_Purchases_Products_ProductID"},{"stringValue":"Purchases"},{"stringValue":"Products"},{"stringValue":"ProductID"},{"stringValue":"ID"}],[{"stringValue":"FK_Purchases_Users_UserId"},{"stringValue":"Purchases"},{"stringValue":"Users"},{"stringValue":"UserId"},{"stringValue":"ID"}],[{"stringValue":"FK_RecipientInfos_FormHeaders_FormHeaderID"},{"stringValue":"RecipientInfos"},{"stringValue":"FormHeaders"},{"stringValue":"FormHeaderID"},{"stringValue":"ID"}],[{"stringValue":"FK_RecipientInfos_ShareInfos_ShareInfoID"},{"stringValue":"RecipientInfos"},{"stringValue":"ShareInfos"},{"stringValue":"ShareInfoID"},{"stringValue":"ID"}],[{"stringValue":"FK_ShareInfos_FormTypeInfos_FormTypeInfoID"},{"stringValue":"ShareInfos"},{"stringValue":"FormTypeInfos"},{"stringValue":"FormTypeInfoID"},{"stringValue":"ID"}]]}

15 Win	SHOW TABLES FROM formvalet_dev LIKE 'REFERENTIAL\_CONSTRAINTS'
{"columnMetadata":[{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"Tables_in_formvalet_dev (REFERENTIALCONSTRAINTS)","name":"TABLE_NAME","nullable":0,"precision":64,"scale":0,"schemaName":"","tableName":"TABLE_NAMES","type":12,"typeName":"VARCHAR"}],"numberOfRecordsUpdated":0,"records":[]}

16 Win	SELECT A.CreatedAt AS A_CreatedAt, A.ID AS A_ID, A.ModifiedAt AS A_ModifiedAt, A.AddedPages AS A_AddedPages, A.Identifier AS A_Identifier, A.Owner AS A_Owner, A.FormTypeInfoID AS A_FormTypeInfoID, A.RecipientID AS A_RecipientID FROM FormHeaders A WHERE A.Owner = 'B2A88D406CC478ED02D9DE0B94677162' ORDER BY A.CreatedAt Desc
{"columnMetadata":[{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"A_CreatedAt","name":"CreatedAt","nullable":0,"precision":19,"scale":0,"schemaName":"","tableName":"FormHeaders","type":93,"typeName":"DATETIME"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"A_ID","name":"ID","nullable":0,"precision":255,"scale":0,"schemaName":"","tableName":"FormHeaders","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"A_ModifiedAt","name":"ModifiedAt","nullable":1,"precision":19,"scale":0,"schemaName":"","tableName":"FormHeaders","type":93,"typeName":"DATETIME"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"A_AddedPages","name":"AddedPages","nullable":1,"precision":256,"scale":0,"schemaName":"","tableName":"FormHeaders","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"A_Identifier","name":"Identifier","nullable":1,"precision":256,"scale":0,"schemaName":"","tableName":"FormHeaders","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"A_Owner","name":"Owner","nullable":1,"precision":256,"scale":0,"schemaName":"","tableName":"FormHeaders","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"A_FormTypeInfoID","name":"FormTypeInfoID","nullable":1,"precision":255,"scale":0,"schemaName":"","tableName":"FormHeaders","type":12,"typeName":"VARCHAR"},{"arrayBaseColumnType":0,"isAutoIncrement":false,"isCaseSensitive":false,"isCurrency":false,"isSigned":false,"label":"A_RecipientID","name":"RecipientID","nullable":1,"precision":255,"scale":0,"schemaName":"","tableName":"FormHeaders","type":12,"typeName":"VARCHAR"}],"numberOfRecordsUpdated":0,"records":[]}

Here is command #16 from the Mac log. Commands 1 - 15 and their results are exactly the same as the Win log.

16 Mac	CREATE TABLE FormHeaders (  CreatedAt DATETIME NOT NULL,  ID VARCHAR(255),  ModifiedAt DATETIME,  AddedPages VARCHAR(256),  FormTypeInfoID VARCHAR(255),  Identifier VARCHAR(256),  Owner VARCHAR(256),  RecipientID VARCHAR(255),  CONSTRAINT PK_FormHeaders PRIMARY KEY (ID))
{"message":"Table 'FormHeaders' already exists; Error code: 1050; SQLState: 42S01","code":"BadRequestException","time":"2021-11-30T10:08:05.226Z","requestId":"88b7eab6-26a0-4684-834d-0ae1a3851ec7","statusCode":400,"retryable":false,"retryDelay":26.16343849823388}
2

We are not aware of such issue. The strange thing is that the CREATE TABLE command is coming after a SELECT from the same table (FormHeaders).

Are you able to debug the Mac app to check from which code this command is coming from? Are you calling TDatabaseManager.Update, or BuildDatabase?

3

I call UpdateDatabase. On the Mac, the SQL appears to be coming from Aurelius, just as on Windows. That's a good thing.

I wasn't clear. Windows performs the SELECT on FormHeaders. Mac performs a CREATE TABLE instead of the SELECT. Mac isn't convinced the database is present and correct and attempts to build it instead of use it.

Writing and posting my message let me think about the whole situation again. I modified the Zeos driver to enable Aurelius to work with serverless. I assumed that if I were mangling the result sets on returning them to Zeos either Zeos or Aurelius would throw an error. But Aurelius' failure to recognize the database IS an error. Aurelius is just too polite and robust to tell me my database looks like garbage.

Parsing the json result sets into Zeos involves a lot of pointer programming. Since the error is only on the Mac I'm going to assume this is some sort of text/unicode/ansistring/widechar/rawbytestring/ 0 -vs-1-index nonsense that going to take me an age to find. But it's the only possibility I can think of that fits the data.

Thanks for your reply, and for taking the time to read and think about my message.

4

It's not clear to me if this is finished? I understand you suspect it's something in your code that you will inspect better?

5

The problem is not fixed, but since you did not recognize the behavior I think it's unlikely the problem lies with Aurelius. Yes, I suspect it's something in my code that I will inspect better.

Thanks

David

1 Like