Downloaded odb39-Before.odb from http://thefrugalcomputerguy.com/libreoffice-base/index.php
Copied table tbl_Employees to tbl_Employees-orig
Go into Tools Relationships and delete the two relationships.
Copy/paste SQL text from http://www.thefrugalcomputerguy.com/libreoffice-base/downloads/odb39a-Create-Employees-Table.txt
into SQL and execute completes successfully on both versions
Copy/paste text from http://www.thefrugalcomputerguy.com/libreoffice-base/downloads/odb39b-Insert-From-Select-with-Case.txt
into SQL and execute – Windows version successfully executes Linux version fails.
Windows 7 – LibreOffice Base 22.214.171.124
Linux Mint 17.3 – LibreOffice Base 126.96.36.199
I can confirm
Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737
CPU Threads: 4; OS Version: Linux 3.19; UI Render: default;
Locale: en-US (en_US.UTF-8)
INSERT INTO via tools>SQL =fail
NEW per comment 1
I can't give it a try because of tdf#97854 (crash when deleting a relationship).
Comment #1 says "Copied table tbl_Employees to tbl_Employees-orig" but the sql of odb39b-Insert-From-Select-with-Case.txt says "tbl_Employees-Original"
Now that I've fixed tdf#97854 if I copy tbl_Employees to tbl_Employees-Original, delete the references and do the rest of the sql statement copy paste execute I get two successfully executed status returns.