[ODBC-159] Creation of temporary tables with multiple statements in one query fails. - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 3.0.5
Fix Version/s: 3.0.6
Component/s: General
Labels:
None
Environment:
MariaDB 10.2.13 on FreeBSD 11.1, Client Windows 10 with ODBC Connector 3.0.5

Description

We are having issues with the creation of temporary tables through the MariaDB ODBC Connector.

The statements we are issuing:

DROP TABLE IF EXISTS _temp_statistics;

CREATE TEMPORARY TABLE _temp_statistics AS (SELECT * FROM INFORMATION_SCHEMA.STATISTICS);

SELECT * FROM _temp_statistics;

We execute these statements in a single query like so:

using (var connection = new OdbcConnection(connectionString))

   connection.Open();

   using (var command = connection.CreateCommand())

      command.CommandText = Resource.CreateAndSelectTempTable;

      int result = command.ExecuteNonQuery();

The error we get is:
" ERROR [42S02] [ma-3.0.5][10.2.13-MariaDB-log]Table 'DB._temp_statistics' doesn't exist"

However if we execute this in multiple queries it does work. Like so:

using (var connection = new OdbcConnection(connectionString))

   int result;

   connection.Open();

   using (var command = connection.CreateCommand())

      command.CommandText = Resource.DropTempTable;

      result = command.ExecuteNonQuery();

   using (var command = connection.CreateCommand())

      command.CommandText = Resource.CreateTempTable;

      result = command.ExecuteNonQuery();

   using (var command = connection.CreateCommand())

      command.CommandText = Resource.SelectTempTable;

      result = command.ExecuteNonQuery();

Is there a bug concering multiple statements in a single query and temporary tables?

Both versions do work with the mysql connector. I have also attached the general logfile for the case when the command fails.

Like always i am happy to provide more information on this as needed.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

general_log.txt
0.5 kB
2018-07-10 13:24

Activity

Ascending order - Click to sort in descending order

Patrick Dudziak created issue - 2018-07-10 13:27

Patrick Dudziak made changes - 2018-07-10 13:29

Field	Original Value	New Value
Description	We are having issues with the creation of temporary tables through the MariaDB ODBC Connector. The statements we are issuing: DROP TABLE IF EXISTS _temp_statistics; CREATE TEMPORARY TABLE _temp_statistics AS (SELECT * FROM INFORMATION_SCHEMA.STATISTICS); SELECT * FROM _temp_statistics; We execute these statements in a single query like so: using (var connection = new OdbcConnection(connectionString)) { connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = Resource.CreateAndSelectTempTable; int result = command.ExecuteNonQuery(); } } The error we get is: " ERROR [42S02] [ma-3.0.5][10.2.13-MariaDB-log]Table 'DB._temp_statistics' doesn't exist" However if we execute this in multiple queries it does work. Like so: using (var connection = new OdbcConnection(connectionString)) { int result; connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = Resource.DropTempTable; result = command.ExecuteNonQuery(); } using (var command = connection.CreateCommand()) { command.CommandText = Resource.CreateTempTable; result = command.ExecuteNonQuery(); } using (var command = connection.CreateCommand()) { command.CommandText = Resource.SelectTempTable; result = command.ExecuteNonQuery(); } } Is there a bug concering multiple statements in a single query and temporary tables? Both versions do work with the mysql connector. I have also attached the general logfile for the case when the command fails. Like always i am happy to provide more information on this as needed.	We are having issues with the creation of temporary tables through the MariaDB ODBC Connector. The statements we are issuing: DROP TABLE IF EXISTS _temp_statistics; CREATE TEMPORARY TABLE _temp_statistics AS (SELECT * FROM INFORMATION_SCHEMA.STATISTICS); SELECT * FROM _temp_statistics; We execute these statements in a single query like so: ^using (var connection = new OdbcConnection(connectionString)) { connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = Resource.CreateAndSelectTempTable; int result = command.ExecuteNonQuery(); } }^ The error we get is: " ERROR [42S02] [ma-3.0.5][10.2.13-MariaDB-log]Table 'DB._temp_statistics' doesn't exist" However if we execute this in multiple queries it does work. Like so: using (var connection = new OdbcConnection(connectionString)) { int result; connection.Open(); using (var command = connection.CreateCommand()) { command.CommandText = Resource.DropTempTable; result = command.ExecuteNonQuery(); } using (var command = connection.CreateCommand()) { command.CommandText = Resource.CreateTempTable; result = command.ExecuteNonQuery(); } using (var command = connection.CreateCommand()) { command.CommandText = Resource.SelectTempTable; result = command.ExecuteNonQuery(); } } Is there a bug concering multiple statements in a single query and temporary tables? Both versions do work with the mysql connector. I have also attached the general logfile for the case when the command fails. Like always i am happy to provide more information on this as needed.

Patrick Dudziak made changes - 2018-07-10 13:29

Description

We are having issues with the creation of temporary tables through the MariaDB ODBC Connector.

The statements we are issuing:

DROP TABLE IF EXISTS _temp_statistics;
CREATE TEMPORARY TABLE _temp_statistics AS (SELECT * FROM INFORMATION_SCHEMA.STATISTICS);
SELECT * FROM _temp_statistics;

We execute these statements in a single query like so:
^using (var connection = new OdbcConnection(connectionString))
{
   connection.Open();
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.CreateAndSelectTempTable;
      int result = command.ExecuteNonQuery();
   }
}^

The error we get is:
" ERROR [42S02] [ma-3.0.5][10.2.13-MariaDB-log]Table 'DB._temp_statistics' doesn't exist"

However if we execute this in multiple queries it does work. Like so:
using (var connection = new OdbcConnection(connectionString))
{
   int result;
   connection.Open();
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.DropTempTable;
      result = command.ExecuteNonQuery();
   }
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.CreateTempTable;
      result = command.ExecuteNonQuery();
   }
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.SelectTempTable;
      result = command.ExecuteNonQuery();
   }
}

Is there a bug concering multiple statements in a single query and temporary tables?

Both versions do work with the mysql connector. I have also attached the general logfile for the case when the command fails.

Like always i am happy to provide more information on this as needed.

We are having issues with the creation of temporary tables through the MariaDB ODBC Connector.

The statements we are issuing:

DROP TABLE IF EXISTS _temp_statistics;
CREATE TEMPORARY TABLE _temp_statistics AS (SELECT * FROM INFORMATION_SCHEMA.STATISTICS);
SELECT * FROM _temp_statistics;

We execute these statements in a single query like so:
using (var connection = new OdbcConnection(connectionString))
{
   connection.Open();
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.CreateAndSelectTempTable;
      int result = command.ExecuteNonQuery();
   }
}

The error we get is:
" ERROR [42S02] [ma-3.0.5][10.2.13-MariaDB-log]Table 'DB._temp_statistics' doesn't exist"

However if we execute this in multiple queries it does work. Like so:
using (var connection = new OdbcConnection(connectionString))
{
   int result;
   connection.Open();
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.DropTempTable;
      result = command.ExecuteNonQuery();
   }
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.CreateTempTable;
      result = command.ExecuteNonQuery();
   }
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.SelectTempTable;
      result = command.ExecuteNonQuery();
   }
}

Is there a bug concering multiple statements in a single query and temporary tables?

Both versions do work with the mysql connector. I have also attached the general logfile for the case when the command fails.

Like always i am happy to provide more information on this as needed.

Patrick Dudziak made changes - 2018-07-10 13:29

Description

We are having issues with the creation of temporary tables through the MariaDB ODBC Connector.

The statements we are issuing:

DROP TABLE IF EXISTS _temp_statistics;
CREATE TEMPORARY TABLE _temp_statistics AS (SELECT * FROM INFORMATION_SCHEMA.STATISTICS);
SELECT * FROM _temp_statistics;

We execute these statements in a single query like so:
using (var connection = new OdbcConnection(connectionString))
{
   connection.Open();
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.CreateAndSelectTempTable;
      int result = command.ExecuteNonQuery();
   }
}

The error we get is:
" ERROR [42S02] [ma-3.0.5][10.2.13-MariaDB-log]Table 'DB._temp_statistics' doesn't exist"

However if we execute this in multiple queries it does work. Like so:
using (var connection = new OdbcConnection(connectionString))
{
   int result;
   connection.Open();
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.DropTempTable;
      result = command.ExecuteNonQuery();
   }
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.CreateTempTable;
      result = command.ExecuteNonQuery();
   }
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.SelectTempTable;
      result = command.ExecuteNonQuery();
   }
}

Is there a bug concering multiple statements in a single query and temporary tables?

Both versions do work with the mysql connector. I have also attached the general logfile for the case when the command fails.

Like always i am happy to provide more information on this as needed.

We are having issues with the creation of temporary tables through the MariaDB ODBC Connector.

The statements we are issuing:

DROP TABLE IF EXISTS _temp_statistics;
CREATE TEMPORARY TABLE _temp_statistics AS (SELECT * FROM INFORMATION_SCHEMA.STATISTICS);
SELECT * FROM _temp_statistics;

We execute these statements in a single query like so:

{code:java}
using (var connection = new OdbcConnection(connectionString))
{
   connection.Open();
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.CreateAndSelectTempTable;
      int result = command.ExecuteNonQuery();
   }
}
{code}

The error we get is:
" ERROR [42S02] [ma-3.0.5][10.2.13-MariaDB-log]Table 'DB._temp_statistics' doesn't exist"

However if we execute this in multiple queries it does work. Like so:
using (var connection = new OdbcConnection(connectionString))
{
   int result;
   connection.Open();
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.DropTempTable;
      result = command.ExecuteNonQuery();
   }
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.CreateTempTable;
      result = command.ExecuteNonQuery();
   }
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.SelectTempTable;
      result = command.ExecuteNonQuery();
   }
}

Is there a bug concering multiple statements in a single query and temporary tables?

Both versions do work with the mysql connector. I have also attached the general logfile for the case when the command fails.

Like always i am happy to provide more information on this as needed.

Patrick Dudziak made changes - 2018-07-10 13:30

Description

We are having issues with the creation of temporary tables through the MariaDB ODBC Connector.

The statements we are issuing:

DROP TABLE IF EXISTS _temp_statistics;
CREATE TEMPORARY TABLE _temp_statistics AS (SELECT * FROM INFORMATION_SCHEMA.STATISTICS);
SELECT * FROM _temp_statistics;

We execute these statements in a single query like so:

{code:java}
using (var connection = new OdbcConnection(connectionString))
{
   connection.Open();
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.CreateAndSelectTempTable;
      int result = command.ExecuteNonQuery();
   }
}
{code}

The error we get is:
" ERROR [42S02] [ma-3.0.5][10.2.13-MariaDB-log]Table 'DB._temp_statistics' doesn't exist"

However if we execute this in multiple queries it does work. Like so:
using (var connection = new OdbcConnection(connectionString))
{
   int result;
   connection.Open();
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.DropTempTable;
      result = command.ExecuteNonQuery();
   }
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.CreateTempTable;
      result = command.ExecuteNonQuery();
   }
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.SelectTempTable;
      result = command.ExecuteNonQuery();
   }
}

Is there a bug concering multiple statements in a single query and temporary tables?

Both versions do work with the mysql connector. I have also attached the general logfile for the case when the command fails.

Like always i am happy to provide more information on this as needed.

We are having issues with the creation of temporary tables through the MariaDB ODBC Connector.

The statements we are issuing:

DROP TABLE IF EXISTS _temp_statistics;
CREATE TEMPORARY TABLE _temp_statistics AS (SELECT * FROM INFORMATION_SCHEMA.STATISTICS);
SELECT * FROM _temp_statistics;

We execute these statements in a single query like so:

{code:java}
using (var connection = new OdbcConnection(connectionString))
{
   connection.Open();
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.CreateAndSelectTempTable;
      int result = command.ExecuteNonQuery();
   }
}
{code}

The error we get is:
" ERROR [42S02] [ma-3.0.5][10.2.13-MariaDB-log]Table 'DB._temp_statistics' doesn't exist"

However if we execute this in multiple queries it does work. Like so:

{code:java}
using (var connection = new OdbcConnection(connectionString))
{
   int result;
   connection.Open();
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.DropTempTable;
      result = command.ExecuteNonQuery();
   }
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.CreateTempTable;
      result = command.ExecuteNonQuery();
   }
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.SelectTempTable;
      result = command.ExecuteNonQuery();
   }
}
{code}

Is there a bug concering multiple statements in a single query and temporary tables?

Both versions do work with the mysql connector. I have also attached the general logfile for the case when the command fails.

Like always i am happy to provide more information on this as needed.

Patrick Dudziak made changes - 2018-07-10 13:30

Description

We are having issues with the creation of temporary tables through the MariaDB ODBC Connector.

The statements we are issuing:

DROP TABLE IF EXISTS _temp_statistics;
CREATE TEMPORARY TABLE _temp_statistics AS (SELECT * FROM INFORMATION_SCHEMA.STATISTICS);
SELECT * FROM _temp_statistics;

We execute these statements in a single query like so:

{code:java}
using (var connection = new OdbcConnection(connectionString))
{
   connection.Open();
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.CreateAndSelectTempTable;
      int result = command.ExecuteNonQuery();
   }
}
{code}

The error we get is:
" ERROR [42S02] [ma-3.0.5][10.2.13-MariaDB-log]Table 'DB._temp_statistics' doesn't exist"

However if we execute this in multiple queries it does work. Like so:

{code:java}
using (var connection = new OdbcConnection(connectionString))
{
   int result;
   connection.Open();
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.DropTempTable;
      result = command.ExecuteNonQuery();
   }
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.CreateTempTable;
      result = command.ExecuteNonQuery();
   }
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.SelectTempTable;
      result = command.ExecuteNonQuery();
   }
}
{code}

Is there a bug concering multiple statements in a single query and temporary tables?

Both versions do work with the mysql connector. I have also attached the general logfile for the case when the command fails.

Like always i am happy to provide more information on this as needed.

We are having issues with the creation of temporary tables through the MariaDB ODBC Connector.

The statements we are issuing:

{code:java}
DROP TABLE IF EXISTS _temp_statistics;
CREATE TEMPORARY TABLE _temp_statistics AS (SELECT * FROM INFORMATION_SCHEMA.STATISTICS);
SELECT * FROM _temp_statistics;
{code}

We execute these statements in a single query like so:

{code:java}
using (var connection = new OdbcConnection(connectionString))
{
   connection.Open();
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.CreateAndSelectTempTable;
      int result = command.ExecuteNonQuery();
   }
}
{code}

The error we get is:
" ERROR [42S02] [ma-3.0.5][10.2.13-MariaDB-log]Table 'DB._temp_statistics' doesn't exist"

However if we execute this in multiple queries it does work. Like so:

{code:java}
using (var connection = new OdbcConnection(connectionString))
{
   int result;
   connection.Open();
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.DropTempTable;
      result = command.ExecuteNonQuery();
   }
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.CreateTempTable;
      result = command.ExecuteNonQuery();
   }
   using (var command = connection.CreateCommand())
   {
      command.CommandText = Resource.SelectTempTable;
      result = command.ExecuteNonQuery();
   }
}
{code}

Is there a bug concering multiple statements in a single query and temporary tables?

Both versions do work with the mysql connector. I have also attached the general logfile for the case when the command fails.

Like always i am happy to provide more information on this as needed.

Lawrin Novitsky made changes - 2018-07-27 15:56

Fix Version/s		3.0.6 [ 23133 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:28

Workflow

MariaDB v3 [ 88340 ]

MariaDB v4 [ 135473 ]

People

Assignee:: Lawrin Novitsky

Reporter:: Patrick Dudziak

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2018-07-10 13:27

Updated:: 2018-08-03 02:28

Resolved:: 2018-07-27 15:56

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Connector/ODBC

Details

Description

Attachments

Attachments

Activity

People

Dates

Git Integration